U
|
¸ý°d k ã @ s d Z ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlm Z dd lm
|
Z
|
dd
|
lm Z dd lm Z dd lm Z dd lmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlm Z ddlm Z ddlm Z ddlm Z dd lm Z dd l!m"Z" dd l#m$Z$ dd l#m%Z% d d!lm&Z' d d"lm(Z( d d#lm)Z) d d$lm#Z# d d%l*m+Z+ d d&l*m,Z, d d'l-m.Z. d d(l/m0Z0 d d)l/m1Z1 d d*l2m3Z3 d d+l4m5Z5 d d,l4m6Z6 d d-l4m7Z7 d d.l4m8Z8 d d/l4m9Z9 d d0l4m:Z: d d1l4m;Z; e ròdd2l<m=Z= dd3l<m>Z> dd4l<m?Z? dd5l<m@Z@ dd6lmAZA dd7lBmCZC dd8lDmEZE dd9lFmGZG dd:lHmIZI dd;lHmJZJ d d<lKmLZL d d=lMmNZN d d>lMmOZO d d?lPmQZQ d d@l4mRZR d dAl4mSZS edBedCZTedDedCZUedEdFdCZVdGdHdIdJdKgZWe)jXG dLdG dGe eT e eT e e)jYZZG dMdN dNeZeT eeT Z[G dOdP dPe e eT eeT Z\dQS )Rz|MapperProperty implementations.
|
|
This is a private module which defines the behavior of individual ORM-
|
mapped attributes.
|
|
é )Ú annotations)ÚAny)Úcast)ÚDict)ÚList)ÚOptional)ÚSequence)ÚSet)ÚTuple)ÚType)Ú TYPE_CHECKING)ÚTypeVaré )Ú
|
attributes)Ústrategy_options)Ú_DeclarativeMapped)Ú class_mapper)ÚCompositeProperty)ÚConcreteInheritedProperty)ÚSynonymProperty)Ú_AttributeOptions)Ú_DEFAULT_ATTRIBUTE_OPTIONS)Ú_IntrospectsAnnotations)Ú _MapsColumns)ÚMapperProperty)ÚPropComparator)ÚStrategizedProperty)ÚRelationshipProperty)Úde_stringify_annotation)Úde_stringify_union_elementsé )Úexc)Ú
|
ForeignKey)Úlog)Úutil)Ú coercions)Úroles)Ú_NoArg)ÚColumn)Ú SchemaConst)Ú
|
TypeEngine)Úde_optionalize_union_types)Ú
|
is_fwd_ref)Úis_optional_union)Ú is_pep593)Úis_union)ÚSelf)Útyping_get_args)Ú_IdentityKeyType)Ú _InstanceDict)Ú_ORMColumnExprArgument)Ú _RegistryType)ÚMapped)Ú_ClassScanMapperConfig)ÚMapper)ÚSession)Ú_InstallLoaderCallableProto)Ú InstanceState)Ú _InfoType)Ú ColumnElement)Ú NamedColumn)Ú OperatorType)Ú_AnnotationScanType)ÚRODescriptorReferenceÚ_T)ÚboundÚ_PTÚ_NCzNamedColumn[Any]ÚColumnPropertyr r r r c s¦ e Zd ZU dZejZdZdZde d< de d< de d < d
|
e d < d Z
|
d d ddd ddd d ddd dddddddddddddd fddZ ddddddd d dd d
|
d d Z e d!d"d#d$Ze d%d"d&d'Zdd"d(d)Ze d*d+¡d,d"d-d.Ze d*d+¡d,d"d/d0Zd1d"d2d3Ze d1d"d4d5Zd6d d7d8d9Zd d" fd:d; Zd<d"d=d>Zd?d@dAd@dAddBdCd dD dEdFZG dGdH dHeje e Z dd"dIdJZ Z S )KrF z¬Describes an object attribute that corresponds to a table column
|
or other column expression.
|
|
Public constructor is the :func:`_orm.column_property` function.
|
|
TFzList[NamedColumn[Any]]ÚcolumnsÚboolÚ _is_polymorphic_discriminatorú Optional[str]Ú_mapped_by_synonymzType[PropComparator[_T]]Úcomparator_factory)rG ÚgroupÚdeferredÚ
|
instrumentrL Úactive_historyÚexpire_on_flushÚ_creation_orderrI rK Z_deferred_column_loaderZ_raise_column_loaderZ_renders_in_subqueriesÚ raiseloadN) Úattribute_optionsrM rN rS rL rP rQ ÚinfoÚdocÚ _instrumentÚ _assume_readonly_dc_attributesz_ORMColumnExprArgument[_T]z_ORMColumnExprArgument[Any]zOptional[_AttributeOptions]z"Optional[Type[PropComparator[_T]]]zOptional[_InfoType]) ÚcolumnÚadditional_columnsrT rM rN rS rL rP rQ rU rV rW rX c sô t j|| d |f| }dd |D | _|| _|| _|| _| | _|d k rN|n| jj| _ || _
|
|| _ | d k rx| j | ¡ |
|
d k r|
|
| _n4t| jD ]"}t|dd }
|
|
|
d k r|
|
| _ q¼qd | _t | ¡ d| jfd| jff| _| jrð| jd7 _d S )N)rT rX c S s g | ]}t tj|¡qS © )r% Úexpectr& ZLabeledColumnExprRole©Ú.0Úcr[ r[ úPd:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\sqlalchemy/orm/properties.pyÚ
|
<listcomp>¡ s z+ColumnProperty.__init__.<locals>.<listcomp>rV rN rO ))rS T)ÚsuperÚ__init__rG rM rN rS rO Ú __class__Ú
|
ComparatorrL rP rQ rU ÚupdaterV ÚreversedÚgetattrr$ Úset_creation_orderÚ strategy_key)ÚselfrY rT rM rN rS rL rP rQ rU rV rW rX rZ rG Úcol©rd r[ r` rc sD þ
|
ÿÿý
|
þzColumnProperty.__init__r7 r5 ú Type[Any]ÚstrúOptional[Type[Mapped[Any]]]ú Optional[_AnnotationScanType]ÚNone©
|
Ú decl_scanÚregistryÚclsÚoriginating_moduleÚkeyÚmapped_containerÚ
|
annotationÚextracted_mapped_annotationÚis_dataclass_fieldÚreturnc
|
C s. | j d }
|
|
|
jd kr||
|
_|
|
jd kr*||
|
_d S ©Nr )rG rx Úname) rk rt ru rv rw rx ry rz r{ r| rY r[ r[ r` Údeclarative_scanÇ s
|
|
|
|
z ColumnProperty.declarative_scanú Optional[MapperProperty[_T]]©r} c C s | S ©Nr[ ©rk r[ r[ r` Úmapper_property_to_assignÙ s z(ColumnProperty.mapper_property_to_assignú List[Tuple[Column[Any], int]]c C s dd | j D S )Nc S s( g | ] }t |tr|jd kr|dfqS r~ )Ú
|
isinstancer( Útabler] r[ r[ r` ra à s
|
|
þz4ColumnProperty.columns_to_assign.<locals>.<listcomp>©rG r r[ r[ r` Úcolumns_to_assignÝ s þz ColumnProperty.columns_to_assignc C s( d| j kr| jjS d| j kp&| | jjkS )N)Zquery_expressionT)rN T)rj ZstrategyZ_have_default_expressionÚparentZ_readonly_propsr r[ r[ r` Ú%_memoized_attr__renders_in_subqueriesæ s
|
|
|
|
ÿz4ColumnProperty._memoized_attr__renders_in_subquerieszsqlalchemy.orm.statezsqlalchemy.orm.strategiesz _InstallLoaderCallableProto[Any]c C s. t jj}t jj}|j | jj| | j ¡| j ¡S r ©
|
r$ Ú preloadedZ orm_stateZorm_strategiesr; Z"_instance_level_callable_processorr Z class_managerZLoadDeferredColumnsrx ©rk ÚstateZ
|
strategiesr[ r[ r` Ú&_memoized_attr__deferred_column_loaderî s
|
ýz5ColumnProperty._memoized_attr__deferred_column_loaderc C s0 t jj}t jj}|j | jj| | j d¡| j ¡S )NTr r r[ r[ r` Ú#_memoized_attr__raise_column_loaderú s ýz2ColumnProperty._memoized_attr__raise_column_loaderzroles.ColumnsClauseRolec C s | j S )zsAllow the ColumnProperty to work in expression before it is turned
|
into an instrumented attribute.
|
)Ú
|
expressionr r[ r[ r` Ú__clause_element__ s z!ColumnProperty.__clause_element__c C s
|
| j d S )aÊ Return the primary column or expression for this ColumnProperty.
|
|
E.g.::
|
|
|
class File(Base):
|
# ...
|
|
name = Column(String(64))
|
extension = Column(String(8))
|
filename = column_property(name + '.' + extension)
|
path = column_property('C:/' + filename.expression)
|
|
.. seealso::
|
|
:ref:`mapper_column_property_sql_expressions_composed`
|
|
r r r r[ r[ r` r s zColumnProperty.expressionz Mapper[Any])Úmapperr} c C s0 | j s
|
d S tj|j| j| | |¡|| jd d S )N)Z
|
comparatorÚ parententityrV )rO r Zregister_descriptorÚclass_rx rL rV )rk r r[ r[ r` Úinstrument_class# s
|
ûz ColumnProperty.instrument_classc sV t ¡ t| jdkrRt| jj | j¡rRt d| j| jd | jd | j
|
f ¡ d S )Nr z»On mapper %s, primary key column '%s' is being combined with distinct primary key column '%s' in attribute '%s'. Use explicit properties to give each column its own mapped attribute name.r ) rb Údo_initÚlenrG Úsetr Z primary_keyÚ
|
issupersetr$ Úwarnrx r rm r[ r` r / s
|
ÿúÿzColumnProperty.do_initzColumnProperty[_T]c C s t | j| j| j| jdS )N)rN rM rP )rF rG rN rM rP r r[ r[ r` Úcopy? s üzColumnProperty.copyr9 zInstanceState[Any]r3 zDict[Any, object]z#Dict[_IdentityKeyType[Any], object]) ÚsessionÚ source_stateÚ source_dictÚ
|
dest_stateÚ dest_dictÚloadÚ
|
_recursiveÚ_resolve_conflict_mapr} c C st | j s
|
d S | j|krL|| j } |s.| || j< qp| | j¡}
|
|
|
||| d ¡ n$|jrp| j|krp|j|| jgdd d S )NT)Z no_loader)rO rx Zget_implr Z has_identityZ_expire_attributes) rk r r r¡ r¢ r£ r¤ r¥ r¦ ÚvalueÚimplr[ r[ r` ÚmergeG s
|
|
ÿzColumnProperty.mergec @ s® e Zd ZU dZesdZded< ded< dddd d
|
ZerHd d d dZd d ddZ dd ddZ
|
dd ddZ dddddZ dddd d d d Z dddd d d d!Zd"S )#zColumnProperty.Comparatora Produce boolean, comparison, and other operators for
|
:class:`.ColumnProperty` attributes.
|
|
See the documentation for :class:`.PropComparator` for a brief
|
overview.
|
|
.. seealso::
|
|
:class:`.PropComparator`
|
|
:class:`.ColumnOperators`
|
|
:ref:`types_operators`
|
|
:attr:`.TypeEngine.comparator_factory`
|
|
)r rU Ú expressionsz*RODescriptorReference[ColumnProperty[_PT]]ÚpropzSequence[NamedColumn[Any]]rª rE )rY r} c C sT | j }|||| jjd}|}| jjr>|}| jj |¡}||d< | |¡ d|d¡S )aí annotate and possibly adapt a column to be returned
|
as the mapped-attribute exposed version of the column.
|
|
The column in this context needs to act as much like the
|
column in an ORM mapped context as possible, so includes
|
annotations to give hints to various ORM functions as to
|
the source entity of this column. It also adapts it
|
to the mapper's with_polymorphic selectable if one is
|
present.
|
|
)Zentity_namespacer Z parentmapperÚ proxy_keyZ adapt_columnZorm)Zcompile_state_pluginZplugin_subject)Z _parententityr« rx Z _parentmapperZ_polymorphic_adapterZtraverseZ _annotateZ_set_propagate_attrs)rk rY Úper rl Zmapper_local_colr[ r[ r` Ú_orm_annotate_column
s ü
|
ÿz.ColumnProperty.Comparator._orm_annotate_columnzNamedColumn[_PT]r c C s d S r r[ r r[ r[ r` r ¯ s z,ColumnProperty.Comparator.__clause_element__c C s4 | j r | | jjd | jj¡S | | jjd ¡S d S r~ )Úadapterr« rG rx r® r r[ r[ r` Ú#_memoized_method___clause_element__² s z=ColumnProperty.Comparator._memoized_method___clause_element__r< c C s2 | ¡ }z|jW S tk
|
r, | jj Y S X dS )z(The .info dictionary for this attribute.N)r rU ÚAttributeErrorr« )rk Zcer[ r[ r` Ú_memoized_attr_infoº s
|
z-ColumnProperty.Comparator._memoized_attr_infoc s6 j r fdd jjD S fdd jjD S dS )z¡The full sequence of columns referenced by this
|
attribute, adjusted for any aliasing in progress.
|
|
.. versionadded:: 1.3.17
|
|
c s g | ]} | jj¡qS r[ )r¯ r« rx ©r^ rl r r[ r` ra Ë s ÿzHColumnProperty.Comparator._memoized_attr_expressions.<locals>.<listcomp>c s g | ]} |¡qS r[ )r® r³ r r[ r` ra Ð s N)r¯ r« rG r r[ r r` Ú_memoized_attr_expressionsà s
|
þ
|
ÿz4ColumnProperty.Comparator._memoized_attr_expressionsro r )rx r} c C s t | ¡ |S )zproxy attribute access down to the mapped column.
|
|
this allows user-defined comparison methods to be accessed.
|
)rh r )rk rx r[ r[ r` Ú_fallback_getattrÔ s z+ColumnProperty.Comparator._fallback_getattrr? úColumnElement[Any]©ÚopÚotherÚkwargsr} c O s || ¡ f||S r ©r ©rk r¸ r¹ rº r[ r[ r` ÚoperateÛ s z!ColumnProperty.Comparator.operatec K s | ¡ }|| ||¡|f|S r ©r Z _bind_param©rk r¸ r¹ rº rl r[ r[ r` Úreverse_operateà s z)ColumnProperty.Comparator.reverse_operateN)Ú__name__Ú
|
__module__Ú __qualname__Ú__doc__r Ú __slots__Ú__annotations__r® r r° r² r´ rµ r½ rÀ r[ r[ r[ r` re a s
|
( re c C s. | j r | jst | ¡S t| j jjd | j S )NÚ.)r rx ÚobjectÚ__repr__ro r rÁ r r[ r[ r` Ú__str__æ s
|
zColumnProperty.__str__)!rÁ r rà rÄ r Z _COLUMN_TOKENZstrategy_wildcard_keyÚ inherit_cacheZ_links_to_entityrÆ rÅ rc r Úpropertyr
r r r$ Úpreload_moduler r r r r r r r© Z MemoizedSlotsr rD re rÊ Ú __classcell__r[ r[ rm r` rF _ sR
|
ò.;
|
|
c @ s e Zd ZdZdZdS )ÚMappedSQLExpressionaN Declarative front-end for the :class:`.ColumnProperty` class.
|
|
Public constructor is the :func:`_orm.column_property` function.
|
|
.. versionchanged:: 2.0 Added :class:`_orm.MappedSQLExpression` as
|
a Declarative compatible subclass for :class:`_orm.ColumnProperty`.
|
|
.. seealso::
|
|
:class:`.MappedColumn`
|
|
TN)rÁ r rà rÄ rË r[ r[ r[ r` rÏ ì s rÏ c @ s: e Zd ZU dZdZded< ded< ded< ded < d
|
ed < d ed < dddddZdddddZeddddZ edddd Z
|
ed dd d Z ddd d!Z d"ddd#d$d%d&Z d"ddd#d$d'd(Zddd)d*Zd+d,d-ddd.d/d/dd0d1
|
d2d3Ze d4¡d,d-dddd5d0d6d7d8Zd-d,d5dd0d9d:d;Zd<S )=Ú MappedColumna_ Maps a single :class:`_schema.Column` on a class.
|
|
:class:`_orm.MappedColumn` is a specialization of the
|
:class:`_orm.ColumnProperty` class and is oriented towards declarative
|
configuration.
|
|
To construct :class:`_orm.MappedColumn` objects, use the
|
:func:`_orm.mapped_column` constructor function.
|
|
.. versionadded:: 2.0
|
|
|
) rY rR Ú _sort_orderÚ foreign_keysÚ _has_nullableÚ_has_insert_defaultrN Údeferred_groupÚdeferred_raiseloadrP Ú_attribute_optionsÚ_has_dataclass_argumentsÚ_use_existing_columnrH rN rÖ rJ rÕ ú
|
Column[_T]rY zOptional[Set[ForeignKey]]rÒ r r× r )ÚargÚkwc O sX | dt¡ | _}| dd¡| _d| _|d k rh|tkrh|jtjk rJd| _n |jtjk sb|j tjk rhd| _| dtj¡}|tjk | _
|
| j
|
r||d< n|j tjk r¨|j |d< | dd ¡| _ | dd ¡| _ | d tj¡| _| jtjkròt| j pì| j | _| d
|
d¡| _| d d ¡| _td t||| _| jj| _d|koF| d¡d tjfk| _t | ¡ d S )NrT Zuse_existing_columnFTÚinsert_defaultÚdefaultrÕ rÖ rN rP Z
|
sort_orderr rÚ Únullable) Úpopr r× rÙ rØ Zdataclasses_default_factoryr' ZNO_ARGZdataclasses_initZdataclasses_reprrÔ Zdataclasses_defaultrÕ rÖ rN rH rP rÑ r r( rY rÒ Úgetr) ZNULL_UNSPECIFIEDrÓ r$ ri )rk rÛ rÜ Z attr_optsrÝ r[ r[ r` rc ) sH ÿ
|
|
ÿ
|
þ
|
|
|
ÿ
|
þzMappedColumn.__init__r0 )rÜ r} c K s | j | j ¡}| jjf ||_| j|_| j|_| j|_|jj|_| j|_| j |_ | j
|
|_
|
| j |_ | j |_ | j |_ | j|_t |¡ |S r )rd Ú__new__rY Ú_copyrN rÕ rÖ rÒ rP rÓ r× rÔ rØ rÙ rÑ r$ ri )rk rÜ Únewr[ r[ r` rã V s
|
|
zMappedColumn._copyro r c C s | j jS r )rY r r r[ r[ r` r g s zMappedColumn.namer c C s4 | j s | jr,t| j| j | j| j| j| jdS d S d S )N)rN rM rS rT rP )rN rP rF rY rÕ rÖ r× r r[ r[ r` r
k s ú z&MappedColumn.mapper_property_to_assignr c C s | j | jfgS r )rY rÑ r r[ r[ r` r y s z MappedColumn.columns_to_assignc C s | j S r )rY r r[ r[ r` r } s z MappedColumn.__clause_element__r? r¶ r· c O s || ¡ f||S r r» r¼ r[ r[ r` r½ s zMappedColumn.operatec K s | ¡ }|| ||¡|f|S r r¾ r¿ r[ r[ r` rÀ
s z MappedColumn.reverse_operatec C s | ¡ S r )rã r r[ r[ r` Úfound_in_pep593_annotated s z&MappedColumn.found_in_pep593_annotatedr7 r5 rn rp rq rr rs c
|
C sÀ | j }
|
| jr^|jr^|jr^|jr(t d¡t|jd} |
|
jd k rD|
|
jn|} | j j
|
| |
|
¡ }
|
| _ |
|
j d krn||
|
_ |
|
jd kr~||
|
_|
|
j } |d kr¬| jr¨| j js¨| ||¡ nd S | ||||¡ d S )Nz3Can't use use_existing_column with deferred mappersF)rY rÙ ZinheritsZsingleZ is_deferredÚsa_excÚ ArgumentErrorr r Z local_tabler_ rá rx ÚtypeÚ_isnullrÒ Z_raise_for_requiredÚ_init_column_for_annotation)rk rt ru rv rw rx ry rz r{ r| rY Zsupercls_mapperZcolnameÚsqltyper[ r[ r` r s@ ÿþýÿ ÿ
|
|
|
üz MappedColumn.declarative_scanzsqlalchemy.orm.decl_baser@ )ru rv rw rx Ú
|
param_nameÚparam_annotationr} c C s* t jj}| || j¡ | ||||¡ d S r )r$ r Z orm_decl_baseZ_undefer_column_namerY rê )rk ru rv rw rx rì rí Ú decl_baser[ r[ r` Ú declarative_scan_for_compositeÀ s
|
ÿz+MappedColumn.declarative_scan_for_composite)rv ru Úargumentrw r} c C sæ | j j}t|ts t|ddr:|d k s*tt|||dd}t|rZ|d k sNtt|||}t |}| j
|
sp|| j _ t |}d }t |ràd} t|}
|
|
|
d } t | rºd}| j
|
s²|| j _ t | } |
|
dd
D ]} t| trÆ| } qèqÆnd} d } |d k r&| js|j jd k rd | j _|j | j ¡ | j j}|jrâ| j jsâd } | rL|| g}n|g}|D ] }| |¡} | d k rV qÖqVt|tst|trºt|trºt d| j jd| d ¡n t d
|
| d | j jd ¡| j | ¡ d S ) NT)Z check_generic)Zinclude_genericr r Fz The type provided inside the z4 attribute Mapped annotation is the SQLAlchemy type z . Expected a Python type insteadz6Could not locate SQLAlchemy Core type for Python type z inside the z attribute Mapped annotation) rY rè r ro r, ÚAssertionErrorr r/ r r- rÓ rß r+ r. r1 rÐ rÔ rÞ Z_mergeré rÒ Z _resolve_typer* Ú
|
issubclassræ rç rx Z _set_type)rk rv ru rð rw rë rß Zour_typeZ use_args_fromZour_type_is_pep593Zpep_593_componentsZraw_pep_593_typeÚelemZ new_sqltypeZchecksZ
|
check_typer[ r[ r` rê Ð s ÿ ÿ ÿ
|
|
ÿ
|
þ
|
|
|
|
ÿþÿÿz(MappedColumn._init_column_for_annotationN)rÁ r rà rÄ rÅ rÆ rc rã rÌ r r
r r r½ rÀ rå r r$ rÍ rï rê r[ r[ r[ r` rÐ þ s0
|
- 2 rÐ N)]rÄ Ú
|
__future__r Útypingr r r r r r r r
|
r r r Ú r r Úbaser r Zdescriptor_propsr r r Z
|
interfacesr r r r r r r Z relationshipsr r$ r r r! ræ r" r# Zsqlr% r& Zsql.baser' Z
|
sql.schemar( r) Z sql.type_apir* Z util.typingr+ r, r- r. r/ r0 r1 Ú_typingr2 r3 r4 r5 r6 rî r7 r r8 r r9 r r: r; Z sql._typingr< Z sql.elementsr= r> Z sql.operatorsr? r@ rA rB rD rE Ú__all__Z class_loggerZ
|
IdentifiedrF rÏ rÐ r[ r[ r[ r` Ú<module> s° û
|
ü
|
ý
|
