Sha256: 013a39692f3e7b4023edc3d7d463eed136b66cf452151be466b527ff389ce67e
Contents?: true
Size: 619 Bytes
Versions: 11
Compression:
Stored size: 619 Bytes
Contents
require 'sqlite3'
Shoes.app :width => 350, :height => 130 do
db = SQLite3::Database.new "simple-sqlite3.db"
db.execute "create table t1 (t1key INTEGER PRIMARY KEY,data " \
"TEXT,num double,timeEnter DATE)"
db.execute "insert into t1 (data,num) values ('This is sample data',3)"
db.execute "insert into t1 (data,num) values ('More sample data',6)"
db.execute "insert into t1 (data,num) values ('Aurélio, Küng, Stärk, Uña, Łuksza',6)"
db.execute "insert into t1 (data,num) values ('And a little more',9)"
rows = db.execute "select * from t1"
rows.each{|k, d, n| para "#{k} : #{d} : #{n}\n"}
end
Version data entries
11 entries across 8 versions & 4 rubygems