SQLite Ruby 处理图像

sqlite> CREATE TABLE Images(Id INTEGER PRIMARY KEY, Data BLOB);

#!/usr/bin/ruby

require 'sqlite3'

begin

    fin = File.open "woman.jpg" , "rb"
    img = fin.read

rescue SystemCallError => e      
    puts e
ensure
    fin.close if fin 
end

begin

    db = SQLite3::Database.open 'test.db'
    blob = SQLite3::Blob.new img
    db.execute "INSERT INTO Images VALUES(1, ?)", blob

rescue SQLite3::Exception => e 

    puts "Exception occurred"
    puts e

ensure
    db.close if db
end

fin = File.open "woman.jpg" , "rb"
img = fin.read

blob = SQLite3::Blob.new img

db.execute "INSERT INTO Images VALUES(1, ?)", blob

#!/usr/bin/ruby

require 'sqlite3'

begin

    db = SQLite3::Database.open 'test.db'   
    data = db.get_first_value "SELECT Data FROM Images LIMIT 1"    

    f = File.new "woman2.jpg", "wb"
    f.write data

rescue SQLite3::Exception, SystemCallError => e 

    puts "Exception occurred"
    puts e

ensure
    f.close if f
    db.close if db
end

data = db.get_first_value "SELECT Data FROM Images LIMIT 1"  

f = File.new "woman2.jpg", "wb"
f.write data