Classe « ColumnClause »

Informations générales

Héritage

        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
                    TypingOnly
        builtins.object
            SQLRole
        builtins.object
            Generic
                TypedColumnsClauseRole
                    ExpressionElementRole
            builtins.object
                TypingOnly
        builtins.object
            Operators
                ColumnOperators
            builtins.object
                Generic
                    SQLCoreOperations
                        SQLColumnExpression
            builtins.object
                SQLRole
                    StructuralRole
                        DDLExpressionRole
                builtins.object
                    SQLRole
                        DDLConstraintColumnRole
                builtins.object
                    SQLRole
                        DMLColumnRole
                builtins.object
                    SQLRole
                        LimitOffsetRole
            builtins.object
                SQLRole
                    ColumnListRole
                builtins.object
                    UsesInspection
                builtins.object
                    AllowsLambdaRole
                        ColumnsClauseRole
        builtins.object
            SQLRole
                ColumnListRole
                    ByOfRole
                builtins.object
                    AllowsLambdaRole
                        OrderByRole
        builtins.object
            SQLRole
        builtins.object
            Generic
                TypedColumnsClauseRole
                    ExpressionElementRole
                        BinaryElementRole
        builtins.object
            SQLRole
                StructuralRole
            builtins.object
                AllowsLambdaRole
                    OnClauseRole
                        WhereHavingRole
            builtins.object
                SQLRole
                    StructuralRole
                        StatementOptionRole
            builtins.object
                SQLRole
                    ColumnArgumentRole
                        ColumnArgumentOrKeyRole
                            ColumnElement
                                KeyedColumnElement
                                    NamedColumn
                                builtins.object
                                    Immutable
                        builtins.object
                            SQLRole
                                ColumnArgumentRole
                                    StrAsPlainColumnRole
                    builtins.object
                        SQLRole
                    builtins.object
                        Generic
                            TypedColumnsClauseRole
                                ExpressionElementRole
                                    LabeledColumnExprRole
                        builtins.object
                            SQLRole
                                DDLConstraintColumnRole
                                    DDLReferredColumnRole
                                        ColumnClause

Définition

class ColumnClause(DDLReferredColumnRole, LabeledColumnExprRole, StrAsPlainColumnRole, Immutable, NamedColumn):

help(ColumnClause)

Represents a column expression from any textual string.

The :class:`.ColumnClause`, a lightweight analogue to the
:class:`_schema.Column` class, is typically invoked using the
:func:`_expression.column` function, as in::

    from sqlalchemy import column

    id, name = column("id"), column("name")
    stmt = select(id, name).select_from("user")

The above statement would produce SQL like:

.. sourcecode:: sql

    SELECT id, name FROM user

:class:`.ColumnClause` is the immediate superclass of the schema-specific
:class:`_schema.Column` object.  While the :class:`_schema.Column`
class has all the
same capabilities as :class:`.ColumnClause`, the :class:`.ColumnClause`
class is usable by itself in those cases where behavioral requirements
are limited to simple SQL expression generation.  The object has none of
the associations with schema-level metadata or with execution-time
behavior that :class:`_schema.Column` does,
so in that sense is a "lightweight"
version of :class:`_schema.Column`.

Full details on :class:`.ColumnClause` usage is at
:func:`_expression.column`.

.. seealso::

    :func:`_expression.column`

    :class:`_schema.Column`

Constructeur(s)

Signature du constructeur	Description
__init__(self, text: 'str', type_: 'Optional[_TypeEngineArgument[_T]]' = None, is_literal: 'bool' = False, _selectable: 'Optional[FromClause]' = None)

Liste des attributs statiques

Nom de l'attribut	Valeur
allows_lambda	True
base_columns	<sqlalchemy.util.langhelpers._memoized_property object at 0x0000020D9F7432A0>
comparator	<sqlalchemy.util.langhelpers.HasMemoized.memoized_attribute object at 0x0000020D9F6F0190>
default	None
description	<sqlalchemy.util.langhelpers._memoized_property object at 0x0000020D9F758590>
foreign_keys	frozenset()
inherit_cache	None
is_clause_element	True
is_dml	False
is_literal	False
is_selectable	False
key	None
onupdate	None
primary_key	False
proxy_set	<sqlalchemy.util.langhelpers._memoized_property object at 0x0000020D9F73FF50>
server_default	None
server_onupdate	None
stringify_dialect	default
supports_execution	False
table	None
timetuple	None
type	<sqlalchemy.util.langhelpers._memoized_property object at 0x0000020D9F743230>
uses_inspection	True

Liste des propriétés

Nom de la propriété	Description
anon_key_label
anon_label
entity_namespace
expression	Return a column expression. _{[extrait de expression.__doc__]}

Liste des opérateurs

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

__invert__

Liste des opérateurs

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

__add__, __contains__, __eq__, __floordiv__, __ge__, __getitem__, __gt__, __le__, __lshift__, __lt__, __mod__, __mul__, __ne__, __neg__, __radd__, __rfloordiv__, __rmod__, __rmul__, __rshift__, __rsub__, __rtruediv__, __sub__, __truediv__

Liste des opérateurs

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

__and__, __or__

Liste des méthodes

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

Signature de la méthode	Description
__class_getitem__	Parameterizes a generic class. _{[extrait de __class_getitem__.__doc__]}
get_children(self, , column_tables=False, *kw)

Méthodes héritées de la classe NamedColumn

__init_subclass__, __subclasshook__

Méthodes héritées de la classe ColumnElement

__getattr__, __setstate__, cast, label, operate, reverse_operate, self_group, shares_lineage

Méthodes héritées de la classe ClauseElement

__bool__, __getstate__, __repr__, compare, params, unique_params

Méthodes héritées de la classe CompilerElement

__str__, compile

Méthodes héritées de la classe HasMemoized

memoized_attribute, memoized_instancemethod

Méthodes héritées de la classe ColumnOperators

all_, any_, asc, between, bitwise_and, bitwise_lshift, bitwise_not, bitwise_or, bitwise_rshift, bitwise_xor, collate, concat, contains, desc, distinct, endswith, icontains, iendswith, ilike, in_, is_, is_distinct_from, is_not, is_not_distinct_from, isnot, isnot_distinct_from, istartswith, like, match, not_ilike, not_in, not_like, notilike, notin_, notlike, nulls_first, nulls_last, nullsfirst, nullslast, regexp_match, regexp_replace, startswith