Tests of sqlite3 via FFI in JRuby

gistfile1.txt

$ SQLITE3_DRIVERS=FFI jruby -v -rubygems -I lib -I test test/tc_database.rb 
jruby 1.4.0dev (ruby 1.8.6p287) (2009-07-10 6586) (Java HotSpot(TM) Client VM 1.5.0_19) [i386-java]
Loaded suite test/tc_database
Started
.........................
Finished in 0.414 seconds.

25 tests, 37 assertions, 0 failures, 0 errors
$ SQLITE3_DRIVERS=FFI jruby -v -rubygems -I lib -I test test/tc_errors.rb 
jruby 1.4.0dev (ruby 1.8.6p287) (2009-07-10 6586) (Java HotSpot(TM) Client VM 1.5.0_19) [i386-java]
Loaded suite test/tc_errors
Started
..........................
Finished in 0.118 seconds.

26 tests, 104 assertions, 0 failures, 0 errors
$ SQLITE3_DRIVERS=FFI jruby -v -rubygems -I lib -I test test/tc_integration.rb 
jruby 1.4.0dev (ruby 1.8.6p287) (2009-07-10 6586) (Java HotSpot(TM) Client VM 1.5.0_19) [i386-java]
Loaded suite test/tc_integration
Started
EE../test/../lib/sqlite3/driver/ffi/driver.rb:206 warning: instance variable @busy_handler_callback not initialized
../test/../lib/sqlite3/driver/ffi/driver.rb:206 warning: instance variable @busy_handler_callback not initialized
F......./test/../lib/sqlite3/driver/ffi/driver.rb:245 warning: instance variable @func_handler_callback not initialized
./test/../lib/sqlite3/driver/ffi/driver.rb:252 warning: instance variable @step_handler_callback not initialized
./test/../lib/sqlite3/driver/ffi/driver.rb:259 warning: instance variable @final_handler_callback not initialized
F./test/../lib/sqlite3/driver/ffi/driver.rb:245 warning: instance variable @func_handler_callback not initialized
./test/../lib/sqlite3/driver/ffi/driver.rb:252 warning: instance variable @step_handler_callback not initialized
./test/../lib/sqlite3/driver/ffi/driver.rb:259 warning: instance variable @final_handler_callback not initialized
F./test/../lib/sqlite3/driver/ffi/driver.rb:245 warning: instance variable @func_handler_callback not initialized
./test/../lib/sqlite3/driver/ffi/driver.rb:252 warning: instance variable @step_handler_callback not initialized
./test/../lib/sqlite3/driver/ffi/driver.rb:259 warning: instance variable @final_handler_callback not initialized
F./test/../lib/sqlite3/driver/ffi/driver.rb:245 warning: instance variable @func_handler_callback not initialized
./test/../lib/sqlite3/driver/ffi/driver.rb:252 warning: instance variable @step_handler_callback not initialized
./test/../lib/sqlite3/driver/ffi/driver.rb:259 warning: instance variable @final_handler_callback not initialized
F./test/../lib/sqlite3/driver/ffi/driver.rb:245 warning: instance variable @func_handler_callback not initialized
./test/../lib/sqlite3/driver/ffi/driver.rb:252 warning: instance variable @step_handler_callback not initialized
./test/../lib/sqlite3/driver/ffi/driver.rb:259 warning: instance variable @final_handler_callback not initialized
F..F............................/test/../lib/sqlite3/driver/ffi/driver.rb:245 warning: instance variable @func_handler_callback not initialized
./test/../lib/sqlite3/driver/ffi/driver.rb:252 warning: instance variable @step_handler_callback not initialized
./test/../lib/sqlite3/driver/ffi/driver.rb:259 warning: instance variable @final_handler_callback not initialized
F..................trace is an experimental feature of SQLite3
E........../test/../lib/sqlite3/statement.rb:196 warning: instance variable @types not initialized
.../test/../lib/sqlite3/statement.rb:196 warning: instance variable @types not initialized
........./test/../lib/sqlite3/statement.rb:196 warning: instance variable @types not initialized
../test/../lib/sqlite3/statement.rb:196 warning: instance variable @types not initialized
...../test/../lib/sqlite3/statement.rb:196 warning: instance variable @types not initialized
../test/../lib/sqlite3/statement.rb:196 warning: instance variable @types not initialized
............/test/../lib/sqlite3/statement.rb:196 warning: instance variable @types not initialized
................/test/../lib/sqlite3/statement.rb:196 warning: instance variable @types not initialized
../test/../lib/sqlite3/statement.rb:196 warning: instance variable @types not initialized
.
Finished in 2.784 seconds.

  1) Error:
test_authorizer_error(Integration::TC_Database_FFI):
NoMethodError: undefined method `set_authorizer' for #<SQLite3::Driver::FFI::Driver:0x726ef8>
    test/tc_integration.rb:149:in `test_authorizer_error'

  2) Error:
test_authorizer_okay(Integration::TC_Database_FFI):
NoMethodError: undefined method `set_authorizer' for #<SQLite3::Driver::FFI::Driver:0xe92fe>
    test/tc_integration.rb:143:in `test_authorizer_okay'

  3) Failure:
test_busy_handler_outwait(Integration::TC_Database_FFI) [test/tc_integration.rb:561]:
<1> expected but was
<35>.

  4) Failure:
test_create_aggregate_handler(Integration::TC_Database_FFI) [test/tc_integration.rb:691]:
<"6"> expected but was
<nil>.

  5) Failure:
test_create_aggregate_with_block(Integration::TC_Database_FFI) [test/tc_integration.rb:657]:
<"6"> expected but was
<nil>.

  6) Failure:
test_create_aggregate_with_no_data(Integration::TC_Database_FFI) [test/tc_integration.rb:672]:
<"0"> expected but was
<nil>.

  7) Failure:
test_create_aggregate_without_block(Integration::TC_Database_FFI) [test/tc_integration.rb:643]:
<"6"> expected but was
<nil>.

  8) Failure:
test_create_function(Integration::TC_Database_FFI) [test/tc_integration.rb:629]:
<nil> expected to be =~
</>>>.*<<</>.

  9) Failure:
test_errmsg_utf16(Integration::TC_Database_FFI) [test/tc_integration.rb:128]:
<"n\000o\000t\000 \000a\000n\000 \000e\000r\000r\000o\000r\000"> expected but was
<#<Pointer address=0x12d510>>.

 10) Failure:
test_interrupt(Integration::TC_Database_FFI) [test/tc_integration.rb:528]:
<SQLite3::SQLException> exception expected but none was thrown.

 11) Error:
test_trace(Integration::TC_Database_FFI):
ArgumentError: Cannot convert argument to pointer
    /Users/asari/personal/jruby/lib/ruby/1.8/ffi/pointer.rb:69:in `write_pointer'
    ./test/../lib/sqlite3/driver/ffi/driver.rb:225:in `trace'
    ./test/../lib/sqlite3/database.rb:136:in `trace'
    test/tc_integration.rb:137:in `test_trace'

119 tests, 180 assertions, 8 failures, 3 errors
$ SQLITE3_DRIVERS=FFI jruby -v -rubygems -I lib -I test test/driver/ffi/tc_driver.rb 
jruby 1.4.0dev (ruby 1.8.6p287) (2009-07-10 6586) (Java HotSpot(TM) Client VM 1.5.0_19) [i386-java]
Loaded suite test/driver/ffi/tc_driver
Started
............F....F....
Finished in 0.201 seconds.

  1) Failure:
test_errmsg16(TC_FFI_Driver) [test/driver/ffi/tc_driver.rb:58]:
<"\376\377\000n\000o\000t\000 \000a\000n\000 \000e\000r\000r\000o\000r"> expected but was
<#<Pointer address=0x12a800>>.

  2) Failure:
test_prepare16_remainder(TC_FFI_Driver) [test/driver/ffi/tc_driver.rb:100]:
<"\376\377\000 \000s\000e\000l\000e\000c\000t\000 \000*\000 \000f\000r\000o\000m\000 \000f\000o\000o"> expected but was
<"">.

22 tests, 72 assertions, 2 failures, 0 errors