Classe « TableClause »

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
                    SQLRole
                        ReturnsRowsRole
                            ReturnsRows
                                Selectable
        builtins.object
            SQLRole
                StructuralRole
            builtins.object
                UsesInspection
            builtins.object
                AllowsLambdaRole
                    JoinTargetRole
        builtins.object
            SQLRole
                ColumnListRole
            builtins.object
                UsesInspection
            builtins.object
                AllowsLambdaRole
                    ColumnsClauseRole
                        FromClauseRole
                            StrictFromClauseRole
                                AnonymizedFromClauseRole
                                    FromClause
                                        NamedFromClause
                                    builtins.object
                                        Immutable
                    builtins.object
                        SQLRole
                            StructuralRole
                        builtins.object
                            UsesInspection
                        builtins.object
                            AllowsLambdaRole
                                JoinTargetRole
                    builtins.object
                        SQLRole
                            ColumnListRole
                        builtins.object
                            UsesInspection
                        builtins.object
                            AllowsLambdaRole
                                ColumnsClauseRole
                                    FromClauseRole
                                        DMLTableRole
                                            TableClause

Définition

class TableClause(DMLTableRole, Immutable, NamedFromClause):

help(TableClause)

Represents a minimal "table" construct.

This is a lightweight table object that has only a name, a
collection of columns, which are typically produced
by the :func:`_expression.column` function, and a schema::

    from sqlalchemy import table, column

    user = table(
        "user",
        column("id"),
        column("name"),
        column("description"),
    )

The :class:`_expression.TableClause` construct serves as the base for
the more commonly used :class:`_schema.Table` object, providing
the usual set of :class:`_expression.FromClause` services including
the ``.c.`` collection and statement generation methods.

It does **not** provide all the additional schema-level services
of :class:`_schema.Table`, including constraints, references to other
tables, or support for :class:`_schema.MetaData`-level services.
It's useful
on its own as an ad-hoc construct used to generate quick SQL
statements when a more fully fledged :class:`_schema.Table`
is not on hand.

Constructeur(s)

Signature du constructeur	Description
__init__(self, name: 'str', columns: 'ColumnClause[Any]', *kw: 'Any')

Liste des attributs statiques

Nom de l'attribut	Valeur
allows_lambda	True
c	<sqlalchemy.util.langhelpers._memoized_property object at 0x0000020D9F9374D0>
columns	<sqlalchemy.util.langhelpers._non_memoized_property object at 0x0000020D9F937590>
description	<sqlalchemy.util.langhelpers._memoized_property object at 0x0000020D9F937CB0>
entity_namespace	<sqlalchemy.util.langhelpers._non_memoized_property object at 0x0000020D9F9375F0>
exported_columns	<sqlalchemy.util.langhelpers._non_memoized_property object at 0x0000020D9F937470>
foreign_keys	<sqlalchemy.util.langhelpers._memoized_property object at 0x0000020D9F9376B0>
implicit_returning	False
inherit_cache	None
is_clause_element	True
is_dml	False
is_selectable	True
named_with_column	True
primary_key	<sqlalchemy.util.langhelpers._memoized_property object at 0x0000020D9F937650>
schema	None
stringify_dialect	default
supports_execution	False
uses_inspection	True

Liste des propriétés

Nom de la propriété	Description
selectable

Propriétés héritées de la classe Selectable

entity_namespace, exported_columns

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 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
__str__(self) -> 'str'
append_column(self, c: 'ColumnClause[Any]') -> 'None'
delete(self) -> 'Delete'	Generate a :func:`_expression.delete` construct against this _{[extrait de delete.__doc__]}
insert(self) -> 'util.preloaded.sql_dml.Insert'	Generate an :class:`_sql.Insert` construct against this _{[extrait de insert.__doc__]}
update(self) -> 'Update'	Generate an :func:`_expression.update` construct against this _{[extrait de update.__doc__]}