diff options
Diffstat (limited to 'test/sql/test_defaults.py')
| -rw-r--r-- | test/sql/test_defaults.py | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/test/sql/test_defaults.py b/test/sql/test_defaults.py index c154daa22..da91ed212 100644 --- a/test/sql/test_defaults.py +++ b/test/sql/test_defaults.py @@ -793,6 +793,36 @@ class SequenceDDLTest(fixtures.TestBase, testing.AssertsCompiledSQL): ) self.assert_compile( + CreateSequence(Sequence( + 'foo_seq', increment=2, start=0, minvalue=0)), + "CREATE SEQUENCE foo_seq INCREMENT BY 2 START WITH 0 MINVALUE 0", + ) + + self.assert_compile( + CreateSequence(Sequence( + 'foo_seq', increment=2, start=1, maxvalue=5)), + "CREATE SEQUENCE foo_seq INCREMENT BY 2 START WITH 0 MAXVALUE 5", + ) + + 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( + CreateSequence(Sequence( + 'foo_seq', start=1, maxvalue=10, cycle=True)), + "CREATE SEQUENCE foo_seq START WITH 1 MAXVALUE 10 CYCLE", + ) + + self.assert_compile( DropSequence(Sequence('foo_seq')), "DROP SEQUENCE foo_seq", ) |