diff options
Diffstat (limited to 'test/dialect/test_sqlite.py')
-rw-r--r-- | test/dialect/test_sqlite.py | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/test/dialect/test_sqlite.py b/test/dialect/test_sqlite.py index 7f5f553bd..c06fcc2c3 100644 --- a/test/dialect/test_sqlite.py +++ b/test/dialect/test_sqlite.py @@ -566,6 +566,19 @@ class TestAutoIncrement(TestBase, AssertsCompiledSQL): dialect=sqlite.dialect() ) + def test_sqlite_autoincrement_constraint(self): + table = Table('autoinctable', MetaData(), + Column('id', Integer, primary_key=True), + Column('x', Integer, default=None), + UniqueConstraint('x'), + sqlite_autoincrement=True) + self.assert_compile( + schema.CreateTable(table), + "CREATE TABLE autoinctable (id INTEGER NOT NULL " + "PRIMARY KEY AUTOINCREMENT, x INTEGER, UNIQUE (x))", + dialect=sqlite.dialect() + ) + def test_sqlite_no_autoincrement(self): table = Table('noautoinctable', MetaData(), Column('id', Integer, primary_key=True), |