JezK
Edit File: reflection.pyc
� 1��fc @ s� d Z d d l Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z e j d � � Z e j d e f d � � Y� Z d S( s� Provides 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.. i����Ni ( t Connectable( t Connection( t Enginei ( t exc( t inspection( t sql( t util( t operators( t schema( t TypeEngine( t topologicalc O s� | j d d � } | d k r1 | | | | | � S| j t d � | D� � t d � | j � D� � f } | j | � } | d k r� | | | | | � } | | | <n | S( Nt info_cachec s s' | ] } t | t j � r | Vq d S( N( t isinstanceR t string_types( t .0t a( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pys <genexpr>2 s c s s- | ]# \ } } | d k r | | f Vq d S( R N( ( R t kt v( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pys <genexpr>3 s ( t gett Nonet __name__t tuplet items( t fnt selft cont argst kwR t keyt ret( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyt cache+ s t Inspectorc B si e Z d Z e j d d � d � � Z e d � � Z d � Z d � Z d � Z e e j d d � d � � � Z e j e � d � � Z e j e � d � � Z e j e � d � � Z e j d � � Z e j d � � Z e d � � Z d � Z d2 d � Z d2 d � Z d2 d � Z d2 d � Z d � Z d � Z! d2 d � Z" d2 d � Z# d2 d � Z$ d2 d � Z% d2 d � Z& d2 d � Z' d2 d � Z( d2 d � Z) d2 d � Z* d2 d � Z+ d2 d! � Z, e j- d" d# � d$ � � Z. d3 e/ d2 d% � Z0 d& � Z1 d' � Z2 d( � Z3 d) � Z4 d* e5 j6 f d+ e5 j7 f d, e5 j8 f d- e5 j9 f g Z: d. � Z; d/ � Z< d0 � Z= d1 � Z> RS(4 s< Performs 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. s 1.4s The __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 C s | j | � S( s� Initialize a new :class:`_reflection.Inspector`. :param bind: a :class:`~sqlalchemy.engine.Connectable`, 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` ( t _init_legacy( R t bind( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyt __init__U s c C sA t | j d � r! | j j } n | j | � } | | | � | S( Nt inspector( t hasattrt dialectR# t __new__( t clst initR! R ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyt _constructn s c C s0 t | d � r | j | � n | j | � d S( Nt exec_driver_sql( R$ t _init_connectiont _init_engine( R R! ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR x s c C sE | | _ | _ | j � j � t | _ | j j | _ i | _ d S( N( R! t enginet connectt closet Truet _op_context_requires_connectR% R ( R R- ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR, ~ s c C s: | | _ | j | _ t | _ | j j | _ i | _ d S( N( R! R- t FalseR1 R% R ( R t connection( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR+ � s s The 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 C s | j | j | � S( s� Construct a new dialect-specific Inspector object from the given engine or connection. :param bind: a :class:`~sqlalchemy.engine.Connectable`, which is typically an instance of :class:`~sqlalchemy.engine.Engine` or :class:`~sqlalchemy.engine.Connection`. 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`. ( R) R ( R' R! ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyt from_engine� s c C s t j t j | � S( N( R R) R ( R! ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyt _connectable_insp� s c C s t j t j | � S( N( R R) R, ( R! ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyt _engine_insp� s c C s t j t j | � S( N( R R) R+ ( R! ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyt _connection_insp� s c c sK | j r | j j � } n | j } z | VWd | j rF | j � n Xd S( s Return 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( R1 R! R. R/ ( R t conn( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyt _operation_context� s c c sB | j � �0 } | j | j j | � } | j | _ | VWd QXd S( s� Return an :class:`_reflection.Inspector` from this one that will run all operations on a single connection. N( R9 R) t __class__R+ R ( R R8 t sub_insp( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyt _inspection_context� s c C s | j j S( s� Return the default schema name presented by the dialect for the current engine's database user. E.g. this is typically ``public`` for PostgreSQL and ``dbo`` for SQL Server. ( R% t default_schema_name( R ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR= � s c C sG t | j d � rC | j � � } | j j | d | j �SWd QXn g S( s Return all schema names.t get_schema_namesR N( R$ R% R9 R> R ( R R8 ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR> � s c C s5 | j � �# } | j j | | d | j �SWd QXd S( s� Return all table names in referred to within a particular schema. The names are expected to be real tables only, not views. Views are instead returned using the :meth:`_reflection.Inspector.get_view_names` method. :param schema: Schema name. If ``schema`` is left at ``None``, the database's default schema is used, else the named schema is searched. If the database does not support named schemas, behavior is undefined if ``schema`` is not passed as ``None``. For special quoting, use :class:`.quoted_name`. .. seealso:: :meth:`_reflection.Inspector.get_sorted_table_and_fkc_names` :attr:`_schema.MetaData.sorted_tables` R N( R9 R% t get_table_namesR ( R R R8 ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR? � s c C s/ | j � � } | j j | | | � SWd QXd S( sM Return True if the backend has a 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. .. versionadded:: 1.4 - the :meth:`.Inspector.has_table` method replaces the :meth:`_engine.Engine.has_table` method. N( R9 R% t has_table( R t table_nameR R8 ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR@ s c C s/ | j � � } | j j | | | � SWd QXd S( s� Return True if the backend has a table of the given name. :param sequence_name: name of the table to check :param schema: schema name to query, if not the default schema. .. versionadded:: 1.4 N( R9 R% t has_sequence( R t sequence_nameR R8 ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyRB s c s� | j � �% } | j j | | d | j �} Wd QXt � } t � } i } x� | D]z } | j | | � } t g | D] } | d ^ qt � | | <x8 | D]0 } | | d k r� | j | d | f � q� q� WqR Wy t t j | | � � } Wnt t j k rb} xC | j D]8 � | j � � | j � f d � | � d D� � q Wt t j | | � � } n Xg | D] } | | | j | � f ^ qjd t | � f g S( s� Return 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. .. versionadded:: 1.0.- .. seealso:: :meth:`_reflection.Inspector.get_table_names` :func:`.sort_tables_and_constraints` - similar method which works with an already-given :class:`_schema.MetaData`. R Nt namet referred_tablec 3 s | ] } � d | f Vq d S( i N( ( R t fkc( t edge( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pys <genexpr>X s i ( R9 R% R? R t sett get_foreign_keyst addt listR t sortR t CircularDependencyErrort edgest removet updatet differenceR ( R R R8 t tnamest tuplest remaining_fkcst fknames_for_tablet tnamet fkeyst fkt fkeyt candidate_sortt err( ( RG sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyt get_sorted_table_and_fkc_names* s. ' " # &c C s2 | j � � } | j j | d | j �SWd QXd S( s� Return a list of temporary table names for the current bind. This method is unsupported by most dialects; currently only SQLite implements it. .. versionadded:: 1.0.0 R N( R9 R% t get_temp_table_namesR ( R R8 ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR] a s c C s2 | j � � } | j j | d | j �SWd QXd S( s� Return a list of temporary view names for the current bind. This method is unsupported by most dialects; currently only SQLite implements it. .. versionadded:: 1.0.0 R N( R9 R% t get_temp_view_namesR ( R R8 ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR^ p s c K sP t | j d � rL | j � �) } | j j | | | d | j | �SWd QXn i S( s� Return a dictionary of options specified when the table of the given name was created. This currently includes some options that apply to MySQL 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`. t get_table_optionsR N( R$ R% R9 R_ R ( R RA R R R8 ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR_ ~ s "c C s5 | j � �# } | j j | | d | j �SWd QXd S( s� Return all view names in `schema`. :param schema: Optional, retrieve names from a non-default schema. For special quoting, use :class:`.quoted_name`. R N( R9 R% t get_view_namesR ( R R R8 ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR` � s c C s5 | j � �# } | j j | | d | j �SWd QXd S( s� Return all sequence names in `schema`. :param schema: Optional, retrieve names from a non-default schema. For special quoting, use :class:`.quoted_name`. R N( R9 R% t get_sequence_namesR ( R R R8 ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyRa � s c C s8 | j � �& } | j j | | | d | j �SWd QXd S( s� Return definition for `view_name`. :param schema: Optional, retrieve names from a non-default schema. For special quoting, use :class:`.quoted_name`. R N( R9 R% t get_view_definitionR ( R t view_nameR R8 ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyRb � s c K sw | j � �+ } | j j | | | d | j | �} Wd QXx7 | D]/ } | d } t | t � s@ | � | d <q@ q@ W| S( s Return information about columns in `table_name`. Given a string `table_name` and an optional string `schema`, return column information as a list of dicts with these keys: * ``name`` - the column's name * ``type`` - the type of this column; an instance of :class:`~sqlalchemy.types.TypeEngine` * ``nullable`` - boolean flag if the column is NULL or NOT NULL * ``default`` - the column's server default value - this is returned as a string SQL expression. * ``autoincrement`` - indicates that the column is auto incremented - this is returned as a boolean or 'auto' * ``comment`` - (optional) the comment on the column. Only some dialects return this key * ``computed`` - (optional) when present it indicates that this column is computed by the database. Only some dialects return this key. Returned as a dict with the keys: * ``sqltext`` - the expression used to generate this column returned as a string SQL expression * ``persisted`` - (optional) boolean that indicates if the column is stored in the table .. versionadded:: 1.3.16 - added support for computed reflection. * ``identity`` - (optional) when present it indicates that this column is a generated always column. Only some dialects return this key. For a list of keywords on this dict see :class:`_schema.Identity`. .. versionadded:: 1.4 - added support for identity column reflection. * ``dialect_options`` - (optional) a dict with dialect specific options :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`. :return: list of dictionaries, each representing the definition of a database column. R Nt type( R9 R% t get_columnsR R R ( R RA R R R8 t col_defst col_deft coltype( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyRe � s 6 ! c K s; | j � �) } | j j | | | d | j | �SWd QXd S( s� Return information about primary key constraint on `table_name`. Given a string `table_name`, and an optional string `schema`, return primary key information as a dictionary with these keys: * ``constrained_columns`` - a list of column names that make up the primary key * ``name`` - optional name of the primary key constraint. :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`. R N( R9 R% t get_pk_constraintR ( R RA R R R8 ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyRi � s c K s; | j � �) } | j j | | | d | j | �SWd QXd S( s� Return 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 dicts with these keys: * ``constrained_columns`` - a list of column names that make up the foreign key * ``referred_schema`` - the name of the referred schema * ``referred_table`` - the name of the referred table * ``referred_columns`` - a list of column names in the referred table that correspond to constrained_columns * ``name`` - optional name of the foreign key constraint. :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`. R N( R9 R% RI R ( R RA R R R8 ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyRI s c K s; | j � �) } | j j | | | d | j | �SWd QXd S( s Return information about indexes in `table_name`. Given a string `table_name` and an optional string `schema`, return index information as a list of dicts with these keys: * ``name`` - the index's name * ``column_names`` - list of column names in order * ``unique`` - boolean * ``column_sorting`` - optional dict mapping column names to tuple of sort keywords, which may include ``asc``, ``desc``, ``nulls_first``, ``nulls_last``. .. versionadded:: 1.3.5 * ``dialect_options`` - dict of dialect-specific index options. May not be present for all dialects. .. versionadded:: 1.0.0 :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`. R N( R9 R% t get_indexesR ( R RA R R R8 ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyRj 8 s $ c K s; | j � �) } | j j | | | d | j | �SWd QXd S( s Return 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 dicts with these keys: * ``name`` - the unique constraint's name * ``column_names`` - list of column names in order :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`. R N( R9 R% t get_unique_constraintsR ( R RA R R R8 ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyRk a s c K s; | j � �) } | j j | | | d | j | �SWd QXd S( s� 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 dictionary with these keys: * ``text`` - text of the comment. Raises ``NotImplementedError`` for a dialect that does not support comments. .. versionadded:: 1.2 R N( R9 R% t get_table_commentR ( R RA R R R8 ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyRl { s c K s; | j � �) } | j j | | | d | j | �SWd QXd S( sc Return 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 dicts with these keys: * ``name`` - the check constraint's name * ``sqltext`` - the check constraint's SQL expression * ``dialect_options`` - may or may not be present; a dictionary with additional dialect-specific options for this CHECK constraint .. versionadded:: 1.3.8 :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`. .. versionadded:: 1.1.0 R N( R9 R% t get_check_constraintsR ( R RA R R R8 ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyRm � s s* :meth:`_reflection.Inspector.reflecttable`s� The :meth:`_reflection.Inspector.reflecttable` method was renamed to :meth:`_reflection.Inspector.reflect_table`. This deprecated alias will be removed in a future release.c O s | j | | � S( s1 See reflect_table. This method name is deprecated( t reflect_table( R R t kwargs( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyt reflecttable� s c s5 | d k r, � | k r d S| j � � n | j j } | j � � } | j � � } Wd QX� j } t � f d � | j D� � } | j | | � j � } | r� � j | � n t j rt | t � r� | j | j � } n t | t � r| j | j � } qn t } i } x? | j | | � j � D]% } t } | j � | | | | � q+W| r�| j | | � r�t j | � � n | j | | � | | � | j | | � | | | | | | � | j | | � | | | | � | j | | � | | | | � | j | | � | | | | � | j | | � | � d S( sZ Given 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. Nc 3 s6 | ], } | � j k r | � j j | � f Vq d S( N( t dialect_kwargsR ( R R ( t table( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pys <genexpr>� s ( R RJ R! R% R9 t schema_for_objectRD t dictt reflection_optionsR_ Rq t _validate_dialect_kwargsR t py2kR t strt decodet encodingR2 Re R0 t _reflect_columnR@ R t NoSuchTableErrort _reflect_pkt _reflect_fkt _reflect_indexest _reflect_unique_constraintst _reflect_check_constraintst _reflect_table_comment( R Rr t include_columnst exclude_columnst resolve_fkst _extend_onR% R8 R RA Ru t tbl_optst found_tablet cols_by_orig_namet col_d( ( Rr sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyRn � s� c s. � d } | j j j | | � � | j j | | � � � d } | rU | | k sg | rk | | k rk d S� d } t � f d � d d d d d d g D� � } d � k r� | j � d � n g } � j d � d k r\� d } t | t j j � rt j | d t �} n7 t | t j � sLt j t j � d � d t �} n | j | � n d � k r�t j � d � } | j | � n d � k r�t j � d � } | j | � n d � k r�| j � | � n t j | | | | � | | <} | j | j k rt | _ n | j | d t �d S( NRD Rd c 3 s+ | ]! } | � k r | � | f Vq d S( N( ( R R ( R� ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pys <genexpr>] s t nullablet autoincrementt quotet infoR t commentt dialect_optionst defaultt _reflectedt computedt identityt sequencet replace_existing( t metadatat dispatcht column_reflectRt RP R R R R t elementst TextClauset sa_schemat DefaultClauseR0 t FetchedValuet textt appendt Computedt Identityt _reflect_col_sequencet ColumnR t primary_keyt append_column( R Rr R� R� R� R� t orig_nameRD Rh t col_kwt colargsR� R� t col( ( R� sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR{ I sP c C s{ d | k rw | d } t j | d d d � } d | k rK | d | _ n d | k rg | d | _ n | j | � n d S( NR� RD i t startt increment( R� t SequenceR� R� R� ( R R� R� t seqR� ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR� � s c C s� | j | | | j � } | r g | d D]( } | | k r) | | k r) | | ^ q) } | j d � | j _ | j j | � n d S( Nt constrained_columnsRD ( Ri Rq R R� RD t _reload( R RA R Rr R� R� t pk_const pkt pk_cols( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR} � s (c C s� | j | | | j � } x�| D]�} | d } g | d D]% } | | k rY | | j n | ^ q: } | r� t | � j | � s | r� t | � j | � r� q n | d } | d } | d } g } | d k r8| rt j | | j d | d | j d | | �n x� | D]% } | j d j | | | g � � q Wnd | rot j | | j d | j d t j d | | �n x* | D]" } | j d j | | g � � qvWd | k r�| d } n i } | j t j | | | d t | �� q Wd S( NRD R� t referred_schemaRE t referred_columnsR t autoload_withR� t .t optionst link_to_name( RI Rq R RH t intersectionRQ R R� t TableR� R! R� t joint BLANK_SCHEMAt append_constraintt ForeignKeyConstraintR0 ( R RA R Rr R� R� R� R� R� Ru RW t fkey_dt connamet cR� R� RE R� t refspect columnR� ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR~ � s^ 3 t asct desct nulls_firstt nulls_lastc C s� | j | | � } x�| D]�} | d } | d } | j d i � } | d } | j d d � } | j d i � } | j d � } | r� t | � j | � r� t j d | d j | � f � q n | r� q n g } x� | D]� } y' | | k r� | | n | j | } Wn. t k r:t j d | | | f � q� n X| j | d � } x2 | j D]' \ } } | | k rW| | � } qWqWW| j | � q� Wt j | d | | t t | j � � d | f g � �q Wd S( NRD t column_namest column_sortingt uniqueRd t indexR� t duplicates_constraints5 Omitting %s key for (%s), key covers omitted columns.s , s5 %s key '%s' was not located in columns for table '%s't _table( ( Rj R RH t issubsetR t warnR� R� t KeyErrort _index_sort_exprsR� R� t IndexRt RK R ( R RA R Rr R� R� R� Ru t indexest index_dRD t columnsR� R� t flavorR� t duplicatest idx_colsR� t idx_colt c_sortingR t op( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR sF c C s= y | j | | � } Wn t k r* d SXx | D]} | d } | d } | j d � } | r� t | � j | � r� t j d d j | � � q2 n | r� q2 n g } xm | D]e } y' | | k r� | | n | j | } Wn( t k rt j d | | f � q� X| j | � q� W| j t j d | | � � q2 Wd S( NRD R� t duplicates_indexsD Omitting unique constraint key for (%s), key covers omitted columns.s , sD unique constraint key '%s' was not located in columns for table '%s'( Rk t NotImplementedErrorR RH R� R R� R� R� R� R� R� R� t UniqueConstraint( R RA R Rr R� R� R� Ru t constraintst const_dR� R� R� t constrained_colsR� t constrained_col( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR� : s6 c C sV y | j | | � } Wn t k r* d SXx$ | D] } | j t j | � � q2 Wd S( N( Rm R� R� R� t CheckConstraint( R RA R Rr R� R� R� Ru R� R� ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR� m s c C sD y | j | | � } Wn t k r* d SX| j d d � | _ d S( NR� ( Rl R� R R R� ( R RA R Rr Ru t comment_dict( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR� � s N( (? R t __module__t __doc__R t deprecatedR" t classmethodR) R R, R+ R4 R t _inspectsR R5 R R6 R R7 t contextlibt contextmanagerR9 R< t propertyR= R> R R? R@ RB R\ R] R^ R_ R` Ra Rb Re Ri RI Rj Rk Rl Rm t deprecated_20Rp R0 Rn R{ R� R} R~ R t asc_opt desc_opt nulls_first_opt nulls_last_opR� R R� R� R� ( ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyR < sl 7 A $ ) " � B P : 3 ( R� R� t baseR R R t R R R R R R R� t sql.type_apiR R t decoratorR t _self_inspectst objectR ( ( ( sO /opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/engine/reflection.pyt <module> s