Classe « StatementLambdaElement »

Informations générales

Héritage

            builtins.object
                SQLRole
                    StatementRole
                        Executable
        builtins.object
            Visitable
                CompilerElement
        builtins.object
            Visitable
        builtins.object
            HasTraverseInternals
                ExternallyTraversible
        builtins.object
            HasTraverseInternals
                HasCopyInternals
        builtins.object
            HasMemoized
        builtins.object
            HasCacheKey
                MemoizedHasCacheKey
builtins.object
    Visitable
builtins.object
    HasTraverseInternals
        ExternallyTraversible
            SupportsAnnotations
                SupportsWrappingAnnotations
                    ClauseElement
                        LambdaElement
                    builtins.object
                        AllowsLambdaRole
                            StatementLambdaElement

Définition

class StatementLambdaElement(AllowsLambdaRole, LambdaElement, Executable):

help(StatementLambdaElement)

Represent a composable SQL statement as a :class:`_sql.LambdaElement`.

The :class:`_sql.StatementLambdaElement` is constructed using the
:func:`_sql.lambda_stmt` function::


    from sqlalchemy import lambda_stmt

    stmt = lambda_stmt(lambda: select(table))

Once constructed, additional criteria can be built onto the statement
by adding subsequent lambdas, which accept the existing statement
object as a single parameter::

    stmt += lambda s: s.where(table.c.col == parameter)

.. versionadded:: 1.4

.. seealso::

    :ref:`engine_lambda_caching`

Constructeur(s)

Signature du constructeur	Description
__init__(self, fn: '_LambdaType', role: 'Type[SQLRole]', opts: 'Union[Type[LambdaOptions], LambdaOptions]' = <class 'sqlalchemy.sql.lambdas.LambdaOptions'>, apply_propagate_attrs: 'Optional[ClauseElement]' = None)

Liste des attributs statiques

Nom de l'attribut	Valeur
allows_lambda	True
description	<sqlalchemy.util.langhelpers._memoized_property object at 0x0000020D9F723AD0>
inherit_cache	None
is_clause_element	True
is_from_statement	False
is_selectable	False
parent_lambda	None
stringify_dialect	default
supports_execution	False
uses_inspection	False

Attributs statiques hérités de la classe Executable

is_delete, is_dml, is_insert, is_select, is_text, is_update

Liste des propriétés

Nom de la propriété	Description
entity_namespace
is_delete
is_dml
is_insert
is_select
is_text
is_update

Liste des opérateurs

Signature de l'opérateur	Description
__add__(self, other: '_StmtLambdaElementType[Any]') -> 'StatementLambdaElement'

Opérateurs hérités de la classe ClauseElement

__invert__

Opérateurs hérités de la classe object

__eq__, __ge__, __gt__, __le__, __lt__, __ne__

Liste des méthodes

Toutes les méthodes Méthodes d'instance Méthodes statiques

Signature de la méthode	Description
add_criteria(self, other: '_StmtLambdaElementType[Any]', enable_tracking: 'bool' = True, track_on: 'Optional[Any]' = None, track_closure_variables: 'bool' = True, track_bound_values: 'bool' = True) -> 'StatementLambdaElement'	Add new criteria to this :class:`_sql.StatementLambdaElement`. _{[extrait de add_criteria.__doc__]}
spoil(self) -> 'NullLambdaStatement'	Return a new :class:`.StatementLambdaElement` that will run _{[extrait de spoil.__doc__]}