sqlalchemy.sql.selectable.TableClause

class documentation

class TableClause(roles.DMLTableRole, Immutable, NamedFromClause): (source)

Known subclasses: sqlalchemy.sql.schema.Table

View In Hierarchy

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.

Method __init__ Undocumented
Method __str__ Undocumented
Method append_column Undocumented
Method delete Generate a :func:`_expression.delete` construct against this :class:`_expression.TableClause`.
Method insert Generate an :class:`_sql.Insert` construct against this :class:`_expression.TableClause`.
Method update Generate an :func:`_expression.update` construct against this :class:`_expression.TableClause`.
Class Variable __visit_name__ Undocumented
Class Variable implicit_returning :class:`_expression.TableClause` doesn't support having a primary key or column -level defaults, so implicit returning doesn't apply.
Instance Variable foreign_keys Return the collection of :class:`_schema.ForeignKey` marker objects which this FromClause references.
Instance Variable fullname Undocumented
Instance Variable name Undocumented
Instance Variable primary_key Return the iterable collection of :class:`_schema.Column` objects which comprise the primary key of this :class:`_selectable.FromClause`.
Instance Variable schema Define the 'schema' attribute for this :class:`_expression.FromClause`.
Property c A synonym for :attr:`.FromClause.columns`
Property columns A named-based collection of :class:`_expression.ColumnElement` objects maintained by this :class:`_expression.FromClause`.
Property description A brief description of this :class:`_expression.FromClause`.
Method _init_collections Undocumented
Method _refresh_for_new_column Given a column added to the .c collection of an underlying selectable, produce the local version of that column, assuming this selectable ultimately should proxy this column.
Class Variable _is_table Undocumented
Class Variable _traverse_internals Undocumented
Instance Variable _columns Undocumented
Property _autoincrement_column No PK or default support so no autoincrement column.
Property _from_objects Undocumented

Inherited from DMLTableRole:

Class Variable __slots__ Undocumented
Class Variable _role_name Undocumented

Inherited from Immutable (via DMLTableRole):

Method params Undocumented
Method unique_params Undocumented
Method _clone Undocumented
Method _copy_internals Undocumented
Class Variable _is_immutable Undocumented

Inherited from NamedFromClause (via DMLTableRole, Immutable):

Method table_valued Return a :class:`_sql.TableValuedColumn` object for this :class:`_expression.FromClause`.
Class Variable named_with_column Undocumented

Inherited from FromClause (via DMLTableRole, Immutable, NamedFromClause):

Method alias Return an alias of this :class:`_expression.FromClause`.
Method is_derived_from Return ``True`` if this :class:`_expression.FromClause` is 'derived' from the given ``FromClause``.
Method join Return a :class:`_expression.Join` from this :class:`_expression.FromClause` to another :class:`FromClause`.
Method outerjoin Return a :class:`_expression.Join` from this :class:`_expression.FromClause` to another :class:`FromClause`, with the "isouter" flag set to True.
Method select Return a SELECT of this :class:`_expression.FromClause`.
Method self_group Apply a 'grouping' to this :class:`_expression.ClauseElement`.
Method tablesample Return a TABLESAMPLE alias of this :class:`_expression.FromClause`.
Class Variable is_selectable Undocumented
Property entity_namespace Return a namespace used for name-based access in SQL expressions.
Property exported_columns A :class:`_expression.ColumnCollection` that represents the "exported" columns of this :class:`_expression.Selectable`.
Method _anonymous_fromclause Undocumented
Method _generate_fromclause_column_proxies Populate columns into an :class:`.AliasedReturnsRows` object.
Method _is_lexical_equivalent Return ``True`` if this :class:`_expression.FromClause` and the other represent the same lexical identity.
Method _populate_column_collection Called on subclasses to establish the .c collection.
Method _reset_column_collection Reset the attributes linked to the ``FromClause.c`` attribute.
Class Variable _is_clone_of Undocumented
Class Variable _is_from_clause Undocumented
Class Variable _is_join Undocumented
Class Variable _use_schema_map Undocumented
Property _cols_populated Undocumented
Property _hide_froms Undocumented
Property _select_iterable Undocumented

Inherited from FromClauseRole (via DMLTableRole, Immutable, NamedFromClause, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole):

Class Variable _is_subquery Undocumented

Inherited from AllowsLambdaRole (via DMLTableRole, Immutable, NamedFromClause, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole):

Class Variable allows_lambda Undocumented

Inherited from UsesInspection (via DMLTableRole, Immutable, NamedFromClause, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole):

Class Variable uses_inspection Undocumented
Class Variable _post_inspect Undocumented

Inherited from Selectable (via DMLTableRole, Immutable, NamedFromClause, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, UsesInspection, ColumnListRole, StructuralRole):

Method corresponding_column Given a :class:`_expression.ColumnElement`, return the exported :class:`_expression.ColumnElement` object from the :attr:`_expression.Selectable.exported_columns` collection of this :class:`_expression...
Method lateral Return a LATERAL alias of this :class:`_expression.Selectable`.
Method replace_selectable Replace all occurrences of :class:`_expression.FromClause` 'old' with the given :class:`_expression.Alias` object, returning a copy of this :class:`_expression.FromClause`.

Inherited from ReturnsRows (via DMLTableRole, Immutable, NamedFromClause, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, UsesInspection, ColumnListRole, StructuralRole, Selectable):

Property selectable Undocumented
Class Variable _is_lateral Undocumented
Class Variable _is_returns_rows Undocumented
Class Variable _is_select_base Undocumented
Class Variable _is_select_statement Undocumented
Property _all_selected_columns A sequence of column expression objects that represents the "selected" columns of this :class:`_expression.ReturnsRows`.

Inherited from DQLDMLClauseElement (via DMLTableRole, Immutable, NamedFromClause, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, UsesInspection, ColumnListRole, StructuralRole, Selectable, ReturnsRows, ReturnsRowsRole, SQLRole):

Method compile Compile this SQL expression.
Method _compiler Return a compiler appropriate for this ClauseElement, given a Dialect.

Inherited from ClauseElement (via DMLTableRole, Immutable, NamedFromClause, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, UsesInspection, ColumnListRole, StructuralRole, Selectable, ReturnsRows, ReturnsRowsRole, SQLRole, DQLDMLClauseElement):

Method __bool__ Undocumented
Method __getstate__ Undocumented
Method __invert__ Undocumented
Method __repr__ Undocumented
Method compare Compare this :class:`_expression.ClauseElement` to the given :class:`_expression.ClauseElement`.
Method get_children Return immediate child :class:`.visitors.HasTraverseInternals` elements of this :class:`.visitors.HasTraverseInternals`.
Class Variable is_clause_element Undocumented
Class Variable is_dml Undocumented
Class Variable negation_clause Undocumented
Method _cloned_set Return the set consisting all cloned ancestors of this ClauseElement.
Method _compile_w_cache Undocumented
Method _execute_on_connection Undocumented
Method _execute_on_scalar an additional hook for subclasses to provide a different implementation for connection.scalar() vs. connection.execute().
Method _negate Undocumented
Method _negate_in_binary a hook to allow the right side of a binary expression to respond to a negation of the binary expression.
Method _replace_params Undocumented
Method _set_propagate_attrs Undocumented
Method _ungroup Return this :class:`_expression.ClauseElement` without any groupings.
Method _with_binary_element_type in the context of binary expression, convert the type of this object to the one given.
Class Variable _cache_key_traversal Undocumented
Class Variable _gen_static_annotations_cache_key Undocumented
Class Variable _is_bind_parameter Undocumented
Class Variable _is_clause_list Undocumented
Class Variable _is_column_element Undocumented
Class Variable _is_from_container Undocumented
Class Variable _is_keyed_column_element Undocumented
Class Variable _is_lambda_element Undocumented
Class Variable _is_select_container Undocumented
Class Variable _is_singleton_constant Undocumented
Class Variable _is_star Undocumented
Class Variable _is_text_clause Undocumented
Class Variable _is_textual Undocumented
Instance Variable _propagate_attrs like annotations, however these propagate outwards liberally as SQL constructs are built, and are set up at construction time.
Property _constructor return the 'constructor' for this ClauseElement.
Property _order_by_label_element Undocumented

Inherited from SupportsWrappingAnnotations (via DMLTableRole, Immutable, NamedFromClause, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, UsesInspection, ColumnListRole, StructuralRole, Selectable, ReturnsRows, ReturnsRowsRole, SQLRole, DQLDMLClauseElement, ClauseElement):

Method _annotate return a copy of this ClauseElement with annotations updated by the given dictionary.
Method _deannotate return a copy of this :class:`_expression.ClauseElement` with annotations removed.
Method _with_annotations return a copy of this ClauseElement with annotations replaced by the given dictionary.

Inherited from SupportsAnnotations (via DMLTableRole, Immutable, NamedFromClause, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, UsesInspection, ColumnListRole, StructuralRole, Selectable, ReturnsRows, ReturnsRowsRole, SQLRole, DQLDMLClauseElement, ClauseElement, SupportsWrappingAnnotations):

Class Variable proxy_set Undocumented
Method _gen_annotations_cache_key Undocumented
Property _annotations_cache_key Undocumented

Inherited from MemoizedHasCacheKey (via DMLTableRole, Immutable, NamedFromClause, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, UsesInspection, ColumnListRole, StructuralRole, Selectable, ReturnsRows, ReturnsRowsRole, SQLRole, DQLDMLClauseElement, ClauseElement, SupportsWrappingAnnotations, SupportsAnnotations):

Method _generate_cache_key return a cache key.

Inherited from HasCacheKey (via DMLTableRole, Immutable, NamedFromClause, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, UsesInspection, ColumnListRole, StructuralRole, Selectable, ReturnsRows, ReturnsRowsRole, SQLRole, DQLDMLClauseElement, ClauseElement, SupportsWrappingAnnotations, SupportsAnnotations, MemoizedHasCacheKey):

Class Variable inherit_cache Indicate if this :class:`.HasCacheKey` instance should make use of the cache key generation scheme used by its immediate superclass.
Class Method _generate_cache_attrs generate cache key dispatcher for a new class.
Class Method _generate_cache_key_for_object Undocumented
Method _gen_cache_key return an optional cache key.
Class Variable _generated_cache_key_traversal Undocumented
Class Variable _hierarchy_supports_caching private attribute which may be set to False to prevent the inherit_cache warning from being emitted for a hierarchy of subclasses.
Class Variable _is_has_cache_key Undocumented

Inherited from CompilerElement (via DMLTableRole, Immutable, NamedFromClause, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, UsesInspection, ColumnListRole, StructuralRole, Selectable, ReturnsRows, ReturnsRowsRole, SQLRole, DQLDMLClauseElement, ClauseElement, SupportsWrappingAnnotations, SupportsAnnotations, MemoizedHasCacheKey, HasCacheKey, HasCopyInternals, ExternallyTraversible, HasTraverseInternals):

Class Variable stringify_dialect Undocumented
Class Variable supports_execution Undocumented

Inherited from Visitable (via DMLTableRole, Immutable, NamedFromClause, FromClause, AnonymizedFromClauseRole, StrictFromClauseRole, FromClauseRole, ColumnsClauseRole, JoinTargetRole, AllowsLambdaRole, UsesInspection, ColumnListRole, StructuralRole, Selectable, ReturnsRows, ReturnsRowsRole, SQLRole, DQLDMLClauseElement, ClauseElement, SupportsWrappingAnnotations, SupportsAnnotations, MemoizedHasCacheKey, HasCacheKey, HasCopyInternals, ExternallyTraversible, HasTraverseInternals, CompilerElement):

Method __class_getitem__ Undocumented
Method __init_subclass__ Undocumented
Class Method _generate_compiler_dispatch Undocumented
Method _compiler_dispatch Undocumented
Class Variable _original_compiler_dispatch Undocumented
def __init__(self, name: str, *columns: ColumnClause[Any], **kw: Any): (source)
overridden in sqlalchemy.sql.schema.Table

Undocumented

def __str__(self) -> str: (source)
overrides sqlalchemy.sql.elements.CompilerElement.__str__
overridden in sqlalchemy.sql.schema.Table

Undocumented

def append_column(self, c: ColumnClause[Any]): (source)
overridden in sqlalchemy.sql.schema.Table

Undocumented

@util.preload_module('sqlalchemy.sql.dml')
def delete(self) -> Delete: (source)

Generate a :func:`_expression.delete` construct against this :class:`_expression.TableClause`. E.g.:: table.delete().where(table.c.id==7) See :func:`_expression.delete` for argument and usage information.

@util.preload_module('sqlalchemy.sql.dml')
def insert(self) -> util.preloaded.sql_dml.Insert: (source)

Generate an :class:`_sql.Insert` construct against this :class:`_expression.TableClause`. E.g.:: table.insert().values(name='foo') See :func:`_expression.insert` for argument and usage information.

@util.preload_module('sqlalchemy.sql.dml')
def update(self) -> Update: (source)

Generate an :func:`_expression.update` construct against this :class:`_expression.TableClause`. E.g.:: table.update().where(table.c.id==7).values(name='foo') See :func:`_expression.update` for argument and usage information.

__visit_name__: str = (source)
overrides sqlalchemy.sql.selectable.FromClause.__visit_name__
overridden in sqlalchemy.sql.schema.Table

Undocumented

implicit_returning: bool = (source)
overridden in sqlalchemy.sql.schema.Table

:class:`_expression.TableClause` doesn't support having a primary key or column -level defaults, so implicit returning doesn't apply.

foreign_keys = (source)
overrides sqlalchemy.sql.selectable.FromClause.foreign_keys
overridden in sqlalchemy.sql.schema.Table

Return the collection of :class:`_schema.ForeignKey` marker objects which this FromClause references. Each :class:`_schema.ForeignKey` is a member of a :class:`_schema.Table`-wide :class:`_schema.ForeignKeyConstraint`. .. seealso:: :attr:`_schema.Table.foreign_key_constraints`

fullname = (source)
overridden in sqlalchemy.sql.schema.Table

Undocumented

name = (source)
overrides sqlalchemy.sql.selectable.NamedFromClause.name

Undocumented

primary_key = (source)
overrides sqlalchemy.sql.selectable.FromClause.primary_key
overridden in sqlalchemy.sql.schema.Table

Return the iterable collection of :class:`_schema.Column` objects which comprise the primary key of this :class:`_selectable.FromClause`. For a :class:`_schema.Table` object, this collection is represented by the :class:`_schema.PrimaryKeyConstraint` which itself is an iterable collection of :class:`_schema.Column` objects.

schema = (source)
overrides sqlalchemy.sql.selectable.FromClause.schema
overridden in sqlalchemy.sql.schema.Table

Define the 'schema' attribute for this :class:`_expression.FromClause`. This is typically ``None`` for most objects except that of :class:`_schema.Table`, where it is taken as the value of the :paramref:`_schema.Table.schema` argument.

@util.ro_non_memoized_property
c: ReadOnlyColumnCollection[str, ColumnClause[Any]] = (source)
overrides sqlalchemy.sql.selectable.FromClause.c
overridden in sqlalchemy.sql.schema.Table

A synonym for :attr:`.FromClause.columns` :return: a :class:`.ColumnCollection`

@util.ro_non_memoized_property
columns: ReadOnlyColumnCollection[str, ColumnClause[Any]] = (source)
overrides sqlalchemy.sql.selectable.FromClause.columns
overridden in sqlalchemy.sql.schema.Table

A named-based collection of :class:`_expression.ColumnElement` objects maintained by this :class:`_expression.FromClause`. The :attr:`.columns`, or :attr:`.c` collection, is the gateway to the construction of SQL expressions using table-bound or other selectable-bound columns:: select(mytable).where(mytable.c.somecolumn == 5) :return: a :class:`.ColumnCollection` object.

@util.ro_memoized_property
description: str = (source)
overrides sqlalchemy.sql.selectable.FromClause.description

A brief description of this :class:`_expression.FromClause`. Used primarily for error message formatting.

def _init_collections(self): (source)
overrides sqlalchemy.sql.selectable.FromClause._init_collections
overridden in sqlalchemy.sql.schema.Table

Undocumented

def _refresh_for_new_column(self, column: ColumnElement[Any]): (source)
overrides sqlalchemy.sql.selectable.FromClause._refresh_for_new_column

Given a column added to the .c collection of an underlying selectable, produce the local version of that column, assuming this selectable ultimately should proxy this column. this is used to "ping" a derived selectable to add a new column to its .c. collection when a Column has been added to one of the Table objects it ultimately derives from. If the given selectable hasn't populated its .c. collection yet, it should at least pass on the message to the contained selectables, but it will return None. This method is currently used by Declarative to allow Table columns to be added to a partially constructed inheritance mapping that may have already produced joins. The method isn't public right now, as the full span of implications and/or caveats aren't yet clear. It's also possible that this functionality could be invoked by default via an event, which would require that selectables maintain a weak referencing collection of all derivations.

_is_table: bool = (source)
overrides sqlalchemy.sql.elements.ClauseElement._is_table

Undocumented

_traverse_internals: _TraverseInternalsType = (source)
overrides sqlalchemy.sql.visitors.HasTraverseInternals._traverse_internals
overridden in sqlalchemy.sql.schema.Table

Undocumented

_columns = (source)
overrides sqlalchemy.sql.selectable.FromClause._columns
overridden in sqlalchemy.sql.schema.Table

Undocumented

@util.ro_memoized_property
_autoincrement_column: Optional[ColumnClause[Any]] = (source)
overridden in sqlalchemy.sql.schema.Table

No PK or default support so no autoincrement column.

@util.ro_non_memoized_property
_from_objects: List[FromClause] = (source)
overrides sqlalchemy.sql.elements.ClauseElement._from_objects

Undocumented