require 'marjoree'
include Marjoree

connect('ODBC_DATASOURCE_NAME', 'USERNAME', 'PASSWORD' )
Kernel.at_exit { disconnect }
puts

execute "CREATE TABLE TEST_TABLE( id int NOT NULL, value int NOT NULL )"



results = select( 'TEST_TABLE' )
puts "Initial Num result rows: #{results.count}"

insert( 'TEST_TABLE', { :id => 0, :value => 10 } )
results = select( 'TEST_TABLE' )

puts "Num result rows: #{results.count}"
puts results

insert( 'TEST_TABLE', { :id => 1, :value => 20 } )
results = select( 'TEST_TABLE' )
puts results



execute "DROP TABLE TEST_TABLE"