Classe « TextClause »

Informations générales

Héritage

                builtins.object
                    Generic
                        Inspectable
        builtins.object
            SQLRole
        builtins.object
            Generic
                TypedColumnsClauseRole
                    ExpressionElementRole
                        BinaryElementRole
        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
                        DQLDMLClauseElement
            builtins.object
                SQLRole
                    StatementRole
                        Executable
                builtins.object
                    HasMemoized
                        Generative
                builtins.object
                    SQLRole
                        InElementRole
            builtins.object
                SQLRole
                    ReturnsRowsRole
            builtins.object
                SQLRole
                    StatementRole
                        SelectStatementRole
        builtins.object
            SQLRole
                StructuralRole
            builtins.object
                UsesInspection
            builtins.object
                AllowsLambdaRole
                    JoinTargetRole
        builtins.object
            SQLRole
                ColumnListRole
            builtins.object
                UsesInspection
            builtins.object
                AllowsLambdaRole
                    ColumnsClauseRole
                        FromClauseRole
        builtins.object
            SQLRole
                ColumnListRole
                    ByOfRole
                builtins.object
                    AllowsLambdaRole
                        OrderByRole
        builtins.object
            SQLRole
                StructuralRole
            builtins.object
                AllowsLambdaRole
                    OnClauseRole
                        WhereHavingRole
            builtins.object
                SQLRole
                    StructuralRole
                        StatementOptionRole
            builtins.object
                SQLRole
                    StructuralRole
                        DDLExpressionRole
                builtins.object
                    SQLRole
                        DDLConstraintColumnRole
                            TextClause

Définition

class TextClause(DDLConstraintColumnRole, DDLExpressionRole, StatementOptionRole, WhereHavingRole, OrderByRole, FromClauseRole, SelectStatementRole, InElementRole, Generative, Executable, DQLDMLClauseElement, BinaryElementRole, Inspectable):

help(TextClause)

Represent a literal SQL text fragment.

E.g.::

    from sqlalchemy import text

    t = text("SELECT * FROM users")
    result = connection.execute(t)

The :class:`_expression.TextClause` construct is produced using the
:func:`_expression.text`
function; see that function for full documentation.

.. seealso::

    :func:`_expression.text`

Constructeur(s)

Signature du constructeur	Description
__init__(self, text: 'str')

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_delete	False
is_dml	False
is_from_statement	False
is_insert	False
is_select	False
is_selectable	False
is_text	False
is_update	False
key	None
stringify_dialect	default
supports_execution	True
uses_inspection	True

Liste des propriétés

Nom de la propriété	Description
comparator
entity_namespace
type

Liste des opérateurs

Signature de l'opérateur	Description
__and__(self, other)

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
bindparams(self, binds: 'BindParameter[Any]', *names_to_values: 'Any') -> 'Self'	Establish the values and/or types of bound parameters within _{[extrait de bindparams.__doc__]}
columns(self, cols: '_ColumnExpressionArgument[Any]', *types: '_TypeEngineArgument[Any]') -> 'TextualSelect'	Turn this :class:`_expression.TextClause` object into a _{[extrait de columns.__doc__]}
self_group(self, against: 'Optional[OperatorType]' = None) -> 'Union[Self, Grouping[Any]]'