U
|
¸ý°dSû ã
|
@ s@ d Z ddlmZ ddlZddlmZ ddlZddlZddlZddl Z ddl m
|
Z
|
ddl m Z ddl m Z ddl m Z 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 mZ ddl Z ddl m 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,m/Z/ dd'l,m0Z0 dd(l,m1Z1 dd)l,m2Z2 dd*l,m3Z3 dd+l,m4Z4 dd,l5m6Z6 dd-l5m7Z7 dd.l5m8Z8 d/d0l m9Z: d/d1l m;Z; d/d2l m<Z< d/d3l m=Z= d/d4l m>Z> d/d5l m5Z5 d/d6l?mZ d/d7l>m@Z@ d/d8l>mAZA d/d9l>mBZB d/d:l>mCZC d/d;l>mDZD d/d<lEmFZF d/d=lEmGZG d/d>lHmIZI d/d?lHmJZJ d/d@lKmLZL d/dAlKmMZM d/dBlKmNZN d/dClKmOZO d/dDlKmPZP d/dElKmQZQ d/dFlKmRZR d/dGlSmTZT d/dHlSmUZU d/dIlSmVZV e jWràddJl mXZX ddKl mYZY ddLl mZZZ ddMl m[Z[ ddNl m\Z\ ddOl m]Z] ddPl m^Z^ ddQl#m_Z_ ddRl`maZa ddSl`mbZb ddTlcmdZd ddUlemfZf ddVlgmhZh ddWlimjZj ddXlkmlZl ddYlmmnZn ddZlompZp dd[l5mqZq dd\l5mrZr d/d]lEmsZs d/d^lEmtZt d/d_lEmuZu d/d`lvmwZw d/dalHmxZx d/dblHmyZy d/dclHmzZz d/ddl{m|Z| d/del}m~Z~ d/dflSmZ d/dglSmZ edhe
|
diZedje
|
diZedke
|
diZedle
|
diZedme
|
diZ
eeee e g ee f dndoe g dnf e g dof f ZeUdp ZeeeFe f Zedqee g dqf f ZeeUdr eeFe
|
e g eeJe
|
f eeeeFe
|
f f Zeeeeeee
|
f f f ZeeIe
|
eGeCjdsf Zeeee e g ee f e g ef ef ZedteFe
|
diZedudvdiZeeeJe
|
eJe
|
f ZeeeJe
|
eJe
|
f ZeeeJe
|
eJe
|
f ZdtdtdwdxdyZdtdtdwdzd{ZejG d|d} d}eeef ZG d~d deZe<jG dd de.e4e e<jZdudduddd
ZG dd dZG dd dZ G dd dee 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)Ú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)Ú ColumnClause)Ú ColumnElement)Ú_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)Ú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ÚdynamicTFNre Fz Mapped[Any]Ú_CEAÚ_CEúColumnElement[Any])ÚexprÚreturnc C s t t tj| ¡ddiS )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_columnsr6 Úexpectr9 ÚColumnArgumentRole©rv © r~ úSd:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\sqlalchemy/orm/relationships.pyrx É s ÿrx c C s t t tj| ¡ddiS )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`
|
|
ÚforeignTry r} r~ r~ r r Ü s ÿr c @ sL e Zd ZU dZdZded< ded< ded< d d
|
d d Zd ddddZdS )Ú_RelationshipArgztstores a user-defined parameter value that must be resolved and
|
parsed later at mapper configuration time.
|
|
)ÚnameÚargumentÚresolvedÚstrr rj r z Optional[_T2]r Úbool©rw 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_resolverrw c C sJ | j }t|tr&||| jdk | _n t|r@t|s@| | _n|| _d S )NÚ secondary)r Ú
|
isinstancer
r r Úcallabler )r r Ú
|
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Ú secondaryjoinzd_RelationshipArg[_ORMOrderByArgument, Union[Literal[(None, False)], Tuple[ColumnElement[Any], ...]]]Ú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 ddddddZ 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@dAdBdCZdDd@dEdFdGZG dHdI dIejee ZdÂdJd/dKd dLdMdNZdÃd?d/dOd/d dPdQdRZdDdSdTdUdVdWdXdYZdÄd/dOd dZd[d\Zd0d]d^d_Zd`dSdTdSdTd/dadbd@dc dddeZe j fdfdTd0dgdhdidjdkZ dÅd0dSdTdldmdndodpdqZ e d/d]drdsZ!e"dtdtd@dudvdwZ#d0d@dxdydzZ$ej%d{d]d|d}Z&ej%d~d]ddZ'd@d] fdd Z(d@d]ddZ)d@d]d
dZ*dddd,d0dddd/d@d
|
ddZ+e ,d¡dÆd?d@dddZ-d@d]ddZ.e dd]ddZ/e dd]ddZ0ej%e ,d¡dd]ddZ1d@d]dd Z2e d¡d]d¢d£Z3e3j4d¤d@d¥d¦d£Z3d¤d@d§d¨d©Z5d¡d@d¥dªd«Z6dDd/dEd¬dZ7dUd/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]Ú _overlapsrZ Ú_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_conditionz5Union[Literal[False], Tuple[ColumnElement[Any], ...]]r ú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, mergero )"Ú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| rt
|
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Ä r4 Ú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Õ e s ,
|
|
|
|
|
|
ú ûÿÿÿ
|
ÿ
|
|
ÿz RelationshipProperty.__init__r r )Úkwrw 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_onlyr4 rÙ )r rã ÚkÚvr~ r~ r rÖ ï s üÿz5RelationshipProperty._warn_for_persistence_only_flagsz Mapper[Any])Úmapperrw 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 ddZdddddZded< ded< ddddZddd d Z d dd d Z
|
d!dd"d#Z d$d%d&d'd(Z d)d*d+d,d-Z d.d/d0d1d2ZdZd.d!d0d3d4ZdId5d.d6d7d8d9ZdJd5d.d!d7d:d;ZdKd5d.d!d7d<d=Zd>d.d!d?d@dAZd.d!d0dBdCZd.d!d0dDdEZd ddFdGZdS )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 )zConstruction 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Õ * s z(RelationshipProperty.Comparator.__init__zAliasedInsp[Any]z$RelationshipProperty.Comparator[Any])rõ rw c C s | j | j| j|| jdS )N)rõ rö )râ rò rø rð )r rõ r~ r~ r rõ ? 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ð r5 rò rî r r~ r~ r Ú_memoized_attr_entity^ s
|
z5RelationshipProperty.Comparator._memoized_attr_entityc C s | j jS r ©rî rè r r~ r~ r Ú_memoized_attr_mapperd s z5RelationshipProperty.Comparator._memoized_attr_mapperre c C s | j r| j jS | jjjS d S r )rù Ú
|
selectablerï ÚparentÚ _with_polymorphic_selectabler r~ r~ r Ú_source_selectableg 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ð r5 rò Ú _create_joinsrñ ) r Z
|
adapt_fromr ÚpjÚsjÚsourceÚdestr Útarget_adapterr~ r~ r Ú__clause_element__m s* ûùz2RelationshipProperty.Comparator.__clause_element__z_EntityType[Any]zPropComparator[_PT])rê rw c C s t j| j| j| j|| jdS )zRedefine 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])Úcriteriarw c G s: t dd t |¡D }tj| j| j| j| j| j | dS )zAdd AND criteria.
|
|
See :meth:`.PropComparator.and_` for an example.
|
|
.. versionadded:: 1.4
|
|
c s s | ]}t tj|¡V qd S r )r6 r{ r9 ÚWhereHavingRole)Ú.0Úclauser~ r~ r Ú <genexpr> s ÿz7RelationshipProperty.Comparator.and_.<locals>.<genexpr>r )
|
Útupler4 Zcoerce_generator_argr rÚ rò rø rù rð rñ )r r Úexprsr~ r~ r Úand_ s
|
þûz$RelationshipProperty.Comparator.and_r r )Úotherrw c C s t ddS )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 |tjrF| jjttfkr.| ¡ S t| jj d| j
|
dS n*| jj rZt d¡nt| jj || j
|
dS 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 r7 ÚNullrï r¸ r' r% Ú_criterion_existsr+ Ú_optimized_compareÚadapterrº r× ÚInvalidRequestErrorr r~ r~ r Ú__eq__¼ s& %
|
ÿÿÿ ÿÿz&RelationshipProperty.Comparator.__eq__z)Optional[_ColumnExpressionArgument[bool]]r0 )Ú criterionÚkwargsrw c K s¸ |d k rt tj|¡nd }t| dd rt| 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 rt d¡ |¡ | |¡ | |¡}n t d¡ |¡ | ¡ | ¡}|S )Nrð F)Údest_selectabler )ÚexcludeÚno_replacement_traverseTr ) r6 r{ r9 r Úgetattrr5 rð ÚAssertionErrorrè rý Úis_aliased_classrï Ú_is_self_referentialÚ_anonymous_fromclauseÚ_single_table_criterionr r r rê r+ r ÚtraverseÚ _annotater3 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 Úany] 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`.
|
|
z4'has()' not implemented for collections. Use any().r6 r7 r~ r~ r Úhas s
|
ÿz#RelationshipProperty.Comparator.hasz _ColumnExpressionArgument[Any])r r# rw 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 |¡dddddfdd dddfd d
|
jjrjtj fd d jj D S tjd d t
|
jj j jj |¡D } |¡ S )Nru úInstanceState[Any]úBindParameter[Any])Ú local_colÚstateÚ
|
remote_colrw c
|
s. |j }tj| j| jd j jj|||¡dS )NT)Útype_ÚuniqueZ callable_)Údictr3 Ú bindparamrë Útyperò Ú_get_attr_w_warn_on_nonerè )r> r? r@ Údict_r r~ r Ústate_bindparam s ÿüzURelationshipProperty.Comparator.__negated_contains_or_equals.<locals>.state_bindparamrt )Úcolrw c s j r | ¡S | S d S r )r ©rI r r~ r Úadapt s
|
zKRelationshipProperty.Comparator.__negated_contains_or_equals.<locals>.adaptc s8 g | ]0\}}t | ||k |d k¡qS r )r3 Úor_©r ÚxÚy)rK r? rH r~ r Ú
|
<listcomp># s ûÿ
|
ýzPRelationshipProperty.Comparator.__negated_contains_or_equals.<locals>.<listcomp>c S s g | ]\}}||kqS r~ r~ rM r~ r~ r rP . s ÿ)rò r¸ r& r Úinstance_staterï Ú_use_getr3 r r· Úziprè Z primary_keyZprimary_key_from_instancer )r r r" r~ )rK r r? rH r Z __negated_contains_or_equals s&
|
úÿ þþÿ
|
z<RelationshipProperty.Comparator.__negated_contains_or_equalsc C sh |dkst |tjrB| 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 r7 r rï r¸ r& r+ r r r rº r× r r: r r~ r~ r Ú__ne__9 s ' ÿÿ
|
ÿz&RelationshipProperty.Comparator.__ne__c C s | j j ¡ | j S r )rò rþ Ú_check_configurer r~ r~ r Ú_memoized_attr_propertys 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 r8 r9 r; r: rT rV r~ r~ r~ r rÚ
|
s<
|
ú
|
< þi þ7 þ&N3:rÚ ÚobjectzOptional[_EntityType[Any]])Úinstancer Ú from_entityrw c C sN |d k s t d }|d k r<t|}|d k s,t t|r<|jj}| j|d||dS )NT)Úvalue_is_parentr r )r( r5 r Z_adapterZ adapt_clauser )r rY r rZ r Zinspr~ r~ r Ú _with_parentw s üz!RelationshipProperty._with_parentzOptional[_CoreAdapterProto])r? r[ r r rw c s d k rRz t W n tjk
|
r. d Y nX d ksDtddsRt d ¡| }d krnj||dS |sjjjj } njj jj
|
} |r¤j nj t ¡ ¡ddd fdd }jd k rö|rötj ¡ |¡}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 r= r )rD rw c s& | j kr" | j ¡| _d S r )Z_identifying_keyrF r )rD ©Ú bind_to_colrG rè r r? r~ r Úvisit_bindparam¹ s
|
üz@RelationshipProperty._optimized_compare.<locals>.visit_bindparamrD )r5 r× ÚNoInspectionAvailabler' rØ Ú_lazy_none_clauser¢ Ú
|
_lazywhereÚ _bind_to_colÚ_rev_lazywhereÚ_rev_bind_to_colrè rþ r Ú instance_dictÚobjr rB r+ r- r: Úcloned_traverse)r r? r[ r r Úreverse_directionr" r_ r~ r] r r sV
|
üÿ ÿþþ ÿþ ÿz'RelationshipProperty._optimized_comparer< rM ru zCallable[[], Any])rè r? rG Úcolumnrw c s< ¡ j¡ jdd 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|st d t f ¡n*|tjkr|st 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_RESULTr4 rÙ )Z
|
last_knownZ to_returnZexisting_is_availableZ current_value©rj rG Z lkv_fixedrè rò r? 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è r? rG rj rq r~ rp r rF Ï s
|
1
|
-z-RelationshipProperty._get_attr_w_warn_on_none)ri r rw c C sD |s| j j| j j }}n| j j| j j }}t||}|r@||}|S r )r¢ rb rc rd re rA )r ri r r" r^ r~ r~ r ra 8 s þþ
|
z&RelationshipProperty._lazy_none_clauser c C s t | jjjd | j S )NÚ.)r
rþ rê r rë r r~ r~ r Ú__str__N s z RelationshipProperty.__str__rX zDict[Any, object]z#Dict[_IdentityKeyType[Any], object]) ÚsessionÚ source_stateÚ source_dictÚ
|
dest_stateÚ dest_dictÚloadÚ
|
_recursiveÚ_resolve_conflict_maprw c C sÎ |r"| j D ]} || f|kr
|
d S q
|
d| jkr0d S | j|kr>d S | jrR| | j¡}
|
t|
|
s^t|
|
||¡} |
|
jrx| j rndst|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 rt | ¡}t | ¡}d||| f< |j|||||d}nd }|s²||| j< n| | j¡ |||d ¡ d S )NÚmergeTrk )ry rz r{ F)Z_adaptrl )rÞ Ú_cascaderë rº Zget_implr r( Úget_collectionÚ
|
collectionÚemptyÚgetr Z PASSIVE_MERGEr rQ rf Z_mergeÚappendZinit_state_collectionZappend_without_eventrÝ )r rt ru rv rw rx ry rz r{ ÚrÚimplZinstances_iterableZ dest_listÚcurrentZ current_stateZ current_dictrg ZcollÚcZ dest_implr~ r~ r r| Q s
|
|
|
ÿ
|
|
û ÿ û
|
|
|
|
û ÿzRelationshipProperty.mergezInstanceState[_O]r z&Sequence[Tuple[InstanceState[_O], _O]])r? rG rë rl rw c C sj |j | j}|j|||d}|tjks.|dkr2g S t|rVdd |j||||dD S t |¡|fgS dS )zReturn a list of tuples (state, obj) for the given
|
key.
|
|
returns an empty list if the value is None/empty/PASSIVE_NO_RESULT
|
rk Nc S s g | ]}t |¡|fqS r~ )r rQ )r Úor~ r~ r rP Å s ÿz;RelationshipProperty._value_as_iterable.<locals>.<listcomp>) Úmanagerr r r ro r r~ r rQ )r r? rG rë rl r rN 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]])rA r? rG Úvisited_statesÚhalt_onrw c c s |dks| j rtj}n tjtjB }|dkrB|j| j j ||¡}n| j ||| j|d}|dkofd| j
|
k}|D ]\} }
|
| |kr~ql|
|
d krql| d k st t |
|
¡} |r¬|| r¬ql|r¸| js¸ql| jj} | | jjj¡sêt d| j| jj|
|
jf | | ¡ |
|
| | | fV qld S )NÚdeletez save-updaterk zrefresh-expireú delete-orphanz@Attribute '%s' on class '%s' doesn't handle objects of type '%s')r¤ r ZPASSIVE_NO_INITIALIZErn ZNO_RAISEr rë r Zget_all_pendingr r} r( r rf rè ZisaZ class_managerrþ rê râ Úadd) r rA r? rG r r rl ZtuplesZ skip_pendingrQ r rf 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_brw 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ë rw c C sÄ | j j|dd}t|ts,t d| |f ¡| | |¡ | || ¡ | j |¡ |j | ¡ | ¡ |j
|
| j ¡st 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 )zReturn the target mapped entity, which is an inspect() of the
|
class or aliased class that is referred towards.
|
|
)rþ rU rî r r~ r~ r rî L s
|
zRelationshipProperty.entityrn c C s | j jS )zcReturn the targeted :class:`_orm.Mapper` for this
|
:class:`.RelationshipProperty`.
|
|
rû r r~ r~ r rè U s zRelationshipProperty.mapperc sn | ¡ | ¡ | ¡ | ¡ | ¡ | | j¡ | ¡ | ¡ | j
|
¡ t ¡ t d| d¡| _d S )NrZ ))rà ro )Ú_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 ] s
|
|
ÿz RelationshipProperty.do_initc C s | j jj | jjj¡ d S r )rþ rè ÚregistryZ_set_depends_onrî r r~ r~ r r l s
|
ÿz1RelationshipProperty._setup_registry_dependenciesc C s | j }dD ] }t||}| | jd ¡ q
|
dD ]4}t||}|j}|dk r.ttjtj ||d|_q.|j
|
j}|dk rt |rt d|| f ¡|jjdk rÆ|jjdk rÆtdd t |jj¡D | _nd| _t d
|
d t |jj¡D ¡| _t d d t |jj¡D ¡| _dS ) zConvert 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 dV qdS )r r¢ N©r6 r{ r9 r| ©r rN r~ r~ r r § s ý ÿzDRelationshipProperty._process_dependent_arguments.<locals>.<genexpr>c s s | ]}t jtj|d dV qdS )r r¢ Nr¤ r¥ r~ r~ r r ° s ý ÿc s s | ]}t jtj|d dV qdS )r r¢ Nr¤ r¥ r~ r~ r r · s ý ÿ)r¹ r' r Ú_clsregistry_resolversr r, r6 r{ r9 r| r r r× rØ r r r4 Zto_listÚ
|
column_setZ to_column_setr r° r )r Z init_argsÚattrZrel_argÚvalr r~ r~ r r q sH
|
|
ÿÿüÿ
|
ÿ
|
þ ü
|
ü
|
|
üz1RelationshipProperty._process_dependent_argumentsrT rP z Type[Any]zOptional[Type[Mapped[Any]]]z Optional[_AnnotationScanType])
|
Ú decl_scanr¡ ÚclsÚoriginating_modulerë Úmapped_containerÚ
|
annotationÚextracted_mapped_annotationÚis_dataclass_fieldrw c
|
C s¾ |}
|
|d kr(| j d kr$| ||¡ nd S |}
|
|d k s8t|d k oHt|t} | rbd| _d| jff| _|d k ort|t} | rd| _d| jff| _t|
|
}
|
t |
|
drh|
|
j
|
} t | t rêt| t jrê| jd krøt | ¡rât d| d¡| | _n| sø| sød| _|
|
jrTt | t r&t| tjr&|
|
jd }n
|
|
|
jd }t |d
|
rN|j}t||}
|
n|}
|
nt d |
|
d ¡n:t |
|
d
|
r¢|
|
j}
|
t|
|
|}
|
| jd kr¢| s¢| s¢d| _| j d krºtd |
|
| _ d S )Nrq rà rr Ú
|
__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 annotationFéÿÿÿÿr Ú__forward_arg__zGeneric alias z requires an argumentz _RelationshipArgumentType[_T])r Z_raise_for_requiredr( Ú
|
issubclassr" rà rÜ r rG Úhasattrr± r rE r r r» Ú _py_inspectÚ
|
isabstractr× rØ rº Ú__args__ÚtypingÚMappingr³ rI 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__argumentrw c C sÞ d| j krd S tjj}|r |}n| j}t|trDtd| |¡ }n$t |rdt|t
|
|j fsd| }n|}t|t
|
rt |dd}nJz t |}W n tjk
|
r¦ d }Y nX t|dsÊ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__r4 Ú preloadedZ
|
orm_mapperr r r
r Ú_clsregistry_resolve_namer rE rV r r5 r× r` 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 X s8 ð z+RelationshipProperty._setup_join_conditionsr c C s
|
| j d S )Nr ©r¦ r r~ r~ r Ú_clsregistry_resolve_argv 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 )r4 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À rw c C s | |¡ d S r )Ú _set_cascade©r rÀ r~ r~ r rÀ ¨ s )Ú cascade_argrw 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 referred towards 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)Úcolsrw c G sR | j jj}|D ]>}|dk r(|j |¡r(q| jjj |¡s| jj |¡s dS qdS )zReturn 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| jsrt| jtr:| ji }}n
|
| j\}}| j ¡ }|jst |
|
¡ |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 | jr| | 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 )
|
r4 rÀ Zorm_dependencyrº r¸ r& rÁ rU Zfrom_relationshipr© )r Ú
|
dependencyr~ r~ r r R 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 rR ] s z RelationshipProperty._use_getc C s | j | j¡S r )rè r rþ r r~ r~ r r* e s z)RelationshipProperty._is_self_referentialr~ z"Optional[_InternalEntityType[Any]]ró zTuple[ColumnElement[bool], Optional[ColumnElement[bool]], FromClause, FromClause, Optional[FromClause], Optional[ClauseAdapter]])r r r$ r r r÷ rw 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 kr
|
| jj }|
|
| ||| | fS )NFT)r rþ Zwith_polymorphicrÿ rè rý rî r* r+ r, Z _is_subqueryr® Ú join_targetsrÏ )r r r r$ r r r÷ ÚaliasedZ dest_mapperr2 r r r r
|
r~ r~ r r i 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 rC rå r© rÕ rÖ rí r4 Z MemoizedSlotsr( rl rÚ r\ r rF ra rs r| r rn 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 rR r* r Ú __classcell__r~ r~ rá r r , s
|
û ýÖ\ t ü ûDk ý gû ú=,M j/
|
, P
|
ùr r` )Úelementr rw c s. ddd fdd | d k r&| } d | S )Nrt )Úelemrw c s* t | tjr| ¡ ¡} | jd | S )N)Úclone)r r7 r= r. ÚcopyZ_copy_internals)rõ ©r rö r~ r rö ¿ s z _annotate_columns.<locals>.cloner~ )rô r r~ rø r rz ¾ s
|
rz 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/d0Z d1d2d d3d4d5Ze j d d$d6d7Ze j d d$d8d9Zd#d$d:d;Zd#d$d<d=Zd#d$d>d?Zd d$d@dAZd d$dBdCZd#d$dDdEZd#d$dFdGZdHd d#dIdJdKZd#d$dLdMZd#d$dNdOZd#d$dPdQZd#d$dRdSZ d#d$dTdUZ d#d$dVdWZ d#d$dXdYZ dd d#dZd[d\Z d#d$d]d^Z!d_d`dadbdcZ"d#d$dddeZ#e$ %¡ Z&dfedg< d#d$dhdiZ'e j djd$dkdlZ(e j djd$dmdnZ)e j djd$dodpZ*d2djdqdrdsZ+dtdudjd3dvdwZ,dddd ddydzd{d|d}Z-dd d~dddZ.dS )r r« Úprimaryjoin_initialrª r r r¬ r r rò r³ r´ r¶ r) r¸ re 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 rI r~ r~ r r 1 s z%s local columns [%s]c s s | ]}d | V qdS r r~ r r~ r~ r r 6 s z %s relationship direction %s) rò ÚloggerrË r r Újoinr´ r¶ r· rÑ r² r¸ )r r1 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)r? 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 dkrt| 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Ë rC rÆ rÈ rù rÅ rÇ r ZNoForeignKeysErrorZAmbiguousForeignKeysError)r rË ZnfeZafer~ r~ r rÿ L s þÿ
|
|
|
ü
|
ü
|
|
|
ü
|
|
|
ùÿ ÷ úÿø
|
øÿ
|
ö úÿøz JoinCondition._determine_joinsc C s t | jddS ©N©Úlocalrx r )r? r r r~ r~ r rç « s z%JoinCondition.primaryjoin_minus_localc C s | j d k stt| j ddS r )r r( r? r r~ r~ r ræ ¯ s z'JoinCondition.secondaryjoin_minus_localc C sJ | j r(dddddd}t | ji |¡S | jr<t| jddS t| jS 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.
|
|
rt r ú Optional[_CE]©rô rã rw c [ s\ d| j kr,t| j }|d= d|d< | |¡S d| j krXt| j }|d= d|d< | |¡S d S )Nrx Tr )Ú _annotationsrC 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_annotationsr? )r r r~ r~ r rè ´ s ÿz(JoinCondition.primaryjoin_reverse_remoterc r
)r r® rw c C s& t |i ¡D ]}||jkr dS q dS rý )r: Úiterater )r r r® rI 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 ©Nrx r" r r~ r~ r r ä s z%JoinCondition._has_remote_annotationsc C s& | j r
|
dS | jr| ¡ n| ¡ dS )zAnnotate 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 )Nrt r r r c s | j kr| ddi¡S d S ©Nr T)rË r. ©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 ddddfdd ddd fd d
|
}t | ji d |i¡| _| jd k rt | ji d |i¡| _d S ) Nru z Optional[ColumnElement[Any]])ÚaÚbrw c sd t | tjr4t |tjr4| |¡r&| S | | ¡r4|S r`| krL| krL| S | kr`| kr`|S d S r )r r2 ZColumnZ
|
references)r) r* )Ú secondarycolsr~ r Ú
|
is_foreign
|
|
s
|
|
z7JoinCondition._annotate_present_fks.<locals>.is_foreignúBinaryExpression[Any]r ©Úbinaryrw c s t | jtjr t | jtjs d S d| jjkrd| jjkr | j| j}|d k r| | j¡rn| j ddi¡| _n | | j¡r| j ddi¡| _d S r& )r Úleftr3 r> Úrightr Úcomparer. )r/ rI )r, r~ r Ú visit_binary
|
s& ÿ þ
|
ÿ
|
þ ÿz9JoinCondition._annotate_present_fks.<locals>.visit_binaryr/ ) r r4 r§ r rÝ r: rh r r ©r r3 r~ )r, r+ r r%
|
s
|
ÿ
|
ÿz#JoinCondition._annotate_present_fksc s@ | j | j dddd fdd }t | ji d|i¡ S )zvReturn True if the join condition contains column
|
comparisons where both columns are in both tables.
|
|
Fr- r r. c s^ | j | j }}t|tjrZt|tjrZ |j¡rZ |j¡rZ |j¡rZ |j¡rZdd S rú )r0 r1 r r7 r= Zis_derived_fromÚtable)r/ r Úf©ÚmtÚptÚresultr~ r r3 ?
|
s
|
ÿ
|
þ
|
ý
|
ü
|
û
|
úz;JoinCondition._refers_to_parent_table.<locals>.visit_binaryr/ )rÅ rÆ r: r- r r4 r~ r7 r Ú_refers_to_parent_table6
|
s z%JoinCondition._refers_to_parent_tablec C s t | j| jS )z5Return True if parent/child tables have some overlap.)rD rÅ rÆ r r~ r~ r Ú_tables_overlapO
|
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 rJ r~ r~ r rû e
|
rü z0JoinCondition._annotate_remote.<locals>.<lambda>F) r r Ú_annotate_remote_secondaryrÐ rþ Ú_annotate_remote_from_argsr; Ú_annotate_selfrefr< Ú _annotate_remote_with_overlapÚ%_annotate_remote_distinct_selectablesr r~ r~ r r V
|
s
|
|
|
ÿ
|
z JoinCondition._annotate_remotec s` | j dk st| j dddd fdd }t | ji |¡| _| jdk sJtt | ji |¡| _dS )z^annotate 'remote' in primaryjoin, secondaryjoin
|
when 'secondary' is present.
|
|
Nrt r r r c s j | ¡r| ddi¡S d S ©Nrx T)r rã r. r' ©Zfixed_secondaryr~ r Úreplu
|
s z6JoinCondition._annotate_remote_secondary.<locals>.repl)r r( r: r r r ©r rE r~ rD r r> l
|
s ÿ ÿz(JoinCondition._annotate_remote_secondaryz$Callable[[ColumnElement[Any]], bool])ÚfnÚremote_side_givenrw c s2 ddd fdd }t ji d|i¡_dS )zxannotate 'remote' in primaryjoin, secondaryjoin
|
when the relationship is detected as self-referential.
|
|
r- r r. c sx | j | j¡}t| j tjrht| jtjrh | j rF| j ddi¡| _ | jrt|st| j ddi¡| _n st ¡ d S rC )r0 r2 r1 r r7 r= r. Ú_warn_non_column_elements)r/ Zequated©rG rH r r~ r r3
|
s ÿ
|
z5JoinCondition._annotate_selfref.<locals>.visit_binaryr/ N)r: rh r )r rG rH r3 r~ rJ r r@
|
s ÿz JoinCondition._annotate_selfrefc sx | j r(| jrt d¡dd | j D n| j | ¡ rL| fddd¡ n(ddd d
|
fd d }t | ji |¡| _d S )zannotate '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 rP ª
|
s z<JoinCondition._annotate_remote_from_args.<locals>.<listcomp>c s | kS r r~ rJ ©r r~ r rû ¯
|
rü z:JoinCondition._annotate_remote_from_args.<locals>.<lambda>Trt r r r c s | t kr| ddi¡S d S rC )rÝ r. r' rK r~ r rE ²
|
s z6JoinCondition._annotate_remote_from_args.<locals>.replN) rÐ rþ r× rØ r; r@ r: r r rF r~ rK r r?
|
s ÿ ÿz(JoinCondition._annotate_remote_from_argsc s` dddfdd }j dk o,j jj 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.
|
|
r- r r. c s0 | j | j\| _ | _ | j| j \| _| _ d S r ©r0 r1 )r/ )Úproc_left_rightr~ r r3 Å
|
s ÿ ÿzAJoinCondition._annotate_remote_with_overlap.<locals>.visit_binaryNru z-Tuple[ColumnElement[Any], ColumnElement[Any]])r0 r1 rw c s¤ t | tjrDt |tjrDjj |¡rjj | ¡r| ddi¡}nX rl|j d¡j
|
j krl| ddi¡}n0 r| j d¡j
|
j kr| ddi¡} n ¡ | |fS )Nrx Trô ) r r7 r= rÆ r rã rÅ r. r r rò rè rI rL )Úcheck_entitiesr r~ r rM Ñ
|
s, ÿÿ þÿþÿþzDJoinCondition._annotate_remote_with_overlap.<locals>.proc_left_rightr/ )rò rè rþ r: rh r r4 r~ )rN rM r r rA ½
|
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.
|
|
rt r r r c s< j j | ¡r8 jj | ¡r* jj | ¡r8| ddi¡S d S rC )rÆ r rã rÇ rÈ r. r' r r~ r rE õ
|
s ÿ þzAJoinCondition._annotate_remote_distinct_selectables.<locals>.replN©r: r r rF r~ r r rB î
|
s ÿz3JoinCondition._annotate_remote_distinct_selectablesc C s t d| j ¡ d S )NzNon-simple column elements in primary join condition for property %s - consider using remote() annotations to mark the remote side.)r4 rÙ rò r r~ r~ r rI 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 rP s z1JoinCondition._annotate_local.<locals>.<listcomp>rt r r r c s$ d| j kr | kr | ddi¡S d S )Nrx r T)r r. r' ©Z
|
local_sider~ r Úlocals_ s z.JoinCondition._annotate_local.<locals>.locals_) r r rÐ r4 r§ rÅ r r: r )r rQ r~ rP r r s ÿ ÿz JoinCondition._annotate_localc s, dddd fdd }t ji |¡ _d S )Nrt r r r c s< d| j kr | d jji¡S d| j kr8| d jji¡S d S )Nrx rô r )r r. rò rè rþ r' r r~ r Úparentmappers_' s
|
|
|
z<JoinCondition._annotate_parentmapper.<locals>.parentmappers_rO )r rR 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ò r4 r§ rÅ r Ú
|
differencerÆ rÙ )r Z
|
not_targetÚ_Zrmtr~ r~ r r 2 s$ ùÿ ÿþûÿz JoinCondition._check_remote_side)rC Úprimaryrw c C s² d}| |d¡}t|}|r(t| j}n
|
t| j}| jr<|sF| jsJ|rJdS | jr|r|sd|rbdpdd|| jf }|d7 }t |¡n*d|rdpd|| jf }|d 7 }t |¡dS )
|
zHCheck the foreign key columns collected and emit error
|
messages.Fr NzCould not locate any simple equality expressions involving locally mapped foreign key columns for %s join condition '%s' on relationship %s.rU 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 rC rU Zcan_syncZ foreign_colsZ has_foreignÚerrr~ r~ r r O 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.
|
|
Nrx r c S s h | ]}d |j kr|qS )rx r= )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.zCan'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¸ r4 r§ rÅ r rÆ rÛ rÒ rV r rÑ r² rS 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 rw 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 | ]\}}| ¡ | ¡ fqS r~ ©Z _deannotaterM r~ r~ r rP î 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|fj|ffD ] \}}|d krPq>||| q> ¡_ |¡_ |¡_d S )Nrª rZ r )Újoincondr rw c s* ddddd fdd }t || d S )Nr- ru r )r/ r0 r1 rw 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 )Nrx r )r rÎ r Úoperatorr8 Úeqr )r/ r0 r1 )r Úlrpr r~ r r3 û s, ÿþýÿþý ÿ
|
|
z<JoinCondition._setup_pairs.<locals>.go.<locals>.visit_binaryrE )r] r r3 ©r` r )r r Úgo÷ s z&JoinCondition._setup_pairs.<locals>.go)r4 Z
|
OrderedSetr r r\ r· r´ r¶ )r Z
|
sync_pairsZsecondary_sync_pairsrb r] r r~ ra 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 ks| 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 | ]\}}||fqS r~ r~ ©r Úfrom_Úto_r~ r~ r rP 4 s zDJoinCondition._warn_for_conflicting_sync_targets.<locals>.<listcomp>c S s g | ]\}}||fqS r~ r~ rd r~ r~ r rP 6 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_©rf r~ r r v s ÿzCJoinCondition._warn_for_conflicting_sync_targets.<locals>.<genexpr>r
|
c s s | ]\}}|j V qd S r ©rë )r rg Úfrr~ r~ r r { s ZqzyxrÝ )rÍ r´ r¶ rc ÚweakrefÚWeakKeyDictionaryrò rä rè Z_dispose_calledrÞ rë r¡ rþ Z
|
is_siblingr r r4 rÙ r Úsorted)r re Z other_propsZ prop_to_fromrg rh r~ ri r r + sx ÿÿþ
|
þÿ
|
ÿ
|
þ ý ü
|
õ ô óòñð îí þÿõóå 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 ro r r~ r~ r r² s zJoinCondition.local_columnsc C s
|
| d¡S r! ro r r~ r~ r rÒ s z!JoinCondition.foreign_key_columns)r® rw c C s> t | | j|¡}| jd k r0| | | j|¡¡ dd |D S )Nc S s h | ] }| ¡ qS r~ r[ r¥ r~ r~ r rX s z9JoinCondition._gather_join_annotations.<locals>.<setcomp>)rÝ rV r r rÛ )r r® Úsr~ r~ r rp s ÿ
|
ÿÿz&JoinCondition._gather_join_annotationsru z Iterable[str]c s" t | fddt |i ¡D S )Nc s& h | ] } |j¡rttt |qS r~ )Úissubsetr r r> r r ©Zannotation_setr~ r rX s þz@JoinCondition._gather_columns_with_annotation.<locals>.<setcomp>)rÝ r: r )r r r® r~ rs r rV s
|
|
þz-JoinCondition._gather_columns_with_annotationr~ ró ztTuple[ColumnElement[bool], Optional[ColumnElement[bool]], Optional[FromClause], Optional[ClauseAdapter], FromClause])r r$ rî r2 r÷ rw c C sL t |ddi}| j| j| j }}}|dk rF|dk r>||@ }n||@ }|rp|dk rb|tj| @ }n|tj| @ }|r:|dk râ|jdd}t|tdd} t|| j d
|
| ¡}
|
|dk rÖt|tdd
|
t|| j d¡} |
|
|¡}n<t|td| j d} |dk r|
|
t|td | j d¡ d}
|
| |¡}|
|
p0| } 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& TN)Zflatr )Ú
|
exclude_fn)Ú equivalents)rt ru rx )r@ r r r r3 r r+ rB Ú_ColInAnnotationsrÊ ÚchainrÉ r- rt ) r r r$ rî r2 r÷ r r r Zprimary_aliasizerZsecondary_aliasizerr
|
r~ r~ r rí ¦ s ÿý
|
|
ÿ ÿþ ÿþý ý
|
ýÿ
|
|
ûzJoinCondition.join_targetszgTuple[ColumnElement[bool], Dict[str, ColumnElement[Any]], Dict[ColumnElement[Any], ColumnElement[Any]]])ri rw c s
|
i i }| j d k rLt t¡| jD ]"\}}| ||f¡ |||< q&n6sj| jD ]\}}|||< qVn| jD ]\}}|||< qpdddd fdd }| j}| j d ks²sÀt |i |¡}| j d k rî| j }rât |i |¡}t
|
||¡} fdd D }|||fS ) Nru r z Optional[BindParameter[Any]]r c sX sd| j ks,rTr | ks,sTd| j krT| krLtjd d | jdd | < | S d S )Nr rx T)rA rB )r r3 rD rE r' ©ÚbindsZ has_secondaryÚlookupri r~ r Ú col_to_bind% s. ÿÿþüüûû ÿ
|
z5JoinCondition.create_lazy_clause.<locals>.col_to_bindc s i | ]} | j |qS r~ rj r )ry r~ r Ú
|
<dictcomp>F s z4JoinCondition.create_lazy_clause.<locals>.<dictcomp>) r Ú collectionsÚ defaultdictÚlistr· r r r: r r3 r ) r ri Zequated_columnsr r r{ Z lazywherer r^ r~ rx r Úcreate_lazy_clause s@
|
|
|
ÿ
|
ÿ z JoinCondition.create_lazy_clause)Nr~ )F)/r r r r rÕ r r rÿ rï rç ræ r4 rñ rè r r r r r$ r% r; r< r r> r@ r? rA rB rI r r r r r r\ r rl rm rc r rÑ r² rÒ rp rV rí r r~ r~ r~ r r Ë s
|
î06&_$2!1 DR 9û
|
W úh ÿr c @ s2 e Zd ZdZdZddddZdddd d
|
Zd S ) rv z<Serializable object that tests for a name in c._annotations.©r r
c C s
|
|| _ d S r r )r r r~ r~ r rÕ P s z_ColInAnnotations.__init__rc r )r rw c C s | j |jkS r )r r )r r r~ r~ r Ú__call__S s z_ColInAnnotations.__call__N)r r r r r rÕ r r~ r~ r~ r rv K s rv 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 W s r )¢r Ú
|
__future__r r} r Z dataclassesr5 r¶ rß r¹ r r r r r r r
|
r r r r r r r r r r r rl Ú r r Ú_typingr r Úbaser r r r r r r! r" Z
|
interfacesr# r$ r% r& r' r( r) r* r4 r+ r, r- r/ r× r0 r1 r2 r3 Z
|
inspectionr6 r7 r8 r9 r: Z sql._typingr; r< Z sql.elementsr= r> Zsql.utilr? r@ rA rB rC rD rF Z util.typingrG rH rI Ú TYPE_CHECKINGrJ rK rL rM rN rO rP rQ Z clsregistryrR rS Z decl_baserT rì rU rè rV ÚqueryrW rt rX r? rY Z
|
strategiesrZ r[ r\ r] r^ r_ Zsql.annotationr` ra rb rc Z
|
sql.schemard Zsql.selectablere rf rg rh rj rk rl rm r
Z_RelationshipArgumentTyperÓ r Z"_RelationshipJoinConditionArgumentZ _RelationshipSecondaryArgumentrÒ ZORMBackrefArgumentZ DMLColumnRoleZ_ORMColCollectionElementZ_ORMColCollectionArgumentrs rt rY r³ rZ rx r Z dataclassr r Z class_loggerZ
|
Identifiedr rz r rv r r~ r~ r~ r Ú<module> s
|
|
úÿ
|
ÿ
|
ÿÿüÿ ÿ
|
üÿ
|
ÿ
|
ü
|
