diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2021-07-12 14:28:19 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2021-07-12 17:10:58 -0400 |
| commit | 204ff1f60cf911b00b7494942fc58bc715dddeed (patch) | |
| tree | f26659888176bfaed484f6f462efd0414542633a /lib/sqlalchemy/sql/dml.py | |
| parent | ca52e87268fec966f6005b1e4aa30206ae895e9e (diff) | |
| download | sqlalchemy-204ff1f60cf911b00b7494942fc58bc715dddeed.tar.gz | |
implement independent CTEs
Added new method :meth:`_sql.HasCTE.add_cte` to each of the
:func:`_sql.select`, :func:`_sql.insert`, :func:`_sql.update` and
:func:`_sql.delete` constructs. This method will add the given
:class:`_sql.CTE` as an "independent" CTE of the statement, meaning it
renders in the WITH clause above the statement unconditionally even if it
is not otherwise referenced in the primary statement. This is a popular use
case on the PostgreSQL database where a CTE is used for a DML statement
that runs against database rows independently of the primary statement.
Fixes: #6752
Change-Id: Ibf635763e40269cbd10f4c17e208850d8e8d0188
Diffstat (limited to 'lib/sqlalchemy/sql/dml.py')
| -rw-r--r-- | lib/sqlalchemy/sql/dml.py | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/lib/sqlalchemy/sql/dml.py b/lib/sqlalchemy/sql/dml.py index dd012ac86..048475040 100644 --- a/lib/sqlalchemy/sql/dml.py +++ b/lib/sqlalchemy/sql/dml.py @@ -829,6 +829,7 @@ class Insert(ValuesBase): + HasPrefixes._has_prefixes_traverse_internals + DialectKWArgs._dialect_kwargs_traverse_internals + Executable._executable_traverse_internals + + HasCTE._has_ctes_traverse_internals ) @ValuesBase._constructor_20_deprecations( @@ -1119,6 +1120,7 @@ class Update(DMLWhereBase, ValuesBase): + HasPrefixes._has_prefixes_traverse_internals + DialectKWArgs._dialect_kwargs_traverse_internals + Executable._executable_traverse_internals + + HasCTE._has_ctes_traverse_internals ) @ValuesBase._constructor_20_deprecations( @@ -1357,6 +1359,7 @@ class Delete(DMLWhereBase, UpdateBase): + HasPrefixes._has_prefixes_traverse_internals + DialectKWArgs._dialect_kwargs_traverse_internals + Executable._executable_traverse_internals + + HasCTE._has_ctes_traverse_internals ) @ValuesBase._constructor_20_deprecations( |