Server Festa 2013 Autumn base syncer

svfes201311_base_sync.rb

require 'mysql2'
require 'dalli'
require 'connection_pool'

$stdout.sync = true

unless ARGV[0]
  puts "Usage: sync.rb PAGE_ID"
  exit 1
end

page_id = ARGV[0]

@memcached = ConnectionPool.new(:size => 5, :timeout => 5) { Dalli::Client.new }
#dc = Dalli::Client.new('localhost:11211')
client = Mysql2::Client.new(:host => "localhost", :username => "USERNAME", :password => "PASSWORD", :database => "wordpress")

@memcached.with do |dc|
  while true do
    time = Time.now
    value = dc.get(page_id)
    query = "UPDATE wp_posts SET comment_count = #{value} WHERE ID = #{page_id}"
    client.query(query)
    puts value
    puts Time.now - time
    sleep 0.005
  end
end