diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2015-07-17 10:05:47 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2015-07-17 10:05:47 -0400 |
| commit | e02de8c4a7ecb0d79169ea90395ebf557439f08f (patch) | |
| tree | bc8ffd0314f2a2462931d5b565dada17a5bc9c59 /test | |
| parent | eed8bcef3ae1341cc9c25f5abff55a9ff880cfac (diff) | |
| parent | 66b9a71ce7457b618e9040c1c0bbc2dbd1966354 (diff) | |
| download | sqlalchemy-e02de8c4a7ecb0d79169ea90395ebf557439f08f.tar.gz | |
Merge remote-tracking branch 'origin/pr/186' into pr186
Diffstat (limited to 'test')
| -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", ) |