rj@vdZddlmZddlmZddlZddlZddlmZddlmZddlm Z ddlm Z dd lm Z dd lm Z dd lm Z dd lmZdd lmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlmZddl m!Z!ddl m"Z"ddl#m$Z$ddl#m%Z%dd lm&Z&dd!l'm(Z(ej$rldd"lm)Z)dd#lm*Z*dd$lm+Z+dd%l,m-Z-dd&l.m/Z/dd'l0m1Z1dd(l2m3Z3dd)l4m5Z5dd*l6m7Z7dd+l8m9Z9dd,lm:Z:dd-l;mZ>dd/l m?Z?dd0l m@Z@dd1l#mAZAdd2lBmCZCdd3lDmEZEGd4d5eZFeGeF\ZHZIZJZKZLZMeLZNGd6d7e&ZOeOjj\ZRZSZTZUZVZWZXZYZZZ[Z\Z]Z^Z_Z`ZaZbZcd8Zdd9ZeGd:d;eZfeGef\ZgZhZiZjGd<d=eZkeGek\ZlZmZnGd>d?eZoGd@dAeoZpeqeNgZreqdeNeHgZseqdgZtejdBZvejdCZwejdDZxedEedFefGZyedHZz ddIZ{er+ddJZ|eddKZ}e ddLZ} ddMZ}ddNZ~ddOZn,dPZ|dQZ}ejeeZ~ejdRZddSZddTZddUZddVZddWZddXZddYZddZZejedd[Z dd\Z dd]Zdd^Zdd_Ze dd`ZerddaZnej$dbZ d ddcZdddZdddeZGdfdgZGdhdieZGdjdke%e"e(ZGdldme e"e(ZGdndoe e"e(ZGdpdqee"e$e"e(ZGdrdsee"ee"ee"ej8ZGdtdue e"e(ZGdvdwee"ee"ZGdxdyee"ZddzZGd{d|ee"ZGd}d~ee"Zy)z;Constants and rudimental functions used throughout the ORM.) annotations)EnumN)Any)Callable)cast)Dict)Generic)Literal) no_type_check)Optional)overload)Tuple)Type) TYPE_CHECKING)TypeVar)Union)exc)_HasPathString)_O)insp_is_mapper) inspection)util)roles)_T)_T_co)SQLColumnExpression)SQLCoreOperations) FastIntFlag) TypingOnly) _EntityType)_ExternalEntityType)_InternalEntityType)InstrumentedAttribute) AppenderQuery) ClassManager)PropComparator)Mapper) MappedColumn) InstanceState) AliasedClass)WriteOnlyCollection) TypedColumns)_ColumnExpressionArgument) _InfoType) ColumnElement) OperatorType)Columnc4eZdZdZ dZ dZ dZ dZ eZ dZ y)LoaderCallableStatusrrrN) __name__ __module__ __qualname__PASSIVE_NO_RESULTPASSIVE_CLASS_MISMATCH ATTR_WAS_SET ATTR_EMPTYNO_VALUE NEVER_SETDONT_SET^/var/www/html/python-recuperauto-other/env/lib/python3.12/site-packages/sqlalchemy/orm/base.pyr5r5BsN DL JJH IHrDr5ceZdZdZdZ dZ dZ dZ dZ dZ dZ d Z d Z d Z d Zee zezezezZ eez Z eez Z eez Z eez Z ee z Z ee zZy ) PassiveFlagz;Bitflag interface that passes options onto loader callablesrrrr7 @iN)r9r:r;__doc__ NO_CHANGE CALLABLES_OKSQL_OKRELATED_OBJECT_OKINIT_OKNON_PERSISTENT_OKLOAD_AGAINST_COMMITTED NO_AUTOFLUSHNO_RAISEDEFERRED_HISTORY_LOADINCLUDE_PENDING_MUTATIONS PASSIVE_OFFPASSIVE_RETURN_NO_VALUEPASSIVE_NO_INITIALIZEPASSIVE_NO_FETCHPASSIVE_NO_FETCH_RELATEDPASSIVE_ONLY_PERSISTENT PASSIVE_MERGErCrDrErGrGtsEILFLG CL4H:F # --7,FO-)G33lB,"V+*->>%),==%(*MrDrG_sa_class_manager_sa_instance_stateceZdZdZdZdZdZy)EventConstantsrrr6r7N)r9r:r; EXT_CONTINUEEXT_STOPEXT_SKIPNO_KEYrCrDrErdrdsLHH FrDrdc eZdZdZdZ dZ dZy)RelationshipDirectionzenumeration which indicates the 'direction' of a :class:`_orm.RelationshipProperty`. :class:`.RelationshipDirection` is accessible from the :attr:`_orm.Relationship.direction` attribute of :class:`_orm.RelationshipProperty`. rrr6N)r9r:r;rN ONETOMANY MANYTOONE MANYTOMANYrCrDrErjrjs+IIJrDrjceZdZdZy)InspectionAttrExtensionTypezXSymbols indicating the type of extension that a :class:`.InspectionAttr` is part of.N)r9r:r;rNrCrDrEroros,rDroceZdZdZy) NotExtension not_extensionN)r9r:r; NOT_EXTENSIONrCrDrErqrqs #MrDrqSET_DEFERRED_EXPIREDDEFER_FOR_STATERAISE_FOR_STATE_F.)bound_Selfc:tjdfd }|S)NcTD]}|||j||g|i||SN)r9)fnselfargskw assertion assertionss rEgeneratez_assertions..generate2s7# )I dBKK ( ) 4$" rD) r}rwr~ryrrrrreturnry)r decorator)rrs` rE _assertionsr/s" ^^ OrDcyr|rCclss rEmanager_of_classr>rDcyr|rCrs rEopt_manager_of_classr@s>ArDcyr|rCrs rErrCs&)rDcyr|rCrs rErrHs%(rDcyr|rCinstances rEinstance_staterLrrDcyr|rCrs rE instance_dictrNrrDc |jtS#t$r}tj|d||d}~wwxYw)Nz2Can't locate an instrumentation manager for class )__dict__DEFAULT_MANAGER_ATTRKeyErrorrUnmappedClassError)rkes rErrTsJ << 45 5 ((I#O  s =8=c@|jjtSr|)rgetrrs rErr\s|| 455rDrc*tt|S)z'Return a string describing an instance.) state_strrrs rE instance_strrds ^H- ..rDcl|yd|jjt|jfzS)z=Return a string describing an instance via its InstanceState.Nonez <%s at 0x%x>)class_r9idobjstates rErrjs0 }!6!6599; HHHrDc<|yd|jjdS)zNReturn a string describing an instance's class via its InstanceState. r<>)rr9rs rEstate_class_strrss&  }..00rDc$t|dz|zSN.)r)r attributes rE attribute_strr~s  !C ') 33rDc$t|dz|zSr)r)rrs rEstate_attribute_strrs U c !I --rDcdtttj|j S)apReturn a user-facing string for a mapped entity, such as a mapped class, :class:`_orm.Mapper`, or :func:`_orm.aliased` construct. Also accepts a :class:`_orm.PathRegistry` directly, which is itself ``inspect()``-able and implements ``path_string()``; in that case this is equivalent to calling :meth:`_orm.PathRegistry.path_string` directly. )rrrinspect path_string)entitys rE entity_strrs%  2 26 : ; G G IIrDc,t|jS)aGiven an object, return the primary Mapper associated with the object instance. Raises :class:`sqlalchemy.orm.exc.UnmappedInstanceError` if no mapping is configured. This function is available via the inspection system as:: inspect(instance).mapper Using the inspection system will raise :class:`sqlalchemy.exc.NoInspectionAvailable` if the instance is not part of a mapping. ) object_statemapperrs rE object_mapperrs  ! ( ((rDcJt|}|tj||S)aGiven an object, return the :class:`.InstanceState` associated with the object. Raises :class:`sqlalchemy.orm.exc.UnmappedInstanceError` if no mapping is configured. Equivalent functionality is available via the :func:`_sa.inspect` function as:: inspect(instance) Using the inspection system will raise :class:`sqlalchemy.exc.NoInspectionAvailable` if the instance is not part of a mapping. )_inspect_mapped_objectrUnmappedInstanceError)rrs rErrs)" #8 ,E }''11 rDcp t|S#tjftjz$rYywxYwr|)rrrNO_STATErs rErrs6h''  " " $s|| 3s %55ctj|d}| |jSt|tsJt j |)NF)rrr isinstancetyperr)class_or_mapperinsps rE_class_to_mapperrsG   ou 5D {{/4000$$_55rDcLtj|d}| |jSy)z`Return the :class:`_orm.Mapper` for the given class or None if the class is not mapped. FN)rrrrrs rE_mapper_or_noners)   fe ,D {{rDctj|d}|duxr)|j xr|jxs |jS)zlReturn True if the given object is a mapped class, :class:`_orm.Mapper`, or :class:`.AliasedClass`. FN)rris_clause_element is_mapperis_aliased_classrs rE_is_mapped_classrsK   fe ,D D 6&& & 6 ^^ 4t44rDcTtj|d}|duxr t|ddS)NFr)rrgetattrrs rE_is_aliased_classrs.   fe ,D t  H.@% HHrDc\tj|}|jr|}|j}nB|jr|j }|}n't |dr|jjx}}n|} t||S#t$r"}tjd|d|d|d}~wwxYw)zReturn a class attribute given an entity and string name. May return :class:`.InstrumentedAttribute` or user-defined attribute. rzEntity 'z' has no property ''N) rr is_selectablecrrhasattrrrrAttributeErrorsa_excInvalidRequestError)rkeyr descriptionerrs rE_entity_descriptorrs   f %D     x #{{111 f vs## ((2=s C  s4 B B+ B&&B+cyr|rCrs rE _state_mapperrrrDzmanager.mapperc t|}| |jsy|j}|r|j|S#tj $rYywxYwr|)r is_mappedr_check_configurerr)r configure class_managerrs rE_inspect_mapped_classrs[ ,V4  (?(?%%   # # % <<s< <AAcztj|d}t|r|Stjd|)NF)raiseerrz%Mapper or mapped class expected, got )rrrr ArgumentError)argrs rE_parse_mapper_argumentr's:   cE 2Dd   !FsgN OOrDct||}|>t|tstjd|dt j ||S)aGiven a class, return the primary :class:`_orm.Mapper` associated with the key. Raises :exc:`.UnmappedClassError` if no mapping is configured on the given class, or :exc:`.ArgumentError` if a non-class object is passed. Equivalent functionality is available via the :func:`_sa.inspect` function as:: inspect(some_mapped_class) Using the inspection system will raise :class:`sqlalchemy.exc.NoInspectionAvailable` if the class is not mapped. )rzClass object expected, got 'z'.)rrrrrrr)rrrs rE class_mapperr/sP"#6Y ?F ~&$'&&6<> $$V,, rDcxeZdZUdZdZded<dZ dZ dZ dZ dZ dZ dZ dZ dZ ej Zded<y) InspectionAttraMA base class applied to all ORM objects and attributes that are related to things that can be returned by the :func:`_sa.inspect` function. The attributes defined here allow the usage of simple boolean checks to test basic facts about the object returned. While the boolean checks here are basically the same as using the Python isinstance() function, the flags here can be used without the need to import all of these classes, and also such that the SQLAlchemy class system can change while leaving the flags here intact for forwards-compatibility. rCzTuple[str, ...] __slots__Froextension_typeN)r9r:r;rNr__annotations__rr is_instancer is_bundle is_property is_attribute_is_internal_proxyrrqrsrrCrDrErrKs "$I#M(GKHIEIAKIL :+3?2L2LN/L rDrc:eZdZdZdZej ddZy)InspectionAttrInfoaAdds the ``.info`` attribute to :class:`.InspectionAttr`. The rationale for :class:`.InspectionAttr` vs. :class:`.InspectionAttrInfo` is that the former is compatible as a mixin for classes that specify ``__slots__``; this is essentially an implementation artifact. rCciS)aInfo dictionary associated with the object, allowing user-defined data to be associated with this :class:`.InspectionAttr`. The dictionary is generated when first accessed. Alternatively, it can be specified as a constructor argument to the :func:`.column_property`, :func:`_orm.relationship`, or :func:`.composite` functions. .. seealso:: :attr:`.QueryableAttribute.info` :attr:`.SchemaItem.info` rC)r~s rEinfozInspectionAttrInfo.infos $ rDN)rr0)r9r:r;rNrrro_memoized_propertyrrCrDrErrs&I rDrcveZdZdZej r' ddZ ddZ d d dZ d d dZ yy) SQLORMOperationsrCcyr|rC)r~rs rEof_typezSQLORMOperations.of_types$'rDcyr|rC)r~criterias rEand_zSQLORMOperations.and_s#&rDNc yr|rCr~ criterionkwargss rEanyzSQLORMOperations.any#&rDc yr|rCrs rEhaszSQLORMOperations.hasrrD)r_EntityType[Any]rzPropComparator[_T_co])rz_ColumnExpressionArgument[bool]rzPropComparator[bool]r|)rz)Optional[_ColumnExpressionArgument[bool]]rrrzColumnElement[bool]) r9r:r;rtypingrrrrr rCrDrErrsI  (* ( " ( '< ' ! ' DH &@ & &!  &DH &@ & &!  &!rDrceZdZdZdZej r2e ddZe d dZed dZ d dZyy) ORMDescriptorz`Represent any Python descriptor that provides a SQL expression construct at the class level.rCcyr|rCr~rowners rE__get__zORMDescriptor.__get__$'rDcyr|rCrs rErzORMDescriptor.__get__s(+rDcyr|rCrs rErzORMDescriptor.__get__BErDcyr|rCrs rErzORMDescriptor.__get__sKNrDN)rrr Literal[None]rzORMDescriptor[_T_co])rrrrrzSQLCoreOperations[_T_co]robjectrrrr)rrrrrz` form of :class:`_orm.Mapper` configuration, where used explicitly it drives the configuration of ORM attributes such as :func:`_orm.mapped_class` and :func:`_orm.relationship`. .. seealso:: :ref:`orm_explicit_declarative_base` :ref:`orm_declarative_table` .. tip:: The :class:`_orm.Mapped` class represents attributes that are handled directly by the :class:`_orm.Mapper` class. It does not include other Python descriptor classes that are provided as extensions, including :ref:`hybrids_toplevel` and the :ref:`associationproxy_toplevel`. While these systems still make use of ORM-specific superclasses and structures, they are not :term:`instrumented` by the :class:`_orm.Mapper` and instead provide their own functionality when they are accessed on a class. .. versionadded:: 1.4 rCcyr|rCrs rErzMapped.__get__7s rDcyr|rCrs rErzMapped.__get__<,/rDcyr|rCrs rErzMapped.__get__ArrDcyr|rCrs rErzMapped.__get__DHKrDcyr|rC)rarg1s rE_empty_constructorzMapped._empty_constructorHsADrDcyr|rCr~rvalues rE__set__zMapped.__set__KrDcyr|rC)r~rs rE __delete__zMapped.__delete__OrrDN)r~zMappedColumn[_T_co]rr.rrrz Column[_T_co]rrrrrzInstrumentedAttribute[_T_co]r)rOptional[object]rrrz9Union[InstrumentedAttribute[_T_co], Column[_T_co], _T_co])r)rrz Mapped[_T_co])rrr-z&Union[SQLCoreOperations[_T_co], _T_co]rr)rrrr) r9r:r;rNrr rr r classmethodr*r.r1rCrDrEr!r! s "HI   % 1= FI      /  /), / ) /  / E E L, L58 L F L D D  (N    95rDr!ceZdZdZdZy)_MappedAttributezVMixin for attributes which should be replaced by mapper-assigned attributes. rCNrrCrDrEr6r6Rs IrDr6c8eZdZdZdZddZeZ ddZy)_DeclarativeMappedzMixin for :class:`.MapperProperty` subclasses that allows them to be compatible with ORM-annotated declarative mappings. rCctSr|NotImplementedr~opotherrs rEoperatez_DeclarativeMapped.operateisrDc tSr|r:r<s rEreverse_operatez"_DeclarativeMapped.reverse_operatens rDN)r=r2r>rrrrr)r9r:r;rNrr?__sa_operate__rArCrDrEr8r8[s? IN'*69 rDr8ceZdZdZdZy)UnmappedaRepresent a database column that is part of the mapped :class:`_schema.Table`, but is not mapped by the ORM. The :class:`_orm.Unmapped` type annotation is used in an :ref:`Annotated Declarative Table ` mapping, in conjunction with the :func:`_orm.unmapped_column` construct, to indicate a column that should be present in the :class:`_schema.Table` generated for the class, while not being part of the Python model at all. The type and nullability of the :class:`_schema.Column` are derived from the annotation in the same way as for :class:`_orm.Mapped`. E.g.:: class User(Base): __tablename__ = "user" id: Mapped[int] = mapped_column(primary_key=True) name: Mapped[str] legacy_name: Unmapped[str | None] = unmapped_column() The ``legacy_name`` column is part of ``User.__table__``, but there is no ``User.legacy_name`` attribute, and when using :ref:`orm_declarative_native_dataclasses`, it is not part of the dataclass. A bare ``Unmapped[]`` annotation with no right-hand side is equivalent to ``unmapped_column()`` with no arguments. When using :ref:`orm_declarative_native_dataclasses`, the attribute is omitted from the dataclass and its ``__init__()`` method in both cases; however, :pep:`681` typing tools are only able to determine this when :func:`_orm.unmapped_column` is present, and otherwise see the attribute as a required ``__init__()`` argument, so it should always be included in that case. .. versionadded:: 2.1.5 .. seealso:: :ref:`orm_declarative_unmapped_column` :func:`_orm.unmapped_column` rCNrrCrDrErDrDts,\IrDrDc|tuSr|)rD)mapped_containers rE_is_unmapped_containerrGs x ''rDc~eZdZdZdZer3e ddZe d dZ d dZ d dZyy) DynamicMappedaRepresent the ORM mapped attribute type for a "dynamic" relationship. The :class:`_orm.DynamicMapped` type annotation may be used in an :ref:`Annotated Declarative Table ` mapping to indicate that the ``lazy="dynamic"`` loader strategy should be used for a particular :func:`_orm.relationship`. .. legacy:: The "dynamic" lazy loader strategy is the legacy form of what is now the "write_only" strategy described in the section :ref:`write_only_relationship`. E.g.:: class User(Base): __tablename__ = "user" id: Mapped[int] = mapped_column(primary_key=True) addresses: DynamicMapped[Address] = relationship( cascade="all,delete-orphan" ) See the section :ref:`dynamic_relationship` for background. .. versionadded:: 2.0 .. seealso:: :ref:`dynamic_relationship` - complete background :class:`.WriteOnlyMapped` - fully 2.0 style version rCcyr|rCrs rErzDynamicMapped.__get__r$rDcyr|rCrs rErzDynamicMapped.__get__rrDcyr|rCrs rErzDynamicMapped.__get__r'rDcyr|rCr,s rEr.zDynamicMapped.__set__r/rDNr2)rrrrrzAppenderQuery[_T_co])rr3rrrz9Union[InstrumentedAttribute[_T_co], AppenderQuery[_T_co]]rrr-ztyping.Collection[_T_co]rr r9r:r;rNrrr rr.rCrDrErIrIs@I  /  /), / ) /  /  '" '+. ' ! '  ' L, L58 L F L  (@   !rDrIc~eZdZdZdZer3e ddZe d dZ d dZ d dZyy) WriteOnlyMappedadRepresent the ORM mapped attribute type for a "write only" relationship. The :class:`_orm.WriteOnlyMapped` type annotation may be used in an :ref:`Annotated Declarative Table ` mapping to indicate that the ``lazy="write_only"`` loader strategy should be used for a particular :func:`_orm.relationship`. E.g.:: class User(Base): __tablename__ = "user" id: Mapped[int] = mapped_column(primary_key=True) addresses: WriteOnlyMapped[Address] = relationship( cascade="all,delete-orphan" ) See the section :ref:`write_only_relationship` for background. .. versionadded:: 2.0 .. seealso:: :ref:`write_only_relationship` - complete background :class:`.DynamicMapped` - includes legacy :class:`_orm.Query` support rCcyr|rCrs rErzWriteOnlyMapped.__get__r$rDcyr|rCrs rErzWriteOnlyMapped.__get__s*-rDcyr|rCrs rErzWriteOnlyMapped.__get__ s rDcyr|rCr,s rEr.zWriteOnlyMapped.__set__r/rDNr2)rrrrrzWriteOnlyCollection[_T_co])rr3rrrz?Union[InstrumentedAttribute[_T_co], WriteOnlyCollection[_T_co]]rNrOrCrDrErQrQs8I  /  /), / ) /  /  -" -+. - ' -  - , 58      (@   %rDrQ)rrrzCallable[[_F], _F])rType[_O]rzClassManager[_O])rzAliasedClass[Any]rr)rz_ExternalEntityType[_O]rzOptional[ClassManager[_O]])rrrInstanceState[_O])rrrzDict[str, Any])rrrstr)rInstanceState[Any]rrX)rrrrXrrX)rrYrrXrrX)rrrrX)rrr Mapper[_T])rrrzInstanceState[_T])rrrzOptional[InstanceState[_T]])rzUnion[Mapper[_T], Type[_T]]rrZ)rz(Union[Type[_T], _InternalEntityType[_T]]rzOptional[Mapper[_T]])rrrbool)rr rrXrr)rrWr Mapper[_O])F)rrVrr[rzOptional[Mapper[_O]])rzUnion[Mapper[_O], Type[_O]]rr\)T)rrVrr[rr\)rFzOptional[type]rr[)rN __future__renumroperatorr rrrrr r r r r rrrrrr_typingrrrrrrsqlr sql._typingrr sql.elementsrrr util.langhelpersr!r"r#r$ attributesr%dynamicr&instrumentationr' interfacesr(rr) propertiesr*rr+r, writeonlyr-sql._annotated_colsr.r/r0r1 sql.operatorsr2 sql.schemar3r5tupler<r=r>r?r@rBrArG __members__valuesrOrPrQrRrSrTrUrVrWrXrYrZr[r\r]r^r_r`rDEFAULT_STATE_ATTRrdrerfrgrhrjrkrlrmrorq frozenset _never_set _none_set_none_only_setsymbol_SET_DEFERRED_EXPIRED_DEFER_FOR_STATE_RAISE_FOR_STATErwryrrrrr attrgetterrrrrrrrr _inspectsrrrrrrrr dottedgetterrrrrrrrrrDDLConstraintColumnRoler!r6r8rDrGrIrQrCrDrErsB"   ##.,) $,,1&-*($".27',,##4#Z     H+H|""$'    +) T ,1+@( h& D F$))>#? 9j,$, . { # tY(9: ; D6"# $:;4;;014;;01 T#s(+,   @ AA ) $) #))) $) #)?> 6)X(();