[Ruby-DBI-devel-CVS] CVS: src/ext/dbd_sqlite/test test.rb,NONE,1.1

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

Update of /cvsroot/ruby-dbi/src/ext/dbd_sqlite/test
In directory sc8-pr-cvs1:/tmp/cvs-serv16393/test

Added Files:
	test.rb 
Log Message:
Patch by <moo...@mo...>:
* fix Row Processed Count(sqlite_changes() function)
* fix DBI::Timestamp quote format for Timestamp sorting
 before '2003-2-13 1.2.3.0' => after '2003-02-13 01:02:03'


--- NEW FILE: test.rb ---
require 'dbi'
  
File.unlink("dbierrortestdb") rescue nil
db = DBI.connect("dbi:SQLite:dbierrortestdb")
db.execute("create table sequences (name varchar(30), val integer)")
db.execute("insert into sequences (name,val) values ('test',1000)")
  
puts "Before: #{db.select_all('select * from sequences').inspect}"
  
sth = db.prepare("update sequences set val=? where val=? and name=?")
sth.execute(1001,1000,"test")

rows = sth.rows

puts "Rows changed: #{rows}"

puts "After: #{db.select_all('select * from sequences').inspect}"

if rows != 1 
  puts "TEST FAILED"
  exit -1 
else
  puts "TEST PASSED"
  exit 0
end