summaryrefslogtreecommitdiff
path: root/test/engine/test_reflection.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/engine/test_reflection.py')
-rw-r--r--test/engine/test_reflection.py20
1 files changed, 20 insertions, 0 deletions
diff --git a/test/engine/test_reflection.py b/test/engine/test_reflection.py
index 1dc65d7d0..62568eb4a 100644
--- a/test/engine/test_reflection.py
+++ b/test/engine/test_reflection.py
@@ -981,6 +981,26 @@ class ReflectionTest(fixtures.TestBase, ComparesTables):
assert set([t2.c.name, t2.c.id]) == set(r2.columns)
assert set([t2.c.name]) == set(r3.columns)
+ @testing.requires.check_constraint_reflection
+ @testing.provide_metadata
+ def test_check_constraint_reflection(self):
+ m1 = self.metadata
+ Table(
+ 'x', m1,
+ Column('q', Integer),
+ sa.CheckConstraint('q > 10', name="ck1")
+ )
+ m1.create_all()
+ m2 = MetaData(testing.db)
+ t2 = Table('x', m2, autoload=True)
+
+ ck = [
+ const for const in
+ t2.constraints if isinstance(const, sa.CheckConstraint)][0]
+
+ eq_(ck.sqltext.text, "q > 10")
+ eq_(ck.name, "ck1")
+
@testing.provide_metadata
def test_index_reflection_cols_busted(self):
t = Table('x', self.metadata,