diff options
Diffstat (limited to 'test/sql/indexes.py')
| -rw-r--r-- | test/sql/indexes.py | 23 |
1 files changed, 20 insertions, 3 deletions
diff --git a/test/sql/indexes.py b/test/sql/indexes.py index ec72beda3..e9af301de 100644 --- a/test/sql/indexes.py +++ b/test/sql/indexes.py @@ -5,16 +5,33 @@ import sys class IndexTest(testbase.AssertMixin): def setUp(self): - global metadata - metadata = BoundMetaData(testbase.db) + global metadata + metadata = BoundMetaData(testbase.db) self.echo = testbase.db.echo self.logger = testbase.db.logger def tearDown(self): testbase.db.echo = self.echo testbase.db.logger = testbase.db.engine.logger = self.logger - metadata.drop_all() + metadata.drop_all() + def test_constraint(self): + employees = Table('employees', metadata, + Column('id', Integer), + Column('soc', String(40)), + Column('name', String(30)), + PrimaryKeyConstraint('id', 'soc') + ) + elements = Table('elements', metadata, + Column('id', Integer), + Column('stuff', String(30)), + Column('emp_id', Integer), + Column('emp_soc', String(40)), + PrimaryKeyConstraint('id'), + ForeignKeyConstraint(['emp_id', 'emp_soc'], ['employees.id', 'employees.soc']) + ) + metadata.create_all() + def test_index_create(self): employees = Table('employees', metadata, Column('id', Integer, primary_key=True), |