class MysqlConnection

Public Class Methods

new(options) click to toggle source
# File lib/poolboy/mysql.rb, line 5
def initialize(options)
  begin
    @mysql = Mysql2::Client.new(options.merge({:database => 'information_schema', :connect_timeout => 2, :symbolize_keys => true}))
  rescue Mysql2::Error => e
    puts e
    exit 1
  end
end

Public Instance Methods

disconnect() click to toggle source
# File lib/poolboy/mysql.rb, line 33
def disconnect
  @mysql.close
end
percona() click to toggle source
# File lib/poolboy/mysql.rb, line 19
def percona
  xtra = query("show variables like 'version_comment'")
  return (xtra.first[:Value].include? "Percona") ? true : false
end
query(query) click to toggle source
# File lib/poolboy/mysql.rb, line 24
def query(query)
  begin
    @mysql.query(query)
  rescue Mysql2::Error => e
    puts e
    exit 1
  end
end
version() click to toggle source
# File lib/poolboy/mysql.rb, line 14
def version
  version = query("SHOW VARIABLES LIKE 'version'")
  return version.first[:Value]
end