,hJ%SrSSKJr SSKJr SSKJr SSKJr SSK r SSK r SSK J r SSK J r SS K Jr SS K Jr SS K Jr SS K Jr SS K Jr SSK Jr SSK Jr SSK Jr SSK Jr SSK Jr SSK Jr SSK Jr SSK Jr SSK Jr SSK Jr SSK Jr SSK Jr SSK Jr SSK r SSK!J"r" SSK!J#r$ SSK!J%r% SSK!J&r& SS K!J'r' SS!K!J(r) SS"K*J+r+ SS#K,J-r- SS$K,J.r. SS%K,J/r/ SS&K,J0r0 SS'K,J1r1 SS(K2J3r3 SS)K2J4r4 SS*K2J5r5 SS+K2J6r6 SS,K2J7r7 SS-K2J8r8 SS.K2J9r9 SS/K:J;r; S0S1K!Jr> S0S3K!J?r? S0S4K!J@r@ S0S5K!JArA S0S!K!J(r( S0S6KKAJKrK S0S?KLJMrM S0S@KNJOrO S0SAKPJQrQ S0SBKPJRrR S0SCKSJTrT S0SDK(JUrU S0SEK(JVrV S0SFKWJXrX \(aSSGK*JYrY SSHK*JZrZ SSIK*J[r[ SSJK*J\r\ SSKK]J^r^ SSLK_J`r` SSMKaJbrb SSNKaJcrc SSOKdJere SSPK%Jfrf SSQK:Jgrg SSRK'Jhrh SSSKiJjrj SSTKkJlrl SSUK(Jmrm S0SVKnJoro S0SWKnJprp S0SXKqJrrr S0SYKqJsrs S0SZKtJuru S0S[KNJvrv S0S\KNJwrw S0S]KSJxrx S0S^K(Jyry \"S_\ S`9rz\"SaSbS`9r{\"ScSdS`9r|\\XSe\\\XSe\\Sf\\ 44\Sg4\\Sf\\ 44r}\ R"5rSh\Si'SSjjrSSkjrSlq\(GR"Sm5r\ GR "5r\>GR\?GR"SnSo\8\7\+\M\5\?GR\>GRSp\C\\+5 55r"SqSr\5rSSsjrSStjr\(GR""Su5SSvj5r\(GR""Su5SSwj5rSSxjrSlSySz.SS{jjrS|rS}r"S~S\S5rg)a5Logic to map Python classes to and from selectables. Defines the :class:`~sqlalchemy.orm.mapper.Mapper` class, the central configurational unit which associates a class with a database table. This is a semi-private module; the main configurational API of the ORM is available in :class:`~sqlalchemy.orm.`. ) annotations)deque)reduce)chainN)Any)Callable)cast) Collection)Deque)Dict) FrozenSet)Generic)Iterable)Iterator)List)Mapping)Optional)Sequence)Set)Tuple)Type) TYPE_CHECKING)TypeVar)Union) attributes)exc)instrumentation)loading) properties)util)_O)_class_to_mapper)_parse_mapper_argument) _state_mapper) PassiveFlag) state_str)_MappedAttribute)EXT_SKIP)InspectionAttr)MapperProperty)ORMEntityColumnsClauseRole)ORMFromClauseRole)StrategizedProperty) PathRegistry)event) inspection)log)schema)sql) dispatcher) EventTarget)base) coercions) expression) operators)roles) TableClause)visitors)MemoizedHasCacheKey)KeyedColumnElement)Column)Table)LABEL_STYLE_TABLENAME_PLUS_COL) HasMemoized)!HasMemoized_ro_memoized_attribute)Literal)_IdentityKeyType) _InstanceDict)_ORMColumnExprArgument) _RegistryType)registry)DependencyProcessor)CompositeProperty)SynonymProperty) MapperEvents) ClassManager)CachingEntityRegistry)ColumnProperty)RelationshipProperty) InstanceState) ORMAdapter)Row) RowMapping)_ColumnExpressionArgument)_EquivalentColumnMap)ReadOnlyColumnCollection) ColumnClause) ColumnElement) FromClause) OrderedSet_T)bound_MPMapperProperty[Any]_FnzCallable[..., Any]* Mapper[Any]r]z.weakref.WeakKeyDictionary[_RegistryType, bool]_mapper_registriescb[ [[5sSSS5 $!,(df  g=fN)_CONFIGURE_MUTEXsetrfM/var/www/auris/envauris/lib/python3.13/site-packages/sqlalchemy/orm/mapper.py_all_registriesrns %&   s  .c#b# [5HnUR5ShvN M gN 7frh)rn_mappers_to_configure)regs rm_unconfigured_mappersrrs' ,,...!.s !/- /F NO_ATTRIBUTEc\rSrSr%SrS\S'SrSrS\S'Sr\ R"SS 9SSSjj5r S r S!r S rSrS"\S#'\SS$j5r\S%5rS \S 'S \S&'S'\S('S)\S*'S+\S,'S-\S.'S/\S0'S\S1'S2\S3'S4\S5'S6\S7'S8\S9'S:\S;'S<\S='S>\S?'S@\SA'SB\SC'S\S'S\S'SD\S'SE\S'S\S'SF\S'SF\SG'SH\S'SI\S'SrS\SJ'S\S'SK\S'SL\SM'S\SN'S\S'SO\S'SP\SQ'S\S'SR\SS'ST\SU'ST\SV'\ R(\ R*"SWSX5SY55r\ R.SSZj5rS[rSS\jrS]rS^rS_rS`rSSajrSSbjr SScjr!SSdjr"SSejr#S r$\%RLSf5r'\%RLSg5r(\%RLSh5r)\ RT"Si5Sj5r+\ RT"Si5S S SSk.SSljj5r,SSmjr-SSSnjjr.\ RT"Si5SSoj5r/\ R`RcSp\2Rf5SSqj5r4SSrjr5Ssr6SStjr7SSujr8\SSvj5r9SSwjr:SSxjr;SSyjrSS|jr?SSS}jjr@SS~jrA\S5rBSSjrCSSjrD\%RLSSj5rE\%RLS5rF\%RLS5rG\%RLS5rH\%RLSSj5rI\%RLS5rJ\KSSj5rL\IrM\KS5rN\%RLS5rO\%RLS5rP\%RLS5rQ\%RLS5rR\%RLSSj5rS\%RLSSj5rT\%RLSSj5rU\%RLSSj5rV\%RLSSj5rW\%RS5rY\ R.S5rZ\SSj5r[SSSjjr\\%RLS5r]\S5r^SSjr_\%RLSSj5r`SSjra\%RLSSj5rb\%RLSSj5rc\%RL\ RT"Si5SSj55rd\%RL\ RT"Si5SSj55re\S5rf\%RLSSj5rg\%RL\ RT"S5SSj55rh\%RL\ RT"Si5SSj55riSSjrj\%RLS5rk\%RLSSj5rlSSjrm\%RLS5rnSroSSjrpSSjrqSSjrrSSjrsGSSjrt\%RLSSj5ruGSSjrvGSSjrw\GSSj5rxSSjrySGSSjjrzSGSSjjr{GSSjr|\}R4GSSjjrGSSjr\%RLS5r\%RLS5r\%RLS5r\%RLS5r\%RLS5r\}R4GSSjjrSrSrSr\}R4SjrSrSr\%RLS5rSrSr\ RT"S5S5r\%RLS5rSGSSjjr\%RLS5r\%RLS5r\%RLS5rGS Sjr\ R.S5rSrg ( Mappera~Defines an association between a Python class and a database table or other relational structure, so that ORM operations against the class may proceed. The :class:`_orm.Mapper` object is instantiated using mapping methods present on the :class:`_orm.registry` object. For information about instantiating new :class:`_orm.Mapper` objects, see :ref:`orm_mapping_classes_toplevel`. zdispatcher[Mapper[_O]]dispatchFr_configure_failed)1.3aThe :paramref:`.mapper.non_primary` parameter is deprecated, and will be removed in a future release. The functionality of non primary mappers is now better suited using the :class:`.AliasedClass` construct, which can also be used as the target of a :func:`_orm.relationship` in 1.3.) non_primaryNTclass_Type[_O] local_table primary_keyrzboolinheritsinherit_conditionalways_refreshversion_id_colversion_id_generator5Optional[Union[Literal[False], Callable[[Any], Any]]]polymorphic_onpolymorphic_identity Optional[Any]concretewith_polymorphicallow_partial_pks Optional[str]c[R"U[S5UlURR<SURR <3Ul[R"U5UlXPl Xl [U [5(aXl SUlO.U b$[R "["R$U SS9OSUlU SLaSUlOU c SUlOXlXlSUlUb[-U5UlOSUlUb+[R "["R0USS S 9UlObUR.(a#UR.R2UlSUlO.[4R6"S URR S 35eUb+[R "["R8U5UlOSUlXlU(a [?U5O0Ul /Ul!UUl"UUl#UUl$U b$[R "["R$U S S9OSUl%UUl&/Ul'[RPUl)UUl*UUl+UUl,SUl-SUl.SUl/0Ul0UUl1SUl2UUl3UR.(aUR((dSUl4OUUl4URkU5 UUl6Xl7U c0Ul8OXl8Ub[Rr"U5Ul:OSUl:U(a[Rr"U5Ul;OSUl;[x [{SUR|R~5RX5 UR5 UR5 UR5 UR5 UR5 URRU5 URS5 UR5 SSS5 UR|RXR5 g!,(df  N4=f)aMDirect constructor for a new :class:`_orm.Mapper` object. The :class:`_orm.Mapper` constructor is not called directly, and is normally invoked through the use of the :class:`_orm.registry` object through either the :ref:`Declarative ` or :ref:`Imperative ` mapping styles. .. versionchanged:: 2.0 The public facing ``mapper()`` function is removed; for a classical mapping configuration, use the :meth:`_orm.registry.map_imperatively` method. Parameters documented below may be passed to either the :meth:`_orm.registry.map_imperatively` method, or may be passed in the ``__mapper_args__`` declarative class attribute described at :ref:`orm_declarative_mapper_options`. :param class\_: The class to be mapped. When using Declarative, this argument is automatically passed as the declared class itself. :param local_table: The :class:`_schema.Table` or other :class:`_sql.FromClause` (i.e. selectable) to which the class is mapped. May be ``None`` if this mapper inherits from another mapper using single-table inheritance. When using Declarative, this argument is automatically passed by the extension, based on what is configured via the :attr:`_orm.DeclarativeBase.__table__` attribute or via the :class:`_schema.Table` produced as a result of the :attr:`_orm.DeclarativeBase.__tablename__` attribute being present. :param polymorphic_abstract: Indicates this class will be mapped in a polymorphic hierarchy, but not directly instantiated. The class is mapped normally, except that it has no requirement for a :paramref:`_orm.Mapper.polymorphic_identity` within an inheritance hierarchy. The class however must be part of a polymorphic inheritance scheme which uses :paramref:`_orm.Mapper.polymorphic_on` at the base. .. versionadded:: 2.0 .. seealso:: :ref:`orm_inheritance_abstract_poly` :param always_refresh: If True, all query operations for this mapped class will overwrite all data within object instances that already exist within the session, erasing any in-memory changes with whatever information was loaded from the database. Usage of this flag is highly discouraged; as an alternative, see the method :meth:`_query.Query.populate_existing`. :param allow_partial_pks: Defaults to True. Indicates that a composite primary key with some NULL values should be considered as possibly existing within the database. This affects whether a mapper will assign an incoming row to an existing identity, as well as if :meth:`.Session.merge` will check the database first for a particular primary key value. A "partial primary key" can occur if one has mapped to an OUTER JOIN, for example. The :paramref:`.orm.Mapper.allow_partial_pks` parameter also indicates to the ORM relationship lazy loader, when loading a many-to-one related object, if a composite primary key that has partial NULL values should result in an attempt to load from the database, or if a load attempt is not necessary. .. versionadded:: 2.0.36 :paramref:`.orm.Mapper.allow_partial_pks` is consulted by the relationship lazy loader strategy, such that when set to False, a SELECT for a composite primary key that has partial NULL values will not be emitted. :param batch: Defaults to ``True``, indicating that save operations of multiple entities can be batched together for efficiency. Setting to False indicates that an instance will be fully saved before saving the next instance. This is used in the extremely rare case that a :class:`.MapperEvents` listener requires being called in between individual row persistence operations. :param column_prefix: A string which will be prepended to the mapped attribute name when :class:`_schema.Column` objects are automatically assigned as attributes to the mapped class. Does not affect :class:`.Column` objects that are mapped explicitly in the :paramref:`.Mapper.properties` dictionary. This parameter is typically useful with imperative mappings that keep the :class:`.Table` object separate. Below, assuming the ``user_table`` :class:`.Table` object has columns named ``user_id``, ``user_name``, and ``password``:: class User(Base): __table__ = user_table __mapper_args__ = {"column_prefix": "_"} The above mapping will assign the ``user_id``, ``user_name``, and ``password`` columns to attributes named ``_user_id``, ``_user_name``, and ``_password`` on the mapped ``User`` class. The :paramref:`.Mapper.column_prefix` parameter is uncommon in modern use. For dealing with reflected tables, a more flexible approach to automating a naming scheme is to intercept the :class:`.Column` objects as they are reflected; see the section :ref:`mapper_automated_reflection_schemes` for notes on this usage pattern. :param concrete: If True, indicates this mapper should use concrete table inheritance with its parent mapper. See the section :ref:`concrete_inheritance` for an example. :param confirm_deleted_rows: defaults to True; when a DELETE occurs of one more rows based on specific primary keys, a warning is emitted when the number of rows matched does not equal the number of rows expected. This parameter may be set to False to handle the case where database ON DELETE CASCADE rules may be deleting some of those rows automatically. The warning may be changed to an exception in a future release. :param eager_defaults: if True, the ORM will immediately fetch the value of server-generated default values after an INSERT or UPDATE, rather than leaving them as expired to be fetched on next access. This can be used for event schemes where the server-generated values are needed immediately before the flush completes. The fetch of values occurs either by using ``RETURNING`` inline with the ``INSERT`` or ``UPDATE`` statement, or by adding an additional ``SELECT`` statement subsequent to the ``INSERT`` or ``UPDATE``, if the backend does not support ``RETURNING``. The use of ``RETURNING`` is extremely performant in particular for ``INSERT`` statements where SQLAlchemy can take advantage of :ref:`insertmanyvalues `, whereas the use of an additional ``SELECT`` is relatively poor performing, adding additional SQL round trips which would be unnecessary if these new attributes are not to be accessed in any case. For this reason, :paramref:`.Mapper.eager_defaults` defaults to the string value ``"auto"``, which indicates that server defaults for INSERT should be fetched using ``RETURNING`` if the backing database supports it and if the dialect in use supports "insertmanyreturning" for an INSERT statement. If the backing database does not support ``RETURNING`` or "insertmanyreturning" is not available, server defaults will not be fetched. .. versionchanged:: 2.0.0rc1 added the "auto" option for :paramref:`.Mapper.eager_defaults` .. seealso:: :ref:`orm_server_defaults` .. versionchanged:: 2.0.0 RETURNING now works with multiple rows INSERTed at once using the :ref:`insertmanyvalues ` feature, which among other things allows the :paramref:`.Mapper.eager_defaults` feature to be very performant on supporting backends. :param exclude_properties: A list or set of string column names to be excluded from mapping. .. seealso:: :ref:`include_exclude_cols` :param include_properties: An inclusive list or set of string column names to map. .. seealso:: :ref:`include_exclude_cols` :param inherits: A mapped class or the corresponding :class:`_orm.Mapper` of one indicating a superclass to which this :class:`_orm.Mapper` should *inherit* from. The mapped class here must be a subclass of the other mapper's class. When using Declarative, this argument is passed automatically as a result of the natural class hierarchy of the declared classes. .. seealso:: :ref:`inheritance_toplevel` :param inherit_condition: For joined table inheritance, a SQL expression which will define how the two tables are joined; defaults to a natural join between the two tables. :param inherit_foreign_keys: When ``inherit_condition`` is used and the columns present are missing a :class:`_schema.ForeignKey` configuration, this parameter can be used to specify which columns are "foreign". In most cases can be left as ``None``. :param legacy_is_orphan: Boolean, defaults to ``False``. When ``True``, specifies that "legacy" orphan consideration is to be applied to objects mapped by this mapper, which means that a pending (that is, not persistent) object is auto-expunged from an owning :class:`.Session` only when it is de-associated from *all* parents that specify a ``delete-orphan`` cascade towards this mapper. The new default behavior is that the object is auto-expunged when it is de-associated with *any* of its parents that specify ``delete-orphan`` cascade. This behavior is more consistent with that of a persistent object, and allows behavior to be consistent in more scenarios independently of whether or not an orphan object has been flushed yet or not. See the change note and example at :ref:`legacy_is_orphan_addition` for more detail on this change. :param non_primary: Specify that this :class:`_orm.Mapper` is in addition to the "primary" mapper, that is, the one used for persistence. The :class:`_orm.Mapper` created here may be used for ad-hoc mapping of the class to an alternate selectable, for loading only. .. seealso:: :ref:`relationship_aliased_class` - the new pattern that removes the need for the :paramref:`_orm.Mapper.non_primary` flag. :param passive_deletes: Indicates DELETE behavior of foreign key columns when a joined-table inheritance entity is being deleted. Defaults to ``False`` for a base mapper; for an inheriting mapper, defaults to ``False`` unless the value is set to ``True`` on the superclass mapper. When ``True``, it is assumed that ON DELETE CASCADE is configured on the foreign key relationships that link this mapper's table to its superclass table, so that when the unit of work attempts to delete the entity, it need only emit a DELETE statement for the superclass table, and not this table. When ``False``, a DELETE statement is emitted for this mapper's table individually. If the primary key attributes local to this table are unloaded, then a SELECT must be emitted in order to validate these attributes; note that the primary key columns of a joined-table subclass are not part of the "primary key" of the object as a whole. Note that a value of ``True`` is **always** forced onto the subclass mappers; that is, it's not possible for a superclass to specify passive_deletes without this taking effect for all subclass mappers. .. seealso:: :ref:`passive_deletes` - description of similar feature as used with :func:`_orm.relationship` :paramref:`.mapper.passive_updates` - supporting ON UPDATE CASCADE for joined-table inheritance mappers :param passive_updates: Indicates UPDATE behavior of foreign key columns when a primary key column changes on a joined-table inheritance mapping. Defaults to ``True``. When True, it is assumed that ON UPDATE CASCADE is configured on the foreign key in the database, and that the database will handle propagation of an UPDATE from a source column to dependent columns on joined-table rows. When False, it is assumed that the database does not enforce referential integrity and will not be issuing its own CASCADE operation for an update. The unit of work process will emit an UPDATE statement for the dependent columns during a primary key change. .. seealso:: :ref:`passive_updates` - description of a similar feature as used with :func:`_orm.relationship` :paramref:`.mapper.passive_deletes` - supporting ON DELETE CASCADE for joined-table inheritance mappers :param polymorphic_load: Specifies "polymorphic loading" behavior for a subclass in an inheritance hierarchy (joined and single table inheritance only). Valid values are: * "'inline'" - specifies this class should be part of the "with_polymorphic" mappers, e.g. its columns will be included in a SELECT query against the base. * "'selectin'" - specifies that when instances of this class are loaded, an additional SELECT will be emitted to retrieve the columns specific to this subclass. The SELECT uses IN to fetch multiple subclasses at once. .. versionadded:: 1.2 .. seealso:: :ref:`with_polymorphic_mapper_config` :ref:`polymorphic_selectin` :param polymorphic_on: Specifies the column, attribute, or SQL expression used to determine the target class for an incoming row, when inheriting classes are present. May be specified as a string attribute name, or as a SQL expression such as a :class:`_schema.Column` or in a Declarative mapping a :func:`_orm.mapped_column` object. It is typically expected that the SQL expression corresponds to a column in the base-most mapped :class:`.Table`:: class Employee(Base): __tablename__ = "employee" id: Mapped[int] = mapped_column(primary_key=True) discriminator: Mapped[str] = mapped_column(String(50)) __mapper_args__ = { "polymorphic_on": discriminator, "polymorphic_identity": "employee", } It may also be specified as a SQL expression, as in this example where we use the :func:`.case` construct to provide a conditional approach:: class Employee(Base): __tablename__ = "employee" id: Mapped[int] = mapped_column(primary_key=True) discriminator: Mapped[str] = mapped_column(String(50)) __mapper_args__ = { "polymorphic_on": case( (discriminator == "EN", "engineer"), (discriminator == "MA", "manager"), else_="employee", ), "polymorphic_identity": "employee", } It may also refer to any attribute using its string name, which is of particular use when using annotated column configurations:: class Employee(Base): __tablename__ = "employee" id: Mapped[int] = mapped_column(primary_key=True) discriminator: Mapped[str] __mapper_args__ = { "polymorphic_on": "discriminator", "polymorphic_identity": "employee", } When setting ``polymorphic_on`` to reference an attribute or expression that's not present in the locally mapped :class:`_schema.Table`, yet the value of the discriminator should be persisted to the database, the value of the discriminator is not automatically set on new instances; this must be handled by the user, either through manual means or via event listeners. A typical approach to establishing such a listener looks like:: from sqlalchemy import event from sqlalchemy.orm import object_mapper @event.listens_for(Employee, "init", propagate=True) def set_identity(instance, *arg, **kw): mapper = object_mapper(instance) instance.discriminator = mapper.polymorphic_identity Where above, we assign the value of ``polymorphic_identity`` for the mapped class to the ``discriminator`` attribute, thus persisting the value to the ``discriminator`` column in the database. .. warning:: Currently, **only one discriminator column may be set**, typically on the base-most class in the hierarchy. "Cascading" polymorphic columns are not yet supported. .. seealso:: :ref:`inheritance_toplevel` :param polymorphic_identity: Specifies the value which identifies this particular class as returned by the column expression referred to by the :paramref:`_orm.Mapper.polymorphic_on` setting. As rows are received, the value corresponding to the :paramref:`_orm.Mapper.polymorphic_on` column expression is compared to this value, indicating which subclass should be used for the newly reconstructed object. .. seealso:: :ref:`inheritance_toplevel` :param properties: A dictionary mapping the string names of object attributes to :class:`.MapperProperty` instances, which define the persistence behavior of that attribute. Note that :class:`_schema.Column` objects present in the mapped :class:`_schema.Table` are automatically placed into ``ColumnProperty`` instances upon mapping, unless overridden. When using Declarative, this argument is passed automatically, based on all those :class:`.MapperProperty` instances declared in the declared class body. .. seealso:: :ref:`orm_mapping_properties` - in the :ref:`orm_mapping_classes_toplevel` :param primary_key: A list of :class:`_schema.Column` objects, or alternatively string names of attribute names which refer to :class:`_schema.Column`, which define the primary key to be used against this mapper's selectable unit. This is normally simply the primary key of the ``local_table``, but can be overridden here. .. versionchanged:: 2.0.2 :paramref:`_orm.Mapper.primary_key` arguments may be indicated as string attribute names as well. .. seealso:: :ref:`mapper_primary_key` - background and example use :param version_id_col: A :class:`_schema.Column` that will be used to keep a running version id of rows in the table. This is used to detect concurrent updates or the presence of stale data in a flush. The methodology is to detect if an UPDATE statement does not match the last known version id, a :class:`~sqlalchemy.orm.exc.StaleDataError` exception is thrown. By default, the column must be of :class:`.Integer` type, unless ``version_id_generator`` specifies an alternative version generator. .. seealso:: :ref:`mapper_version_counter` - discussion of version counting and rationale. :param version_id_generator: Define how new version ids should be generated. Defaults to ``None``, which indicates that a simple integer counting scheme be employed. To provide a custom versioning scheme, provide a callable function of the form:: def generate_version(version): return next_version Alternatively, server-side versioning functions such as triggers, or programmatic versioning schemes outside of the version id generator may be used, by specifying the value ``False``. Please see :ref:`server_side_version_counter` for a discussion of important points when using this option. .. seealso:: :ref:`custom_version_counter` :ref:`server_side_version_counter` :param with_polymorphic: A tuple in the form ``(, )`` indicating the default style of "polymorphic" loading, that is, which tables are queried at once. is any single or list of mappers and/or classes indicating the inherited classes that should be loaded at once. The special value ``'*'`` may be used to indicate all descending classes should be loaded immediately. The second tuple argument indicates a selectable that will be used to query for multiple classes. The :paramref:`_orm.Mapper.polymorphic_load` parameter may be preferable over the use of :paramref:`_orm.Mapper.with_polymorphic` in modern mappings to indicate a per-subclass technique of indicating polymorphic loading styles. .. seealso:: :ref:`with_polymorphic_mapper_config` r{.NrargnameFcU=(d SS-$)Nrrrk)xs rm!Mapper.__init__..s 16Q,rlTr})disable_inspectionrMapper[zM(None)] has None for a primary table argument and does not specify 'inherits'rrO constructed)Kr!assert_arg_typetyper{ __module____name__ _sort_keyto_list_primary_key_argumentrzr isinstancer+version_id_proprr9expectr<ColumnArgumentOrKeyRolerrsingler$rStrictFromClauseRoler}sa_exc ArgumentError OnClauseRolerinherit_foreign_keysdict_init_properties_delete_orphansbatcheager_defaults column_prefixrpolymorphic_abstract_dependency_processors EMPTY_DICT validatorspassive_updatespassive_deleteslegacy_is_orphan_clause_adapter_requires_row_aliasing_inherits_equated_pairs_memoized_values_compiled_cache_size_reconstructorrconfirm_deleted_rows_set_with_polymorphicpolymorphic_loadrpolymorphic_mapto_setinclude_propertiesexclude_propertiesrir rw_events_new_mapper_instance_configure_inheritance _configure_class_instrumentation_configure_properties_configure_polymorphic_setter_configure_pksrK_flag_new_mapper_log_expire_memoizationsafter_mapper_constructed)selfr{r}r r~rzrrrrrrr_polymorphic_maprrrrrrrrrrrrrrrrs rm__init__Mapper.__init__sr**64B KK " " KK   &*\\+%>"&, nn 5 5#1 "&D "-   11",    5 ((-D % ! )(>D %(< %   28Z 0B! ,*)   --(   %9!&(#//.. 0#&+#'+$ "$8!"!2 ==(-D %(UR(aUR Ul!OURRBUl!URJc7URRJUl%URRLUl&OURRJbtURJURRJLaQ[RH"SURJR.<SURRJR.<S35 URRNUl'URRPUl(URRRSU5 URRFUl#URRTUl*URRV=(d URVUl+URRXUl,UR@bUR@URN;aR[RH"SUR@<SURNUR@<SU<SUR@<S3 5 XRNUR@'URZ(a'UR(a[ R"S5eURZS:XaURR]U5 OURZS:XaOURZb#[ R"SURZ-5eOk[_5Ul,Xl#URceURUl UR@bXRNUR@'UR Ul!URc[ R"SU-5eg ![ R,anURRceURce[ R,"S URRR.<S URR.<S35UeS nAf[ R0anURRceURce[ R0"S URRR.<S URR.<S35UeS nAff=f) zPConfigure settings related to inheriting and/or inherited mappers being present.zClass 'z' does not inherit from ''primaryz non-primaryzInheritance of z mapper for class 'z' is only allowed from a z mapperNTz?Can't determine the inherit condition between inherited table 'z' and inheriting table 'z'; tables have no foreign key relationships established. Please ensure the inheriting table has a foreign key relationship to the inherited table, or provide an 'on clause' using the 'inherit_condition' mapper argument.z'; tables have more than one foreign key relationship established. Please specify the 'on clause' using the 'inherit_condition' mapper argument.)consider_as_foreign_keysz| does not indicate a 'polymorphic_identity', yet is part of an inheritance hierarchy that has a 'polymorphic_on' column of 'a''. If this is an intermediary class that should not be instantiated, the class may either be left unmapped, or may include the 'polymorphic_abstract=True' parameter in its Mapper arguments. To leave the class unmapped when using Declarative, set the '__abstract__ = True' attribute on the class.zInheriting version_id_col 'z+' does not match inherited version_id_col 'z' and will not automatically populate the inherited versioning column. version_id_col should only be specified on the base-most mapper that includes versioning.z1Reassigning polymorphic association for identity z from z to z: Check for duplicate use of z# as value for polymorphic_identity.zKpolymorphic_load is not currently supported with concrete table inheritanceinlineselectinz)unknown argument for polymorphic_load: %rz9Mapper '%s' does not have a persist_selectable specified.)0r! WeakSequencerr issubclassr{rrrrw_updaterzrrr}riterate_to_rootrrrsql_utiljoin_conditionNoForeignKeysError descriptionAmbiguousForeignKeysErrorr5joinrrcriterion_as_pairsonclauserrrrrwarnrrrrappendrrrr_add_with_polymorphic_subclassrj)rnprnfeafefkss rmrMapper._configure_inheritancesr $(#4#4#6 ===dkk4==+?+?@@**{{++T]]-A-A-J-JL MM ! !$--"8"8 94==#<#<<)))7iH=**4;;//5 {{*.--*J*J'!!)B)BB==.2.>.>D+"&"6"6"8!00<<@F9#9--5 ''5=5L5L $ 9 94;K;K6D2N ==;;GGG.1hh 88((../D+ ++d&?&?@C3;3N3N//88144D0 +/*:*:'((0'+{{$11 11@@LII&!!MM55DDEFH H '+{{$'+}}'D'D$""*&*mm&B&B#,0MM,N,N) ,,8''t}}/K/KK ++77 44@@ $(==#@#@D ,,DJ MM - - 4 4T :#}}88D #'==#@#@D  --E1E1E   $}}88D ((4,,0D0DDII !55 001J1JK  55 CG$$T%>%>?$$**6$$0 <%>?#';;D  " " *&&K  +_ &88'#'==#<#<#HH#H#'#3#3#??#?"(";";%)MM$=$=$I$I$($4$4$@$@!"# $'!'" &??'#'==#<#<#HH#H#'#3#3#??#?"("B"B%)MM$=$=$I$I$($4$4$@$@ !" #$' ''s& :\>>a"A:_  a"#A:aa"c,US:XaSUlO~[U[[45(a?[US[[[45(a[ SU5UlO.US4UlO$Ub[ R"SU<35eSUlUR(aUURSbEURS[R"[RURSSS94UlUR(aUR5 gg) Nrd)rdNrzTuple[ Union[ Literal["*"], Sequence[Union["Mapper[Any]", Type[Any]]], ], Optional["FromClause"], ]z&Invalid setting for with_polymorphic: rT allow_select)rrtupleliststrr rrr9rr<rrr)rrs rmrMapper._set_with_polymorphicms s "$/D ! (5$- 8 8*1-UD/ABB(,% )%*:4(@%  )&&89I8LM %)D !  T%:%:1%=%I%%a(  ..))!,!%%D ! ??  % % ' rlc.URnURcURU45 gURSS:waV[URS[5(deURURSU4-URS45 gg)Nrrdr)r{rrrr)rrsubcls rmr%Mapper._add_with_polymorphic_subclasss   (  & &x 0  " "1 % ,d33A6>> >>  & &&&q)UH4d6K6KA6NO -rlc|UR(deUR(ae[U[5(deXlURRR UR5 URRUlUR 5HnURcMSUlM URRUl URHnURRUl M URRRU5 URRUlURRUlUR R#5H@up4X0R ;dMUR%X3SSS9(aM.UR'X4S5 MB g)zSet the given :class:`_orm.Mapper` as the 'inherits' for this :class:`_orm.Mapper`, assuming this :class:`_orm.Mapper` is concrete and does not already have an inherits.NTFlocalcolumn)rrrrurupdater rrrself_and_descendantsrrrrrritems_should_exclude_adapt_inherited_property)rrmpkeyprops rm_set_concrete_baseMapper._set_concrete_basesP }}}==  &&))))  %%,,T-A-AB#}}<<**,F$$004--]](( ++B!]]66BN, ))006#}}<<==44,,.IC++%d.B.Bd/C//..s%@ /rlc2XlURS5 g)NT)rr)rrs rm_set_polymorphic_onMapper._set_polymorphic_ons, **40rlc [R"UR5nUR(aU(aUR(d#[ R "SUR-5eXlURceURUlURRUl URRU5 gUbUR(d[ R "S5eURRXR5 [R"URU[ R""[$R&U5SS9nXlURceURUlURcg[(R*"US[,SS9 [ R."UR5GHup#US:Xa:[1US 5(a)UR2n[1US 5(a UR4n[7U5(dMX[1US 5(a#X0l[(R*"US [:SS9 M[1US 5(dMUR<nUR>HTnXPR@;a[ R "SU<SU<S35eUR@RCXSU405Ul MV GM g)alIf this mapper is to be a primary mapper (i.e. the non_primary flag is not set), associate this Mapper with the given class and entity name. Subsequent calls to ``class_mapper()`` for the ``class_`` / ``entity`` name combination will return this mapper. Also decorate the `__init__` method on the mapped class to include optional auto-session attachment logic. ztClass %s has no primary mapper configured. Configure a primary mapper first before setting up a non primary Mapper.NzThe _mapper() function and Mapper() constructor may not be invoked directly outside of a declarative registry. Please use the sqlalchemy.orm.registry.map_imperatively() function for a classical mapping.T)rexpired_attribute_loaderfinalizeinit)rawr_sa_original_init__func____sa_reconstructor__load__sa_validators__z+A validation function for mapped attribute z on mapper z already exists.)"ropt_manager_of_classr{rz is_mappedrInvalidRequestErrorrrKrr_add_non_primary_mapperrwinstrument_classrregister_classr!partialrload_scalar_attributesr1listen_event_on_inititerate_attributeshasattrr<r=callabler_event_on_load__sa_validation_opts__r@runion)rmanagerr0methodvalidation_optsnames rmr'Mapper._configure_class_instrumentationsU11$++>   '"3"300 $ , ") ##/ //#,,DM#*>>#A#AD    4 4T :  ?'"2"2,,4  &&t[[9"00 KK%)\\..&   %+++((  >> !  Wfn$?224;;?KCj WV5H%I%I116:..#__F6#9::*0'LL&.dKV%899&,&C&CO & 8 8??2"("<"<$(!/# +///*?*?!O#<=+!9@rlcfSUlSUlSUlURR SS5 g)NTrx)r_ready_for_configure_dispose_called__dict__poprs rm_set_dispose_flagsMapper._set_dispose_flagss.$(!# -t4rlcdURUnURn[ U[5(d[R"SUSUS35eU$![a#n[R"SUSUS35UeSnAff=f![ a#n[R"SUSUS35UeSnAff=f)NzCan't determine z column 'z(' - no attribute is mapped to this name.z4'; property does not refer to a single mapped Column)rKeyErrorrrr:AttributeErrorrrA)rrr0r1errexpraes rm_str_arg_to_mapped_colMapper._str_arg_to_mapped_col!s ;;s#D  ??D $''&&"7)9SE:     % &&"7)9SE:77   &&"7)9SE:DD  s.A B A?A::A? B/ B**B/c ^[R"TR5TlTRR STR55 0Tl0Tl[R"[TRVs/sHoRPM sn65n[R"SU55n[TR5RTR/5HnUR(a\UR!UR5(a<[R""UR5R%U5TR U'[R""UR&5R%U5TRU'M TR((aKSTR(5Vs/sH,n[+U[,5(aTR/SU5OUPM. nnOSnU(axUHqnUR0TR ;a,[R2"5TR UR0'TR UR0R5U5 Ms OTRTR ;d&[7TR TR5S:Xa3[8R:"ST<STRR<<S35eTR>TR ;aV[+TR>[@RB5(a-[RD"S TR>R<-5 TRF(a>TRH(d-TR((dTRFRTlOU(a&U4S jU5VVs/sH upUbUOUPM n nnO,[RJ"TR TRS S 9n [7U 5S:Xa3[8R:"ST<STRR<<S35e[MU 5TlTROS U 5 TRVs1sH^nTRUTRP;dM"[SUS5(aUR0TR;dMOTRUiM` snTl*gs snfs snfs snnfs snf)Nc3$# UHov M g7frhrk).0ts rm (Mapper._configure_pks..;s7;a;sc3J# UHoR(dMUv M g7frh)r~)rgrs rmrirjDs!GX!!Xs# #c3j# UH)n[R"[RUSS9v M+ g7f)r~rN)r9rr<DDLConstraintColumnRole)rg coerce_pks rmrirj[s7 &@ $$55! - &@s13r~rzMapper z> could not assemble any primary key columns for mapped table 'rzlCould not assemble any primary keys for locally mapped table '%s' - no rows will be persisted in this Table.c3^># UH"nTRRU5U4v M$ g7frh)rcorresponding_column)rgrrs rmrirjs."!/A00EEaH!L!/s*-T)ignore_nonexistent_tablesz"Identified primary key columns: %sr)+r  find_tablesrrrr*rrr! column_setrr proxy_setrjrPr~ issupersetordered_column_set intersectionrrrr!rcrr^addlenrrrr}r4rBrrrreduce_columnsrr_identity_key_propsrL_readonly_props) rcolall_colspk_colsfcrcoerced_pk_argkccr~s ` rmrMapper._configure_pks8s0**4+B+BC  74;;77 ?? T-C-CD-CcMM-CD E //!GX!GGdkk"(($*A*A)BCB~~'"4"4R^^"D"D*.)@)@NN*,""2& '+&=&=bdd&C&P&P'D   #D  % % &*%?%?   A"!S))// qA N "N #77$"4"4426//2CD&&qww/""177+//2$  # #4+=+= =4%%d&=&=>?1D&&00<<>    T%7%7 7J   fll= =  II;""../  MMMM.. $}}88D  "!/"".Ba/" '55&&t'>'>?.2 ;1$**T44@@B %[1D  II:K H -- -%%c*$2J2JJ (C))99D$7$77 (D " "3 '- YE(v: s$S% 3S*S/7!S5)S5 S5c[R"5=UlUl[R "5Ul[U5Ul0n0nUR(aURR5Hup4[U[5(dURX45nOUnSn[U[R5(aKURH;nUR RR#U5(dM/SnXRU'UU4X'M= U(dMUR%UUSS9 M UR&(aUR&R R5Hup8UR)X3SSS9(aMUR+U5n U (a1UR-UUSU S9n XU'U RH n UU 4X'M MfX0R ;dMwUR/X8S5 M UR0RHn X;aXup=UR%X=SS9 M XR;aM1UR2=(d SU R4-nUR)U R4UUR RR#U 5U S9(aMUR75H-nXR;dMURU R4nM/ UR%UU SSS9 M g)NTF)r:r') warn_only incoming_propr: setparent)sql_baseColumnCollectionrrr! OrderedDictrrrrr,rr+_make_prop_from_columnr rRr}contains_column_configure_propertyrr-get%_reconcile_prop_with_incoming_columnsr.rrr0r )rexplicit_col_props_by_columnexplicit_col_props_by_keyr0prop_argpossible_col_prop_map_as_property_now given_colinherited_proprnew_propinc_colr)r1 column_keyrs rmrMapper._configure_propertiess ( 9 9 ;; tv&&( "0!5  %EG!  !%!6!6! !(N;;(,(C(C)%)1%(,$/1J1JKK%6%>%> ++--==iHH380=Nc: # 1G8C &?(',,)"-3"?D =='+}}';';'A'A'C#''d'K 9 = =c B  #II&"'&3 J H 6>c2#0#8#8$A4=$9  +223N)(D8--55F59@ (((?111,,2fjj@J## &&((88@ $ ..0555!'!9!9&!A!E!EJ1  $ $ % 76rlc^ SnSm URGbKSn[UR[5(aURURUlURUR;aURURnGO[UR[5(aM[UR[R5(d[ R "S5eURnGOIURRUR5nUcSnSnURn[U[R5(a`URb0URSb URSRU5c#[ R "SUR"-5eOSn[%USS5nU(a2UR'XwSU5(a[ R "S U-5eO$UR)S 5=UlnUR*n[R"XVS 9nUR-XtUSS 9 UR.S UlUR*m OUR15HnURcMURURLaURUlO*URRUR5UlURb5UR2UlUR4UlUR6Ul gSUlSUl g UR8(a#URc[ R "S5eU(a!U 4Sjn T UlU 4Sjn XlU UlgSUlSUlg![a)n[ R "SUR-5UeSnAff=f)auConfigure an attribute on the mapper representing the 'polymorphic_on' column, if applicable, and not already generated by _configure_properties (which is typical). Also create a setter function which will assign this attribute to the value of the 'polymorphic_identity' upon instance construction, also if applicable. This routine will run when an instance is created. FNTzPCan't determine polymorphic_on value '%s' - no attribute is mapped to this name.zUOnly direct column-mapped property or SQL expression can be passed for polymorphic_onrzkCould not map polymorphic_on column '%s' to the mapped table - polymorphic loads will not function properlyr0z6Cannot exclude or override the discriminator column %r_sa_polymorphic_on) _instrumentrrzThe Mapper.polymorphic_abstract parameter may only be used on a mapper hierarchy which includes the Mapper.polymorphic_on parameter at the base of the hierarchy.cP>URnURRRnUcSURRR(a.[ R "SURRS35eURT5RUUUS5 g)NzCan't instantiate class for z,; mapper is marked polymorphic_abstract=True) rrQrrrrrCget_implrj)statedict_rpolymorphic_keys rmrGMapper._configure_polymorphic_setter.._set_polymorphic_identitys  MM((==%)0 ,,AA 446u}}7K7K6LMEE /33( rlc>TU;a:UTUR;a&[R"S[U5UT45 ggg)NznFlushing object %s with incompatible polymorphic identity %r; the object may not refresh and/or load correctly)"_acceptable_polymorphic_identitiesr! warn_limitedr')rrrrs rmrLMapper._configure_polymorphic_setter.._validate_polymorphic_identitysW#u,o.!DDE%%G#5)5+AB E-rl)rrr!rr^rrrr+r rRrrpr4rArrCrgetattrr-labelr0rrr rrrr) rr:setterr`r1r} instrumentr0rrrrs @rmr$Mapper._configure_polymorphic_setter+s)-    *F$--s33*.++d6I6I*JD'""d&<&<<--d.A.ABD//@@"'')B)B!..; **--BB'';#F!&J--C!#v}}55--5003;003HHM %88?"oo."&Jc5$/++CeSAA$8868;<B 14 :N0OOD'#''C!00M(((N#',,q/D "hhO..0 ((4..&2K2KK.4.C.C+!33..v/D/DE+ **6"<<6#882#AA; :>6592;1>  $ $)<)<)D,,P   0*9D & .G *.  /*.D &-1D *]  ../151D1DE sN O$OOcPURbURUR$grh)rrrs rm_version_id_propMapper._version_id_props(    *))$*=*=> >rlc[5n[U/5nU(ahUR5nURURLa6UR UR 5 UR UR5 U(aMhU$rh)rjrpopleftrrxrextendr)r identitiesstackitems rmr)Mapper._acceptable_polymorphic_identitiessiU tf ==?D&&$*A*AAt889 T556 e rlcH[URR55$rh) frozensetrvaluesrs rm _prop_setMapper._prop_sets++-..rlzsqlalchemy.orm.descriptor_propsc[RRnUR(dUR XSSS9 gXR ;azUR RX5nXRLd8[U[R5(a;URURLa!UR UUR5USS9 gggg)NFrT)r! preloadedorm_descriptor_propsrrrr_get_class_attr_mrorrInstrumentedAttribute _parententityparentConcreteInheritedProperty)rr0r1r:descriptor_propsimplementing_attributes rmr. Mapper._adapt_inherited_property s>>>>}}  $ $SUe $ L  #&*%7%7%K%K& "&-*J,L,L+88DKKG(($>>@" )H$rl)r:rwarn_for_existingc  [RRnURSXRR 5 [ U[5(dURX5nOUn[ U[R5(GaURRURS5nUcUR(aU/n URR5Hn U R RURS5nUbNU Hn U RR#U5 M URRURS5n OU R%U 5 M UcgURSn['US5(aF['US5(aUR(UR*;aUR,R/U5 Oo['US5(a^UR(UR*;aDXR*UR(;a(UR*UR(R/U5 ['US5(d4XR0L=(d URSUR0LUl[ U[4R65(aU=UlUlURR/X5 URH$nUR<Hn XpR>U 'M M& [AUSU5U:wa[[RB"SURDR S UR8S U<S UR8<S UR8<S 3 5 XlU(aURGX5 XRH;a^[AURHUS S5(a?URHURJn [LRN"SU <SU<SU<SU <35eXRH;a[ URHUURP5(d[ XvRR5(dhU(a5[RT"SURDR S USUS3S5 URHUnURVRYUS5 OU(aURDRZR]US5b[ XvRR5(dj[ URHR]US5URP5(d5[RT"SURDR S USUS3S5 XpRHU'UR^(dURaU5 URbHnUReXU5 M U(a!URg5 URiU5 URj(aURm5 U$)Nz_configure_property(%s, %s)rr|rr_is_polymorphic_discriminatorr0zORM mapped property rz being assigned to attribute z& is already associated with attribute z+. The attribute will be de-associated from _mapped_by_synonymFz'Can't call map_column=True for synonym =z4, a ColumnProperty already exists keyed to the name z for column zUser-placed attribute z on z is replacing an existing ORM-mapped attribute. Behavior is not fully defined in this case. This use is deprecated and will raise an error in a future releasez2.0z is replacing an existing class-bound attribute of the same name. Behavior is not fully defined in this case. This use is deprecated and will raise an error in a future release)7r!rrr __class__rrr+_property_from_columnr rRrrprrr r}_refresh_for_new_columnrrLrrr|rxrrr:Labelr0 _tq_key_labelrtrrrr{ set_parentrrrrrrNwarn_deprecatedrrZrYrrzrErr.r:post_instrument_classrr)rr0rr:rrrr1r}pathmm2 proxy_colsynoldproprs rmrMapper._configure_property(s  >>>> )30B0B0K0K (N33(,(B(B)DD dJ55 6 6))>>t||AOC {t}}v668A--<||A$*=*==2 #z//00/21#+ LL  S &||!$I8<**95"/$ 4 $ + II&t{{';';&auD&   C  ! !$ '..F  , ,S =/  IIK  & &t , ??  % % ' rlc [R"U5n/nUHnURRU5nUczURRU5nUbURR U5 URRU5nUc#[ R"SU<SU<SU<S35eURU5 M [R"U6$)NzWhen configuring property '' on , column 'z' is not represented in the mapper's table. Use the `column_property()` function to force this column to be mapped as a read-only attribute.) r!rrrpr}rrrrr rR)rr0r)r mapped_columnrmcs rmrMapper._make_prop_from_columns,,v& A((==a@Bz%%::1=> ++CCBG,,AA!D: .. ),T1 6   $'(((-88rlcU(a2UR(d[U[R5(dU$URSnU(aXdR;aU$UcUceUnURSU4nO$UbeURSnXrRS4nUR (aXR ;aUR U5(dlX`RLa^XpRLaPSURS<SU<SU<S3n U(a[R"U 5 O[R"U 5eUR5n U RRSU5 URSU5 U $)NrzImplicitly combining column z with column z under attribute 'zT'. Please configure one or more attributes for these same-named columns explicitly.zAinserting column to existing list in properties.ColumnProperty %s)rrr rRrrshares_lineagerr!rrrCcopyinsertr) rr0 existing_proprr single_columnexisting_columnincoming_columnequated_pair_keymsgrs rmr,Mapper._reconcile_prop_with_incoming_columnssj  MMmZ-F-FGG '//2 _0E0EE   , ,,+O - 5 5a 8/J  ( ((+33A6O /1F1Fq1IJ 00$,H,HH#22?CC':'::':'::"))"-#  #0055 !%%'?3  .  rlc [RRnURR U5n[ U[ R5(aURUUUURULS9$Ub[ XCR5(aURX5$[R"SU<SU<SUR<SU<S3 5e)zjgenerate/update a :class:`.ColumnProperty` given a :class:`_schema.Column` or other SQL expression object.)rrz$WARNING: when configuring property 'rrz' conflicts with property 'aG'. To resolve this, map the column to the class under a different name in the 'properties' dictionary. Or, to remove all awareness of the column entirely (including its availability as a foreign key), use the 'include_properties' or 'exclude_properties' mapper arguments to control specifically which table columns get mapped.)r!rrrrrr rRrrrrrrr0)rr0r)rr1s rmrMapper._property_from_column4 s >>>>{{s# dJ55 6 6==$++T1 >  \Z <<  ..s; ;&&*-dFJJF  rlzThis warning originated from the `configure_mappers()` process, which was invoked automatically in response to a user-initiated operation.cfURR(a[UR1SS9 gg)NTcascade)rK _new_mappers_configure_registriesrs rm_check_configureMapper._check_configureY s& == % % !4==/4 @ &rlcURS5 URR5VVs/sHupX4PM nnnUHkupURSU5 URULa!UR(dUR 5 UR (dMZURU5 Mm URS5 SUlgs snnf)zCall the ``init()`` method on all ``MapperProperties`` attached to this mapper. This is a deferred configuration step which is intended to execute once all mappers have been constructed. z$_post_configure_properties() startedzinitialize prop %sz%_post_configure_properties() completeTN) rrr,r_configure_startedr:_configure_finishedrr)rr0r1ls rm_post_configure_properties!Mapper._post_configure_propertiesc s 89*.++*;*;*= >*=YSc[*= >IC II*C 0{{d"4+B+B '''**40 9: ?sC cXUR5Hup#URX#5 M g)zNAdd the given dictionary of properties to this mapper, using `add_property`. N)r, add_property)rdict_of_propertiesr0values rmadd_propertiesMapper.add_propertiesz s' -224JC   c )5rlcURXURSS9n[U[5(deX RU'g)aAdd an individual MapperProperty to this mapper. If the mapper has not been configured yet, just adds the property to the initial properties dictionary sent to the constructor. If this Mapper has already been configured, then the given MapperProperty is configured immediately. T)r:rN)rrrr+r)rr0r1s rmrMapper.add_property sG'' DOOt( $////%)c"rlcRUR5HnUR5 M grh)r _reset_memoizationsrrs rmrMapper._expire_memoizations s!**,F  & & (-rlcSURR-S-URSL=(a URR=(d [ UR5-UR =(a S=(d S-S-$)N(|z |non-primaryr))r{rr}rr!rzrs rm _log_descMapper._log_desc s kk"" #   ,1$$00)t''(  2N8b :  rlc`URR"SU-/UR4U-Q76 gNz%s )loggerinforrrargss rmr Mapper._log s) B(9D(@Brlc`URR"SU-/UR4U-Q76 gr)rdebugrrs rm _log_debugMapper._log_debug s) %#+C$..):T)ACrlcJS[U5URR4-$)Nz)idr{rrs rm__repr__Mapper.__repr__ s %D4;;3G3G(HHHrlcSURR<UR=(a S=(d S<SURbURROUR R<S3$)Nrz (non-primary)rr z)])r{rrzr}rrrs rm__str__Mapper.__str__ sc KK    1!1 7R 7##/  ,,,,889   rlcVSnUR5HnURHmupESn[R"U5R XUR S9nUR (a U(a gUR (aMcU(aMl g M UR (aU$g)NFT) optimistic)r rrmanager_of_class has_parent has_identityr)rrorphan_possiblerr0clsr&s rm _is_orphanMapper._is_orphan s**,F"22"&'88=HH5+=+=I ((Z ...zz3-  " "rlcXR;$rh)r)rr0s rm has_propertyMapper.has_property skk!!rlcU(aUR5 URU$![a#n[R"SUSUS35UeSnAff=f)z6return a MapperProperty associated with the given key.zMapper 'z' has no property 'zw'. If this property was indicated from other mappers or configure events, ensure registry.configure() has been called.N)rrr^rrC)rr0_configure_mappersr`s rm get_propertyMapper.get_property sg   ! ! # ;;s# # ,,4& 3C5988   s( AAAc URU$)zcGiven a :class:`_schema.Column` object, return the :class:`.MapperProperty` which maps this column.)r)rr)s rmget_property_by_columnMapper.get_property_by_column s %%f--rlcH[URR55$)z1return an iterator of all MapperProperty objects.)iterrrrs rmiterate_propertiesMapper.iterate_properties sDKK&&())rlchUS:Xa[UR5nOU(a[5n[R"U5Hvn[ U5nUR U5(d[R"U<SU<35eUc!URUR55 MeURU5 Mx URVs/sH oUU;dM UPM nnO/nUbA[[R"USS95nUVs/sHoURU;dMUPM nnU$s snfs snf)zgiven a with_polymorphic() argument, return the set of mappers it represents. Trims the list of mappers to just those represented within the given selectable, if present. This helps some more legacy-ish mappings. rdz does not inherit from T)include_aliases)r r+rjr!rr#isarrCr*r rxr rrr})rspec selectablemappers mapper_setrrs rm_mappers_from_specMapper._mappers_from_spec s 3;4445G J\\$'$Q'uuT{{ 449:DA%%%a&7&7&9:NN1%(#'";";O";QJq";GOGG  !$$ZFF#*E'Q]]f-Dq'GEPFs D*D* D/ D/cZURnUHnX@LaM UR(a[R"S5eUR(aMCU(a(UR UR UR5nMrURUR UR5nM U$)zgiven a list of mappers (assumed to be within this mapper's inheritance hierarchy), construct an outerjoin amongst those mapper's mapped tables. z^'with_polymorphic()' requires 'selectable' argument when concrete-inheriting mappers are used.) rrrrCrrr}r outerjoin)rr? innerjoinfrom_objrs rm_selectable_from_mappersMapper._selectable_from_mappers s**Ayzz00AXXX'}} q':': H (11 q':': H$rlcURnUcg[U[5(dgURSL=(dR URSL=(a= URR (+=(a URR (+$NFT)rrrAserver_defaultdefault is_scalar is_callable)rvid_cols rm!_version_id_has_server_side_value(Mapper._version_id_has_server_side_value1 ss%% ?GV,,))5t+1118#OO777  rlc4UR(aUR(aqURbdURRXS.5R UR Vs/sH"nUR (aMURPM$ sn5$gs snf)N) parententity parentmapper)rrr _annotatein_r+rrrrs rm_single_table_criterionMapper._single_table_criterionC s ;;4==T-@-@-L&&00!%<c"66611+A**6 s $B=BcvUR=(a' [URS[R5$)zreturn True if with_polymorphic[1] is an aliased fromclause, like a subquery. As of #8168, polymorphic adaption with ORMAdapter is used only if this is present. r)rrr:AliasedReturnsRowsrs rm#_has_aliased_polymorphic_fromclause*Mapper._has_aliased_polymorphic_fromclauseR s5$$   ! !! $  ) )*  rlcUR=(dF UR=(d3 URR=(d URR$)adetermine if _MapperEntity or _ORMColumnEntity will need to use polymorphic adaption when setting up a SELECT as well as fetching rows for mapped classes and subclasses against this Mapper. moved here from context.py for #8456 to generalize the ruleset for this condition. )r\rrrs rm _should_select_with_poly_adapter'Mapper._should_select_with_poly_adapter` sKV  4 4 7** 7  DD 766  rlczUR5 UR(d/$UR"UR6$rh)rrrArs rm_with_polymorphic_mappers Mapper._with_polymorphic_mappers s3 $$I&&(=(=>>rlc$UR5 g)zThis hook is invoked by attribute inspection. E.g. when Query calls: coercions.expect(roles.ColumnsClauseRole, ent, keep_inspect=True) This allows the inspection process run a configure mappers hook. N)rrs rm _post_inspectMapper._post_inspect s rlcUR(d UR$URupUbU$URURX5S5$NF)rrrGrA)rr=r>s rm_with_polymorphic_selectable#Mapper._with_polymorphic_selectable sT$$** *00  ! 00''95 rlc URR5VVs0sHupU[SU55_M snn$s snnf)Nc3^# UH#oRR(dMUv M% g7frh)rshould_evaluate_nonergr}s rmri6Mapper._insert_cols_evaluating_none.. s&((*G*Gws- -rr,rrrrs rm_insert_cols_evaluating_none#Mapper._insert_cols_evaluating_none sW #'"5"5";";"=  #> 9& #>    Ac URR5VVs0sHupU[SU55_M snn$s snnf)Nc3# UHgnUR(aMUR(aM)UR(aM<URR(aMYUR v Mi g7frh)r~rKrLrrmr0rns rmri.Mapper._insert_cols_as_none.. sV"C**  55 "sA1A1A1A1A1rprqs rm_insert_cols_as_noneMapper._insert_cols_as_none sW#'"5"5";";"=  #> 9" #>   rtc URR5VVVs0sH/upXVs0sHo0RURU_M sn_M1 snnn$s snfs snnnfrh)rr,rr0rrrr}s rm_propkey_to_colMapper._propkey_to_col se#'"5"5";";"= "= GLGS**3/33S8GL L"=  L s A#AAAc URR5VVVs0sH+upU[UVs/sHo3RPM sn5_M- snnn$s snfs snnnfrh)rr,rr0rrpksr}s rm_pk_keys_by_tableMapper._pk_keys_by_table sX#00668 8  95#gg56 68  5 sAA AAc URR5VVVs0sH8upU[UVs/sHo0RURPM sn5_M: snnn$s snfs snnnfrh)rr,rrr0rs rm_pk_attr_keys_by_tableMapper._pk_attr_keys_by_table se#00668 8  9M#44S9==MN N8  M sA("A# A(#A(c 8URR5VVVs0sHeupU[[SU5Vs/sH>nURc,UR cMUR R (dM<UPM@ sn5_Mg snnn$s snfs snnnfNzIterable[Column[Any]])rr,rr rKrLis_clause_elementr{s rm_server_default_colsMapper._server_default_cols s #'"5"5";";"=  #> 9 $$;WEE))5   KK99 E  #>    "BBB:B BBc 8URR5VVVs0sHeupU[[SU5Vs/sH>nURc,UR cMUR R (dM<UPM@ sn5_Mg snnn$s snfs snnnfr)rr,rr server_onupdateonupdaterr{s rm_server_onupdate_default_cols$Mapper._server_onupdate_default_cols s #'"5"5";";"=  #> 9 $$;WEE**6   LL:: E  #>    rc URR5VVs0sHupU[SU55_M snn$s snnf)Nc3V# UHoRcMURv M! g7frhr0rns rmri2Mapper._server_default_col_keys.. LWSWW)))rr,rrrcolss rmrMapper._server_default_col_keys sJ $88>>@ @  9LLL L@   rtc URR5VVs0sHupU[SU55_M snn$s snnf)Nc3V# UHoRcMURv M! g7frhrrns rmri;Mapper._server_onupdate_default_col_keys.. rr)rr,rrs rm!_server_onupdate_default_col_keys(Mapper._server_onupdate_default_col_keys sJ $AAGGI I  9LLL LI   rtch^[5nURmURR5H/up#UR U4SjUR T555 M1 UR R5H/up#UR U4SjUR T555 M1 U$)Nc3B># UHnTURv M g7frhrrgr}col_to_propertys rmri@Mapper._server_default_plus_onupdate_propkeys..! #@C $((@c3B># UHnTURv M g7frhrrs rmrir& rr)rjrrr,r*rwr)rresultrrrs @rm&_server_default_plus_onupdate_propkeys-Mapper._server_default_plus_onupdate_propkeys s500"77==?NE MM"//@ @ #@@FFHNE MM"//@ I  rlcUUUS.nURURLa4URRUUUS.5RSUS.5US'URRU5RSUS.5$)N)entity_namespacerSrTormcompile_state_pluginplugin_subject dml_table)rr}rU_set_propagate_attrsr>)rrs rm__clause_element__Mapper.__clause_element__, s!%  '  " "$*:*: :(,'7'7'A'A(,$($(( #").$G  $((5JJ%*d C  rlcx[R"5RUUUSS.5RSUS.5$)NT)rrSrTidentity_tokenrr)r:nullrUrrs rmselect_identity_tokenMapper.select_identity_tokenD sC OO  Y(,$($(&* " !).$G rlcUR$)a The :class:`_schema.FromClause` construct this :class:`_orm.Mapper` selects from by default. Normally, this is equivalent to :attr:`.persist_selectable`, unless the ``with_polymorphic`` feature is in use, in which case the full "polymorphic" selectable is returned. )rirs rmr>Mapper.selectableU s000rlc.US;a$[R"[RUSS9nUR(a+U(dURSnUSLaURSnOUSLaSnUR X5nUbXB4$X@R XC54$)NrhTrrFr)r9rr<rrrArG)rr=r>rEr?s rm_with_polymorphic_argsMapper._with_polymorphic_argsa s ] *"))**JTJ  ,,Q/U"!2215 5 J))$;  !& &99'MM MrlcJ[URUR55$rh)r _iterate_polymorphic_propertiesrbrs rm_polymorphic_propertiesMapper._polymorphic_propertiesy s&  0 0..   rlc$URnURnUVVs/sHcn[U[R5(dM$UR (dM7UR HnU(aUR UOUPM Me snn$s snnfrh)r_polymorphic_adapterrr rR_renders_in_subqueriesr)rpoly_propertiesadapterr1rs rm_all_column_expressionsMapper._all_column_expressions s66++( '$ 9 9: 1++ 1\\ #*GOOA q 0" 1'   s#B B 0B cU(aURU5nO URnUVs/sH?n[U[R5(dM$UR UR S4PMA sn$s snf)Nr)rrrr rRr0r)rpolymorphic_mappersrr1s rm_columns_plus_keysMapper._columns_plus_keys so "BB#O#::O( '$ 9 9: (TXXt||A ''   s #A3A3cUR(aD[R"[RRUUR UR SS9$g)NF)r> equivalentslimit_on_entity)r\orm_utilrU_TraceAdaptRoleMAPPER_POLYMORPHIC_ADAPTERr>_equivalent_columnsrs rmrMapper._polymorphic_adapter sH  3 3&&((CC?? 44 %  rlc ## Uc URnU(dURHnUv M g[R"[ U/U-Vs/sHn[ UR5PM sn65HDn[ USS5(a+URbURSURLaM@Uv MF gs snf7f)zMReturn an iterator of MapperProperty objects which will render into a SELECT.NrFr) rbr8r! unique_listrr rrr)rr?rrs rmr&Mapper._iterate_polymorphic_properties s ?44G,,- %%(,fw&6&6FV667&61=uEE''/yy|4+>+>>sA CB> -ACcbUR5 [R"UR5$)aA namespace of all :class:`.MapperProperty` objects associated this mapper. This is an object that provides each property based on its key name. For instance, the mapper for a ``User`` class which has ``User.name`` attribute would provide ``mapper.attrs.name``, which would be the :class:`.ColumnProperty` representing the ``name`` column. The namespace object can also be iterated, which would yield each :class:`.MapperProperty`. :class:`_orm.Mapper` has several pre-filtered views of this attribute which limit the types of properties returned, including :attr:`.synonyms`, :attr:`.column_attrs`, :attr:`.relationships`, and :attr:`.composites`. .. warning:: The :attr:`_orm.Mapper.attrs` accessor namespace is an instance of :class:`.OrderedProperties`. This is a dictionary-like object which includes a small number of named methods such as :meth:`.OrderedProperties.items` and :meth:`.OrderedProperties.values`. When accessing attributes dynamically, favor using the dict-access scheme, e.g. ``mapper.attrs[somename]`` over ``getattr(mapper.attrs, somename)`` to avoid name collisions. .. seealso:: :attr:`_orm.Mapper.all_orm_descriptors` )rr!ReadOnlyPropertiesrrs rmattrs Mapper.attrs s&F &&t{{33rlcp[R"[URR 555$)a A namespace of all :class:`.InspectionAttr` attributes associated with the mapped class. These attributes are in all cases Python :term:`descriptors` associated with the mapped class or its superclasses. This namespace includes attributes that are mapped to the class as well as attributes declared by extension modules. It includes any Python descriptor type that inherits from :class:`.InspectionAttr`. This includes :class:`.QueryableAttribute`, as well as extension types such as :class:`.hybrid_property`, :class:`.hybrid_method` and :class:`.AssociationProxy`. To distinguish between mapped attributes and extension attributes, the attribute :attr:`.InspectionAttr.extension_type` will refer to a constant that distinguishes between different extension types. The sorting of the attributes is based on the following rules: 1. Iterate through the class and its superclasses in order from subclass to superclass (i.e. iterate through ``cls.__mro__``) 2. For each class, yield the attributes in the order in which they appear in ``__dict__``, with the exception of those in step 3 below. In Python 3.6 and above this ordering will be the same as that of the class' construction, with the exception of attributes that were added after the fact by the application or the mapper. 3. If a certain attribute key is also in the superclass ``__dict__``, then it's included in the iteration for that class, and not the class in which it first appeared. The above process produces an ordering that is deterministic in terms of the order in which attributes were assigned to the class. .. versionchanged:: 1.3.19 ensured deterministic ordering for :meth:`_orm.Mapper.all_orm_descriptors`. When dealing with a :class:`.QueryableAttribute`, the :attr:`.QueryableAttribute.property` attribute refers to the :class:`.MapperProperty` property, which is what you get when referring to the collection of mapped properties via :attr:`_orm.Mapper.attrs`. .. warning:: The :attr:`_orm.Mapper.all_orm_descriptors` accessor namespace is an instance of :class:`.OrderedProperties`. This is a dictionary-like object which includes a small number of named methods such as :meth:`.OrderedProperties.items` and :meth:`.OrderedProperties.values`. When accessing attributes dynamically, favor using the dict-access scheme, e.g. ``mapper.all_orm_descriptors[somename]`` over ``getattr(mapper.all_orm_descriptors, somename)`` to avoid name collisions. .. seealso:: :attr:`_orm.Mapper.attrs` )r!rrr_all_sqla_attributesrs rmall_orm_descriptorsMapper.all_orm_descriptors s/D&& ##88: ;  rlcz[RRnURVs1sHo"RiM nnUR R 5VVs0sHJupE[XQR5(dM!URU;dM3URUR_ML snn$s snfs snnf)znreturn a dictionary of {syn_attribute_name: pk_attr_name} for all synonyms that refer to primary key columns ) r!rrr{r0rr,rrNrT)rrr1pk_keysrrs rm _pk_synonymsMapper._pk_synonyms1 s >>>>(,(@(@A(@88(@A++++- -#??@ G# CGGSXX -  B sB2 B7B7B7cl[RRnURUR5$)zReturn a namespace of all :class:`.Synonym` properties maintained by this :class:`_orm.Mapper`. .. seealso:: :attr:`_orm.Mapper.attrs` - namespace of all :class:`.MapperProperty` objects. )r!rr_filter_propertiesrN)rrs rmsynonymsMapper.synonymsC s, >>>>&&'7'G'GHHrlcUR$rhrrs rmrMapper.entity_namespaceT s {{rlc@UR[R5$)zReturn a namespace of all :class:`.ColumnProperty` properties maintained by this :class:`_orm.Mapper`. .. seealso:: :attr:`_orm.Mapper.attrs` - namespace of all :class:`.MapperProperty` objects. )rr rRrs rm column_attrsMapper.column_attrsX s&&z'@'@AArlzsqlalchemy.orm.relationshipschUR[RRR5$)aA namespace of all :class:`.Relationship` properties maintained by this :class:`_orm.Mapper`. .. warning:: the :attr:`_orm.Mapper.relationships` accessor namespace is an instance of :class:`.OrderedProperties`. This is a dictionary-like object which includes a small number of named methods such as :meth:`.OrderedProperties.items` and :meth:`.OrderedProperties.values`. When accessing attributes dynamically, favor using the dict-access scheme, e.g. ``mapper.relationships[somename]`` over ``getattr(mapper.relationships, somename)`` to avoid name collisions. .. seealso:: :attr:`_orm.Mapper.attrs` - namespace of all :class:`.MapperProperty` objects. )rr!rorm_relationshipsrSrs rm relationshipsMapper.relationshipsf s*6&& NN , , A A  rlchUR[RRR5$)zReturn a namespace of all :class:`.Composite` properties maintained by this :class:`_orm.Mapper`. .. seealso:: :attr:`_orm.Mapper.attrs` - namespace of all :class:`.MapperProperty` objects. )rr!rrrMrs rm compositesMapper.composites s*&& NN / / A A  rlc^UR5 [R"[R"U4SjURR 5555$)Nc3T># UHup[UT5(dMX4v M g7frh)r)rgrvtype_s rmri,Mapper._filter_properties.. s$#641*Q:N#6s( ()rr!rrrr,)rrs `rmrMapper._filter_properties sL &&   #';;#4#4#6   rlc 2[URS5VVs/sH)upU[R"SU-URS94PM+ nnn[R "UVVs/sH upEXE:HPM snn6[ R"U54$s snnfs snnf)zcreate a "get clause" based on the primary key. this is used by query.get() and many-to-one lazyloads to load this item by primary key. rzpk_%dr) enumerater~r5 bindparamrand_r! column_dict)ridxr~paramsrrs rm _get_clauseMapper._get_clause s%.d.>.>$B  %C  gm;3C3CD %C   HHF3F&1qvF3 4   V $   4s 0B "B c^0mU4SjnURRH6nURcM[R"UR0SU05 M8 T$)aCreate a map of all equivalent columns, based on the determination of column pairs that are equated to one another based on inherit condition. This is designed to work with the queries that util.polymorphic_union comes up with, which often don't include the columns from the base table directly (including the subclass table columns only). The resulting structure is a dictionary of columns mapped to lists of equivalent columns, e.g.:: {tablea.col1: {tableb.col1, tablec.col1}, tablea.col2: {tabled.col2}} c>UR[R:XaURT;a)TURR UR 5 OUR 1TUR'UR T;a)TUR R UR5 gUR1TUR 'ggrh)operatorr;eqleftrxright)binaryrs rm visit_binary0Mapper._equivalent_columns..visit_binary s),,.;;&(6;;'++FLL9+1<<.F6;;'<<6)6<<(,,V[[9,2KK=F6<<(/rlr )rr+rr>traverse)rr rrs @rmrMapper._equivalent_columns sZ (* 9&&;;F''3!!,,b8\2J<  rlc[U[[R[R 45(agXR ;$rh)rr(rrPr:r\_dataclass_fields)r assigned_nameobjs rm_is_userland_descriptorMapper._is_userland_descriptor s@   ,,((    (>(>> >rlc[R"UR5Vs/sHoRPM sn$s snfrh)r!dataclass_fieldsr{rT)rfs rmrMapper._dataclass_fields s- $ 5 5dkk BC B1 BCCCs;cvUb[R"U5(agU(aWURRR US5b.UR X RRU5(agO6UR RUS5nUbUR X%5(agURb6XR;a'UbX@R;aURSU-5 gURb6XR;dUb$X@R;aURSU-5 gg)zdetermine whether a particular property should be implicitly present on the class. This occurs when properties are propagated from an inherited class, or are applied from the columns present in the mapped table. NTznot including property %szexcluding property %sF) r_never_select_columnr{rYrrrrrrr)rrTrr(r)attrs rmr-Mapper._should_exclude s*  ("?"?"G"G {{##''t"::{{33MB%%99-NDD$@$@%%  # # /33361H1H#H II1T: ;  " " . ++ +"v1H1H'H II-6 7rlc2URURL$)zPReturn true if the given mapper shares a common inherited parent as this mapper.)rrothers rm common_parentMapper.common_parent s5#4#444rlcURURL=(a3 URU5(+=(a URU5(+$)zkreturn true if the other mapper is an inheriting sibling to this one. common parent but different branch )rr<rs rm is_siblingMapper.is_sibling sC    1 1 1 $HHUO# $IIdO# rlcUR5nURcU(a[U5RU5$[U5UL$rh)primary_mapperrr%r<)rrallow_subtypesss rm_canloadMapper._canload( sF    !    *n '++A. . '1, ,rlcdUnU(aX!LaURnU(aX!LaM[U5$)z>Return True if the this mapper inherits from the given mapper.)rr)rrrs rmr< Mapper.isa1 s+$(AN AANAwrlc#R# UnU(aUv URnU(aMgg7frh)rrWs rmr Mapper.iterate_to_root9 s"#'G Aas!''c/n[U/5nU(aEUR5nURU5 URUR5 U(aME[ R "U5$)zThe collection including this mapper and all descendant mappers. This includes not just the immediately inheriting mappers but all their inheriting mappers as well. )rrrrrr!r)r descendantsrrs rmr+Mapper.self_and_descendants? s\ tf ==?D   t $ LL11 2e  --rlc,[UR5$)aIterate through the collection including this mapper and all descendant mappers. This includes not just the immediately inheriting mappers but all their inheriting mappers as well. To iterate through an entire hierarchy, use ``mapper.base_mapper.polymorphic_iterator()``. )r7r+rs rmpolymorphic_iteratorMapper.polymorphic_iteratorO sD--..rlc.URR$)zKReturn the primary mapper corresponding to this mapper's class key (class).)rrrs rmr&Mapper.primary_mapper\ s!!(((rlcBURRR$rh)rrrrs rmprimary_base_mapperMapper.primary_base_mapperb s!!((444rlcURnU(aUVs/sHoBRUPM nnUR5nUH nXe;dM g gs snfrJ)r~rkeys)rrrrrrkr}s rm_result_has_identity_keyMapper._result_has_identity_keyf sR/3/?/? 3:;7aq)7G; [[]C} # UH nTUv M g7frhrk)rgr)mappings rmri/Mapper.identity_key_from_row.. s8f'&/s)r~rrLr@rr)rrowrrrrrBs @rmidentity_key_from_rowMapper.identity_key_from_rowq sv"04/?/? 3:;7aq)7G; 3 # #llGG  88 8   [S[TURS555$)Nc3@# UHupUbU"U5OUv M g7frhrk)rgkey_fnvals rmri=Mapper._persistent_sortkey_fn..key.. s''A $*#5F3K3>'Asr)rzipr0)rkey_fnss rmr0*Mapper._persistent_sortkey_fn..key s,'*7EIIaL'Arlc URS$Nrr)rs rmr0rb syy|#rl)r~rsort_key_functionrj difference)rr}r0ras @rm_persistent_sortkey_fnMapper._persistent_sortkey_fn s\9=9I9IJ9I#88--9IJ w< " "D6 * *   $ KsAc^URVs/sHoRUPM sn$s snfrh)r~rrr}s rmr{Mapper._identity_key_props s+7;7G7GH7G&&s+7GHHHs*c|[5nURH!nURURU5 M# U$rh)rjrr*r)r collectionrs rm _all_pk_colsMapper._all_pk_cols s6-0U [[E   d007 8!rlc[UR5nURbURUR5 U$rh)rjr~rrx)rrs rm_should_undefer_in_wildcard"Mapper._should_undefer_in_wildcard s5(+D,<,<(=    * HHT(( ) rlcrURVs1sHoRURiM sn$s snfrh)rnrr0rjs rm_primary_key_propkeysMapper._primary_key_propkeys s1;?;L;LM;LC&&s+//;LMMMs"4cURUnURURRR XUS9$NrT)rrQr0rSrrrrr)rTr1s rm_get_state_attr_by_column Mapper._get_state_attr_by_column s=%%f-}}TXX&++//g/NNrlcURUnURURRR XU5 grh)rrQr0rSset_committed_valuerrrr)rr1s rm#_set_committed_state_attr_by_column*Mapper._set_committed_state_attr_by_columns5%%f- dhh$$88uMrlcURUnURURRR XUS5 grh)rrQr0rSrjr~s rm_set_state_attr_by_column Mapper._set_state_attr_by_column s7%%f- dhh$$((udCrlc[R"U5n[R"U5nURX4U[R S9$rw)rrL instance_dict#_get_committed_state_attr_by_columnr&rN)rrr)rrs rm_get_committed_attr_by_column$Mapper._get_committed_attr_by_columnsG))#.((-77 &+*A*A8  rlcURUnURURRR XUS9$rw)rrQr0rSget_committed_valuerys rmr*Mapper._get_committed_state_attr_by_columnsE%%f-}}TXX&++?? '@  rlc^^^TRn[U5RTRRR 55n[[ UVVs/sH.nX5RHn[R"USS9PM M0 snn65mTRRT;agUUU4Sjn/nSn [[TR555Hn U RT;aSn O+[U R[ R"5(d gU (dMJU R$(aM]U R&(deU R((aeU R*ceUR-U R*5 TR/U R5 M [0R2"US0SU05n XS'[6R8"U6n /n UH nU R;X5R5 M" [6R<"U 6R?U 5RA[B5$s snnf![4a gf=f)a<assemble a WHERE clause which retrieves a given state by primary key, using a minimized set of tables. Applies to a joined-table inheritance mapper where the requested attribute names are only present on joined tables, not the base table. The WHERE clause attempts to include only those tables to minimize joins. T) check_columnsNc`>URnURnUbUcgURT;awTRTTRU[ R S9nU[R;a [5e[R"SX0RRS9UlgURT;awTRTTRU[ R S9nU[R;a [5e[R"SX@RRS9Ulgg)Nrxr) rr rrrr&PASSIVE_NO_INITIALIZEr _none_set_OptGetColumnsNotAvailabler5rr)r leftcolrightcolleftvalrightvalrrrs rmr 5Mapper._optimized_get_statement..visit_binary;s kkG||H("2}}F*BBJJ'== C h000466!mm'):): v-CCJJ'== D x111466"}}(,,*;*;  .rlFrr )"rrjrwrrr;rrr rrrr}reversedr r rr:r=rrrrrrxr>cloned_traverserr5rrselectwhereset_label_stylerC)rrattribute_namespropscol_attribute_namesr0rr allcondsstartr _traversedcondrrs`` @rm_optimized_get_statementMapper._optimized_get_statements !/2?? LL % % * * , #&  32"Z//(($?/@2 #     ' '6 1 >/1 tD$8$8$:; "/2O"U5RA[B5nURDRGU 5n U Vs/sHoRDRGU5PM n nURIU RK[6RL"S SS 955RN"U 6nOi[6R>"U5RA[B5nURIU RK[6RL"S SS 955RN"U 6nXU4$s sn fs snf) zRAssemble a that can load the columns local to this subclass as a SELECT with IN. rT)_reconcile_to_other do_nothingF _orm_adaptrr primary_keys) expanding)(r!rorm_strategy_optionsrrrrjr{Loadrrxrrr0rrrr._set_generic_strategyrrr strategy_keyr~r _deep_annotateryr5tuple_is_aliased_classrrrrC_adapterr rrVrorder_by)rrrstrategy_optionspolymorphic_prop keep_props disable_opt enable_optclasses_to_includerr1pkr~in_exprqrs rm_subclass_load_via_inMapper._subclass_load_via_ins2 >>>>}}}    *#55d6I6IJ ./$2J2JJKJT556J&++F3 %**62 "V#'== M)""j0  " "1 % A M)""j0 %%(:(::Dxxt111{{00D4F"$(;<<'==V44dhh?A**+(, > *??V44dhh?A!4((- @ 3;H&& &  # #Bt(< =&   { a jj+.G!!nG  " "==D( (( 6"22.Aoo..w7G@KL 1??33A6 KL CMM.DIJh#%A 4 00.A CMM.DIJh#%Ak))A (Ms .#M9%$M>c8URXR5$rh)rrrs rm_subclass_load_via_in_mapper#Mapper._subclass_load_via_in_mapperFs))$0@0@AArlc ## [5n[5[5peURRU5(de[ [ URR R 55XRUR4/5nU(aUSuppU(dUR5 M(XLavUR5n U R(aXR;aM^U ceU ce[ U RUU U UU55n U (aURXSS45 OWXLaSUR5unnnnUUUU4v UR[ UR R 55UUU45 U(aMgg7f)aIterate each element and its mapper in an object graph, for all relationships that meet the given cascade rule. :param type\_: The name of the cascade rule (i.e. ``"save-update"``, ``"delete"``, etc.). .. note:: the ``"all"`` cascade is not accepted here. For a generic object traversal function, see :ref:`faq_walk_objects`. :param state: The lead InstanceState. child items will be processed per the relationships defined for this object's mapper. :return: the method yields individual object instances. .. seealso:: :ref:`unitofwork_cascades` :ref:`faq_walk_objects` - illustrates a generic function to traverse all objects without relying on cascades. rN) rjobjectrr<rrrrrZrrcascade_iteratorr)rrrhalt_onvisited_statesprpmpp visitablesiterator item_type parent_state parent_dictr1queuerOinstance_mappercorresponding_statecorresponding_dicts rmrMapper.cascade_iteratorKs@36%8VXS||%%%%ELL''..013uzz J K =G^ :H '')||uLL'@#///"...))$#& %%u4&>?! $$& #'&#'&  !!o44;;=>+* Ijs FF F cB[R"UR5$rh)r!LRUCacherrs rm_compiled_cacheMapper._compiled_caches}}T6677rlc2[UR5S:$rd)ryrrs rm_multiple_persistence_tables#Mapper._multiple_persistence_tabless4;;!##rlc^ 0m URRH'nURHnT RX!5 M M) /nT R 5HGupAUR nU(dMUR URVs/sHofU4PM sn5 MI U 4Sjn[R"T UUS9n[R"5n UH nT UX'M U $s snf)Nc>TRURR5nTRURR5nUbUbX!LaURb[ [ R"UR55nURbTUR[ R"UR55nURU;=(a URU;$URU;$grh) rrrr)rrjr  _find_columnsrP)fkrdeprtable_to_mappers rmskip#Mapper._sorted_tables..skips %((9F!%%biioo6C"O%))5811#2G2GHI++7:: ..v/G/GHD99D0JRYYd5JJ99D00rl)skip_fnextra_dependencies) rr+r setdefaultr,rrr  sort_tablesr!r) rrrhrrsuper_ super_tablersorted_retrs @rm_sorted_tablesMapper._sorted_tabless:<&&;;F]]**15#< ,224ME__Fv"))=C]]K]k5)]K5 0&& 1   A$Q'CF ILs C% cXR;a[[URU5$U"5=URU'nU$rh)rr r_)rr0 callable_rs rm_memo Mapper._memosB '' 'D11#67 71: .set_unions771: rl) r! defaultdictr rrjrr rrwrrtr)rrrrrrrrs rm_table_to_equatedMapper._table_to_equateds   T "  ((EuwwrrrrrrrrXrrrrrrrrrr|rWrrrrrrrrrrr{rrrrrrrrrrrrrr}rzrrrrrrrrr~rKrrrrrrr)NNNFNNNFNNNNNFNFNTTNNNTFTrFd):r{r|r}Optional[FromClause]r z+Optional[Mapping[str, MapperProperty[Any]]]r~z/Optional[Iterable[_ORMColumnExprArgument[Any]]]rzrrz'Optional[Union[Mapper[Any], Type[Any]]]rz)Optional[_ColumnExpressionArgument[bool]]rz/Optional[Sequence[_ORMColumnExprArgument[Any]]]rrrz%Optional[_ORMColumnExprArgument[Any]]rrrzFOptional[Union[_ORMColumnExprArgument[Any], str, MapperProperty[Any]]]rz Optional[Dict[Any, Mapper[Any]]]rrrrrOptional[_WithPolymorphicArg]rrrz'Optional[Literal['selectin', 'inline']]rrrrrrrOptional[Sequence[str]]rrrrrrrrrzLiteral[True, False, 'auto']rrrint)return Mapper[_O])rrQ)rrrNonerr)rr!r0r!rz Column[Any])F) r0r!rz3Union[KeyedColumnElement[Any], MapperProperty[Any]]r:rrrrrrrb)r0r!r)zAUnion[Sequence[KeyedColumnElement[Any]], KeyedColumnElement[Any]]rColumnProperty[Any])NN) r0r!rrbrrrzOptional[ColumnProperty[Any]]rrrr)r0r!r)zKeyedColumnElement[Any]rr)r0r!r1z'Union[Column[Any], MapperProperty[Any]]rr)rr!)rr!rrrr)rInstanceState[_O]rr)r0r!rr)r0r!r0rrrb)r)zColumnElement[_T]rzMapperProperty[_T])r=rr>rrSequence[Mapper[Any]])r?zIterable[Mapper[Any]]rErrr])rr)rr)rr])rz+Mapping[FromClause, FrozenSet[Column[Any]]])rz#Mapping[FromClause, FrozenSet[str]])rzSet[str])NFF)r=rr>z'Union[Literal[False, None], FromClause]rErrz(Tuple[Sequence[Mapper[Any]], FromClause])rk)rzOptional[orm_util.ORMAdapter]rh)rz,util.ReadOnlyProperties[MapperProperty[Any]])rz'util.ReadOnlyProperties[InspectionAttr])rzDict[str, str])rz-util.ReadOnlyProperties[SynonymProperty[Any]])rz,util.ReadOnlyProperties[ColumnProperty[Any]])rz2util.ReadOnlyProperties[RelationshipProperty[Any]])rz/util.ReadOnlyProperties[CompositeProperty[Any]])rz Type[_MP]rzutil.ReadOnlyProperties[_MP])rrY)rr!rrrr)rrerr)rzInstanceState[Any]r'rrrrzIterator[Mapper[Any]])rre)rDzUnion[Row[Any], RowMapping]rrrzOptional[ORMAdapter]r_IdentityKeyType[_O])r~Tuple[Any, ...]rrrr)rOr"rr)rrrTr&rr)rOr"rr) rrrrHr)ColumnElement[Any]rTr&rr)rr!rrrz.Optional[Callable[[InstanceState[Any]], bool]]rzGIterator[Tuple[object, Mapper[Any], InstanceState[Any], _InstanceDict]])r0rrzCallable[[], _T]rr_)rr __qualname____firstlineno____doc____annotations__rXrxrWr!deprecated_paramsrrr is_mapperrepresents_outer_joinpropertyrrrnon_memoized_property deprecatedrmemoized_propertyrrrrr2r5rr[rcrrrrrDmemoized_attributerrrpreload_moduler.rrrr langhelperstag_method_for_warningsr SAWarningrrrrrrrrrr!r*r-r1r4r8rArGrPrXr\r_rbrerEriwith_polymorphic_mappersrrrxr|rrrrrrrmemoized_instancemethodrrr>rrrrrrrrrrrrrrrrrrrr-r r#r)r<r r+r3r&r8r=rErHrPr&PASSIVE_RETURN_NO_VALUErMrXrgr{rnrqrtrzrrrrrrrrrrrrrrrrr __static_attributes__rkrlrmrurusR %$O"s"    -1BFGK!<@GK $@D  =A.2:>%*DH"&'+6:6: $ %%)7=!&$'I^ B^ B*^ B@ ^ B E ^ B  ^ B:^ BE^ B ^ B^ B>^ B ^ B" #^ B(;)^ B*,+^ B,-^ B.8/^ B0#1^ B2B3^ B4 5^ B67^ B8%9^ B:4;^ B<4=^ B>?^ B@A^ BB#C^ BD5E^ BFG^ BH"I^ B ^ B@ ' I%!  A00552277!!((BBDD 6644%%LL% "! DC00PO0#"2$# 54J N)(.$# L65 ,+ ('  87 214  __U56'7 ' --}~%( =%( %(NA61[z5.} ~rhD2L&*"##$ ## $ ##/$/ :;<8 :; "'h hFh  h  h h h<hT9 9 9  9H8<;? @ @+@ @ 5 @ 9 @ @D :;" "("  "<"H --    A  A.***E* *")    CDI  ("49,0 ".'. .** ""%9" "H,9= :##$"## $ ##  $  ##. $. `##?$?##  $  ' '  9 ' ' ##  $  ## $ ## $ ## $ ## 4 $ $## 4 $ $## $ ## , $ ##$ (( ) .    1 1>C NN<N N 2 N0## $       ## $ 8###4$#4J##C $C J## :; <$ ## :; I<$ I## B$ B## 78 ; 9$ :## :;  <$    % ## $ $##"$"H ?##D$D,\5  -'-9=- - ## .$ . /) 55 )-(,  ( & &    H)- $ &    "M& +BB       $ ##$$##I$I##$ ##$ ##N$N +BB O OO# O  O OND -8,O,O d L ##$6p, :;_*<_*B##B$BCG __!_@ _   _B##8$8##$$$##0$0d rlrurc\rSrSrSrg)rirkN)rrrrr0rkrlrmrrsrlrc([[5SS9 g)a Initialize the inter-mapper relationships of all mappers that have been constructed thus far across all :class:`_orm.registry` collections. The configure step is used to reconcile and initialize the :func:`_orm.relationship` linkages between mapped classes, as well as to invoke configuration events such as the :meth:`_orm.MapperEvents.before_configured` and :meth:`_orm.MapperEvents.after_configured`, which may be used by ORM extensions or user-defined extension hooks. Mapper configuration is normally invoked automatically, the first time mappings from a particular :class:`_orm.registry` are used, as well as whenever mappings are used and additional not-yet-configured mappers have been constructed. The automatic configuration process however is local only to the :class:`_orm.registry` involving the target mapper and any related :class:`_orm.registry` objects which it may depend on; this is equivalent to invoking the :meth:`_orm.registry.configure` method on a particular :class:`_orm.registry`. By contrast, the :func:`_orm.configure_mappers` function will invoke the configuration process on all :class:`_orm.registry` objects that exist in memory, and may be useful for scenarios where many individual :class:`_orm.registry` objects that are nonetheless interrelated are in use. .. versionchanged:: 1.4 As of SQLAlchemy 1.4.0b2, this function works on a per-:class:`_orm.registry` basis, locating all :class:`_orm.registry` objects present and invoking the :meth:`_orm.registry.configure` method on each. The :meth:`_orm.registry.configure` method may be preferred to limit the configuration of mappers to those local to a particular :class:`_orm.registry` and/or declarative base class. Points at which automatic configuration is invoked include when a mapped class is instantiated into an instance, as well as when ORM queries are emitted using :meth:`.Session.query` or :meth:`_orm.Session.execute` with an ORM-enabled statement. The mapper configure process, whether invoked by :func:`_orm.configure_mappers` or from :meth:`_orm.registry.configure`, provides several event hooks that can be used to augment the mapper configuration step. These hooks include: * :meth:`.MapperEvents.before_configured` - called once before :func:`.configure_mappers` or :meth:`_orm.registry.configure` does any work; this can be used to establish additional options, properties, or related mappings before the operation proceeds. * :meth:`.MapperEvents.mapper_configured` - called as each individual :class:`_orm.Mapper` is configured within the process; will include all mapper state except for backrefs set up by other mappers that are still to be configured. * :meth:`.MapperEvents.after_configured` - called once after :func:`.configure_mappers` or :meth:`_orm.registry.configure` is complete; at this stage, all :class:`_orm.Mapper` objects that fall within the scope of the configuration operation will be fully configured. Note that the calling application may still have other mappings that haven't been produced yet, such as if they are in modules as yet unimported, and may also have mappings that are still to be configured, if they are in other :class:`_orm.registry` collections not part of the current scope of configuration. TrN)rrnrkrlrmconfigure_mappersr3sH/+T:rlcUHnUR(dM O g[ [(a SSS5 gSqUHnUR(dM O SqSSS5 g[RR [5R 5 [X5 SqSSS5 [RR [5R5 g!Sqf=f!,(df  NG=f)NTF) rri_already_compilingrurw _for_classbefore_configured_do_configure_registriesafter_configured) registriesrrqs rmrrZs            " '!###""' +   OO & &v . @ @ B %Z 9!& + , OOv&779"' +  s9 C%C%CCC%%//1F Moo>> "6== 9  H,#H ? (v2E::.. v77 9'-&>&>#$$$557//1OO55fmmL52@$C w3,,77==,,/ O?<!,,.+C"3(;<<360 s AF"";Gc[RRRn[ U5nUR "U5GHnU(d6UR RU5(a[R"S5eUR(aAURR5upVURU5 UR(aMAURR5 UR R5 UR HnUR R#U5 M UR R5 SUlGM g![a Nf=f)Nz^Registry has dependent registries that are not disposed; pass cascade=True to clear these alsoF)r!rr<rKrj_recurse_with_dependents _dependentsrfrrC _managerspopitem_dispose_manager_and_mapperr^_non_primary_mappersclearrCdiscardr)r:rrKrDrqrQ_rs rm_dispose_registriesrRs~~**33H z?D00<3??55d;;,,8  mm 9 ]]224  //8mmm   &&( $$C OO # #C (% ! !3=  sE E+*E+cSUlU$)auDecorate a method as the 'reconstructor' hook. Designates a single method as the "reconstructor", an ``__init__``-like method that will be called by the ORM after the instance has been loaded from the database or otherwise reconstituted. .. tip:: The :func:`_orm.reconstructor` decorator makes use of the :meth:`_orm.InstanceEvents.load` event hook, which can be used directly. The reconstructor will be invoked with no arguments. Scalar (non-collection) database-mapped attributes of the instance will be available for use within the function. Eagerly-loaded collections are generally not yet available and will usually only contain the first element. ORM state changes made to objects at this stage will not be recorded for the next flush() operation, so the activity within a reconstructor should be conservative. .. seealso:: :meth:`.InstanceEvents.load` T)r>)rGs rm reconstructorrTs4#B IrlTinclude_removesinclude_backrefsc ^^^SUUU4SjjnU$)a!Decorate a method as a 'validator' for one or more named properties. Designates a method as a validator, a method which receives the name of the attribute as well as a value to be assigned, or in the case of a collection, the value to be added to the collection. The function can then raise validation exceptions to halt the process from continuing (where Python's built-in ``ValueError`` and ``AssertionError`` exceptions are reasonable choices), or can modify or replace the value before proceeding. The function should otherwise return the given value. Note that a validator for a collection **cannot** issue a load of that collection within the validation routine - this usage raises an assertion to avoid recursion overflows. This is a reentrant condition which is not supported. :param \*names: list of attribute names to be validated. :param include_removes: if True, "remove" events will be sent as well - the validation function must accept an additional argument "is_remove" which will be a boolean. :param include_backrefs: defaults to ``True``; if ``False``, the validation function will not emit if the originator is an attribute event related via a backref. This can be used for bi-directional :func:`.validates` usage where only one validator should emit per attribute operation. .. versionchanged:: 2.0.16 This paramter inadvertently defaulted to ``False`` for releases 2.0.0 through 2.0.15. Its correct default of ``True`` is restored in 2.0.16. .. seealso:: :ref:`simple_validators` - usage examples for :func:`.validates` c*>TUlTTS.UlU$)NrU)r@rO)rGrWrVnamess rmwrapvalidates..wraps"$. 0% ! rlrGrcrrcrk)rVrWrZr[s``` rm validatesr^sP KrlcURRnUR(a URUR55 ggrh)rQrrr)rctxinstrumenting_mappers rmrNrN$s4 ==//**++EIIK8+rlcURRnU(a4UR5 UR(aURU5 ggg)zRun init_instance hooks. This also includes mapper compilation, normally not needed here but helps with some piecemeal configuration scenarios (such as in the ORM tutorial). N)rQrrr)rrkwargsras rmrJrJ+sD!==//--/  9 9 : :5 A :rlc(\rSrSrSrSrSrSrSrg)ri;z4Error reporting helper for mapper._columntoproperty.rcXlgrhrer s rmr_ColumnMapping.__init__@s rlc HURRRU5nU(aN[R"SUR R <SUR <SUR<SU<35e[R"SU<SUR<S35e)NzColumn 'rz1' is not available, due to conflicting property 'z':z No column z is configured on mapper z...)rrrorm_excUnmappedColumnErrorrrTr0)rr)r1s rm __missing___ColumnMapping.__missing__Dsx{{!!%%f- --<<$$fkk6::tE  ))t{{ $  rlN) rrrrr __slots__rrkr0rkrlrmrr;s>I  rlr)rrb)rz Set[registry]rr)r:zSet[_RegistryType]rrrrr])rZr!rVrrWrrzCallable[[_Fn], _Fn])r __future__r collectionsr functoolsr itertoolsrrA threadingtypingrrr r r r r rrrrrrrrrrrrrweakrefrrrrirrr r!r_typingr"r8r#r$r%r&r' interfacesr(r)r*r+r,r-r. path_registryr/r1rr2r3r4r5r6r7rr9r:r;r<r=r r> sql.cache_keyr? sql.elementsr@ sql.schemarArBsql.selectablerCrDrE util.typingrFrGrHrIrJdecl_apirK dependencyrLrrMrNeventsrOrPrQrRrrSrrTrUenginerVrW sql._typingrXrYsql.baserZr[r\r]r^r_rarc_WithPolymorphicArgWeakKeyDictionaryrfr rnrrr5symbolrsRLockri_self_inspects class_logger Identified Inspectablerur@rr3rr)r8rRrTr^rNrJrrkrlrmrsI#  "(( &&2)+'""/-;4!)&/&"/31$-4*3$ #723+,+! T e01 e/0 CL  gclHU=$s)+C%DEEF  U=$s)+ ,- / B ' /  {{>* ??$ h=r"NN<( BKh=h=V{  D;N:":-1: :D./1"1-11 101h./!0!B>*/0 0"&0BF00f9 B  TEF rl