From fb97a666bb6e352ae908d763d2d8ac3c087cd529 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sun, 10 Apr 2011 10:47:34 -0400 Subject: - Fixed bug where reflection of foreign key created as "REFERENCES " without col name would fail. [ticket:2115] (also in 0.6.7) --- test/dialect/test_sqlite.py | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) (limited to 'test/dialect/test_sqlite.py') diff --git a/test/dialect/test_sqlite.py b/test/dialect/test_sqlite.py index c50bc69c6..20e3419c4 100644 --- a/test/dialect/test_sqlite.py +++ b/test/dialect/test_sqlite.py @@ -667,3 +667,22 @@ class AutoIncrementTest(fixtures.TestBase, AssertsCompiledSQL): 'CREATE TABLE autoinctable (id INTEGER NOT ' 'NULL PRIMARY KEY AUTOINCREMENT)', dialect=sqlite.dialect()) + + +class ReflectHeadlessFKsTest(fixtures.TestBase): + def setup(self): + testing.db.execute("CREATE TABLE a (id INTEGER PRIMARY KEY)") + testing.db.execute("CREATE TABLE b (id INTEGER PRIMARY KEY REFERENCES a)") + + def teardown(self): + testing.db.execute("drop table b") + testing.db.execute("drop table a") + + def test_reflect_tables_fk_no_colref(self): + meta = MetaData() + a = Table('a', meta, autoload=True, autoload_with=testing.db) + b = Table('b', meta, autoload=True, autoload_with=testing.db) + + assert b.c.id.references(a.c.id) + + -- cgit v1.2.1