ruby操作sqlite
require 'sqlite3'db = SQLite3::Database.new 'abc.db'
rows = db.execute <<-SQL
create table numbers(
name varchar(30),
val int
);
SQL
{
"one"=>1,
"two"=>2,
}.each do |pair|
db.execute "insert into numbers values(?,?)",pair
end
db.execute("select * from numbers") do |row|
p row
end
##################################################
下面可写入blob
require 'sqlite3'
require 'base64'
if File.exist?('abc.db')
File.delete('abc.db')
end
db = SQLite3::Database.new 'abc.db'
rows = db.execute <<-SQL
create table numbers(
name varchar(30),
image blob
);
SQL
na='phoenix'
bl=File.open('simple.gif').read
db.execute "insert into numbers values(?,?)",na,Base64.encode64(bl)
页:
[1]