MySQL Casual 2011 sample

dbi_sample.rb

require 'rubygems'
require 'dbi'
require 'pp'

dbh = DBI.connect('dbi:mysql:database=test;host=localhost', 'test', 'test')
pp dbh.select_one('SELECT VERSION()')

sth = dbh.prepare('SELECT * FROM mysql_casual WHERE name = ?')
sth.execute('ikasam_a')
while row = sth.fetch_hash do
  pp row
end
sth.finish

dbh.disconnect

dbi_with_test_mysqld.rb

require 'rubygems'
require 'dbi'
require 'test/mysqld'
require 'pp'

module Test
  Mysqld.class_eval do
    def username
      dsn[:username]
    end

    def dbi_dsn
      "dbi:Mysql:database=#{dsn[:database]};socket=#{dsn[:socket]}"
    end
  end
end

mysqld = Test::Mysqld.new(:auto_start => true)
pp mysqld.dbi_dsn
# "dbi:Mysql:database=test;socket=/tmp/11wkcy6n/tmp/mysql.sock"

dbh = DBI.connect(mysqld.dbi_dsn, mysqld.username)
# ...

mysql2_with_test_mysqld.rb

require 'rubygems'
require 'mysql2'
require 'test/mysqld'
require 'pp'

mysqld = Test::Mysqld.new(:auto_start => true)
pp mysqld.dsn
# {:port=>13306,
#  :socket=>"/tmp/11wkcy6n/tmp/mysql.sock",
#  :username=>"root",
#  :database=>"test"}

client = Mysql2::Client.new(mysqld.dsn)
# ...