diff options
| author | mike bayer <mike_mp@zzzcomputing.com> | 2020-11-09 15:56:15 +0000 |
|---|---|---|
| committer | Gerrit Code Review <gerrit@bbpush.zzzcomputing.com> | 2020-11-09 15:56:15 +0000 |
| commit | b3f2f08f4870877d689b987747d7db5baa7aca75 (patch) | |
| tree | 2b7fb2f5a8e8e0eb6d792c2afea50867846ae8a2 /test/dialect/test_sqlite.py | |
| parent | 89ddd0b8976ed695d239898a2a8e4ebf531537f2 (diff) | |
| parent | 4b39b0f89dfd47dc9f5ba948e564c2afbbd44fef (diff) | |
| download | sqlalchemy-b3f2f08f4870877d689b987747d7db5baa7aca75.tar.gz | |
Merge "Support SQLite WITHOUT ROWID tables"
Diffstat (limited to 'test/dialect/test_sqlite.py')
| -rw-r--r-- | test/dialect/test_sqlite.py | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/test/dialect/test_sqlite.py b/test/dialect/test_sqlite.py index 10e43b221..456bad7bd 100644 --- a/test/dialect/test_sqlite.py +++ b/test/dialect/test_sqlite.py @@ -1162,6 +1162,16 @@ class SQLTest(fixtures.TestBase, AssertsCompiledSQL): ), ) + def test_create_table_without_rowid(self): + m = MetaData() + tbl = Table( + "atable", m, Column("id", Integer), sqlite_with_rowid=False + ) + self.assert_compile( + schema.CreateTable(tbl), + "CREATE TABLE atable (id INTEGER) WITHOUT ROWID", + ) + class OnConflictDDLTest(fixtures.TestBase, AssertsCompiledSQL): |