require 'rubygems'
require 'mysql'
require 'yaml'
require 'fastercsv'

con = Mysql.new('db', 'user', 'password', 'tabla')
FasterCSV.open("used_stat.csv", "w") do |csv|
  print "processing."
  con.query('select * from centros').each_hash do  |h|
    print "."
    number=con.query("select count(clave) from cuestionarios where clave like '%#{h['master_key']}%'").fetch_row
    csv << (h.values + number)
  end
  con.close
end

print "\n\n"
puts "output dump into used_stat.csv"