From a1472f5339fb163b0ca5a330c8c599e51f0468f0 Mon Sep 17 00:00:00 2001 From: Jamis Buck Date: Tue, 30 Jan 2007 00:07:47 +0000 Subject: make the table_info method adjust the returned default value for the rows so that the sqlite3 change in 3.3.8 and greater can be handled transparently --- test/tc_integration.rb | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'test') diff --git a/test/tc_integration.rb b/test/tc_integration.rb index 8bb4c4a..9d78313 100644 --- a/test/tc_integration.rb +++ b/test/tc_integration.rb @@ -82,6 +82,17 @@ module Integration assert_nothing_raised { @db.table_info("foo") } end + define_method( "test_table_info_with_defaults_for_version_3_3_8_and_higher" ) do + @db.transaction do + @db.execute "create table defaults_test ( a string default NULL, b string default 'Hello' )" + data = @db.table_info( "defaults_test" ) + assert_equal({"name" => "a", "type" => "string", "dflt_value" => nil, "notnull" => "0", "cid" => "0", "pk" => "0"}, + data[0]) + assert_equal({"name" => "b", "type" => "string", "dflt_value" => "Hello", "notnull" => "0", "cid" => "1", "pk" => "0"}, + data[1]) + end + end + define_method( "test_complete_fail" ) do assert !@db.complete?( "select * from foo" ) end -- cgit