diff options
| author | Jesse Bakker <github@jessebakker.com> | 2022-09-06 16:00:10 -0400 |
|---|---|---|
| committer | mike bayer <mike_mp@zzzcomputing.com> | 2022-10-04 02:40:20 +0000 |
| commit | b6eed88ef4ebb3fd7035b4e366bf6653ebb26d15 (patch) | |
| tree | e98e19d6fa7b236cf2fc7eed3ffc96c805b80667 /test/sql/test_sequences.py | |
| parent | d5905ccd7df000143194975f8f3d72fcef0672e3 (diff) | |
| download | sqlalchemy-b6eed88ef4ebb3fd7035b4e366bf6653ebb26d15.tar.gz | |
Make if_exists and if_not_exists flags on ddl statements match compiler
Added ``if_exists`` and ``if_not_exists`` parameters for all "Create" /
"Drop" constructs including :class:`.CreateSequence`,
:class:`.DropSequence`, :class:`.CreateIndex`, :class:`.DropIndex`, etc.
allowing generic "IF EXISTS" / "IF NOT EXISTS" phrases to be rendered
within DDL. Pull request courtesy Jesse Bakker.
Fixes: #7354
Closes: #8492
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/8492
Pull-request-sha: d107c6ce553bd430111607815f5b3938ffc4770c
Change-Id: I367e57b2d9216f5180bcc44e86ca6f3dc794e5ca
Diffstat (limited to 'test/sql/test_sequences.py')
| -rw-r--r-- | test/sql/test_sequences.py | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/test/sql/test_sequences.py b/test/sql/test_sequences.py index 19f95c661..457aeb960 100644 --- a/test/sql/test_sequences.py +++ b/test/sql/test_sequences.py @@ -93,9 +93,19 @@ class SequenceDDLTest(fixtures.TestBase, testing.AssertsCompiledSQL): ) self.assert_compile( + CreateSequence(Sequence("foo_seq"), if_not_exists=True), + "CREATE SEQUENCE IF NOT EXISTS foo_seq START WITH 1", + ) + + self.assert_compile( DropSequence(Sequence("foo_seq")), "DROP SEQUENCE foo_seq" ) + self.assert_compile( + DropSequence(Sequence("foo_seq"), if_exists=True), + "DROP SEQUENCE IF EXISTS foo_seq", + ) + class SequenceExecTest(fixtures.TestBase): __requires__ = ("sequences",) |