dbの読み込みテスト

ruby sqlite mysql

sqlite.rb

#sqlite.rb
#ruby1.8
require 'rubygems'
require 'sqlite3'

db_location = "F:\\tools\\spatialite-gui-win-x86-1.3.0_beta\\20100318.sqlite"

db = SQLite3::Database.new(db_location)
sql = "select distinct aac, cn2 from japan"
res = db.query(sql)

res.each do |row|
  puts row.join(" | ")
end

mysql.rb

#mysql.rb
#ruby1.8 mysql5.1
require 'rubygems'
require 'mysql'

#mysqlのdbを開く
hostname = "localhost"
user = "root"
password = "hoge040piyo"
dbname = "wikidb"

db = Mysql::new(hostname, user, password, dbname)
res = db.query("select * from page limit 10")

#中身を表示する
res.each do |row|
  p row[0]
end

db.close