[Ruby-DBI-devel-CVS] CVS: src/examples trace_test.rb,NONE,1.1

[Michael N. <mne...@us...>]

Update of /cvsroot/ruby-dbi/src/examples
In directory usw-pr-cvs1:/tmp/cvs-serv30017

Added Files:
	trace_test.rb 
Log Message:
initial import


--- NEW FILE: trace_test.rb ---
require "dbi"
require "dbi/trace"

DBI.trace(0)

dbh = DBI.connect('dbi:Mysql:database=test')

dbh.do('CREATE TABLE trace_test (name VARCHAR(30))')

dbh.trace(1, File.new('trace.log', 'w+'))

sql = 'INSERT INTO trace_test VALUES (?)'
dbh.prepare(sql) do |sth|
  sth.execute('Michael')

  sth.trace(2)

  sth.execute('John')
end

dbh.do('DROP TABLE trace_test')

dbh.select_one('SELECT * FROM trace_test')

dbh.disconnect