Contents

#require 'sqlite3'

require "rubygems"
require_gem "sqlite3-ruby"


db = SQLite3::Database.new( "test.db" )
db.execute( "create table test ( foo int, bar text, baz int );" )
db.execute( "insert into test ( foo, bar, baz ) values ( 1, 'test', 3 );" )
puts "EXECUTE ----------------------------------------"
db.execute( "select * from test" ) { |row| puts row.join( ',' ) }
puts "EXECUTE2 ---------------------------------------"
db.execute2( "select * from test" ) { |row| puts row.join( ',' ) }

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
hutch-xamplr-1.0.0	lib/xamplr/sqlite/sqlite-play.rb
hutch-xamplr-1.0.1	lib/xamplr/sqlite/sqlite-play.rb
hutch-xamplr-1.0.2	lib/xamplr/sqlite/sqlite-play.rb