ruby mysql2链接数据库

#encoding:utf-8
require "rubygems"
require "mysql2"
require "erb"
require "active_record"
require "fileutils"
require "yaml"


#加入配置文件
config=YAML.load(ERB.new(File.open("#{Dir.getwd}/test_config.yml").read).result)
$database = config["database"]
#链接数据库

1）

$test_db=Mysql2::Client.new(:username => "root", :host => "127.0.0.1", :database => "#{$database}", :password => "123")

2）
ActiveRecord::Base.establish_connection(:adapter => 'mysql2',:host => "127.0.0.1", :database => "#{$database}", :username => "root", :password => "123")
#写日志
def write_log(str)
  File.open("log.txt", 'a') { |f| f.write(str) }
end

$test_db.query("SELECT * FROM user").each do |row|

  puts row["name"]

end