관리-도구
편집 파일: relationships.cpython-38.pyc
U -?�f�� � @ s� d Z ddlmZ ddlZddlmZ ddlZddlZddlZddl Z ddl Z ddl m Z ddl m Z ddl m Z ddl mZ dd l mZ dd l mZ dd l mZ dd l mZ dd l mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl m Z ddl m Z ddl Z ddl m Z ddl m!Z! ddl"m#Z# dd l"m$Z$ dd l%m&Z& dd l%m'Z' dd l%m(Z( dd l%m)Z) dd!l%m*Z* dd"l%m+Z+ dd#l%m,Z, dd$l%m-Z- dd%l.m/Z/ dd&l.m0Z0 dd'l.m1Z1 dd(l.m2Z2 dd)l.m3Z3 dd*l.m4Z4 dd+l.m5Z5 dd,l.m6Z6 dd-l7m8Z8 dd.l7m9Z9 dd/l7m:Z: d0d1l m;Z< d0d2l m=Z= d0d3l m>Z> d0d4l m?Z? d0d5l m@Z@ d0d6l m7Z7 d0d7lAmZ d0d8l@mBZB d0d9l@mCZC d0d:l@mDZD d0d;l@mEZE d0d<l@mFZF d0d=lGmHZH d0d>lGmIZI d0d?lJmKZK d0d@lLmMZM d0dAlLmNZN d0dBlOmPZP d0dClOmQZQ d0dDlOmRZR d0dElOmSZS d0dFlOmTZT d0dGlOmUZU d0dHlOmVZV d0dIlOmWZW d0dJlXmYZY d0dKlXmZZZ d0dLlXm[Z[ e j\�rddMl"m]Z] ddNl"m^Z^ ddOl"m_Z_ ddPl"m`Z` ddQl"maZa ddRl"mbZb ddSl"mcZc ddTl%mdZd ddUlemfZf ddVlemgZg ddWlhmiZi ddXljmkZk ddYllmmZm ddZlnmoZo dd[lpmqZq dd\lrmsZs dd]ltmuZu dd^l7mvZv dd_l7mwZw d0d`lGmxZx d0dalGmyZy d0dblGmzZz d0dclJm{Z{ d0ddlJm|Z| d0delLm}Z} d0dflLm~Z~ d0dglLmZ d0dhl�m�Z� d0dil�m�Z� d0djlXm�Z� d0dklXm�Z� e dle dm�Z�e dne dm�Z�e doe dm�Z�e dpe dm�Z�e dqe dm�Z�e e�ee� e g ee� f drdse g drf e g dsf f Z�eZdt Z�e e�eHe� f Z�e due�e g duf f Z�e eZdv e�eHe e g eHe f e g eeHe f ee e�eHe f f Z�e e�ee�ee�e f f f Z�e eMe eIe eEj�dwf Z�e e�ee� e g ee� f e g e�f e�f Z�e dxeHe dm�Z�e dydzdm�Z�eeeNe eNe f Z�eeeNe eNe f Z�eeeNe eNe f Z�dxdxd{�d|d}�Z�dxdxd{�d~d�Z�ej�G d�d�� d�ee�e�f ��Z�e eZdv eeNe d�f f Z�G d�d�� d�e�Z�e>j�G d�d�� d�e0e6e� e>j���Z�dyd�dyd��d�d��Z�G d�d�� d��Z�G d�d�� d��Z�e�d�d��Z�e�d}d��Z�G d�d�� d�e�e� e&e� �Z�G d�d�� d�e�e� e-e� e)e� �Z�dS )�a Heuristics related to join conditions as used in :func:`_orm.relationship`. Provides the :class:`.JoinCondition` object, which encapsulates SQL annotation and aliasing behavior focused on the `primaryjoin` and `secondaryjoin` aspects of :func:`_orm.relationship`. � )� annotationsN)�abc)�Any)�Callable)�cast)� Collection)�Dict)� FrozenSet)�Generic)�Iterable)�Iterator)�List)� NamedTuple)�NoReturn)�Optional)�Sequence)�Set)�Tuple)�Type)�TypeVar)�Union� )� attributes)�strategy_options)�insp_is_aliased_class)�is_has_collection_adapter)�_DeclarativeMapped)�_is_mapped_class)� class_mapper)� DynamicMapped)�LoaderCallableStatus)� PassiveFlag)� state_str)�WriteOnlyMapped)�_AttributeOptions)�_IntrospectsAnnotations)� MANYTOMANY)� MANYTOONE)� ONETOMANY)�PropComparator)�RelationshipDirection)�StrategizedProperty)� _orm_annotate)�_orm_deannotate)�CascadeOptions� )�exc)�Exists)�log)�schema)�sql)�util)�inspect)� coercions)� expression)� operators)�roles)�visitors)�_ColumnExpressionArgument)�_HasClauseElement)�_safe_annotate)� ColumnClause)� ColumnElement��_deep_annotate)�_deep_deannotate)�_shallow_annotate)�adapt_criterion_to_null)� ClauseAdapter)�join_condition)�selectables_overlap��visit_binary_product)�de_optionalize_union_types)�Literal)� resolve_name_to_real_class_name)� _EntityType)�_ExternalEntityType)�_IdentityKeyType)� _InstanceDict)�_InternalEntityType)�_O)� _RegistryType)�Mapped)�_class_resolver)�_ModNS)�_ClassScanMapperConfig)�DependencyProcessor)�Mapper)�Query)�Session)� InstanceState)� LazyLoader)� AliasedClass)� AliasedInsp)�_CoreAdapterProto)�_EquivalentColumnMap)� _InfoType)�_AnnotationDict)�SupportsAnnotations)�BinaryExpression)� BindParameter)� ClauseElement)�Table)� FromClause)�_AnnotationScanType)�RODescriptorReference�_T)�bound�_T1�_T2�_PT�_PT2� Mapper[_T]zAliasedClass[_T]) �selectZjoinedZselectinZsubquery�raiseZ raise_on_sqlZnoloadZ immediate� write_only�dynamicTFNrj Fz Mapped[Any]�_CEA�_CE�ColumnElement[Any])�expr�returnc C s t t�tj| �ddi�S )a Annotate a portion of a primaryjoin expression with a 'remote' annotation. See the section :ref:`relationship_custom_foreign` for a description of use. .. seealso:: :ref:`relationship_custom_foreign` :func:`.foreign` �remoteT��_annotate_columnsr7 �expectr: �ColumnArgumentRole�r{ � r� �L/opt/hc_python/lib64/python3.8/site-packages/sqlalchemy/orm/relationships.pyr} � s �r} c C s t t�tj| �ddi�S )a Annotate a portion of a primaryjoin expression with a 'foreign' annotation. See the section :ref:`relationship_custom_foreign` for a description of use. .. seealso:: :ref:`relationship_custom_foreign` :func:`.remote` �foreignTr~ r� r� r� r� r� � s �r� c @ sL e Zd ZU dZdZded< ded< ded< d d �d d �Zd dd�dd�ZdS )�_RelationshipArgztstores a user-defined parameter value that must be resolved and parsed later at mapper configuration time. )�name�argument�resolved�strr� ro r� z Optional[_T2]r� �bool�r| c C s | j d k S �N)r� ��selfr� r� r� � _is_populated s z _RelationshipArg._is_populated�&Callable[[str, bool], _class_resolver]�None)�clsregistry_resolverr| c C sJ | j }t|t�r&||| jdk�� | _n t|�r@t|�s@|� | _n|| _d S )N� secondary)r� � isinstancer� r� r� �callabler )r� r� Z attr_valuer� r� r� �_resolve_against_registry s � z*_RelationshipArg._resolve_against_registryN)�__name__� __module__� __qualname__�__doc__� __slots__�__annotations__r� r� r� r� r� r� r� � s r� .c @ sB e Zd ZU dZded< ded< ded< ded< d ed < d ed < d S ) �_RelationshipArgszWstores user-passed parameters that are resolved at mapper configuration time. zP_RelationshipArg[Optional[_RelationshipSecondaryArgument], Optional[FromClause]]r� z\_RelationshipArg[Optional[_RelationshipJoinConditionArgument], Optional[ColumnElement[Any]]]� primaryjoin� secondaryjoinz>_RelationshipArg[_ORMOrderByArgument, _RelationshipOrderByArg]�order_byzN_RelationshipArg[Optional[_ORMColCollectionArgument], Set[ColumnElement[Any]]]� foreign_keys� remote_sideN)r� r� r� r� r� r� r� r� r� r� s r� c ' sT e Zd ZU dZejZdZdZdZ de d< de d< e dddddd�Z d Z d e d < d e d < de d< de d< de d< de d< de d< de d< de d< de d< de d < d e d < d e d < d e d!< d"e d#< d�d d d d d dd d dd$dd d%ddddd d d d ddd dd d d d d ddd dd&�"d'd(d)d*d+d+d,d-d.d,d/d0d/d1d2d3d/d/d/d4d4d5d6d/d/d)d/d7d8d9d)d,d:d;d d/d<�$� fd=d>�Zd?d@dA�dBdC�ZdDd@dE�dFdG�ZG dHdI� dIejee �Zd�dJd/dKd dL�dMdN�Zd�d?d/dOd/d dP�dQdR�ZdDdSdTdUdVdW�dXdY�Zd�d/dOd dZ�d[d\�Zd0d]�d^d_�Zd`dSdTdSdTd/dadbd@dc� ddde�Ze j fdfdTd0dgdhdi�djdk�Z d�d0dSdTdldmdndo�dpdq�Z e d/d]�drds��Z!e"dtdtd@du�dvdw��Z#d0d@dx�dydz�Z$ej%d{d]�d|d}��Z&ej%d~d]�dd���Z'd@d]�� fd�d�� Z(d@d]�d�d��Z)d@d]�d�d��Z*d�d�d�d,d0d�d�d�d/d@d�� d�d��Z+e�,d��d�d?d@d��d�d���Z-d@d]�d�d��Z.e d�d]�d�d���Z/e d�d]�d�d���Z0ej%e�,d��d�d]�d�d����Z1d@d]�d�d��Z2e d�d]�d�d���Z3e3j4d�d@d��d�d���Z3d�d@d��d�d��Z5d�d@d��d�d��Z6dDd/dE�d�d��Z7dUd/d��d�d��Z8d@d]�d�d��Z9e�,d��d@d]�d�d���Z:ej%d/d]�d�d���Z;ej%d/d]�d�d���Z<d�d/ddd�d/d�d�d��d�d��Z=� Z>S )��RelationshipPropertyz�Describes an object property that holds a single item or list of items that correspond to a related database table. Public constructor is the :func:`_orm.relationship` function. .. seealso:: :ref:`relationship_config_toplevel` Tz Sequence[str]� _overlapsr^ �_lazy_strategyF��passive_deletes�passive_updates�enable_typechecks�active_history�cascade_backrefsNz Optional[DependencyProcessor]�_dependency_processor�ColumnElement[bool]r� � Optional[ColumnElement[bool]]r� �Optional[FromClause]r� � JoinCondition�_join_condition�_RelationshipOrderByArgr� �Set[ColumnElement[Any]]�_user_defined_foreign_keys�_calculated_foreign_keysr� � local_columns� _ColumnPairs�synchronize_pairs�Optional[_ColumnPairs]�secondary_synchronize_pairs�local_remote_pairsr* � directionr� � _init_argszsave-update, mergert )"�uselist�collection_classr� r� �back_populatesr� �backref�overlaps� post_update�cascade�viewonly�attribute_options�lazyr� r� r� r� r� r� � join_depth�comparator_factory� single_parent� innerjoin�distinct_target_key�load_on_pending� query_class�info� omit_join� sync_backref�doc� bake_queriesr� �_local_remote_pairs� _legacy_inactive_history_stylez'Optional[_RelationshipArgumentType[_T]]z(Optional[_RelationshipSecondaryArgument]zOptional[bool]zEOptional[Union[Type[Collection[Any]], Callable[[], Collection[Any]]]]z,Optional[_RelationshipJoinConditionArgument]z Optional[str]�_ORMOrderByArgumentz Optional[ORMBackrefArgument]r� r� zOptional[_AttributeOptions]�_LazyLoadArgumentTypezUnion[Literal['all'], bool]z#Optional[_ORMColCollectionArgument]z Optional[int]z4Optional[Type[RelationshipProperty.Comparator[Any]]]zOptional[Type[Query[Any]]]zOptional[_InfoType]zLiteral[(None, False)]z Literal[True]zLiteral[False])$r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� c " % s� t � j|d� || _|| _ttd|d �td|d �td|d �td|d �td|d �td|d ��| _| | _| | _| r�| j |||||"d� | r�| r�t � d ��| | _ || _ || _|| _|| _|"r�t � d ��|| _|| _| | _|| _|| _| | _|| _|$| _|| _| �rt�d � | | _ |#| _ || _ |�p"t j | _!t�"| � | d k �rF| j#�$| � d | j ff| _%t&� | _'| �rvt&t(�)d | ��| _*nd| _*| | _+|| _,| j,�r�| �r�t � d��d | _-n| | _-d S )N)r� r� r� r� r� r� r� r� z-sync_backref and viewonly cannot both be TruezSThe 'cascade_backrefs' parameter passed to relationship() may only be set to False.z�setting omit_join to True is not supported; selectin loading of this relationship may not work correctly if this flag is set explicitly. omit_join optimization is automatically detected for conditions under which it is supported.r� z\s*,\s*r� zCbackref and back_populates keyword arguments are mutually exclusive).�super�__init__r� r� r� r� r� r� r� � _warn_for_persistence_only_flags�sa_exc� ArgumentErrorr� r� r� r� r� r� r� r� r� r� r� r� r� r� r5 �warnr� r� r� r� � Comparatorr� Zset_creation_orderr� �update� strategy_key�set�_reverse_property�re�splitr� r� r� r� )%r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� �� __class__r� r� r� n s� , � ���� � �z RelationshipProperty.__init__r r� )�kwr| c K s4 |� � D ]&\}}|| j| krt�d|f � qd S )Nz�Setting %s on relationship() while also setting viewonly=True does not make sense, as a viewonly=True relationship does not perform persistence operations. This configuration may raise an error in a future release.)�items�_persistence_onlyr5 r� )r� r� �k�vr� r� r� r� � s ��z5RelationshipProperty._warn_for_persistence_only_flagsz Mapper[Any])�mapperr| c C s& t j|j| j| �| |�|| jd� d S )N)Z comparator� parententityr� )r Zregister_descriptor�class_�keyr� r� �r� r� r� r� r� �instrument_class s �z%RelationshipProperty.instrument_classc @ sV e Zd ZU dZdZded< ded< dHd d d dd d �dd�Zddd�dd�Zded< ded< dd�dd�Zdd�d d �Z d d�d d �Z d!d�d"d#�Z d$d%d&�d'd(�Z d)d*d+�d,d-�Z d.d/d0�d1d2�ZdZd.d!d0�d3d4�ZdId5d.d6d7�d8d9�ZdJd5d.d!d7�d:d;�ZdKd5d.d!d7�d<d=�Zd>d.d!d?�d@dA�Zd.d!d0�dBdC�Zd.d!d0�dDdE�Zd d�dFdG�ZdS )Lz RelationshipProperty.Comparatora� Produce boolean, comparison, and other operators for :class:`.RelationshipProperty` attributes. See the documentation for :class:`.PropComparator` for a brief overview of ORM level operator definition. .. seealso:: :class:`.PropComparator` :class:`.ColumnProperty.Comparator` :class:`.ColumnOperators` :ref:`types_operators` :attr:`.TypeEngine.comparator_factory` )�entityr� �property�_of_type�_extra_criteriaz0RODescriptorReference[RelationshipProperty[_PT]]�propzOptional[_EntityType[_PT]]r� Nr� zRelationshipProperty[_PT]z_InternalEntityType[Any]zOptional[AliasedInsp[Any]]� Tuple[ColumnElement[bool], ...])r� � parentmapper�adapt_to_entity�of_type�extra_criteriac C s. || _ || _|| _|r || _nd| _|| _dS )z�Construction of :class:`.RelationshipProperty.Comparator` is internal to the ORM's attribute mechanics. N)r� � _parententity�_adapt_to_entityr� r� )r� r� r� r� r� r� r� r� r� r� 3 s z(RelationshipProperty.Comparator.__init__zAliasedInsp[Any]z$RelationshipProperty.Comparator[Any])r� r| c C s | j | j| j|| jd�S )N)r� r� )r� r� r� r� )r� r� r� r� r� r� H s �z/RelationshipProperty.Comparator.adapt_to_entityz_InternalEntityType[_PT]r� z Mapper[_PT]r� r� c C s | j rt| j �S | jjS d S r� )r� r6 r� r� r� r� r� r� �_memoized_attr_entityg s z5RelationshipProperty.Comparator._memoized_attr_entityc C s | j jS r� �r� r� r� r� r� r� �_memoized_attr_mapperm s z5RelationshipProperty.Comparator._memoized_attr_mapperrj c C s | j r| j jS | jjjS d S r� )r� � selectabler� �parent� _with_polymorphic_selectabler� r� r� r� �_source_selectablep s z2RelationshipProperty.Comparator._source_selectabler� c C sZ | � � }| jrt| j�}nd }| jj|d|d| jd�\}}}}}}|d k rR||@ S |S d S )NT)�source_selectable�source_polymorphic�of_type_entity�alias_secondaryr� )r r� r6 r� � _create_joinsr� ) r� Z adapt_fromr �pj�sj�source�destr� �target_adapterr� r� r� �__clause_element__v s* ��z2RelationshipProperty.Comparator.__clause_element__z_EntityType[Any]zPropComparator[_PT])r� r| c C s t j| j| j| j|| jd�S )z�Redefine this object in terms of a polymorphic subclass. See :meth:`.PropComparator.of_type` for an example. �r� r� r� )r� r� r� r� r� r� )r� r� r� r� r� r� � s �z'RelationshipProperty.Comparator.of_typez _ColumnExpressionArgument[bool]zPropComparator[Any])�criteriar| c G s: t dd� t�|�D ��}tj| j| j| j| j| j | d�S )z�Add AND criteria. See :meth:`.PropComparator.and_` for an example. .. versionadded:: 1.4 c s s | ]}t �tj|�V qd S r� )r7 r� r: �WhereHavingRole)�.0�clauser� r� r� � <genexpr>� s �z7RelationshipProperty.Comparator.and_.<locals>.<genexpr>r ) �tupler5 Zcoerce_generator_argr� r� r� r� r� r� r� )r� r Zexprsr� r� r� �and_� s ��z$RelationshipProperty.Comparator.and_r r )�otherr| c C s t d��dS )z�Produce an IN clause - this is not implemented for :func:`_orm.relationship`-based attributes at this time. zvin_() not yet supported for relationships. For a simple many-to-one, use in_() against the set of foreign key values.N)�NotImplementedError�r� r r� r� r� �in_� s �z#RelationshipProperty.Comparator.in_c C st |dkst |tj�rF| jjttfkr.| �� S t| jj d| j d��S n*| jj rZt � d��nt| jj || j d��S dS )a� Implement the ``==`` operator. In a many-to-one context, such as:: MyClass.some_prop == <some object> this will typically produce a clause such as:: mytable.related_id == <some id> Where ``<some id>`` is the primary key of the given object. The ``==`` operator provides partial functionality for non- many-to-one comparisons: * Comparisons against collections are not supported. Use :meth:`~.Relationship.Comparator.contains`. * Compared to a scalar one-to-many, will produce a clause that compares the target columns in the parent to the given target. * Compared to a scalar many-to-many, an alias of the association table will be rendered as well, forming a natural join that is part of the main body of the query. This will not work for queries that go beyond simple AND conjunctions of comparisons, such as those which use OR. Use explicit joins, outerjoins, or :meth:`~.Relationship.Comparator.has` for more comprehensive non-many-to-one scalar membership tests. * Comparisons against ``None`` given in a one-to-many or many-to-many context produce a NOT EXISTS clause. N�� adapt_source�]Can't compare a collection to an object or collection; use contains() to test for membership.)r� r8 �Nullr� r� r( r& �_criterion_existsr, �_optimized_compare�adapterr� r� �InvalidRequestErrorr r� r� r� �__eq__� s& % ��� ��z&RelationshipProperty.Comparator.__eq__z)Optional[_ColumnExpressionArgument[bool]]r1 )� criterion�kwargsr| c K s� |d k rt �tj|�nd }t| dd �r�t| j�}|d k s<t�|j|j |j }}}| j j rf|sf|� � }|j}|d k r�|d k r�||@ }q�|}nd}d }| jr�| �� } nd } | j j|| d�\} } } } }}|D ]2}t| j jj|�|| k}|d kr�|}q�||@ }q�| d k �rt| �| @ }nt| | j jd�}|d k �rD|�rD|�sD|�|�}|d k �r\|�ddi�}|tj�|�@ }|d k �r�t�d��|�� | |�� | |�}n t�d��|�� | �� | �}|S )Nr� F)�dest_selectabler )�exclude�no_replacement_traverseTr ) r7 r� r: r �getattrr6 r� �AssertionErrorr� r �is_aliased_classr� �_is_self_referential�_anonymous_fromclause�_single_table_criterionr# r r r� r, r� �traverse� _annotater4 ZTrue_Z_ifnone�exists�where� select_fromZcorrelate_except)r� r& r' Zwhere_criteriar� Z target_mapperZ to_selectabler- � single_critr r r r r r� r r� �crit�j�exr� r� r� r! � s� �� � � �� ��� � � � �� ����z1RelationshipProperty.Comparator._criterion_existsc K s | j jst�d��| j|f|�S )aS Produce an expression that tests a collection against particular criterion, using EXISTS. An expression like:: session.query(MyClass).filter( MyClass.somereference.any(SomeRelated.x==2) ) Will produce a query like:: SELECT * FROM my_table WHERE EXISTS (SELECT 1 FROM related WHERE related.my_id=my_table.id AND related.x=2) Because :meth:`~.Relationship.Comparator.any` uses a correlated subquery, its performance is not nearly as good when compared against large target tables as that of using a join. :meth:`~.Relationship.Comparator.any` is particularly useful for testing for empty collections:: session.query(MyClass).filter( ~MyClass.somereference.any() ) will produce:: SELECT * FROM my_table WHERE NOT (EXISTS (SELECT 1 FROM related WHERE related.my_id=my_table.id)) :meth:`~.Relationship.Comparator.any` is only valid for collections, i.e. a :func:`_orm.relationship` that has ``uselist=True``. For scalar references, use :meth:`~.Relationship.Comparator.has`. z9'any()' not implemented for scalar attributes. Use has().�r� r� r� r$ r! �r� r& r' r� r� r� �anye s -�z#RelationshipProperty.Comparator.anyc K s | j jrt�d��| j|f|�S )a� Produce an expression that tests a scalar reference against particular criterion, using EXISTS. An expression like:: session.query(MyClass).filter( MyClass.somereference.has(SomeRelated.x==2) ) Will produce a query like:: SELECT * FROM my_table WHERE EXISTS (SELECT 1 FROM related WHERE related.id==my_table.related_id AND related.x=2) Because :meth:`~.Relationship.Comparator.has` uses a correlated subquery, its performance is not nearly as good when compared against large target tables as that of using a join. :meth:`~.Relationship.Comparator.has` is only valid for scalar references, i.e. a :func:`_orm.relationship` that has ``uselist=False``. For collection references, use :meth:`~.Relationship.Comparator.any`. z3'has()' not implemented for collections. Use any().r: r; r� r� r� �has� s �z#RelationshipProperty.Comparator.hasz _ColumnExpressionArgument[Any])r r' r| c K s@ | j jst�d��| j j|| jd�}| j jdk r<| �|�|_|S )a� Return a simple expression that tests a collection for containment of a particular item. :meth:`~.Relationship.Comparator.contains` is only valid for a collection, i.e. a :func:`_orm.relationship` that implements one-to-many or many-to-many with ``uselist=True``. When used in a simple one-to-many context, an expression like:: MyClass.contains(other) Produces a clause like:: mytable.id == <some id> Where ``<some id>`` is the value of the foreign key attribute on ``other`` which refers to the primary key of its parent object. From this it follows that :meth:`~.Relationship.Comparator.contains` is very useful when used with simple one-to-many operations. For many-to-many operations, the behavior of :meth:`~.Relationship.Comparator.contains` has more caveats. The association table will be rendered in the statement, producing an "implicit" join, that is, includes multiple tables in the FROM clause which are equated in the WHERE clause:: query(MyClass).filter(MyClass.contains(other)) Produces a query like:: SELECT * FROM my_table, my_association_table AS my_association_table_1 WHERE my_table.id = my_association_table_1.parent_id AND my_association_table_1.child_id = <some id> Where ``<some id>`` would be the primary key of ``other``. From the above, it is clear that :meth:`~.Relationship.Comparator.contains` will **not** work with many-to-many collections when used in queries that move beyond simple AND conjunctions, such as multiple :meth:`~.Relationship.Comparator.contains` expressions joined by OR. In such cases subqueries or explicit "outer joins" will need to be used instead. See :meth:`~.Relationship.Comparator.any` for a less-performant alternative using EXISTS, or refer to :meth:`_query.Query.outerjoin` as well as :ref:`orm_queryguide_joins` for more details on constructing outer joins. kwargs may be ignored by this operator but are required for API conformance. z9'contains' not implemented for scalar attributes. Use ==r N) r� r� r� r$ r" r# r� �'_Comparator__negated_contains_or_equalsZnegation_clause)r� r r' r r� r� r� �contains� s =� � �z(RelationshipProperty.Comparator.containsc s� �j jtkrjt�|��ddddd��fdd� �ddd��fd d � � �jjrjtj� ��fd d ��jj D �� S tjd d � t �jj j �jj � |��D �� }��|� S )Nrz �InstanceState[Any]�BindParameter[Any])� local_col�state� remote_colr| c s. |j }tj| j| jd� j�� jj|||�d�S )NT)�type_�uniqueZ callable_)�dictr4 � bindparamr� �typer� �_get_attr_w_warn_on_noner� )rB rC rD �dict_r� r� r� �state_bindparam s ��zURelationshipProperty.Comparator.__negated_contains_or_equals.<locals>.state_bindparamry )�colr| c s � j r� � | �S | S d S r� )r# �rM r� r� r� �adapt# s zKRelationshipProperty.Comparator.__negated_contains_or_equals.<locals>.adaptc s8 g | ]0\}}t �� |��� |��|�k� |�d k��qS r� )r4 �or_�r �x�y)rO rC rL r� r� � <listcomp>+ s �� �zPRelationshipProperty.Comparator.__negated_contains_or_equals.<locals>.<listcomp>c S s g | ]\}}||k�qS r� r� rQ r� r� r� rT 6 s �)r� r� r' r �instance_stater� �_use_getr4 r r� �zipr� Z primary_keyZprimary_key_from_instancer! )r� r r& r� )rO r� rC rL r� Z __negated_contains_or_equals s& �� ��� z<RelationshipProperty.Comparator.__negated_contains_or_equalsc C sh |dkst |tj�rB| jjtkr8t| jjd| jd� �S | � � S n"| jj rVt � d��nt| � |��S dS )a Implement the ``!=`` operator. In a many-to-one context, such as:: MyClass.some_prop != <some object> This will typically produce a clause such as:: mytable.related_id != <some id> Where ``<some id>`` is the primary key of the given object. The ``!=`` operator provides partial functionality for non- many-to-one comparisons: * Comparisons against collections are not supported. Use :meth:`~.Relationship.Comparator.contains` in conjunction with :func:`_expression.not_`. * Compared to a scalar one-to-many, will produce a clause that compares the target columns in the parent to the given target. * Compared to a scalar many-to-many, an alias of the association table will be rendered as well, forming a natural join that is part of the main body of the query. This will not work for queries that go beyond simple AND conjunctions of comparisons, such as those which use OR. Use explicit joins, outerjoins, or :meth:`~.Relationship.Comparator.has` in conjunction with :func:`_expression.not_` for more comprehensive non-many-to-one scalar membership tests. * Comparisons against ``None`` given in a one-to-many or many-to-many context produce an EXISTS clause. Nr r )r� r8 r r� r� r' r, r" r# r! r� r� r$ r> r r� r� r� �__ne__A s ' �� �z&RelationshipProperty.Comparator.__ne__c C s | j j�� | j S r� )r� r �_check_configurer� r� r� r� �_memoized_attr_property{ s z7RelationshipProperty.Comparator._memoized_attr_property)NNr� )N)N)N)r� r� r� r� r� r� r� r� r� r r r r� r r �__hash__r% r! r< r= r? r> rX rZ r� r� r� r� r� s< � < �h �7 �&N3:r� �objectzOptional[_EntityType[Any]])�instancer � from_entityr| c C sN |d k s t �d }|d k r<t|�}|d k s,t �t|�r<|jj}| j|d||d�S )NT)�value_is_parentr r )r, r6 r Z_adapterZ adapt_clauser" )r� r] r r^ r Zinspr� r� r� � _with_parent s �z!RelationshipProperty._with_parentzOptional[_CoreAdapterProto])rC r_ r r r| c s �d k rRz t ���W n tjk r. d �Y nX �d ksDt�dd�sRt�d� ��| }�d krn�j||d�S |s��jj�jj }� n�jj �jj }� |r��j �n�j �t ���� ��ddd�� ����fdd � }�jd k r�|r�t�j�� ��|�}t�|i d |i�}|�r||�}|S ) NZ is_instanceFz�Mapped instance expected for relationship comparison to object. Classes, queries and other SQL elements are not accepted in this context; for comparison with a subquery, use %s.has(**criteria).r rA r� )rH r| c s& | j � kr"������ | j �| _d S r� )Z_identifying_keyrJ r� )rH �� bind_to_colrK r� r� rC r� r� �visit_bindparam� s �z@RelationshipProperty._optimized_compare.<locals>.visit_bindparamrH )r6 r� �NoInspectionAvailabler+ r� �_lazy_none_clauser� � _lazywhere� _bind_to_col�_rev_lazywhere�_rev_bind_to_colr� r r � instance_dict�objr� rF r/ r1 r; �cloned_traverse)r� rC r_ r r �reverse_directionr& rc r� ra r� r" � sV �� ��� �� �z'RelationshipProperty._optimized_comparer@ rQ rz zCallable[[], Any])r� rC rK �columnr| c s< �� � �����j� �j�dd�� �����fdd� }|S )aK Create the callable that is used in a many-to-one expression. E.g.:: u1 = s.query(User).get(5) expr = Address.user == u1 Above, the SQL should be "address.user_id = 5". The callable returned by this method produces the value "5" based on the identity of ``u1``. r r� c s� �d k s t ���j } }| tjk }�j��� �jr:tjn tjtj A d�}|tj krp|s�t � d� t ��f ��n*|tjkr�|s�t � d� t ��f ��n|}|d kr�t�d� � |S )N��passivezUCan't resolve value for column %s on object %s; no value has been set for this columnz`Can't resolve value for column %s on object %s; the object is detached and the value was expiredz�Got None for value of column %s; this is unsupported for a relationship comparison and will not currently produce an IS comparison (but may in a future release))r, r� r ZNO_VALUEZ_get_state_attr_by_column� persistentr! � PASSIVE_OFFZPASSIVE_NO_FETCHZINIT_OKZ NEVER_SETr� r$ r" �PASSIVE_NO_RESULTr5 r� )Z last_knownZ to_returnZexisting_is_available� current_value�rn rK Z lkv_fixedr� r� rC r� r� �_go sD �� � �� ����z:RelationshipProperty._get_attr_w_warn_on_none.<locals>._go)Zget_property_by_columnZ_track_last_known_valuer� Z_last_known_values)r� r� rC rK rn rv r� ru r� rJ � s 1 /z-RelationshipProperty._get_attr_w_warn_on_none)rm r r| c C sD |s| j j| j j }}n| j j| j j }}t||�}|r@||�}|S r� )r� rf rg rh ri rE )r� rm r r& rb r� r� r� re B s �� z&RelationshipProperty._lazy_none_clauser� c C s t | jjj�d | j S )N�.)r� r r� r� r� r� r� r� r� �__str__X s z RelationshipProperty.__str__r\ zDict[Any, object]z#Dict[_IdentityKeyType[Any], object]) �session� source_state� source_dict� dest_state� dest_dict�load� _recursive�_resolve_conflict_mapr| c C s� |r"| j D ]} || f|kr d S q d| jkr0d S | j|kr>d S | j�rR|�| j�} t| �s^t�| �||�} | jrx| j r�nds�t�|r�|�| j�j ||t j d� g } | D ]J} t �| �}t �| �}d||| f< |j|||||d�}|d k r�| �|� q�|�s t �||| j�}| D ]}|�|� �q n0|�| j�}t|��s:t�|j||| dt j d� nx|| j } | d k �r�t �| �}t �| �}d||| f< |j|||||d�}nd }|�s�||| j< n|�| j��|||d � d S )N�mergeTro )r~ r r� F)Z_adaptrp )r� �_cascader� r� Zget_implr r, �get_collection� collection�empty�getr! Z PASSIVE_MERGEr rU rj �_merge�appendZinit_state_collectionZappend_without_eventr� )r� ry rz r{ r| r} r~ r r� �r�implZinstances_iterableZ dest_list�currentZ current_stateZ current_dictrk Zcoll�cZ dest_implr� r� r� r� [ s� � � � � � �zRelationshipProperty.mergezInstanceState[_O]r! z&Sequence[Tuple[InstanceState[_O], _O]])rC rK r� rp r| c C sj |j | j}|j|||d�}|tjks.|dkr2g S t|�rVdd� |j||||d�D �S t�|�|fgS dS )z�Return a list of tuples (state, obj) for the given key. returns an empty list if the value is None/empty/PASSIVE_NO_RESULT ro Nc S s g | ]}t �|�|f�qS r� )r rU )r �or� r� r� rT � s �z;RelationshipProperty._value_as_iterable.<locals>.<listcomp>) �managerr� r� r rs r r� r rU )r� rC rK r� rp r� rR r� r� r� �_value_as_iterable� s �z'RelationshipProperty._value_as_iterablezSet[InstanceState[Any]]z.Optional[Callable[[InstanceState[Any]], bool]]zDIterator[Tuple[Any, Mapper[Any], InstanceState[Any], _InstanceDict]])rE rC rK �visited_states�halt_onr| c c s |dks| j rtj}n tjtjB }|dkrB|j| j j�||�}n| j ||| j|d�}|dkofd| j k}|D ]�\} } | |kr~ql| d kr�ql| d k s�t �t � | �} |r�|| �r�ql|r�| js�ql| jj} | �| jjj�s�t d| j| jj| jf ��|�| � | | | | fV qld S )N�deletez save-updatero zrefresh-expire� delete-orphanz@Attribute '%s' on class '%s' doesn't handle objects of type '%s')r� r! ZPASSIVE_NO_INITIALIZErr ZNO_RAISEr� r� r� Zget_all_pendingr� r� r, r rj r� ZisaZ class_managerr r� r� �add) r� rE rC rK r� r� rp ZtuplesZ skip_pendingrU r� rj Zinstance_mapperr� r� r� �cascade_iterator� sB �� �� z%RelationshipProperty.cascade_iteratorc C s | j r dS | jdk S d S )NF)r� r� r� r� r� r� �_effective_sync_backref s z,RelationshipProperty._effective_sync_backref�RelationshipProperty[Any])�rel_a�rel_br| c C s> | j r |jr t�d|| f ��| j r:|j s:|jdk r:d|_d S )NzQRelationship %s cannot specify sync_backref=True since %s includes viewonly=True.F)r� r� r� r$ )r� r� r� r� r� �_check_sync_backref s �����z(RelationshipProperty._check_sync_backref)r� r| c C s� | j j|dd�}t|t�s,t�d| |f ��| �| |� | �|| � | j�|� |j�| � |� � |j � | j �s�t� d|| || j f ��|j r�| jttfkr�| j|jkr�t� d|| | jf ��d S )NF)Z_configure_mappersz�back_populates on relationship '%s' refers to attribute '%s' that is not a relationship. The back_populates parameter should refer to the name of a relationship on the target class.zereverse_property %r on relationship %s references relationship %s, which does not reference mapper %szv%s and back-reference %s are both of the same direction %r. Did you mean to set remote_side on the many-to-one side ?)r� Z get_propertyr� r� r� r$ r� r� r� � _setup_entity� common_parentr r� Z_configure_startedr� r( r' )r� r� r r� r� r� �_add_reverse_property) s: �� ��� � � ��z*RelationshipProperty._add_reverse_propertyz_InternalEntityType[_T]c C s | j �� | jS )z�Return the target mapped entity, which is an inspect() of the class or aliased class that is referenced by this :class:`.RelationshipProperty`. )r rY r� r� r� r� r� r� U s zRelationshipProperty.entityrs c C s | j jS )zcReturn the targeted :class:`_orm.Mapper` for this :class:`.RelationshipProperty`. r r� r� r� r� r� _ s zRelationshipProperty.mapperc sn | � � | �� | �� | �� | �� | �| j� | �� | �� | j � � t � � � t d| �d��| _d S )Nr^ ))r� rt )�_check_conflicts� _process_dependent_argumentsr� � _setup_registry_dependencies�_setup_join_conditions�_check_cascade_settingsr� � _post_init�_generate_backrefr� �"_warn_for_conflicting_sync_targetsr� �do_initr Z _get_strategyr� r� r� r� r� r� g s �z RelationshipProperty.do_initc C s | j jj�| jjj� d S r� )r r� �registryZ_set_depends_onr� r� r� r� r� r� v s �z1RelationshipProperty._setup_registry_dependenciesc C s | j }dD ] }t||�}|�| jd � q dD ]4}t||�}|j}|dk r.ttjtj ||d��|_q.|j j}|dk r�t |�r�t � d|| f ��|jjdk r�|jjdk r�tdd � t�|jj�D ��| _nd| _t�d d � t�|jj�D ��| _t�d d � t�|jj�D ��| _dS ) z�Convert incoming configuration arguments to their proper form. Callables are resolved, ORM annotations removed. )r� r� r� r� r� r� r )r� r� N��argnamez�secondary argument %s passed to to relationship() %s must be a Table object or other FROM clause; can't send a mapped class directly as rows in 'secondary' are persisted independently of a class that is mapped to that same table.Fc s s | ]}t jtj|d d�V qdS )r� r� N�r7 r� r: r� �r rR r� r� r� r � s � �zDRelationshipProperty._process_dependent_arguments.<locals>.<genexpr>c s s | ]}t jtj|d d�V qdS )r� r� Nr� r� r� r� r� r � s � �c s s | ]}t jtj|d d�V qdS )r� r� Nr� r� r� r� r� r � s � �)r� r+ r� �_clsregistry_resolversr� r- r7 r� r: r� r� r r� r� r� r r5 Zto_list� column_setZ to_column_setr� r� r� )r� Z init_args�attrZrel_arg�valr� r� r� r� r� { sH ���� � � � � �z1RelationshipProperty._process_dependent_argumentsrX rT z Type[Any]zOptional[Type[Mapped[Any]]]z Optional[_AnnotationScanType]) � decl_scanr� �cls�originating_moduler� �mapped_container� annotation�extracted_mapped_annotation�is_dataclass_fieldr| c C s� |} |d kr(| j d kr$| �||� nd S |} |d k s8t�|d k r�t|t�} t|t�} | rnd| _d| jff| _q�| r�d| _d| jff| _nd } } t| �} t | d��rl| j } t | t �r�t| t j�r�| jd kr�t�| �r�t�d| � d���| | _n| s�| s�d| _| j�rXt | t ��r*t| tj��r*| jd }n | jd }t |d ��rR|j}t||�} n|} nt�d | � d ���n t | d ��r�| j} t| |�} | jd k�r�| �s�| �s�d| _| j d k�r�td | �| _ d S )Nrv r� rw F� __origin__zCollection annotation type z� cannot be instantiated; please provide an explicit 'collection_class' parameter (e.g. list, set, etc.) to the relationship() function to accompany this annotation���r �__forward_arg__zGeneric alias z requires an argumentz _RelationshipArgumentType[_T])r� Z_raise_for_requiredr, � issubclassr# r r� r� rK �hasattrr� r� rI r r r� � _py_inspect� isabstractr� r� r� �__args__�typing�Mappingr� rM r )r� r� r� r� r� r� r� r� r� r� r� Z is_write_onlyZ is_dynamicZ arg_originZtype_argZ str_argumentr� r� r� �declarative_scan� s� � � � � � ���� z%RelationshipProperty.declarative_scanzsqlalchemy.orm.mapper)� _RelationshipProperty__argumentr| c C s� d| j krd S tjj}|r |}n| j}t|t�rDtd| �|�� �}n$t |�rdt|t |j f�sd|� }n|}t|t �r�t |dd�}nJz t |�}W n tjk r� d }Y nX t|d�s�t�d| jt |�f ��|| _| jj| _d S )Nr� z_ExternalEntityType[Any]F�� configurer� zErelationship '%s' expects a class or a mapper argument (received: %s))�__dict__r5 � preloadedZ orm_mapperr� r� r� r �_clsregistry_resolve_namer� rI rZ r r6 r� rd r� r� r� r� �persist_selectable�target)r� r� Z mapperlibr� Zresolved_argumentr� r� r� r� r� + s> � � ��z"RelationshipProperty._setup_entityc C s� t | jj| jj| jj| jj| jjj| jjj| jj j| jj | j j | j | j | j| j| | j | jd� | _}|j| _|j | _ |j| _|j| _|j | _ |j| _|j| _|j| _|j| _|j| _d S )N��parent_persist_selectable�child_persist_selectable�parent_local_selectable�child_local_selectabler� r� r� �parent_equivalents�child_equivalents�consider_as_foreign_keysr� r� �self_referentialr� � support_sync�can_be_synced_fn)r� r r� r� � local_tabler� r� r� r� r� Z_equivalent_columnsr� r� r� r� r. r� �_columns_are_mappedr� r� �remote_columnsr� r� �foreign_key_columnsr� r� )r� Zjcr� r� r� r� [ s8 � z+RelationshipProperty._setup_join_conditionsr� c C s | j d S )Nr �r� r� r� r� r� �_clsregistry_resolve_argy s z-RelationshipProperty._clsregistry_resolve_argz>Callable[[str], Callable[[], Union[Type[Any], Table, _ModNS]]]c C s | j d S )Nr r� r� r� r� r� r� s z.RelationshipProperty._clsregistry_resolve_namezsqlalchemy.orm.clsregistryzmTuple[Callable[[str], Callable[[], Union[Type[Any], Table, _ModNS]]], Callable[[str, bool], _class_resolver]]c C s t jjj}|| jj| �S r� )r5 r� Zorm_clsregistry� _resolverr r� )r� r� r� r� r� r� � s z+RelationshipProperty._clsregistry_resolversc C sF | j jrBt| j jdd��| j�sBt�d| j| j jj| j jjf ��dS )zOTest that this relationship is legal, warn about inheritance conflicts.Fr� z�Attempting to assign a new relationship '%s' to a non-primary mapper on class '%s'. New relationships can only be added to the primary mapper, i.e. the very first mapper created for class '%s' N) r � non_primaryr r� � has_propertyr� r� r� r� r� r� r� r� r� � s �����z%RelationshipProperty._check_conflictsr. c C s | j S )z\Return the current cascade setting for this :class:`.RelationshipProperty`. )r� r� r� r� r� r� � s z RelationshipProperty.cascadezUnion[str, CascadeOptions])r� r| c C s | � |� d S r� )� _set_cascade�r� r� r� r� r� r� � s )� cascade_argr| c C sJ t |�}| jr t |�t j��}d| jkr2| �|� || _| jrF|| j_d S )Nr� ) r. r� � intersectionZ_viewonly_cascadesr� r� r� r� r� )r� r� r� r� r� r� r� � s � z!RelationshipProperty._set_cascadec C s� |j rV| jsV| jtks | jtkrVtjd| | jtkr6dnd| jjj | j jj d� dd��| j dkr~d|kspd |kr~t�d | ��|j r�| j � � j �| j| jjf� d S ) Na� For %(direction)s relationship %(rel)s, delete-orphan cascade is normally configured only on the "one" side of a one-to-many relationship, and not on the "many" side of a many-to-one or many-to-many relationship. To force this relationship to allow a particular "%(relatedcls)s" object to be referenced by only a single "%(clsname)s" object at a time via the %(rel)s relationship, which would allow delete-orphan cascade to take place in this direction, set the single_parent=True flag.z many-to-onez many-to-many)�relr� ZclsnameZ relatedclsZbbf0��code�allr� r� z^On %s, can't set passive_deletes='all' in conjunction with 'delete' or 'delete-orphan' cascade)Z delete_orphanr� r� r& r' r� r� r r� r� r� r� �primary_mapperZ_delete_orphansr� r� r� r� r� r� r� � sD �������� ���� �z,RelationshipProperty._check_cascade_settingsc C s | j |jko|j| j | kS )zaReturn True if this property will persist values on behalf of the given mapper. )r� Z relationshipsr� r� r� r� � _persists_for� s �z"RelationshipProperty._persists_for)�colsr| c G sR | j jj}|D ]>}|dk r(|j�|�r(q| jjj�|�s| jj�|�s dS qdS )z�Return True if all columns in the given collection are mapped by the tables referenced by this :class:`.RelationshipProperty`. NFT)r� r� r� r� �contains_columnr r� r� )r� r� r� r� r� r� r� r� � s � �z(RelationshipProperty._columns_are_mappedc C s� | j jr dS | jdk �rr| j�srt| jt�r:| ji }}n | j\}}| j�� }|js�t |� � �� |j �}|D ](}|� |�rl|jslt�d|| |f ��ql| jdk r�|�d| jj�}|�d| jj�}n*|�d| jj�}|�dd�}|r�t�d��|�d| j�}| j �� } |�d| j� |�d| j� |�d | j� |�d | j � || _t | | jf|||| j d �|��} |j || d d � | j�r�| � | j� dS )zlInterpret the 'backref' instruction to create a :func:`_orm.relationship` complementary to this one.Nz]Error creating backref '%s' on relationship '%s': property of that name exists on mapper '%s'r� r� zOCan't assign 'secondaryjoin' on a backref against a non-secondary relationship.r� r� r� r� r� )r� r� r� r� T)Zwarn_for_existing)!r r� r� r� r� r� r� r� Zconcreter� Ziterate_to_root�unionZself_and_descendantsr� r� r� r� �popr� �secondaryjoin_minus_local�primaryjoin_minus_local�primaryjoin_reverse_remoter$ r� � setdefaultr� r� r� r� r� r� Z_configure_propertyr� ) r� Z backref_keyr' r� �check�mr r r� r Z relationshipr� r� r� r� s� ��� ��� � � ��� �z&RelationshipProperty._generate_backrefzsqlalchemy.orm.dependencyc C s6 t jj}| jd kr | jtk | _| js2|j�| �| _ d S r� ) r5 r� Zorm_dependencyr� r� r' r� rY Zfrom_relationshipr� )r� � dependencyr� r� r� r� W s ��z RelationshipProperty._post_initc C s | j }|jS )zPmemoize the 'use_get' attribute of this RelationshipLoader's lazyloader.)r� Zuse_get)r� Zstrategyr� r� r� rV b s z RelationshipProperty._use_getc C s | j �| j�S r� )r� r� r r� r� r� r� r. j s z)RelationshipProperty._is_self_referentialr� z"Optional[_InternalEntityType[Any]]r� z�Tuple[ColumnElement[bool], Optional[ColumnElement[bool]], FromClause, FromClause, Optional[FromClause], Optional[ClauseAdapter]])r r r( r r r� r| c C s d}|r| j d k rd}|d kr2|r2| jjr2| jj}|rP|j}|d krV|j}d}n| j}|d kr�| jj}| jjrrd}| jr�|d kr�|�� }d}n|| jjk s�| jjr�d}|j } |p�|d k o�|| jjk p�|j }| j � |||| |�\} } } } }|d kr�| jj }|d k�r | jj }| | ||| | fS )NFT)r� r Zwith_polymorphicr r� r r� r. r/ r0 Z _is_subqueryr� � join_targetsr� )r� r r r( r r r� �aliasedZ dest_mapperr6 r� r� r� r r� r� r� r n sp ������ �z"RelationshipProperty._create_joins)NN)TN)FNT)FN)N)N)FNNNFr� )?r� r� r� r� r Z_RELATIONSHIP_TOKENZstrategy_wildcard_key� inherit_cacheZ_links_to_entityZ_is_relationshipr� rG r� r� r� r� r� r5 Z MemoizedSlotsr) rq r� r` r" rJ re rx r� r! rr r� r� r� r� � staticmethodr� r� �memoized_propertyr� r� r� r� r� r� Zpreload_moduler� r� r� r� r� r� r� �setterr� r� r� r� r� r� rV r. r � __classcell__r� r� r� r� r� 5 s � ��\ s � �Dm � f� �=, L d/ . P �r� rd )�elementr r| c s. ddd�� �fdd� �| d k r&�| �} d �| S )Nry )�elemr| c s* t | tj�r| �� �� �} | j�d� | S )N)�clone)r� r8 r? r2 �copyZ_copy_internals)r� �r r� r� r� r� � s z _annotate_columns.<locals>.cloner� )r� r r� r� r� r � s r c @ s, e Zd ZU ded< ded< ded< ded< ded < d ed < d ed < d ed< ded< ded< ded< ded< ded< dddddddddddd� d� dddddddd d d dd d dd d d �d!d"�Zd#d$�d%d&�Zd#d$�d'd(�Zd#d$�d)d*�Zedd$�d+d,��Z edd$�d-d.��Z e j dd$�d/d0��Z d1d2d d3�d4d5�Ze j d d$�d6d7��Ze j d d$�d8d9��Zd#d$�d:d;�Zd#d$�d<d=�Zd#d$�d>d?�Zd d$�d@dA�Zd d$�dBdC�Zd#d$�dDdE�Zd#d$�dFdG�ZdHd d#dI�dJdK�Zd#d$�dLdM�Zd#d$�dNdO�Zd#d$�dPdQ�Zd#d$�dRdS�Z d#d$�dTdU�Z d#d$�dVdW�Z d#d$�dXdY�Z dd d#dZ�d[d\�Z d#d$�d]d^�Z!d_d`da�dbdc�Z"d#d$�ddde�Z#e$�%� Z&dfedg< d#d$�dhdi�Z'e j djd$�dkdl��Z(e j djd$�dmdn��Z)e j djd$�dodp��Z*d2djdq�drds�Z+dtdudjd3�dvdw�Z,e j dxd$�dydz��Z-d�ddd dd|d}d~�dd��Z.d�d d�d��d�d��Z/dS )�r� r� �primaryjoin_initialr� r� r� r� r� r� r� r� r� r� r* r� rj r� r� r� r� r� r� NFTc G s dS �NTr� )r� r� r� r� �<lambda>� � zJoinCondition.<lambda>) r� r� r� r� r� r� r� r� r� r� r� z Optional[_EquivalentColumnMap]r r� zCallable[..., bool]r� c C s� || _ || _|| _|| _|| _| | _|| _|| _|| _| | _ | | _ | | _ || _ | | _ || _|| _| �� | jd k svt�| �� | �� | �� | �� | �� | �� | �| jd� | jd k r�| �| jd� | �� | �� | � � d S �NTF) r� r� r� r� r� r� r� r� r� r� r� � _remote_sider� r� r� r� �_determine_joinsr� r, �_sanitize_joins� _annotate_fks�_annotate_remote�_annotate_local�_annotate_parentmapper� _setup_pairs�_check_foreign_cols�_determine_direction�_check_remote_side� _log_joins)r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� � s< zJoinCondition.__init__r� r� c C s� | j j}|�d| j | j� |�d| j | j� |�d| j d�dd� | jD ��� |�d| j d�dd� | jpjg D ��� |�d | j d�d d� | jD ��� |�d | j d�d d� | j D ��� |�d | j d�dd� | j D ��� |�d| j | j � d S )Nz%s setup primary join %sz%s setup secondary join %sz%s synchronize pairs [%s]�,c s s | ]\}}d ||f V qdS �z (%s => %s)Nr� �r �lr� r� r� r� r s z+JoinCondition._log_joins.<locals>.<genexpr>z#%s secondary synchronize pairs [%s]c s s | ]\}}d ||f V qdS r r� r r� r� r� r $ s �z%s local/remote pairs [%s]c s s | ]\}}d ||f V qdS )z (%s / %s)Nr� r r� r� r� r , s z%s remote columns [%s]c s s | ]}d | V qdS �z%sNr� �r rM r� r� r� r 3 s z%s local columns [%s]c s s | ]}d | V qdS r r� r r� r� r� r 8 s z %s relationship direction %s) r� �loggerr� r� r� �joinr� r� r� r� r� r� )r� r2 r� r� r� r sF �� �� ����zJoinCondition._log_joinsc C s. t | jdd�| _| jdk r*t | jdd�| _dS )a_ remove the parententity annotation from our join conditions which can leak in here based on some declarative patterns and maybe others. "parentmapper" is relied upon both by the ORM evaluator as well as the use case in _join_fixture_inh_selfref_w_entity that relies upon it being present, see :ticket:`3364`. )r� � proxy_key��valuesN)rC r� r� r� r� r� r� r < s � �z JoinCondition._sanitize_joinsc C sv | j dk r$| jdkr$t�d| j ��z�| jp.d}| jdk r�| j dkr\t| j| j| j|d�| _ | j dkr�t| j | j| j |d�| _ q�| j | _ n,| j dkr�t| j | j| j |d�| _ n| j | _ W n� tj k �r } z:| jdk r�t� d| j| jf �|�nt� d| j �|�W 5 d}~X Y n^ tjk �rp } z<| jdk �rNt�d| j| jf �|�nt�d| j �|�W 5 d}~X Y nX dS )z�Determine the 'primaryjoin' and 'secondaryjoin' attributes, if not passed to the constructor already. This is based on analysis of the foreign key relationships between the parent and target mapped selectables. NzMProperty %s specified with secondary join condition but no secondary argument)Za_subsetr� a1 Could not determine join condition between parent/child tables on relationship %s - there are no foreign keys linking these tables via secondary table '%s'. Ensure that referencing columns are associated with a ForeignKey or ForeignKeyConstraint, or specify 'primaryjoin' and 'secondaryjoin' expressions.a Could not determine join condition between parent/child tables on relationship %s - there are no foreign keys linking these tables. Ensure that referencing columns are associated with a ForeignKey or ForeignKeyConstraint, or specify a 'primaryjoin' expression.al Could not determine join condition between parent/child tables on relationship %s - there are multiple foreign key paths linking the tables via secondary table '%s'. Specify the 'foreign_keys' argument, providing a list of those columns which should be counted as containing a foreign key reference from the secondary table to each of the parent and child tables.a' Could not determine join condition between parent/child tables on relationship %s - there are multiple foreign key paths linking the tables. Specify the 'foreign_keys' argument, providing a list of those columns which should be counted as containing a foreign key reference to the parent table.)r� r� r� r� r� r� rG r� r� r� r� r� r� ZNoForeignKeysErrorZAmbiguousForeignKeysError)r� r� ZnfeZafer� r� r� r N s� �� � � � �� � ��� �� � ���z JoinCondition._determine_joinsc C s t | jdd�S �N��localr} r )rC r� r� r� r� r� r� � s z%JoinCondition.primaryjoin_minus_localc C s | j d k st�t| j dd�S r )r� r, rC r� r� r� r� r� � s z'JoinCondition.secondaryjoin_minus_localc C sJ | j r(dddd�dd�}t�| ji |�S | jr<t| jdd�S t| j�S d S ) a( Return the primaryjoin condition suitable for the "reverse" direction. If the primaryjoin was delivered here with pre-existing "remote" annotations, the local/remote annotations are reversed. Otherwise, the local/remote annotations are removed. ry r � Optional[_CE]�r� r� r| c [ s\ d| j kr,t| j �}|d= d|d< | �|�S d| j krXt| j �}|d= d|d< | �|�S d S )Nr} Tr )� _annotationsrG Z_with_annotations)r� r� r� r� r� r� �replace� s z9JoinCondition.primaryjoin_reverse_remote.<locals>.replacer r N)�_has_remote_annotationsr; �replacement_traverser� �_has_foreign_annotationsrC )r� r! r� r� r� r� � s �z(JoinCondition.primaryjoin_reverse_remoterh r� )r r� r| c C s& t �|i �D ]}||jkr dS q dS r )r; �iterater )r� r r� rM r� r� r� �_has_annotation� s z JoinCondition._has_annotationc C s | � | jd�S �Nr� �r& r� r� r� r� r� r$ � s z&JoinCondition._has_foreign_annotationsc C s | � | jd�S �Nr} r( r� r� r� r� r" � s z%JoinCondition._has_remote_annotationsc C s& | j r dS | jr| �� n| �� dS )z�Annotate the primaryjoin and secondaryjoin structures with 'foreign' annotations marking columns considered as foreign. N)r$ r� �_annotate_from_fk_list�_annotate_present_fksr� r� r� r� r � s zJoinCondition._annotate_fksc sH dddd�� fdd� }t �� ji |�� _� jd k rDt �� ji |�� _d S )Nry r r r c s | � j kr| �ddi�S d S �Nr� T)r� r2 �r� r� r� r� r� �check_fk� s z6JoinCondition._annotate_from_fk_list.<locals>.check_fk)r; r# r� r� )r� r. r� r� r� r* � s � �z$JoinCondition._annotate_from_fk_listc s� | j d k rt�| j j��nt� �dddd��fdd� � ddd�� fd d � }t�| ji d |i�| _| jd k r�t�| ji d |i�| _d S ) Nrz z Optional[ColumnElement[Any]])�a�br| c sd t | tj�r4t |tj�r4| �|�r&| S |�| �r4|S � r`| � krL|� krL| S |� kr`| � kr`|S d S r� )r� r3 �ColumnZ references)r/ r0 )� secondarycolsr� r� � is_foreign s z7JoinCondition._annotate_present_fks.<locals>.is_foreign�BinaryExpression[Any]r� ��binaryr| c s� t | jtj�r t | jtj�s d S d| jjkr�d| jjkr�� | j| j�}|d k r�|�| j�rn| j�ddi�| _n |�| j�r�| j�ddi�| _d S r, )r� �leftr4 r@ �rightr �comparer2 )r6 rM )r3 r� r� � visit_binary s& � � � � �z9JoinCondition._annotate_present_fks.<locals>.visit_binaryr6 ) r� r5 r� r� r� r; rl r� r� �r� r: r� )r3 r2 r� r+ s � �z#JoinCondition._annotate_present_fksc s@ | j �| j� d�ddd�� ��fdd� }t�| ji d|i� �S )zvReturn True if the join condition contains column comparisons where both columns are in both tables. Fr4 r� r5 c s^ | j | j }}t|tj�rZt|tj�rZ��|j�rZ��|j�rZ� �|j�rZ� �|j�rZd�d S r )r7 r8 r� r8 r? Zis_derived_from�table)r6 r� �f��mt�pt�resultr� r� r: A s � � � � � �z;JoinCondition._refers_to_parent_table.<locals>.visit_binaryr6 )r� r� r; r1 r� r; r� r> r� �_refers_to_parent_table8 s z%JoinCondition._refers_to_parent_tablec C s t | j| j�S )z5Return True if parent/child tables have some overlap.)rH r� r� r� r� r� r� �_tables_overlapQ s �z JoinCondition._tables_overlapc C sl | j r dS | jdk r | �� nJ| js*| jr4| �� n4| �� rN| �dd� d� n| �� r`| � � n| � � dS )z�Annotate the primaryjoin and secondaryjoin structures with 'remote' annotations marking columns considered as part of the 'remote' side. Nc S s d| j kS r' �r rN r� r� r� r g r z0JoinCondition._annotate_remote.<locals>.<lambda>F) r" r� �_annotate_remote_secondaryr� r �_annotate_remote_from_argsrB �_annotate_selfrefrC � _annotate_remote_with_overlap�%_annotate_remote_distinct_selectablesr� r� r� r� r X s � z JoinCondition._annotate_remotec s` | j dk st�| j � dddd�� fdd� }t�| ji |�| _| jdk sJt�t�| ji |�| _dS )z^annotate 'remote' in primaryjoin, secondaryjoin when 'secondary' is present. Nry r r r c s � j �| �r| �ddi�S d S �Nr} T)r� r� r2 r- �Zfixed_secondaryr� r� �replw s z6JoinCondition._annotate_remote_secondary.<locals>.repl)r� r, r; r# r� r� �r� rL r� rK r� rE n s � �z(JoinCondition._annotate_remote_secondaryz$Callable[[ColumnElement[Any]], bool])�fn�remote_side_givenr| c s2 ddd�� ��fdd� }t ��ji d|i��_dS )zxannotate 'remote' in primaryjoin, secondaryjoin when the relationship is detected as self-referential. r4 r� r5 c sx | j �| j�}t| j tj�rht| jtj�rh� | j �rF| j �ddi�| _ � | j�rt|st| j�ddi�| _n �st��� d S rJ )r7 r9 r8 r� r8 r? r2 �_warn_non_column_elements)r6 Zequated�rN rO r� r� r� r: � s � z5JoinCondition._annotate_selfref.<locals>.visit_binaryr6 N)r; rl r� )r� rN rO r: r� rQ r� rG � s �z JoinCondition._annotate_selfrefc sx | j r(| jrt�d��dd� | j D �� n| j� | �� rL| �� fdd�d� n(ddd d �� fd d � }t�| ji |�| _d S )z�annotate 'remote' in primaryjoin, secondaryjoin when the 'remote_side' or '_local_remote_pairs' arguments are used. zTremote_side argument is redundant against more detailed _local_remote_side argument.c S s g | ] \}}|�qS r� r� r r� r� r� rT � s z<JoinCondition._annotate_remote_from_args.<locals>.<listcomp>c s | � kS r� r� rN �r� r� r� r � r z:JoinCondition._annotate_remote_from_args.<locals>.<lambda>Try r r r c s | t � �kr| �ddi�S d S rJ )r� r2 r- rR r� r� rL � s z6JoinCondition._annotate_remote_from_args.<locals>.replN) r� r r� r� rB rG r; r# r� rM r� rR r� rF � s � �z(JoinCondition._annotate_remote_from_argsc s` ddd��fdd� }�j dk o,�j j�j jk � dddd �� �fd d � �t��ji d |i��_dS ) z�annotate 'remote' in primaryjoin, secondaryjoin when the parent/child tables have some set of tables in common, though is not a fully self-referential relationship. r4 r� r5 c s0 � | j | j�\| _ | _� | j| j �\| _| _ d S r� �r7 r8 )r6 )�proc_left_rightr� r� r: � s � �zAJoinCondition._annotate_remote_with_overlap.<locals>.visit_binaryNrz z-Tuple[ColumnElement[Any], ColumnElement[Any]])r7 r8 r| c s� t | tj�rDt |tj�rD�jj�|�r��jj�| �r�|�ddi�}nX� rl|j� d��j j krl|�ddi�}n0� r�| j� d��j j kr�| �ddi�} n�� � | |fS )Nr} Tr� ) r� r8 r? r� r� r� r� r2 r r� r� r� rP rS )�check_entitiesr� r� r� rT � s, �� �����zDJoinCondition._annotate_remote_with_overlap.<locals>.proc_left_rightr6 )r� r� r r; rl r� r; r� )rU rT r� r� rH � s � �z+JoinCondition._annotate_remote_with_overlapc s, dddd�� fdd� }t �� ji |�� _dS )z}annotate 'remote' in primaryjoin, secondaryjoin when the parent/child tables are entirely separate. ry r r r c s< � j j�| �r8� jj�| �r*� jj�| �r8| �ddi�S d S rJ )r� r� r� r� r� r2 r- r� r� r� rL � s � �zAJoinCondition._annotate_remote_distinct_selectables.<locals>.replN�r; r# r� rM r� r� r� rI � s �z3JoinCondition._annotate_remote_distinct_selectablesc C s t �d| j � d S )Nz�Non-simple column elements in primary join condition for property %s - consider using remote() annotations to mark the remote side.)r5 r� r� r� r� r� r� rP s ��z'JoinCondition._warn_non_column_elementsc sj | � | jd�rdS | jr0t�dd� | jD ��� nt�| jj�� dddd�� fd d � }t�| ji |�| _dS ) aC Annotate the primaryjoin and secondaryjoin structures with 'local' annotations. This annotates all column elements found simultaneously in the parent table and the join condition that don't have a 'remote' annotation set up from _annotate_remote() or user-defined. r Nc S s g | ] \}}|�qS r� r� r r� r� r� rT s z1JoinCondition._annotate_local.<locals>.<listcomp>ry r r r c s$ d| j kr | � kr | �ddi�S d S )Nr} r T)r r2 r- �Z local_sider� r� �locals_ s z.JoinCondition._annotate_local.<locals>.locals_) r& r� r� r5 r� r� r� r; r# )r� rX r� rW r� r s � �z JoinCondition._annotate_localc s, dddd�� fdd� }t �� ji |�� _d S )Nry r r r c s< d| j kr | �d� jji�S d| j kr8| �d� jji�S d S )Nr} r� r )r r2 r� r� r r- r� r� r� �parentmappers_) s z<JoinCondition._annotate_parentmapper.<locals>.parentmappers_rV )r� rY r� r� r� r ( s �z$JoinCondition._annotate_parentmapperc C s^ | j st�d| jf ��n@t�| jj��| j j�}| j D ] \}}||kr8t� d|f � q8d S )Na Relationship %s could not determine any unambiguous local/remote column pairs based on join condition and remote_side arguments. Consider using the remote() annotation to accurately mark those elements of the join condition that are on the remote side of the relationship.z�Expression %s is marked as 'remote', but these column(s) are local to the local side. The remote() annotation is needed only for a self-referential relationship where both sides of the relationship refer to the same tables.) r� r� r� r� r5 r� r� r� � differencer� r� )r� Z not_target�_Zrmtr� r� r� r 4 s$ �� ����z JoinCondition._check_remote_side)rG �primaryr| c C s� d}| � |d�}t|�}|r(t| j�}n t| j�}| jr<|sF| jsJ|rJdS | jr�|r�|s�d|rbdpdd|| jf }|d7 }t�|��n*d|r�dp�d|| jf }|d 7 }t�|��dS ) zHCheck the foreign key columns collected and emit error messages.Fr� Nz�Could not locate any simple equality expressions involving locally mapped foreign key columns for %s join condition '%s' on relationship %s.r\ r� a Ensure that referencing columns are associated with a ForeignKey or ForeignKeyConstraint, or are annotated in the join condition with the foreign() annotation. To allow comparison operators other than '==', the relationship can be marked as viewonly=True.z`Could not locate any relevant foreign key columns for %s join condition '%s' on relationship %s.z� Ensure that referencing columns are associated with a ForeignKey or ForeignKeyConstraint, or are annotated in the join condition with the foreign() annotation.)� _gather_columns_with_annotationr� r� r� r� r� r� r� )r� rG r\ Zcan_syncZ foreign_colsZ has_foreign�errr� r� r� r P sR � ���� ��� � ��� �z!JoinCondition._check_foreign_colsc C s� | j dk rt| _n�t�| jj�}t�| jj�}|�| j �}|�| j �}|r�|r�| � | j dd�}dd� | � | j d�D �}|r�|r�| j �| j �}|�|�}|�|�}|r�|s�t| _q�|r�|s�t| _q�t�d| j ��n(|r�t| _n |r�t| _nt�d| j ��dS )z[Determine if this relationship is one to many, many to one, many to many. Nr} r� c S s h | ]}d |j kr|�qS )r} rD �r r� r� r� r� � <setcomp>� s �z5JoinCondition._determine_direction.<locals>.<setcomp>aD Can't determine relationship direction for relationship '%s' - foreign key columns within the join condition are present in both the parent and the child's mapped tables. Ensure that only those columns referring to a parent column are marked as foreign, either via the foreign() annotation or via the foreign_keys argument.z�Can't determine relationship direction for relationship '%s' - foreign key columns are present in neither the parent nor the child's mapped tables)r� r& r� r5 r� r� r� r� r� r� r] r� r� r� rZ r( r' r� r� r� )r� Z parentcolsZ targetcolsZ onetomany_fkZ manytoone_fkZonetomany_localZmanytoone_localZ self_equatedr� r� r� r � sT � �� � �� ��z"JoinCondition._determine_direction�_ColumnPairIterable�_MutableColumnPairs)r� r| c C s dd� |D �S )z�provide deannotation for the various lists of pairs, so that using them in hashes doesn't incur high-overhead __eq__() comparisons against original columns mapped. c S s g | ]\}}|� � |� � f�qS r� �Z _deannotaterQ r� r� r� rT � s z3JoinCondition._deannotate_pairs.<locals>.<listcomp>r� )r� r� r� r� r� �_deannotate_pairs� s z JoinCondition._deannotate_pairsc s� g }t �g �� g }dddd�� �fdd� }�j|f�j|ffD ] \}}|d krPq>|||� q>��� ��_��|��_��|��_d S )Nr� rb r� )�joincondr� r| c s* ddddd�� ��fdd� }t || � d S )Nr4 rz r� )r6 r7 r8 r| c s� d|j kr.d|j kr.��|�r.��||f� n,d|j krZd|j krZ��|�rZ��||f� | jtjkr���||�r�d|j kr�� �||f� nd|j kr�� �||f� d S )Nr} r� )r r� r� �operatorr9 �eqr� )r6 r7 r8 )r� �lrpr� r� r� r: � s, ������ � z<JoinCondition._setup_pairs.<locals>.go.<locals>.visit_binaryrI )re r� r: �rh r� )r� r� �go� s z&JoinCondition._setup_pairs.<locals>.go)r5 Z OrderedSetr� r� rd r� r� r� )r� Z sync_pairsZsecondary_sync_pairsrj re r� r� ri r� r � s � � �zJoinCondition._setup_pairszwweakref.WeakKeyDictionary[ColumnElement[Any], weakref.WeakKeyDictionary[RelationshipProperty[Any], ColumnElement[Any]]]� _track_overlapping_sync_targetsc s� | j s d S dd� | jD �dd� | jD � D �]b\}� � | jkrVt�| j|i�| j� < q*g }| j� }|�� D ]�\}}|jj sl|| jj krl|j | jj krl| jj |j krld| jj krld|j krl| jj �|j �sl| jj�|j�sl| jj �|j�sl| jj�|j �sl| jj |j k�s| jj �|j �sl|�||f� ql|�r~tjd| j|� d�t� fdd�|D ���d �td d� |D ���| jf d d � || j� | j< q*d S ) Nc S s g | ]\}}||f�qS r� r� �r �from_�to_r� r� r� rT 5 s zDJoinCondition._warn_for_conflicting_sync_targets.<locals>.<listcomp>c S s g | ]\}}||f�qS r� r� rl r� r� r� rT 7 s z__*a relationship '%s' will copy column %s to column %s, which conflicts with relationship(s): %s. If this is not the intention, consider if these relationships should be linked with back_populates, or if viewonly=True should be applied to one or more if they are read-only. For the less common case that foreign key constraints are partially overlapping, the orm.foreign() annotation can be used to isolate the columns that should be written towards. To silence this warning, add the parameter 'overlaps="%s"' to the '%s' relationship.z, c 3 s | ]\}}d ||� f V qdS )z'%s' (copies %s to %s)Nr� )r �pr�fr_�rn r� r� r v s �zCJoinCondition._warn_for_conflicting_sync_targets.<locals>.<genexpr>r c s s | ]\}}|j V qd S r� �r� )r ro �frr� r� r� r { s Zqzyxr� )r� r� r� rk �weakref�WeakKeyDictionaryr� r� r� Z_dispose_calledr� r� r� r Z is_siblingr� r� r5 r� r �sorted)r� rm Z other_propsZ prop_to_fromro rp r� rq r� r� , st ��� � � � � � � � ���� �� ����� z0JoinCondition._warn_for_conflicting_sync_targetsr� c C s | � d�S r) ��_gather_join_annotationsr� r� r� r� r� � s z JoinCondition.remote_columnsc C s | � d�S )Nr rw r� r� r� r� r� � s zJoinCondition.local_columnsc C s | � d�S r' rw r� r� r� r� r� � s z!JoinCondition.foreign_key_columns)r� r| c C s> t | �| j|��}| jd k r0|�| �| j|�� dd� |D �S )Nc S s h | ] }|� � �qS r� rc r� r� r� r� r` � s z9JoinCondition._gather_join_annotations.<locals>.<setcomp>)r� r] r� r� r� )r� r� �sr� r� r� rx � s � ��z&JoinCondition._gather_join_annotationsrz z Iterable[str]c s" t |�� � fdd�t�|i �D �S )Nc s& h | ] }� � |j�rttt |��qS r� )�issubsetr r r@ r r �Zannotation_setr� r� r` � s �z@JoinCondition._gather_columns_with_annotation.<locals>.<setcomp>)r� r; r% )r� r r� r� r{ r� r] � s �z-JoinCondition._gather_columns_with_annotationz FrozenSet[ColumnElement[Any]]c C s0 | j d k r&ttjdd� | j jD �� �S tjS d S )Nc S s g | ] }|j �qS r� )Z proxy_setr_ r� r� r� rT � s z8JoinCondition._secondary_lineage_set.<locals>.<listcomp>)r� � frozenset� itertools�chainr� r5 � EMPTY_SETr� r� r� r� �_secondary_lineage_set� s �z$JoinCondition._secondary_lineage_setr� r� ztTuple[ColumnElement[bool], Optional[ColumnElement[bool]], Optional[FromClause], Optional[ClauseAdapter], FromClause])r r( r� r6 r� r| c sj t |ddi�}�j�j�j }}}|dk rF|dk r>||@ }n||@ }|r�dddd��fdd� � t� fd d �|D ��}|dk r�|tj|� @ }n|tj|� @ }|�rX|dk �r|jdd �}t|t d �} t|�j d �� | �} |dk r�t|t d �� t|�j d ��} | � |�}n4t|t �j d�} |dk �r8| � t|t�j d�� d} | � |�}| �pN| } d| _nd} |||| |fS )a7 Given a source and destination selectable, create a join between them. This takes into account aliasing the join clause to reference the appropriate corresponding columns in the target objects, as well as the extra child criterion, equivalent column sets, etc. r* TNre rd )r� r r| c sB | j �dd�}|� jjk r:|� jjk r:| � jkr:t| |�S | S dS )a note unrelated columns in the "extra criteria" as either should be adapted or not adapted, even though they are not part of our "local" or "remote" side. see #9779 for this case, as well as #11010 for a follow up r� N)r r� r� r r� r� r> )r� r Zparentmapper_for_elementr� r� r� �mark_exclude_cols� s � � �� z5JoinCondition.join_targets.<locals>.mark_exclude_colsc 3 s | ]}t |d di� d�V qdS )�should_not_adaptT)Zannotate_callableNrA )r r� )r� r� r� r � s ��z-JoinCondition.join_targets.<locals>.<genexpr>)Zflat)� exclude_fn)� equivalents)r� r� )rD r� r� r� r r4 r r/ rF �_local_col_excluder� r~ r� r1 �_remote_col_excluder� ) r� r r( r� r6 r� r� r� r� Zprimary_aliasizerZsecondary_aliasizerr r� )r� r� r� r� � s� �� � � ����� � �� �zJoinCondition.join_targetszgTuple[ColumnElement[bool], Dict[str, ColumnElement[Any]], Dict[ColumnElement[Any], ColumnElement[Any]]])rm r| c s i � i }| j d k ��rLt�t��| jD ]"\}}�| �||f� |||< q&n6�sj| jD ]\}}|||< qVn| jD ]\}}|||< qpdddd�� ���fdd� }| j}| j d ks��s�t�|i |�}| j d k r�| j }�r�t�|i |�}t � ||�}� fdd�� D �}|||fS ) Nrz r z Optional[BindParameter[Any]]r c sX �sd| j ks,�rT�r | �ks,�sTd| j krT| � krLtjd d | jdd�� | < � | S d S )Nr r} T)rE rF )r r4 rH rI r- ��bindsZ has_secondary�lookuprm r� r� � col_to_bindP s. ������� � z5JoinCondition.create_lazy_clause.<locals>.col_to_bindc s i | ]}� | j |�qS r� rr r )r� r� r� � <dictcomp>p s z4JoinCondition.create_lazy_clause.<locals>.<dictcomp>) r� � collections� defaultdict�listr� r� r� r; r# r4 r ) r� rm Zequated_columnsr r� r� Z lazywherer� rb r� r� r� �create_lazy_clause: s@ � � z JoinCondition.create_lazy_clause)Nr� )F)0r� r� r� r� r� r r r r� r� r� r5 r� r� r& r$ r" r r* r+ rB rC r rE rG rF rH rI rP r r r r r rd r rt ru rk r� r� r� r� rx r] r� r� r� r� r� r� r� r� � s� �05&_$2!1 DR 9� V � r� c @ s2 e Zd ZdZdZdd�dd�Zddd�d d �Zd S ) �_ColInAnnotationsz�Serializable object that tests for names in c._annotations. TODO: does this need to be serializable anymore? can we find what the use case was for that? )�namesr� c G s t |�| _d S r� )r| r� )r� r� r� r� r� r� s z_ColInAnnotations.__init__rh r� )r� r| c C s t | j�|j��S r� )r� r� r� r )r� r� r� r� r� �__call__� s z_ColInAnnotations.__call__N)r� r� r� r� r� r� r� r� r� r� r� r� u s r� r r� c @ s e Zd ZdZdZdS )� Relationshipa� Describes an object property that holds a single item or list of items that correspond to a related database table. Public constructor is the :func:`_orm.relationship` function. .. seealso:: :ref:`relationship_config_toplevel` .. versionchanged:: 2.0 Added :class:`_orm.Relationship` as a Declarative compatible subclass for :class:`_orm.RelationshipProperty`. TN)r� r� r� r� r� r� r� r� r� r� � s r� c @ s& e Zd ZdZdZedd�dd��ZdS )�_RelationshipDeclaredz>Relationship subclass used implicitly for declarative mapping.Tr� r� c C s dS )Nr� r� )r� r� r� r� �_mapper_property_name� s z+_RelationshipDeclared._mapper_property_nameN)r� r� r� r� r� � classmethodr� r� r� r� r� r� � s r� )�r� � __future__r r� r � dataclassesr6 r� r} r� r� r r r r r r r r r r r r r r r r r r r rt � r r Z_typingr r �baser r r r r r! r" r# Z interfacesr$ r% r& r' r( r) r* r+ r5 r, r- r. r0 r� r1 r2 r3 r4 Z inspectionr7 r8 r9 r: r; Z sql._typingr< r= Zsql.annotationr> Z sql.elementsr? r@ Zsql.utilrB rC rD rE rF rG rH rJ Z util.typingrK rL rM � TYPE_CHECKINGrN rO rP rQ rR rS rT rU Z clsregistryrV rW Z decl_baserX r� rY r� rZ �queryr[ ry r\ rC r] Z strategiesr^ r_ r` ra rb rc rd re rf rg rh Z sql.schemari Zsql.selectablerj rk rl rm ro rp rq rr r� Z_RelationshipArgumentTyper� r� Z"_RelationshipJoinConditionArgumentZ _RelationshipSecondaryArgumentr� ZORMBackrefArgumentZ DMLColumnRoleZ_ORMColCollectionElementZ_ORMColCollectionArgumentrx ry ra r� rb r} r� � dataclassr� r� r� Z class_loggerZ Identifiedr� r r� r� r� r� r� r� r� r� r� r� �<module> s� �� � ���� �� �� � / � �