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
|
