From 85c04dd0bb9d0f140dde25e3901b172ebb431f7e Mon Sep 17 00:00:00 2001 From: Jon Nelson Date: Fri, 14 Nov 2014 19:53:28 -0600 Subject: [PATCH] - add test_get_unnamed_unique_constraints to SQLite reflection tests --- test/dialect/test_sqlite.py | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) diff --git a/test/dialect/test_sqlite.py b/test/dialect/test_sqlite.py index 22772d2fb6..b4524dc273 100644 --- a/test/dialect/test_sqlite.py +++ b/test/dialect/test_sqlite.py @@ -603,6 +603,24 @@ class DialectTest(fixtures.TestBase, AssertsExecutionResults): eq_(inspector.get_unique_constraints('bar'), [{'column_names': [u'b'], 'name': u'bar_b'}]) + def test_get_unnamed_unique_constraints(self): + meta = MetaData(testing.db) + t1 = Table('foo', meta, Column('f', Integer), + UniqueConstraint('f')) + t2 = Table('bar', meta, Column('b', Integer), + UniqueConstraint('b'), + prefixes=['TEMPORARY']) + meta.create_all() + from sqlalchemy.engine.reflection import Inspector + try: + inspector = Inspector(testing.db) + eq_(inspector.get_unique_constraints('foo'), + [{'column_names': [u'f'], 'name': u''}]) + eq_(inspector.get_unique_constraints('bar'), + [{'column_names': [u'b'], 'name': u''}]) + finally: + meta.drop_all() + class AttachedMemoryDBTest(fixtures.TestBase): __only_on__ = 'sqlite' -- 2.47.3