summaryrefslogtreecommitdiff
path: root/test/dialect/test_sqlite.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/dialect/test_sqlite.py')
-rw-r--r--test/dialect/test_sqlite.py13
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),