Test database connection

test_connection.rb

require "mysql"
require "json"

db_host = ""
db_user = ""
db_pass = ""
db_name = ""

# Test database conneciton
requests = 0
errors = 0
while true
	requests += 1
	begin
		db = Mysql.init
		db.options(Mysql::OPT_READ_TIMEOUT, 2)
		db.real_connect(db_host, db_user, db_pass, db_name)
		db.query("SHOW TABLES")
		puts "DB: OK (#{errors} / #{requests})"
	rescue Mysql::Error => err
		errors += 1
		puts "DB: Error (#{errors} / #{requests})"
	end
	sleep 2
end