Classe « Join »

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
                builtins.object
                    SQLRole
                        StructuralRole
                    builtins.object
                        UsesInspection
                    builtins.object
                        AllowsLambdaRole
                            JoinTargetRole
                builtins.object
                    SQLRole
                        ColumnListRole
                    builtins.object
                        UsesInspection
                    builtins.object
                        AllowsLambdaRole
                            ColumnsClauseRole
                                FromClauseRole
                                    DMLTableRole
                                        Join

Définition

class Join(DMLTableRole, FromClause):

help(Join)

Represent a ``JOIN`` construct between two
:class:`_expression.FromClause`
elements.

The public constructor function for :class:`_expression.Join`
is the module-level
:func:`_expression.join()` function, as well as the
:meth:`_expression.FromClause.join` method
of any :class:`_expression.FromClause` (e.g. such as
:class:`_schema.Table`).

.. seealso::

    :func:`_expression.join`

    :meth:`_expression.FromClause.join`

Constructeur(s)

Signature du constructeur	Description
__init__(self, left: '_FromClauseArgument', right: '_FromClauseArgument', onclause: 'Optional[_OnClauseArgument]' = None, isouter: 'bool' = False, full: 'bool' = False)	Construct a new :class:`_expression.Join`. _{[extrait de __init__.__doc__]}

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._non_memoized_property object at 0x0000020D9F9377D0>
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>
inherit_cache	None
is_clause_element	True
is_dml	False
is_selectable	True
named_with_column	False
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
is_derived_from(self, fromclause: 'Optional[FromClause]') -> 'bool'
select(self) -> 'Select[Any]'	Create a :class:`_expression.Select` from this _{[extrait de select.__doc__]}
self_group(self, against: 'Optional[OperatorType]' = None) -> 'FromGrouping'