From c7ab095fdbb13d045376df3f997a30058d7c82dd Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sun, 23 Sep 2012 11:30:07 -0400 Subject: - [bug] Adjusted column default reflection code to convert non-string values to string, to accommodate old SQLite versions that don't deliver default info as a string. [ticket:2265] - factor sqlite column reflection to be like we did for postgresql, in a separate method. --- test/dialect/test_sqlite.py | 15 ++++++++++++++- 1 file changed, 14 insertions(+), 1 deletion(-) (limited to 'test/dialect/test_sqlite.py') diff --git a/test/dialect/test_sqlite.py b/test/dialect/test_sqlite.py index cfc49af12..3f714b825 100644 --- a/test/dialect/test_sqlite.py +++ b/test/dialect/test_sqlite.py @@ -346,7 +346,7 @@ class DefaultsTest(fixtures.TestBase, AssertsCompiledSQL): @testing.provide_metadata def test_boolean_default(self): - t= Table("t", self.metadata, + t = Table("t", self.metadata, Column("x", Boolean, server_default=sql.false())) t.create(testing.db) testing.db.execute(t.insert()) @@ -356,6 +356,19 @@ class DefaultsTest(fixtures.TestBase, AssertsCompiledSQL): [(False,), (True,)] ) + def test_old_style_default(self): + """test non-quoted integer value on older sqlite pragma""" + + dialect = sqlite.dialect() + eq_( + dialect._get_column_info("foo", "INTEGER", False, 3, False), + {'primary_key': False, 'nullable': False, + 'default': '3', 'autoincrement': False, + 'type': INTEGER, 'name': 'foo'} + ) + + + class DialectTest(fixtures.TestBase, AssertsExecutionResults): -- cgit v1.2.1