queries.rb 618 B

123456789101112131415161718192021222324252627
  1. class World
  2. def db
  3. @db ||= Userdata.new("my_#{Process.pid}").db
  4. end
  5. def find(id)
  6. ret = nil
  7. db.execute("select * from World where id = ?", id) do |row, fields|
  8. ret = Hash[fields.zip(row)]
  9. end
  10. ret
  11. end
  12. def save(world)
  13. db.execute("update World set randomNumber = ? where id = ?", world["randomNumber"], world["randomNumber"])
  14. end
  15. end
  16. r = Nginx::Request.new
  17. num_queries = r.var.arg_queries.to_i
  18. num_queries = 1 if num_queries < 1
  19. num_queries = 500 if num_queries > 500
  20. world = World.new
  21. ret = num_queries.times.map { world.find(rand(10000)) }
  22. Nginx.rputs JSON::stringify(ret)