Sqlite3-ruby

<code ruby> #!/usr/bin/env ruby # # Created by nofxx on 2007-10-21. # Copyright © 2007. All rights reserved.

require 'rubygems' require 'sqlite3'

db = SQLite3::Database.new(“xxx.db”)# ⇒ breve… , 0644) query = “SELECT * FROM xma” query2 = “SELECT * FROM xma”

puts db.complete?(query)

db.execute(query2) do |r|

puts r

end

def cria

db.execute <<SQL

CREATE TABLE xma (
id INTEGER PRIMARY KEY,
nome VARCHAR(100),
sexo BOOLEAN
);

SQL end <code>