summaryrefslogtreecommitdiff
path: root/test/sql/test_defaults.py
diff options
context:
space:
mode:
authorjakeogh <github.com@v6y.net>2015-06-27 18:37:09 +0000
committerjakeogh <github.com@v6y.net>2015-06-27 18:37:09 +0000
commitad7caa69884bddf6f35da2facc516ab08904c71e (patch)
tree75b3af57694a2a773b105f179fb5e45deaf3bd42 /test/sql/test_defaults.py
parentf31c288b65281511338c518bdf7fbe78c985af58 (diff)
downloadsqlalchemy-ad7caa69884bddf6f35da2facc516ab08904c71e.tar.gz
add MAXVALUE support to Sequence()
Diffstat (limited to 'test/sql/test_defaults.py')
-rw-r--r--test/sql/test_defaults.py9
1 files changed, 8 insertions, 1 deletions
diff --git a/test/sql/test_defaults.py b/test/sql/test_defaults.py
index 9aebfc010..b218aa53f 100644
--- a/test/sql/test_defaults.py
+++ b/test/sql/test_defaults.py
@@ -793,11 +793,18 @@ class SequenceDDLTest(fixtures.TestBase, testing.AssertsCompiledSQL):
)
self.assert_compile(
- CreateSequence(Sequence('foo_seq', increment=2, start=0, minvalue=0)),
+ 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(
DropSequence(Sequence('foo_seq')),
"DROP SEQUENCE foo_seq",
)