o E6dk@s~dZddlmZddlmZddlmZddlmZddlmZddlmZddlm Z dd lm Z dd lm Z dd lm Z dd lm Z dd lmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlm Z ddl!m"Z"ddl#m$Z$ddl#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/m0Z0d d)l/m1Z1d d*l2m3Z3d d+l4m5Z5d d,l4m6Z6d d-l4m7Z7d d.l4m8Z8d d/l4m9Z9d d0l4m:Z:d d1l4m;Z;e rydd2lZ>dd4llMmOZOd d?lPmQZQd d@l4mRZRd dAl4mSZSedBedCZTedDedCZUedEdFdCZVgdGZWe)jXGdHdIdIeeTe eTee)jYZZGdJdKdKeZeTeeTZ[GdLdMdMeeeTeeTZ\dNS)Oz|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])ColumnPropertyrrrrc s4eZdZUdZejZdZ dZde d<de d<de d <d e d <d Z d d ddd ddd d ddd defd d!Z dfd3d4Z e dgd6d7Ze dhd9d:Zdid;d<Zed=d>djd@dAZed=d>djdBdCZdkdEdFZe dkdGdHZdldKdLZdmfdMdN ZdndPdQZdod_d`ZGdadbdbejeeZdpdcddZZ S)qrFzDescribes 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]]columnsbool_is_polymorphic_discriminator Optional[str]_mapped_by_synonymzType[PropComparator[_T]]comparator_factory)rGgroupdeferred instrumentrLactive_historyexpire_on_flush_creation_orderrIrKZ_deferred_column_loaderZ_raise_column_loaderZ_renders_in_subqueries raiseloadN) attribute_optionsrMrNrSrLrPrQinfodoc _instrument_assume_readonly_dc_attributescolumn_ORMColumnExprArgument[_T]additional_columns_ORMColumnExprArgument[Any]rTOptional[_AttributeOptions]rMrNrS"Optional[Type[PropComparator[_T]]]rPrQrUOptional[_InfoType]rVrWrXc stj|| d|f| }dd|D|_||_||_||_| |_|dur'|n|jj|_ ||_ ||_ | dur<|j | | durD| |_nt|jD]}t|dd} | durZ| |_nqId|_t|d|jfd|jff|_|jrz|jd7_dSdS)N)rTrXcSsg|] }ttj|qS)r%expectr&ZLabeledColumnExprRole.0cr`r`pC:\Users\jesus\OneDrive\Desktop\erpjis_fastapi\backend\jisbackend\Lib\site-packages\sqlalchemy/orm/properties.py sz+ColumnProperty.__init__..rVrNrO))rST)super__init__rGrMrNrSrO __class__ ComparatorrLrPrQrUupdaterVreversedgetattrr$set_creation_order strategy_key)selfrYrTrMrNrSrLrPrQrUrVrWrXr[rGcolrir`rerhsH    zColumnProperty.__init__ decl_scanr7registryr5cls Type[Any]originating_modulekeystrmapped_containerOptional[Type[Mapped[Any]]] annotationOptional[_AnnotationScanType]extracted_mapped_annotationis_dataclass_fieldreturnNonec Cs2|jd} | jdur || _| jdur|| _dSdSNr)rGrxname) rprsrtrurwrxrzr|r~rrYr`r`redeclarative_scans   zColumnProperty.declarative_scanOptional[MapperProperty[_T]]cCs|SNr`rpr`r`remapper_property_to_assignsz(ColumnProperty.mapper_property_to_assignList[Tuple[Column[Any], int]]cCsdd|jDS)NcSs(g|]}t|tr|jdur|dfqSr) isinstancer(tablerbr`r`rerfs z4ColumnProperty.columns_to_assign..rGrr`r`recolumns_to_assignsz ColumnProperty.columns_to_assigncCs(d|jvr |jjSd|jvp||jjvS)N)Zquery_expressionT)rNT)roZstrategyZ_have_default_expressionparentZ_readonly_propsrr`r`re%_memoized_attr__renders_in_subqueriess   z4ColumnProperty._memoized_attr__renders_in_subquerieszsqlalchemy.orm.statezsqlalchemy.orm.strategies _InstallLoaderCallableProto[Any]cCs.tjj}tjj}|j|jj||j |j Sr r$ preloadedZ orm_stateZorm_strategiesr;Z"_instance_level_callable_processorrZ class_managerZLoadDeferredColumnsrxrpstate strategiesr`r`re&_memoized_attr__deferred_column_loaders z5ColumnProperty._memoized_attr__deferred_column_loadercCs0tjj}tjj}|j|jj||j d|j S)NTrrr`r`re#_memoized_attr__raise_column_loaders z2ColumnProperty._memoized_attr__raise_column_loaderroles.ColumnsClauseRolecC|jS)zsAllow the ColumnProperty to work in expression before it is turned into an instrumented attribute. ) expressionrr`r`re__clause_element__sz!ColumnProperty.__clause_element__cCs |jdS)aReturn 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` rrrr`r`rer s zColumnProperty.expressionmapper Mapper[Any]cCs0|jsdStj|j|j|||||jddS)N)Z comparator parententityrV)rOrZregister_descriptorclass_rxrLrV)rprr`r`reinstrument_class#s  zColumnProperty.instrument_classcs^tt|jdkr+t|jj|jr-t d|j|jd|jd|j fdSdSdS)NrzOn 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) rgdo_initlenrGsetrZ primary_key issupersetr$warnrxrrrr`rer/s zColumnProperty.do_initColumnProperty[_T]cCst|j|j|j|jdS)N)rNrMrP)rFrGrNrMrPrr`r`recopy?s zColumnProperty.copysessionr9 source_stateInstanceState[Any] source_dictr3 dest_state dest_dictload _recursiveDict[Any, object]_resolve_conflict_map#Dict[_IdentityKeyType[Any], object]c Cs|jsdS|j|vr(||j} |s| ||j<dS||j} | ||| ddS|jr<|j|vr>|j||jgdddSdSdS)NT)Z no_loader)rOrxZget_implrZ has_identityZ_expire_attributes) rprrrrrrrrvalueimplr`r`remergeGs      zColumnProperty.mergec@seZdZUdZes dZded<ded< d%d d Zer d&d dZd&ddZ d'ddZ d(ddZ d)ddZ d*d d!Z d*d"d#Zd$S)+zColumnProperty.ComparatoraProduce 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` )rrU expressionsz*RODescriptorReference[ColumnProperty[_PT]]propSequence[NamedColumn[Any]]rrYrErcCsT|j}||||jjd}|}|jjr|}|jj|}||d<||d|dS)aannotate 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_namespacerZ parentmapper proxy_keyZ adapt_columnZorm)Zcompile_state_pluginZplugin_subject)Z _parententityrrxZ _parentmapperZ_polymorphic_adaptertraverseZ _annotateZ_set_propagate_attrs)rprYperrqZmapper_local_colr`r`re_orm_annotate_columns  z.ColumnProperty.Comparator._orm_annotate_columnNamedColumn[_PT]cCsdSrr`rr`r`rersz,ColumnProperty.Comparator.__clause_element__cCs0|jr||jjd|jjS||jjdSr)adapterrrGrxrrr`r`re#_memoized_method___clause_element__sz=ColumnProperty.Comparator._memoized_method___clause_element__r<cCs,|}z|jWSty|jjYSw)z(The .info dictionary for this attribute.)rrUAttributeErrorr)rpZcer`r`re_memoized_attr_infos   z-ColumnProperty.Comparator._memoized_attr_infocs2jrfddjjDSfddjjDS)zThe full sequence of columns referenced by this attribute, adjusted for any aliasing in progress. .. versionadded:: 1.3.17 csg|] }|jjqSr`)rrrxrcrqrr`rerfszHColumnProperty.Comparator._memoized_attr_expressions..csg|]}|qSr`)rrrr`rerfs )rrrGrr`rre_memoized_attr_expressionss  z4ColumnProperty.Comparator._memoized_attr_expressionsrxryrcCst||S)zproxy attribute access down to the mapped column. this allows user-defined comparison methods to be accessed. )rmr)rprxr`r`re_fallback_getattrsz+ColumnProperty.Comparator._fallback_getattropr?otherkwargsColumnElement[Any]cO||g|Ri|Srrrprrrr`r`reoperatez!ColumnProperty.Comparator.operatecK"|}|||||fi|SrrZ _bind_paramrprrrrqr`r`rereverse_operatez)ColumnProperty.Comparator.reverse_operateN)rYrErrE)rr)rr<)rr)rxryrrrr?rrrrrr)__name__ __module__ __qualname____doc__r __slots____annotations__rrrrrrrrr`r`r`rerjas  (     rjcCs.|jr|js t|St|jjjd|jS)N.)rrxobject__repr__ryrrrr`r`re__str__s  zColumnProperty.__str__)rYrZr[r\rTr]rMrJrNrHrSrHrLr^rPrHrQrHrUr_rVrJrWrHrXrHrsr7rtr5rurvrwrJrxryrzr{r|r}r~r}rrHrrrrrr)rrH)rr)rr)rrrr)rr)rr)rr9rrrr3rrrr3rrHrrrrrrrry)!rrrrrZ _COLUMN_TOKENZstrategy_wildcard_key inherit_cacheZ_links_to_entityrrrhrpropertyrrrr$preload_modulerrrrrrrrZ MemoizedSlotsrrDrjr __classcell__r`r`rrrerF_sV  ;           rFc@seZdZdZdZdS)MappedSQLExpressionaNDeclarative 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)rrrrrr`r`r`rers rc@seZdZUdZdZded<ded<ded<ded <d ed <d ed <dHddZdIddZedJddZ edKddZ edLddZ dMd d!Z dNd'd(Z dNd)d*ZdOd+d,ZdPddQdBdCZdRdEdFZdGS)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 ) rYrR _sort_order foreign_keys _has_nullable_has_insert_defaultrNdeferred_groupdeferred_raiseloadrP_attribute_options_has_dataclass_arguments_use_existing_columnrHrNrrJr Column[_T]rYzOptional[Set[ForeignKey]]rrrargrkwcOsZ|dt|_}|dd|_d|_|dur4|tkr4|jtjur%d|_n|jtjus1|j tjur4d|_|dtj}|tju|_ |j rI||d<n |j tjurT|j |d<|dd|_ |dd|_ |d tj|_|jtjuryt|j pv|j |_|d d|_|d d |_td t|i||_|jj|_d|vo|ddtjfv|_t|dS)NrTZuse_existing_columnFTinsert_defaultdefaultrrrNrPZ sort_orderrrnullable)poprrrrZdataclasses_default_factoryr'ZNO_ARGZdataclasses_initZdataclasses_reprrZdataclasses_defaultrrrNrHrPrrr(rYrgetr)ZNULL_UNSPECIFIEDrr$rn)rprrZ attr_optsrr`r`rerh)sB           zMappedColumn.__init__rr0cKs|j|j}|jjdi||_|j|_|j|_|j|_|jj|_|j|_|j |_ |j |_ |j |_ |j |_ |j |_ |j|_t||S)Nr`)ri__new__rY_copyrNrrrrPrrrrrrr$rn)rprnewr`r`rerUs  zMappedColumn._copyrycCs|jjSr)rYrrr`r`rerfszMappedColumn.namercCs0|js|jrt|j|j|j|j|j|jdSdS)N)rNrMrSrTrP)rNrPrFrYrrrrr`r`rerjs  z&MappedColumn.mapper_property_to_assignrcCs|j|jfgSr)rYrrr`r`rerxszMappedColumn.columns_to_assigncCrr)rYrr`r`rer|szMappedColumn.__clause_element__rr?rrrcOrrrrr`r`rerrzMappedColumn.operatecKrrrrr`r`rerrzMappedColumn.reverse_operatecCstSr)rrr`r`refound_in_pep593_annotatedsz&MappedColumn.found_in_pep593_annotatedrsr7rtr5rurvrwrxrzr{r|r}r~rrc Cs|j} |jr/|jr/|jr/|jrtdt|jd} | jdur"| jn|} | j j | | } |_| j dur7|| _ | jdur?|| _| j } |durV| jrT|jjsT|||ndS|||||dS)Nz3Can't use use_existing_column with deferred mappersF)rYrZinheritssingleZ is_deferredsa_exc ArgumentErrorrrZ local_tablerdrrxtype_isnullrZ_raise_for_required_init_column_for_annotation)rprsrtrurwrxrzr|r~rrYZsupercls_mapperZcolnamesqltyper`r`rers>    zMappedColumn.declarative_scanzsqlalchemy.orm.decl_base param_nameparam_annotationr@cCs*tjj}|||j|||||dSr)r$rZ orm_decl_baseZ_undefer_column_namerYr)rprtrurwrxrr decl_baser`r`redeclarative_scan_for_composites  z+MappedColumn.declarative_scan_for_compositeargumentcCs|jj}t|tst|ddr|dusJt|||dd}t|r-|dus'Jt|||}t|}|j s8||j_ t |}d}t |rpd} t |} | d} t| r]t | } d}|j s]||j_ | ddD] } t| trn| }nqcnd} d} |dur|js|jjdurd|j_|j|j|jj}|jr|jjsd} | r|| g}n|g}|D] }||} | durn,qt|tst|trt|trtd|jjd|d td |d |jjd |j| dSdSdS) NT)Z check_generic)Zinclude_genericrrFzThe 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)rYrrryr,rr/rr-rrr+r.r1rrr_mergerrZ _resolve_typer* issubclassrrrxZ _set_type)rprurtrrwrrZour_typeZ use_args_fromZour_type_is_pep593Zpep_593_componentsZraw_pep_593_typeelemZ new_sqltypeZchecksZ check_typer`r`rers         z(MappedColumn._init_column_for_annotationN)rrrr)rrrr0rrr)rrr)rrr)rtr5rurvrwrJrxryrryrr@rr) rurvrtr5rr@rwrJrr)rrrrrrrhrrrrrrrrrrr$rrrr`r`r`rers2   ,        2 rN)]r __future__rtypingrrrrrrr r r r r rrbaserrZdescriptor_propsrrrZ interfacesrrrrrrrZ relationshipsrr$rrr!rr"r#sqlr%r&Zsql.baser'Z sql.schemar(r)Z sql.type_apir*Z util.typingr+r,r-r.r/r0r1Z_typingr2r3r4r5r6rr7rr8rr9rr:r;Z sql._typingr<Z sql.elementsr=r>Z sql.operatorsr?r@rArBrDrE__all__Z class_loggerZ IdentifiedrFrrr`r`r`res