,h-'NSrSSKJr SSKrSSKJr SSKJr SSKJr SSKJ r SSK J r SS K J r SS K J r 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 SSKJr SSKJr SSKJr SSKJr SSKJr SSKJ r SSKJ!r! SSKJ"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.J/r/ \(a6SS'K0J1r1 SS(K0J2r2 SS)K0J3r3 SS*K0J4r4 SS+K0J5r5 SS,K0J6r6 SS-K0J7r7 SS.K0J8r8 SS/K0J9r9 \"S05r:\ RvS=S1j5r<S>S2jr=\ "S3S4\55r>\ "S5S6\55r?\R"S7S8\RS855rB\/"S9S:55rC\"S;S<55rDg)?aProvides an abstraction for obtaining database schema information. Usage Notes: Here are some general conventions when accessing the low level inspector methods such as get_table_names, get_columns, etc. 1. Inspector methods return lists of dicts in most cases for the following reasons: * They're both standard types that can be serialized. * Using a dict instead of a tuple allows easy expansion of attributes. * Using a list for the outer structure maintains order and is easy to work with (e.g. list comprehension [d['name'] for d in cols]). 2. Records that contain a name, such as the column name in a column record use the key 'name'. So for most return values, each record will have a 'name' attribute.. ) annotationsN) dataclass)auto)Flag)unique)Any)Callable) Collection)Dict) Generator)Iterable)List)Optional)Sequence)Set)Tuple) TYPE_CHECKING)TypeVar)Union) Connection)Engine)exc) inspection)sql)util) operators)schema)_ad_hoc_cache_key_from_args) quoted_name) TextClause) TypeEngine)InternalTraversal) topological)final)Dialect)ReflectedCheckConstraint)ReflectedColumn)ReflectedForeignKeyConstraint)ReflectedIndex)ReflectedPrimaryKeyConstraint)ReflectedTableComment)ReflectedUniqueConstraint)TableKey_Rc^URSS5nUc U"X/UQ70UD6$SS1mUR[SU55[U4SjUR5554nURU5nUcU"X/UQ70UD6nXuU'U$)N info_cache unreflectablec3# UHJn[U[5(dM[U[5(a[U5UR4OUv ML g7fN) isinstancestrr!quote).0as T/var/www/auris/envauris/lib/python3.13/site-packages/sqlalchemy/engine/reflection.py cache..]sB !S! CA{!;!;SVQWW  Bs A5Ac3># UH?upUT;dM U[U[5(a[U5UR4OU4v MA g7fr5)r6r!r7r8)r9kvexcludes r;r<r=bsE " HQZ;%?%?Q!Q G"s A 7A )get__name__tupleitems) fnselfconargskwr2keyretrAs @r;cacherMOs d+J$)d)b))_-G          CnnS!C {(T(R(3 JcV^[RSU4Sjj5nU$)Nc>URSS5nUc U"X/UQ70UD6$[UR4TU5nURU5nUcU"X/UQ70UD6nXuU'U$)Nr2)rBr rC) rFrGrHrIrJr2rKrL traverse_argss r;goflexi_cache..gorswVVL$/  d-$-"- -)2;;.-N..% ;T,,,C!sO rN rFzCallable[..., _R]rGr'rHrrIrrJrreturnr0)r decorator)rQrRs` r; flexi_cacherWosZ ^^     " IrNcd\rSrSrSr\"5r\"5r\"5r\\-r \\-\-r Sr g) ObjectKindaEnumerator that indicates which kind of object to return when calling the ``get_multi`` methods. This is a Flag enum, so custom combinations can be passed. For example, to reflect tables and plain views ``ObjectKind.TABLE | ObjectKind.VIEW`` may be used. .. note:: Not all dialect may support all kind of object. If a dialect does not support a particular object an empty dict is returned. In case a dialect supports an object, but the requested method is not applicable for the specified kind the default value will be returned for each reflected object. For example reflecting check constraints of view return a dict with all the views with empty lists as values. N) rC __module__ __qualname____firstlineno____doc__rTABLEVIEWMATERIALIZED_VIEWANY_VIEWANY__static_attributes__r[rNr;rYrYsH" FE 6D &''H& $,* *C!rNrYcB\rSrSrSr\"5r\"5r\\-rSr g) ObjectScopezUEnumerator that indicates which scope to use when calling the ``get_multi`` methods. r[N) rCr\r]r^r_rDEFAULT TEMPORARYrdrer[rNr;rgrgs*fGI I C)rNrgc\rSrSr%SrS\S'S\S'S\S'S \S 'S \S '\R"S S5SHSj5r\ SISj5r SJSjr SKSjr SLSjr SMSjr\ \R"S S5SNSj55r\R""\5SNSj5r\R""\5SOSj5r\R.SPSj5r\R.SQSj5r\SRSj5rSSSjrS$STSjjrS$SUSjjrS$SVS jjrS$SWS!jjr SXS"jr!S$SYS#jjr"SZS[S%jjr#SSS&jr$SSS'jr%S$S\S(jjr&SS\'RP\)RT4S]S)jjr+S$STS*jjr,S$STS+jjr-S$STS,jjr.S$S^S-jjr/S$S_S.jjr0S`S/jr1SS\'RP\)RT4SaS0jjr2S$SbS1jjr3SS\'RP\)RT4ScS2jjr4S$SdS3jjr5SS\'RP\)RT4SeS4jjr6S$SfS5jjr7SS\'RP\)RT4SgS6jjr8S$ShS7jjr9SS\'RP\)RT4SiS8jjr:S$SjS9jjr;SS\'RP\)RT4SkS:jjr<S$SlS;jjr=SS\'RP\)RT4SmS<jjr>SnSoS=jjr?SpS>jr@SqS?jrASrS@jrB\CR\CR\CR\CRSA.rHSsSBjrISsSCjrJSsSDjrKStSEjrLSuSvSFjjrMSGrNg)w InspectoraPerforms database schema inspection. The Inspector acts as a proxy to the reflection methods of the :class:`~sqlalchemy.engine.interfaces.Dialect`, providing a consistent interface as well as caching support for previously fetched metadata. A :class:`_reflection.Inspector` object is usually created via the :func:`_sa.inspect` function, which may be passed an :class:`_engine.Engine` or a :class:`_engine.Connection`:: from sqlalchemy import inspect, create_engine engine = create_engine("...") insp = inspect(engine) Where above, the :class:`~sqlalchemy.engine.interfaces.Dialect` associated with the engine may opt to return an :class:`_reflection.Inspector` subclass that provides additional methods specific to the dialect's target database. Union[Engine, Connection]bindrenginebool_op_context_requires_connectr'dialectzDict[Any, Any]r2z1.4aThe __init__() method on :class:`_reflection.Inspector` is deprecated and will be removed in a future release. Please use the :func:`.sqlalchemy.inspect` function on an :class:`_engine.Engine` or :class:`_engine.Connection` in order to acquire an :class:`_reflection.Inspector`.c&URU5 g)aRInitialize a new :class:`_reflection.Inspector`. :param bind: a :class:`~sqlalchemy.engine.Connection`, which is typically an instance of :class:`~sqlalchemy.engine.Engine` or :class:`~sqlalchemy.engine.Connection`. For a dialect-specific instance of :class:`_reflection.Inspector`, see :meth:`_reflection.Inspector.from_engine` N) _init_legacyrGros r;__init__Inspector.__init__s. $rNc[URS5(aURRnURU5nU"X25 U$)N inspector)hasattrrsrz__new__)clsinitrorGs r; _constructInspector._constructs? 4<< - -,,((C{{3 T rNcl[US5(aURU5 gURU5 g)Nexec_driver_sql)r{_init_connection _init_enginervs r;ruInspector._init_legacys, 4* + +  ! !$ '   d #rNcU=UlUlUR5R5 SUlURR Ul0Ulg)NT)rorpconnectcloserrrsr2)rGrps r;rInspector._init_enginesC"(( DK ,0){{** rNcXlURUlSUlURRUl0Ulg)NF)rorprrrsr2)rG connections r;rInspector._init_connections4  '' ,1){{** rNc8URR5 g)zreset the cache for this :class:`.Inspector`. Inspection methods that have data cached will emit SQL queries when next called to get new data. .. versionadded:: 2.0 N)r2clearrGs r; clear_cacheInspector.clear_cache s rNaThe from_engine() method on :class:`_reflection.Inspector` is deprecated and will be removed in a future release. Please use the :func:`.sqlalchemy.inspect` function on an :class:`_engine.Engine` or :class:`_engine.Connection` in order to acquire an :class:`_reflection.Inspector`.c:URURU5$)aConstruct a new dialect-specific Inspector object from the given engine or connection. :param bind: a :class:`~sqlalchemy.engine.Connection` or :class:`~sqlalchemy.engine.Engine`. This method differs from direct a direct constructor call of :class:`_reflection.Inspector` in that the :class:`~sqlalchemy.engine.interfaces.Dialect` is given a chance to provide a dialect-specific :class:`_reflection.Inspector` instance, which may provide additional methods. See the example at :class:`_reflection.Inspector`. )rru)r}ros r; from_engineInspector.from_engines:~~c..55rNcJ[R[RU5$r5)rlrrros r; _engine_inspInspector._engine_insp7s##I$:$:DAArNcJ[R[RU5$r5)rlrrrs r;_connection_inspInspector._connection_insp;s##I$>$>EErNc## UR(aURR5nO URnUv UR(aUR5 gg!UR(aUR5 ff=f7f)zReturn a context that optimizes for multiple operations on a single transaction. This essentially allows connect()/close() to be called if we detected that we're against an :class:`_engine.Engine` and not a :class:`_engine.Connection`. N)rrrorr)rGconns r;_operation_contextInspector._operation_context?sc  , ,99$$&D99D J00 1t00 1s9B A##B #$BB c## UR5nURURRU5nURUlUv SSS5 g!,(df  g=f7f)zmReturn an :class:`_reflection.Inspector` from this one that will run all operations on a single connection. N)rr __class__rr2)rGrsub_insps r;_inspection_contextInspector._inspection_contextTsK $ $ &$t~~'F'FMH"&//H N' & &sA)' & &rc UR5nURR"XAU4SUR0UD6sSSS5 $!,(df  g=f)aReturn True if the backend has a table, view, or temporary table of the given name. :param table_name: name of the table to check :param schema: schema name to query, if not the default schema. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. .. versionadded:: 1.4 - the :meth:`.Inspector.has_table` method replaces the :meth:`_engine.Engine.has_table` method. .. versionchanged:: 2.0:: :meth:`.Inspector.has_table` now formally supports checking for additional table-like objects: * any type of views (plain or materialized) * temporary tables of any kind Previously, these two checks were not formally specified and different dialects would vary in their behavior. The dialect testing suite now includes tests for all of these object types and should be supported by all SQLAlchemy-included dialects. Support among third party dialects may be lagging, however. r2N)rrs has_tabler2rG table_namerrJrs r;rInspector.has_tablesI8 $ $ &$<<))&59__HJ' & & *A Ac UR5nURR"XAU4SUR0UD6sSSS5 $!,(df  g=f)ajReturn True if the backend has a sequence with the given name. :param sequence_name: name of the sequence to check :param schema: schema name to query, if not the default schema. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. .. versionadded:: 1.4 r2N)rrs has_sequencer2)rG sequence_namerrJrs r;rInspector.has_sequencesI $ $ &$<<,,V8<KM' & &rc UR5nURR"UUUU4SUR0UD6sSSS5 $!,(df  g=f)aCheck the existence of a particular index name in the database. :param table_name: the name of the table the index belongs to :param index_name: the name of the index to check :param schema: schema name to query, if not the default schema. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. .. versionadded:: 2.0 r2N)rrs has_indexr2)rGr index_namerrJrs r;rInspector.has_indexsT& $ $ &$<<))   ??   ' & &s ,A Ac UR5nURR"X14SUR0UD6sSSS5 $!,(df  g=f)a$Return True if the backend has a schema with the given name. :param schema_name: name of the schema to check :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. .. versionadded:: 2.0 r2N)rrs has_schemar2)rG schema_namerJrs r;rInspector.has_schemasG $ $ &$<<**.2ooAC' & &rc URU4S9VVVVVs/sH1unnU(aUSOSUVVVs/sH uupVovU4PM snnn4PM3 snnnnn$s snnnfs snnnnnf)aReturn dependency-sorted table and foreign key constraint names in referred to within a particular schema. This will yield 2-tuples of ``(tablename, [(tname, fkname), (tname, fkname), ...])`` consisting of table names in CREATE order grouped with the foreign key constraint names that are not detected as belonging to a cycle. The final element will be ``(None, [(tname, fkname), (tname, fkname), ..])`` which will consist of remaining foreign key constraint names that would require a separate CREATE step after-the-fact, based on dependencies between tables. :param schema: schema name to query, if not the default schema. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. .. seealso:: :meth:`_reflection.Inspector.get_table_names` :func:`.sort_tables_and_constraints` - similar method which works with an already-given :class:`_schema.MetaData`. )consider_schemasrN)%sort_tables_on_foreign_key_dependency)rGrrJ table_key fk_collection_tnamefkss r;get_sorted_table_and_fkc_names(Inspector.get_sorted_table_and_fkc_namessyP;;"(<   !* ! t5BC]/*1c]C   D  sA A A A r5c ^[[[[4n[5n[5n0n/nUHnUR"U40UD6n UR U 5 U R 5HXuupn U V s1sHoSiM sn XhU 4'U H1nXS:wd XS:wdMURUSUS4X445 M3 MZ M [[R"XG55nUVV V s/sH8upX4XhU 4R!SU55V s/sHn X4U 4PM sn 4PM: nn nn US[U54/-$s sn f![RannURH5mURT5 URU4SjUTS55 M7 [[R"XG55nSnANSnAff=fs sn fs sn n nf)aReturn dependency-sorted table and foreign key constraint names referred to within multiple schemas. This method may be compared to :meth:`.Inspector.get_sorted_table_and_fkc_names`, which works on one schema at a time; here, the method is a generalization that will consider multiple schemas at once including that it will resolve for cross-schema foreign keys. .. versionadded:: 2.0 namereferred_tablereferred_schemac32># UH nTSU4v M g7f)rNr[)r9fkcedges r;r<BInspector.sort_tables_on_foreign_key_dependency..`s&.HsT!WcN.HsrNc3*# UH upUv M g7fr5r[)r9rrs r;r<rmsM,:Ns)rrr7setget_multi_foreign_keysextendrEaddlistr%sortrCircularDependencyErroredgesremoveupdate difference)rGrrJ SchemaTabtuplesremaining_fkcsfknames_for_tabletnamesschname schema_fkeysrrfkeysfkfkeycandidate_sorterrrLrs @r;r/Inspector.sort_tables_on_foreign_key_dependency(s,(3-,- 365?BuAC"$'G66wE"EL MM, '%1%7%7%9! E).7).2vJ7!E"23"D&6!77"+<&== %)):$;$()9$:!"") 0  " &:(* D!+"2"26"BCN.%3  %3  0%0@ALLM,:M%r* %3  tT.12333W7&** D  d#%%&.?Q.H&" "+"2"26"BCN D  s79EE 3(GG*G G A$G  GGc UR5nURR"U4SUR0UD6sSSS5 $!,(df  g=f)aPReturn a list of temporary table names for the current bind. This method is unsupported by most dialects; currently only Oracle Database, PostgreSQL and SQLite implements it. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. r2N)rrsget_temp_table_namesr2rs r;rInspector.get_temp_table_namesvsG $ $ &$<<44!%46' & &rc UR5nURR"U4SUR0UD6sSSS5 $!,(df  g=f)a>Return a list of temporary view names for the current bind. This method is unsupported by most dialects; currently only PostgreSQL and SQLite implements it. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. r2N)rrsget_temp_view_namesr2rs r;rInspector.get_temp_view_namessG $ $ &$<<33!%46' & &rc UR5nURR"XAU4SUR0UD6sSSS5 $!,(df  g=f)aReturn a dictionary of options specified when the table of the given name was created. This currently includes some options that apply to MySQL and Oracle Database tables. :param table_name: string name of the table. For special quoting, use :class:`.quoted_name`. :param schema: string schema name; if omitted, uses the default schema of the database connection. For special quoting, use :class:`.quoted_name`. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. :return: a dict with the table options. The returned keys depend on the dialect in use. Each one is prefixed with the dialect name. .. seealso:: :meth:`Inspector.get_multi_table_options` r2N)rrsget_table_optionsr2rs r;rInspector.get_table_optionssI4 $ $ &$<<11&59__HJ' & &rc UR5nURR"U4UUUUURS.UD6n[ U5sSSS5 $!,(df  g=f)aReturn a dictionary of options specified when the tables in the given schema were created. The tables can be filtered by passing the names to use to ``filter_names``. This currently includes some options that apply to MySQL and Oracle tables. :param schema: string schema name; if omitted, uses the default schema of the database connection. For special quoting, use :class:`.quoted_name`. :param filter_names: optionally return information only for the objects listed here. :param kind: a :class:`.ObjectKind` that specifies the type of objects to reflect. Defaults to ``ObjectKind.TABLE``. :param scope: a :class:`.ObjectScope` that specifies if options of default, temporary or any tables should be reflected. Defaults to ``ObjectScope.DEFAULT``. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. :return: a dictionary where the keys are two-tuple schema,table-name and the values are dictionaries with the table options. The returned keys in each dict depend on the dialect in use. Each one is prefixed with the dialect name. The schema is ``None`` if no schema is provided. .. versionadded:: 2.0 .. seealso:: :meth:`Inspector.get_table_options` r filter_nameskindscoper2N)rrsget_multi_table_optionsr2dict)rGrrrrrJrress r;r!Inspector.get_multi_table_optionssaZ $ $ &$,,66)?? C9' & &s 8A A!c UR5nURR"X14SUR0UD6sSSS5 $!,(df  g=f)aReturn all non-materialized view names in `schema`. :param schema: Optional, retrieve names from a non-default schema. For special quoting, use :class:`.quoted_name`. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. .. versionchanged:: 2.0 For those dialects that previously included the names of materialized views in this list (currently PostgreSQL), this method no longer returns the names of materialized views. the :meth:`.Inspector.get_materialized_view_names` method should be used instead. .. seealso:: :meth:`.Inspector.get_materialized_view_names` r2N)rrsget_view_namesr2rs r;rInspector.get_view_namessG0 $ $ &$<<..)-<>' & &rc UR5nURR"X14SUR0UD6sSSS5 $!,(df  g=f)aReturn all materialized view names in `schema`. :param schema: Optional, retrieve names from a non-default schema. For special quoting, use :class:`.quoted_name`. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. .. versionadded:: 2.0 .. seealso:: :meth:`.Inspector.get_view_names` r2N)rrsget_materialized_view_namesr2rs r;r%Inspector.get_materialized_view_names sG& $ $ &$<<;;)-<>' & &rc UR5nURR"X14SUR0UD6sSSS5 $!,(df  g=f)a;Return all sequence names in `schema`. :param schema: Optional, retrieve names from a non-default schema. For special quoting, use :class:`.quoted_name`. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. r2N)rrsget_sequence_namesr2rs r;rInspector.get_sequence_names$sG $ $ &$<<22)-<>' & &rc UR5nURR"XAU4SUR0UD6sSSS5 $!,(df  g=f)aReturn definition for the plain or materialized view called ``view_name``. :param view_name: Name of the view. :param schema: Optional, retrieve names from a non-default schema. For special quoting, use :class:`.quoted_name`. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. r2N)rrsget_view_definitionr2)rG view_namerrJrs r;r Inspector.get_view_definition6sI $ $ &$<<3348OOGI' & &rc UR5nURR"XAU4SUR0UD6nSSS5 W(aUR U/5 U$!,(df  N)=f)aReturn information about columns in ``table_name``. Given a string ``table_name`` and an optional string ``schema``, return column information as a list of :class:`.ReflectedColumn`. :param table_name: string name of the table. For special quoting, use :class:`.quoted_name`. :param schema: string schema name; if omitted, uses the default schema of the database connection. For special quoting, use :class:`.quoted_name`. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. :return: list of dictionaries, each representing the definition of a database column. .. seealso:: :meth:`Inspector.get_multi_columns`. r2N)rrs get_columnsr2_instantiate_types)rGrrrJrcol_defss r;rInspector.get_columnsJsg4 $ $ &$||//&59__HJH'   # #XJ / ' &s +A A-ctUH2nUH)nUSn[U[5(aMU"5US'M+ M4 g)Ntype)r6r#)rGdatarcol_defcoltypes r;rInspector._instantiate_typesls9H#!&/!':66&-iGFO$rNc UR5n[URR"U4UUUUURS.UD65nSSS5 UR WR 55 U$!,(df  N/=f)aReturn information about columns in all objects in the given schema. The objects can be filtered by passing the names to use to ``filter_names``. For each table the value is a list of :class:`.ReflectedColumn`. :param schema: string schema name; if omitted, uses the default schema of the database connection. For special quoting, use :class:`.quoted_name`. :param filter_names: optionally return information only for the objects listed here. :param kind: a :class:`.ObjectKind` that specifies the type of objects to reflect. Defaults to ``ObjectKind.TABLE``. :param scope: a :class:`.ObjectScope` that specifies if columns of default, temporary or any tables should be reflected. Defaults to ``ObjectScope.DEFAULT``. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. :return: a dictionary where the keys are two-tuple schema,table-name and the values are list of dictionaries, each representing the definition of a database column. The schema is ``None`` if no schema is provided. .. versionadded:: 2.0 .. seealso:: :meth:`Inspector.get_columns` rN)rrrsget_multi_columnsr2rvalues)rGrrrrrJrtable_col_defss r;rInspector.get_multi_columnsvsX $ $ &$! ..!!-#  N'  5 5 78' &s 7A11 A?c UR5nURR"XAU4SUR0UD6sSSS5 $!,(df  g=f)aReturn information about primary key constraint in ``table_name``. Given a string ``table_name``, and an optional string `schema`, return primary key information as a :class:`.ReflectedPrimaryKeyConstraint`. :param table_name: string name of the table. For special quoting, use :class:`.quoted_name`. :param schema: string schema name; if omitted, uses the default schema of the database connection. For special quoting, use :class:`.quoted_name`. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. :return: a dictionary representing the definition of a primary key constraint. .. seealso:: :meth:`Inspector.get_multi_pk_constraint` r2N)rrsget_pk_constraintr2rs r;rInspector.get_pk_constraintsI0 $ $ &$<<11&59__HJ' & &rc UR5n[URR"U4UUUUURS.UD65sSSS5 $!,(df  g=f)aReturn information about primary key constraints in all tables in the given schema. The tables can be filtered by passing the names to use to ``filter_names``. For each table the value is a :class:`.ReflectedPrimaryKeyConstraint`. :param schema: string schema name; if omitted, uses the default schema of the database connection. For special quoting, use :class:`.quoted_name`. :param filter_names: optionally return information only for the objects listed here. :param kind: a :class:`.ObjectKind` that specifies the type of objects to reflect. Defaults to ``ObjectKind.TABLE``. :param scope: a :class:`.ObjectScope` that specifies if primary keys of default, temporary or any tables should be reflected. Defaults to ``ObjectScope.DEFAULT``. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. :return: a dictionary where the keys are two-tuple schema,table-name and the values are dictionaries, each representing the definition of a primary key constraint. The schema is ``None`` if no schema is provided. .. versionadded:: 2.0 .. seealso:: :meth:`Inspector.get_pk_constraint` rN)rrrsget_multi_pk_constraintr2rGrrrrrJrs r;r!!Inspector.get_multi_pk_constraints^V $ $ &$ 44!!-#  ' & & 6A Ac UR5nURR"XAU4SUR0UD6sSSS5 $!,(df  g=f)aReturn information about foreign_keys in ``table_name``. Given a string ``table_name``, and an optional string `schema`, return foreign key information as a list of :class:`.ReflectedForeignKeyConstraint`. :param table_name: string name of the table. For special quoting, use :class:`.quoted_name`. :param schema: string schema name; if omitted, uses the default schema of the database connection. For special quoting, use :class:`.quoted_name`. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. :return: a list of dictionaries, each representing the a foreign key definition. .. seealso:: :meth:`Inspector.get_multi_foreign_keys` r2N)rrsget_foreign_keysr2rs r;r&Inspector.get_foreign_keyssI4 $ $ &$<<00&59__HJ' & &rc UR5n[URR"U4UUUUURS.UD65sSSS5 $!,(df  g=f)aReturn information about foreign_keys in all tables in the given schema. The tables can be filtered by passing the names to use to ``filter_names``. For each table the value is a list of :class:`.ReflectedForeignKeyConstraint`. :param schema: string schema name; if omitted, uses the default schema of the database connection. For special quoting, use :class:`.quoted_name`. :param filter_names: optionally return information only for the objects listed here. :param kind: a :class:`.ObjectKind` that specifies the type of objects to reflect. Defaults to ``ObjectKind.TABLE``. :param scope: a :class:`.ObjectScope` that specifies if foreign keys of default, temporary or any tables should be reflected. Defaults to ``ObjectScope.DEFAULT``. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. :return: a dictionary where the keys are two-tuple schema,table-name and the values are list of dictionaries, each representing a foreign key definition. The schema is ``None`` if no schema is provided. .. versionadded:: 2.0 .. seealso:: :meth:`Inspector.get_foreign_keys` rN)rrrsrr2r"s r;r Inspector.get_multi_foreign_keys%s^Z $ $ &$ 33!!-#  ' & &r$c UR5nURR"XAU4SUR0UD6sSSS5 $!,(df  g=f)aReturn information about indexes in ``table_name``. Given a string ``table_name`` and an optional string `schema`, return index information as a list of :class:`.ReflectedIndex`. :param table_name: string name of the table. For special quoting, use :class:`.quoted_name`. :param schema: string schema name; if omitted, uses the default schema of the database connection. For special quoting, use :class:`.quoted_name`. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. :return: a list of dictionaries, each representing the definition of an index. .. seealso:: :meth:`Inspector.get_multi_indexes` r2N)rrs get_indexesr2rs r;r+Inspector.get_indexes_sI2 $ $ &$<<++&59__HJ' & &rc UR5n[URR"U4UUUUURS.UD65sSSS5 $!,(df  g=f)aReturn information about indexes in in all objects in the given schema. The objects can be filtered by passing the names to use to ``filter_names``. For each table the value is a list of :class:`.ReflectedIndex`. :param schema: string schema name; if omitted, uses the default schema of the database connection. For special quoting, use :class:`.quoted_name`. :param filter_names: optionally return information only for the objects listed here. :param kind: a :class:`.ObjectKind` that specifies the type of objects to reflect. Defaults to ``ObjectKind.TABLE``. :param scope: a :class:`.ObjectScope` that specifies if indexes of default, temporary or any tables should be reflected. Defaults to ``ObjectScope.DEFAULT``. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. :return: a dictionary where the keys are two-tuple schema,table-name and the values are list of dictionaries, each representing the definition of an index. The schema is ``None`` if no schema is provided. .. versionadded:: 2.0 .. seealso:: :meth:`Inspector.get_indexes` rN)rrrsget_multi_indexesr2r"s r;r.Inspector.get_multi_indexes}s^X $ $ &$ ..!!-#  ' & &r$c UR5nURR"XAU4SUR0UD6sSSS5 $!,(df  g=f)aReturn information about unique constraints in ``table_name``. Given a string ``table_name`` and an optional string `schema`, return unique constraint information as a list of :class:`.ReflectedUniqueConstraint`. :param table_name: string name of the table. For special quoting, use :class:`.quoted_name`. :param schema: string schema name; if omitted, uses the default schema of the database connection. For special quoting, use :class:`.quoted_name`. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. :return: a list of dictionaries, each representing the definition of an unique constraint. .. seealso:: :meth:`Inspector.get_multi_unique_constraints` r2N)rrsget_unique_constraintsr2rs r;r1 Inspector.get_unique_constraintssI4 $ $ &$<<66&59__HJ' & &rc UR5n[URR"U4UUUUURS.UD65sSSS5 $!,(df  g=f)aReturn information about unique constraints in all tables in the given schema. The tables can be filtered by passing the names to use to ``filter_names``. For each table the value is a list of :class:`.ReflectedUniqueConstraint`. :param schema: string schema name; if omitted, uses the default schema of the database connection. For special quoting, use :class:`.quoted_name`. :param filter_names: optionally return information only for the objects listed here. :param kind: a :class:`.ObjectKind` that specifies the type of objects to reflect. Defaults to ``ObjectKind.TABLE``. :param scope: a :class:`.ObjectScope` that specifies if constraints of default, temporary or any tables should be reflected. Defaults to ``ObjectScope.DEFAULT``. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. :return: a dictionary where the keys are two-tuple schema,table-name and the values are list of dictionaries, each representing the definition of an unique constraint. The schema is ``None`` if no schema is provided. .. versionadded:: 2.0 .. seealso:: :meth:`Inspector.get_unique_constraints` rN)rrrsget_multi_unique_constraintsr2r"s r;r4&Inspector.get_multi_unique_constraintss^Z $ $ &$ 99!!-#  ' & &r$c UR5nURR"XAU4SUR0UD6sSSS5 $!,(df  g=f)a+Return information about the table comment for ``table_name``. Given a string ``table_name`` and an optional string ``schema``, return table comment information as a :class:`.ReflectedTableComment`. Raises ``NotImplementedError`` for a dialect that does not support comments. :param table_name: string name of the table. For special quoting, use :class:`.quoted_name`. :param schema: string schema name; if omitted, uses the default schema of the database connection. For special quoting, use :class:`.quoted_name`. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. :return: a dictionary, with the table comment. .. versionadded:: 1.2 .. seealso:: :meth:`Inspector.get_multi_table_comment` r2N)rrsget_table_commentr2rs r;r7Inspector.get_table_commentsI: $ $ &$<<11&59__HJ' & &rc UR5n[URR"U4UUUUURS.UD65sSSS5 $!,(df  g=f)aReturn information about the table comment in all objects in the given schema. The objects can be filtered by passing the names to use to ``filter_names``. For each table the value is a :class:`.ReflectedTableComment`. Raises ``NotImplementedError`` for a dialect that does not support comments. :param schema: string schema name; if omitted, uses the default schema of the database connection. For special quoting, use :class:`.quoted_name`. :param filter_names: optionally return information only for the objects listed here. :param kind: a :class:`.ObjectKind` that specifies the type of objects to reflect. Defaults to ``ObjectKind.TABLE``. :param scope: a :class:`.ObjectScope` that specifies if comments of default, temporary or any tables should be reflected. Defaults to ``ObjectScope.DEFAULT``. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. :return: a dictionary where the keys are two-tuple schema,table-name and the values are dictionaries, representing the table comments. The schema is ``None`` if no schema is provided. .. versionadded:: 2.0 .. seealso:: :meth:`Inspector.get_table_comment` rN)rrrsget_multi_table_commentr2r"s r;r:!Inspector.get_multi_table_comment1s^^ $ $ &$ 44!!-#  ' & &r$c UR5nURR"XAU4SUR0UD6sSSS5 $!,(df  g=f)aReturn information about check constraints in ``table_name``. Given a string ``table_name`` and an optional string `schema`, return check constraint information as a list of :class:`.ReflectedCheckConstraint`. :param table_name: string name of the table. For special quoting, use :class:`.quoted_name`. :param schema: string schema name; if omitted, uses the default schema of the database connection. For special quoting, use :class:`.quoted_name`. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. :return: a list of dictionaries, each representing the definition of a check constraints. .. seealso:: :meth:`Inspector.get_multi_check_constraints` r2N)rrsget_check_constraintsr2rs r;r=Inspector.get_check_constraintsmsI4 $ $ &$<<55&59__HJ' & &rc UR5n[URR"U4UUUUURS.UD65sSSS5 $!,(df  g=f)aReturn information about check constraints in all tables in the given schema. The tables can be filtered by passing the names to use to ``filter_names``. For each table the value is a list of :class:`.ReflectedCheckConstraint`. :param schema: string schema name; if omitted, uses the default schema of the database connection. For special quoting, use :class:`.quoted_name`. :param filter_names: optionally return information only for the objects listed here. :param kind: a :class:`.ObjectKind` that specifies the type of objects to reflect. Defaults to ``ObjectKind.TABLE``. :param scope: a :class:`.ObjectScope` that specifies if constraints of default, temporary or any tables should be reflected. Defaults to ``ObjectScope.DEFAULT``. :param \**kw: Additional keyword argument to pass to the dialect specific implementation. See the documentation of the dialect in use for more information. :return: a dictionary where the keys are two-tuple schema,table-name and the values are list of dictionaries, each representing the definition of a check constraints. The schema is ``None`` if no schema is provided. .. versionadded:: 2.0 .. seealso:: :meth:`Inspector.get_check_constraints` rN)rrrsget_multi_check_constraintsr2r"s r;r@%Inspector.get_multi_check_constraintss^Z $ $ &$ 88!!-#  ' & &r$c UbX;agURU5 URRnUR5nUR U5n SSS5 UR n UR V s0sH/n XR;dMXRRU 5_M1 n n W U 4n UbXR;a?UR"U 4U /[R[RUS.URD6nXR;aURU eXR;a[R "U 5eUR"(a3UR"RU 5nU(aUR%U5 Sn0nURU HnSnUR'UUUUU5 M U(d,UR)X5(d[R "U 5eUR+XmUUU5 UR-UU UUUUUUU 5 UR/UU UUUUU 5 UR1UU UUUUU 5 UR3UU UUUUU 5 UR5UU UU 5 g!,(df  GN(=fs sn f)aGiven a :class:`_schema.Table` object, load its internal constructs based on introspection. This is the underlying method used by most dialects to produce table reflection. Direct usage is like:: from sqlalchemy import create_engine, MetaData, Table from sqlalchemy import inspect engine = create_engine("...") meta = MetaData() user_table = Table("user", meta) insp = inspect(engine) insp.reflect_table(user_table, None) .. versionchanged:: 1.4 Renamed from ``reflecttable`` to ``reflect_table`` :param table: a :class:`~sqlalchemy.schema.Table` instance. :param include_columns: a list of string column names to include in the reflection process. If ``None``, all columns are reflected. N)rrr _reflect_infoFT)rrorsrschema_for_objectrreflection_optionsdialect_kwargsrBcolumns_get_reflection_inforYrdrgr3rNoSuchTableError table_options_validate_dialect_kwargs_reflect_columnr _reflect_pk _reflect_fk_reflect_indexes_reflect_unique_constraints_reflect_check_constraints_reflect_table_comment)rGtableinclude_columnsexclude_columns resolve_fks _extend_onrCrsrrrr?rErtbl_opts found_tablecols_by_orig_namecol_ds r; reflect_tableInspector.reflect_tablesB  !"u%))##  $ $ &$++E2F'ZZ // /((( +A##''* */  Z(  I5J5J$J 55(\^^!oo+  && M 33 3--i8 8 11 1&&z2 2  & &$2266yAH..x8 >@"**95EK  !  64>>*#E#E&&z2 2  e->                      ((         ''         ##      O' & sI45J J4 JcUSnURRRXU5 URRXU5 USnU(aXs;d U(aXt;agUSnSV s0sHn X;dM XU _M n n SU;aU RUS5 /n UR S5bUSn U ce[ U [ 5(a[R"U SS9n OK[ U [R5(d*[R"[R"U 5SS9n OU n U RU 5 SU;a*[R"S 0USD6nU RU5 S U;a*[R"S 0US D6nU RU5 [R"Xx/U Q70U D6=XV'nUR UR";aSUlUR%USS 9 gs sn f) Nrr)nullable autoincrementr8inforKcommentdialect_optionsdefaultT) _reflectedcomputedidentity)replace_existingr[)metadatadispatchcolumn_reflectrrBr6r" sa_schema DefaultClause FetchedValuertextappendComputedIdentityColumnrK primary_key append_column)rGrSr[rTrUrZ orig_namerrr?col_kwcolargs default_textrdrfrgcols r;rLInspector._reflect_column]s&M  ..tEB %%d59V}  ;  7 -  z AQxK     % MM% 12 3 99Y  + +L+ ++, 33#11 T i.D.DEE#11HH\*t' NN7 #   ))>E*,=>H NN8 $   ))>E*,=>H NN8 $-6-=-= . #. '-.  $s 77e'' '"CO C$7_  s / G6< G6cURRU5nU(aUSVs/sHnXt;dM Xu;dMXGPM nnURS5URlURSS5URlURS5n U (a%URR R U 5 URRU5 ggs snf)Nconstrained_columnsrrbrc) pk_constraintrBrtrrbrFr_reload) rGrCrrSrZrUpk_conspkpk_colsrcs r;rMInspector._reflect_pks --11)< ""788B*&/1/H&!%8 &-[[%8E   "(/ It(DE   %%kk*; ["R$"S UR&SU SSRU5S35 GMf=f)Nrr}rrreferred_columns)r autoload_withrWrC.)rrrWrCoptionsTrb) link_to_namerbzOn reflected table z0, skipping reflection of foreign key constraint z-; one or more subject columns within name(s) z, z are not present in the table) foreign_keysrBrKr intersectionrrlTablerirorpjoin BLANK_SCHEMAappend_constraintForeignKeyConstraintrConstraintColumnNotFoundErrorrwarnr)rGrCrrSrZrTrUrVrWrErfkey_dconnamecr}rrrrefspeccolumnrs r;rNInspector._reflect_fksd**..y"=FVnG  56#6A-.,B!$((I6 #  +,99/JJ#/0;;OLL$%67O#$45N%&89 G*OO& /&*ii#-&3 -/FNN/>6!JK/ OO&'+ii(55#-&3 -/FNN388^V,D#EF/F" + ''22+&* & 9 5  "  s#~44  )%**6.i #yy)<=>?++ sG:GA H.-H.)ascdesc nulls_first nulls_lastc URRU/5nUGHn U Sn U Sn U RS5n U RS05n U SnU RSS5nU RS05nU RS 5nU(a![U 5RU5(dMU(aM/n[ U 5HunnUcHU (d'[ R "S US U <S US -S35 M[R"U U5nO_UU;aUUnOURUnU RUS5H,nUUR;dMURUnU"U5nM. URU5 M [R"U /UQ7UUS.UD6 GM g![a/ [ R "USU<SUR<35 GM f=f)Nr column_names expressionscolumn_sortingrrindexrcduplicates_constraintz Skipping  z because key rz5 reflected as None but no 'expressions' were returnedz key z& was not located in columns for table r[)_tabler)indexesrBrissubset enumeraterrrrorKeyErrorr_index_sort_exprsrprlIndex)rGrCrrSrZrTrUrErindex_drrGrrrflavorrc duplicates idx_elementsrr idx_elementoptionops r;rOInspector._reflect_indexes s ''++Ir:G6?Dn-G!++m4K$[[)92>NX&F[[1F%kk*;R@O %<=Js7|'<'<_'M'ML%g.q9& 'xq $qyk*:: "%((;u+=">K ! 11*;A*>K*/''!*K#1"4"4Q";!T%;%;;!%!7!7!?B*,[/K#<##K05/8!!!  & ]D$! %heA51116@! !s F0&F004G)(G)c ^URRU/5nUHn U Sn U Sn U RS5n U RS5n U RS05nU(a![U 5RU5(dMiU (aMr/nU H/nUU;aUUOURUnUR U5 M1 UR[R"UU U S .UD65 M g![ a- [R"SU<SUR<S35 Mf=f) Nrrrbduplicates_indexrczunique constraint key 'z(' was not located in columns for table '')rrb) unique_constraintsrBrrrrprrrrrrlUniqueConstraint)rGrCrrSrZrTrUrE constraintsconst_drrGrbrrcconstrained_colsrconstrained_cols r;rP%Inspector._reflect_unique_constraintsbs0$66::9bI "GfoGn-Gkk),G %78J%kk*;R@Os7|'<'<_'M'M "  = 11*!,"WWQZ$%++O<  # #**% #&  7#( II45uzzCsC553D,+D,cURRU/5nUH(n UR[R"S0U D65 M* g)Nr[)check_constraintsrBrrlCheckConstraint) rGrCrrSrZrTrUrErrs r;rQ$Inspector._reflect_check_constraintssB$5599)RH "G  # #I$=$=$H$H I#rNc^URRU5nU(a USUlggNro) table_commentrBrb)rGrCrrSrE comment_dicts r;rR Inspector._reflect_table_comments.%2266yA (0EM rNc ^^^^ ^ UTS'T(a.U(a'[T5S:a[T5[U5- m OSm 0=TS'nSm SSS.S UU U UU4Sjjjn[U"TRSS9U"TR5U"TR5U"TR 5U"TR SS 9U"TRSS 9U"TRSS 9U"TRSS 9US 9 nU(aURU5 U$U$) Nrdr3TF)optionalcheck_filter_names_from_methc>Tb0TS::d*T RRUR5(dTnOSnT(aU"SSU0TD6nU(a U(dSmU$0nU$![a U(de0nU$f=f)Ng?rFr[)rs_overrides_defaultrCNotImplementedError) methrr_fnrrfraction has_resultrJrGs r;run+Inspector._get_reflection_info..runs s?||66t}}EE" 6C626C3C&+ J C J ' J  s!A#A##A;:A;)r)r) rGr~rrrrrrJr3)rrrrqrrqrUr) len_ReflectionInforr!rr.r4r:r@rr) rGrr availablerCrJr3rrarrs ` ` ` @@r;rHInspector._get_reflection_infos<8 I#l*;c*A<(3y>9HH/10?m #16 ! ! ! +/ !   ! ! F&&Td::;T889../"11D d::TJ!004d::TJ' "    & KrN)rrrorsrpr2)rorn)r~zCallable[..., Any]rornrUrl)rornrUNone)rprrUr)rrrUr)rUr)rorrUrl)rorrUrl)rUz!Generator[Connection, None, None])rUz Generator[Inspector, None, None])rU Optional[str])rJrrU List[str])rrrJrrUr)rr7rrrJrrUrq)rr7rrrJrrUrq) rr7rr7rrrJrrUrq)rr7rJrrUrq)rrrJrrUz;List[Tuple[Optional[str], List[Tuple[str, Optional[str]]]]])r5)rzCollection[Optional[str]]rJrrUzgList[Tuple[Optional[Tuple[Optional[str], str]], List[Tuple[Tuple[Optional[str], str], Optional[str]]]]])rr7rrrJrrUDict[str, Any]) rrrOptional[Sequence[str]]rrYrrgrJrrUDict[TableKey, Dict[str, Any]])r r7rrrJrrUr7)rr7rrrJrrUList[ReflectedColumn])rzIterable[List[ReflectedColumn]]rUr) rrrrrrYrrgrJrrU%Dict[TableKey, List[ReflectedColumn]])rr7rrrJrrUr,) rrrrrrYrrgrJrrUz-Dict[TableKey, ReflectedPrimaryKeyConstraint])rr7rrrJrrU#List[ReflectedForeignKeyConstraint]) rrrrrrYrrgrJrrU3Dict[TableKey, List[ReflectedForeignKeyConstraint]])rr7rrrJrrUList[ReflectedIndex]) rrrrrrYrrgrJrrU$Dict[TableKey, List[ReflectedIndex]])rr7rrrJrrUList[ReflectedUniqueConstraint]) rrrrrrYrrgrJrrU/Dict[TableKey, List[ReflectedUniqueConstraint]])rr7rrrJrrUr-) rrrrrrYrrgrJrrUz%Dict[TableKey, ReflectedTableComment])rr7rrrJrrUList[ReflectedCheckConstraint]) rrrrrrYrrgrJrrU.Dict[TableKey, List[ReflectedCheckConstraint]])r[TNN)rSsa_schema.TablerTOptional[Collection[str]]rUCollection[str]rVrqrWOptional[Set[sa_schema.Table]]rCOptional[_ReflectionInfo]rUr) rSrr[r)rTrrUrrZ Dict[str, sa_schema.Column[Any]]rUr) rCrrr/rSrrZrrUrrUr)rCrrr/rSrrZrrTrrUrrVrqrWrrErrUr)rCrrr/rSrrZrrTrrUrrErrUr) rCrrr/rSrrErrUr)NNNN) rrrrrrrCrrJrrUr)OrCr\r]r^r___annotations__r deprecatedrw classmethodrrurrrrr _inspectsrrrr contextlibcontextmanagerrrpropertyrrrrrrrrrrrrrYr`rgrirrrrr rrrrr!r&rr+r.r1r4r7r:r=r@r\rLrMrNrasc_opdesc_opnulls_first_op nulls_last_oprrOrPrQrRrHrer[rNr;rlrlsH 0 $# N"&&  __  5      %-F $    __  5 6 6&&!B"B*%F&F(  00 '+#25 D8<'4CF D;? *7FI .!%      :$!%+ + +  E + ^7>L43L4L4  L4\""8<'4CF B!%04%++(00 77.7 7  7  7 (7t'+#25 <'+#25 2'+#25 &7;&3BE *8<  '4 CF   D030 0!%04%++(00 99.9 9  9  9 /9x8<'4CF &>!%04%++(00 66.6 6  6  6 76r8<'4CF ,B!%04%++(00 88.8 8  8  8 =8v8<'4CF @!%04%++(00 77.7 7  7  7 .7t8<'4CF (B!%04%++(00 88.8 8  8  8 98v8<  '4 CF   H!%04%++(00 ::.: :  :  : /:z8<'4CF 'B!%04%++(00 88.8 8  8  8 88|,. 5937U U 3U ) U  U 3 U 1U  U nF8F8F83 F8 ) F8 < F8 F8P/&// / < / ) / /6W&WW W < W 3 W)WW3W+W Wt!! //-- @&@@ @ < @ 3 @)@+@ @D.&.. . < . 3 .).+. .` J& J J J < J 3 J) J+ J  J 1& 1 1 1 + 1  1!%26/337 LL0L- L 1 L  L LLrNrlc\rSrSrSr\S Sj5r\SSj5r\SSj5r\SSj5r \SSj5r \SSj5r \SS j5r \SS j5r S rg )ReflectionDefaultsiz5provides blank default values for reflection methods.c/$r5r[r}s r;rGReflectionDefaults.columns rNc S/S.$)N)rr}r[rs r;r~ ReflectionDefaults.pk_constraints#%  rNc/$r5r[rs r;rReflectionDefaults.foreign_keys rrNc/$r5r[rs r;rReflectionDefaults.indexes rrNc/$r5r[rs r;r%ReflectionDefaults.unique_constraintsrrNc/$r5r[rs r;r$ReflectionDefaults.check_constraintsrrNc0$r5r[rs r;rJ ReflectionDefaults.table_optionsrrNc SS0$rr[rs r;r ReflectionDefaults.table_comments ~rNr[N)rUr)rUr,)rUr)rUr)rUr)rUr)rUr)rUr-)rCr\r]r^r_rrGr~rrrrrJrrer[rNr;rrs?  rNrcz\rSrSr%S\S'S\S'S\S'S\S 'S \S 'S \S 'S\S'S\S'S\S'SSjrSrg)ri"rrGz7Dict[TableKey, Optional[ReflectedPrimaryKeyConstraint]]r~rrrrrrz/Dict[TableKey, Optional[ReflectedTableComment]]rrrrrJz+Dict[TableKey, exc.UnreflectableTableError]r3cURR5H7up#[X5nUcMUc[XU5 M&UR U5 M9 gr5)__dict__rEgetattrsetattrr)rGotherr?r@ovs r;r_ReflectionInfo.update/sDMM'')DA"B~9DR(HHRL *rNr[N)rrrUr)rCr\r]r^rrrer[rNr;rr"s= 22JJEE 11GGBBEE11>>!rNrrT)rQzTuple[str, InternalTraversal]rUz0Callable[[Callable[..., _R]], Callable[..., _R]])Er_ __future__rr dataclassesrenumrrrtypingrr r r r r rrrrrrrrbaserrrrrrrrrl sql.cache_keyr sql.elementsr!r" sql.type_apir# sql.visitorsr$r% util.typingr& interfacesr'r(r)r*r+r,r-r.r/r0rVrMrWrYrg_self_inspects Inspectablerlrrr[rNr;r"s&#! %7&%%,#4+9*915$ T]        >150"""> *$ * * A &&{3AAH:$$$N !! !rN