diff options
| author | jakeogh <github.com@v6y.net> | 2015-06-27 18:48:46 +0000 |
|---|---|---|
| committer | jakeogh <github.com@v6y.net> | 2015-06-27 18:48:46 +0000 |
| commit | 85ebe01349e0b4314d9e25cacc6701d6fed7b87e (patch) | |
| tree | 051d0ba290a3f5407922b86cc2c0de3eae0d849b /test/sql | |
| parent | ad7caa69884bddf6f35da2facc516ab08904c71e (diff) | |
| download | sqlalchemy-85ebe01349e0b4314d9e25cacc6701d6fed7b87e.tar.gz | |
add NO MINVALUE and NO MAXVALUE support to Sequence()
Diffstat (limited to 'test/sql')
| -rw-r--r-- | test/sql/test_defaults.py | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/test/sql/test_defaults.py b/test/sql/test_defaults.py index b218aa53f..53eb6c500 100644 --- a/test/sql/test_defaults.py +++ b/test/sql/test_defaults.py @@ -805,6 +805,18 @@ class SequenceDDLTest(fixtures.TestBase, testing.AssertsCompiledSQL): ) self.assert_compile( + CreateSequence(Sequence( + 'foo_seq', increment=2, start=1, nomaxvalue=True)), + "CREATE SEQUENCE foo_seq INCREMENT BY 2 START WITH 0 NO MAXVALUE", + ) + + self.assert_compile( + CreateSequence(Sequence( + 'foo_seq', increment=2, start=0, nominvalue=True)), + "CREATE SEQUENCE foo_seq INCREMENT BY 2 START WITH 0 NO MINVALUE", + ) + + self.assert_compile( DropSequence(Sequence('foo_seq')), "DROP SEQUENCE foo_seq", ) |