sqlalchemy.sql.selectable.HasSuffixes

class documentation

class HasSuffixes(object):

Known subclasses: sqlalchemy.orm.query.Query, sqlalchemy.sql.expression.Select, sqlalchemy.sql.selectable.CTE

View In Hierarchy

Undocumented

Method ​_setup​_suffixes Undocumented
Method suffix​_with Add one or more expressions following the statement as a whole.
Class Variable ​_has​_suffixes​_traverse​_internals Undocumented
Instance Variable ​_suffixes Undocumented
def _setup_suffixes(self, suffixes, dialect=None):

Undocumented

@_generative
@_document_text_coercion('expr', ':meth:`_expression.HasSuffixes.suffix_with`', ':paramref:`.HasSuffixes.suffix_with.*expr`')
def suffix_with(self, *expr, **kw):

Add one or more expressions following the statement as a whole.

This is used to support backend-specific suffix keywords on certain constructs.

E.g.:

stmt = select(col1, col2).cte().suffix_with(
    "cycle empno set y_cycle to 1 default 0", dialect="oracle")

Multiple suffixes can be specified by multiple calls to _expression.HasSuffixes.suffix_with.

Parameters
*exprtextual or _expression.ClauseElement construct which will be rendered following the target clause.
**kwA single keyword 'dialect' is accepted. This is an optional string dialect name which will limit rendering of this suffix to only that dialect.
_has_suffixes_traverse_internals =

Undocumented

_suffixes =
overridden in sqlalchemy.sql.selectable.CTE

Undocumented