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)