Module « sqlalchemy »

Classe « Column »

Informations générales

Héritage

        builtins.object
            Traversible
        builtins.object
            HasCopyInternals
    builtins.object
        HasMemoized
    builtins.object
        HasCacheKey
            MemoizedHasCacheKey
    builtins.object
        SupportsAnnotations
            SupportsWrappingAnnotations
        builtins.object
            SQLRole
                ClauseElement
        builtins.object
            Operators
                ColumnOperators
    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
            ExpressionElementRole
                BinaryElementRole
builtins.object
    SQLRole
        StructuralRole
    builtins.object
        AllowsLambdaRole
            OnClauseRole
                WhereHavingRole
    builtins.object
        SQLRole
            StructuralRole
                StatementOptionRole
    builtins.object
        SQLRole
            ColumnArgumentRole
                ColumnArgumentOrKeyRole
                    ColumnElement
                        NamedColumn
                    builtins.object
                        Immutable
            builtins.object
                SQLRole
                    ColumnArgumentRole
                        StrAsPlainColumnRole
            builtins.object
                SQLRole
                    ExpressionElementRole
                        LabeledColumnExprRole
            builtins.object
                SQLRole
                    DDLConstraintColumnRole
                        DDLReferredColumnRole
                            ColumnClause
                    builtins.object
                        Traversible
                    builtins.object
                        SchemaEventTarget
                            SchemaItem
                        builtins.object
                            DialectKWArgs
                                Column

Définition

class Column(DialectKWArgs, SchemaItem, ColumnClause):

Description _{[extrait de Column.doc]}

Represents a column in a database table.

Constructeur(s)

Signature du constructeur	Description
__init__(self, args, *kwargs)

Liste des attributs statiques

Nom de l'attribut	Valeur
allows_lambda	True
base_columns	<sqlalchemy.util.langhelpers.memoized_property object at 0x7f40cbdd6800>
bind	None
comparator	<sqlalchemy.util.langhelpers.HasMemoized.memoized_attribute object at 0x7f40cbdd67a0>
create_drop_stringify_dialect	default
default	None
description	<sqlalchemy.util.langhelpers.memoized_property object at 0x7f40cbc05030>
dialect_kwargs	<sqlalchemy.util.langhelpers.memoized_property object at 0x7f40cbecc6d0>
dialect_options	<sqlalchemy.util.langhelpers.memoized_property object at 0x7f40cbece8c0>
dispatch	<sqlalchemy.event.base.DDLEventsDispatch object at 0x7f40cbc2af40>
foreign_keys	None
index	None
info	<sqlalchemy.util.langhelpers.memoized_property object at 0x7f40cbc85d20>
inherit_cache	True
is_clause_element	True
is_literal	False
is_selectable	False
key	None
onupdate	None
primary_key	False
proxy_set	<sqlalchemy.util.langhelpers.memoized_property object at 0x7f40cbdd6860>
server_default	None
server_onupdate	None
stringify_dialect	default
supports_execution	False
table	None
timetuple	None
type	<sqlalchemy.util.langhelpers.memoized_property object at 0x7f40cbdd6740>
unique	None
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 __doc__]}
kwargs	A synonym for :attr:`.DialectKWArgs.dialect_kwargs`. _{[extrait de __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__, __ge__, __getitem__, __gt__, __le__, __lshift__, __lt__, __mod__, __mul__, __ne__, __neg__, __radd__, __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
__repr__(self)
__str__(self)
append_foreign_key(self, fk)
copy(self, **kw)
references(self, column)	Return True if this Column references the given column via foreign _{[extrait de references.__doc__]}

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

__init_subclass__, __subclasshook__, get_children

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

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

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

__bool__, __getstate__, __nonzero__, compare, compile, params, unique_params

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

memoized_attribute, memoized_instancemethod

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

__div__, __rdiv__, all_, any_, asc, between, collate, concat, contains, desc, distinct, endswith, ilike, in_, is_, is_distinct_from, is_not, is_not_distinct_from, isnot, isnot_distinct_from, like, match, not_ilike, not_in, not_like, notilike, notin_, notlike, nulls_first, nulls_last, nullsfirst, nullslast, regexp_match, regexp_replace, startswith