Файловый менеджер - Редактировать - /opt/imh-python/lib/python3.9/site-packages/sqlalchemy/engine/__pycache__/reflection.cpython-39.pyc
Ðазад
a _�h�� � @ s� d Z ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ dd lm Z dd l m Z dd lm Z dd lmZ ejd d� �ZG dd� de�ZdS )a� 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.. � )� Connectable� )�exc)� inspection)�sql)�util)� operators)�schema)� TypeEngine)� deprecated)� topologicalc O s� |� dd �}|d u r,| ||g|�R i |��S | jtdd� |D ��tdd� |�� D ��f}|� |�}|d u r�| ||g|�R i |��}|||< |S )N� info_cachec s s | ]}t |tj�r|V qd S �N)� isinstancer � string_types)�.0�a� r ��/root/rpmbuild/BUILDROOT/imh-python39-modules-3.9.7-92.el8.x86_64/opt/imh-python/lib/python3.9/site-packages/sqlalchemy/engine/reflection.py� <genexpr>/ � zcache.<locals>.<genexpr>c s s" | ]\}}|d kr||fV qdS )r Nr )r �k�vr r r r 0 r )�get�__name__�tuple�items)�fn�self�con�args�kwr �key�retr r r �cache( s � r$ c @ s` e Zd ZdZdd� Zedd� �Ze�e �dd� �Z e dd � �Z d d � Z ejd d �dGdd��ZdHdd�Zdd� Zdd� ZdIdd�ZdJdd�ZdKdd �ZdLd d �Zed d �dMd!d"��ZdNd#d$�ZdOd%d&�ZdPd'd(�Z dQd)d*�Z dRd+d,�Z dSd-d.�Z dTd1d2�Z d3d4� Z!d5d6� Z"d7d8� Z#d9d:� Z$d;e%j&fd<e%j'fd=e%j(fd>e%j)fgZ*d?d@� Z+dAdB� Z,dCdD� Z-dEdF� Z.dS )U� Inspectora� 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:: from sqlalchemy import inspect, create_engine engine = create_engine('...') insp = inspect(engine) The inspection method above is equivalent to using the :meth:`_reflection.Inspector.from_engine` method, i.e.:: engine = create_engine('...') insp = Inspector.from_engine(engine) Where above, the :class:`~sqlalchemy.engine.interfaces.Dialect` may opt to return an :class:`_reflection.Inspector` subclass that provides additional methods specific to the dialect's target database. c C sJ || _ t|d�r|j| _n|| _| j|u r6|�� �� | jj| _i | _dS )a� 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` �engineN)�bind�hasattrr& �connect�close�dialectr )r r' r r r �__init__U s zInspector.__init__c C s t |jd�r|j�|�S t|�S )a� 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`. � inspector)r( r+ r- r% )�clsr' r r r � from_engineq s zInspector.from_enginec C s t �| �S r )r% r/ )r' r r r �_insp� s zInspector._inspc C s | j jS )z�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+ �default_schema_name�r r r r r1 � s z Inspector.default_schema_namec C s$ t | jd�r | jj| j| jd�S g S )zReturn all schema names.�get_schema_names�r )r( r+ r3 r' r r2 r r r r3 � s �zInspector.get_schema_names)z1.0a The :paramref:`get_table_names.order_by` parameter is deprecated and will be removed in a future release. Please refer to :meth:`_reflection.Inspector.get_sorted_table_and_fkc_names` for a more comprehensive solution to resolving foreign key cycles between tables.)�order_byNc C s� t | jd�r$| jj| j|| jd�}n | j�|�}|dkr�g }|D ]4}| �||�D ]"}||d krP|�|d |f� qPq@t t � ||��}|S )a� 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`. :param order_by: Optional, may be the string "foreign_key" to sort the result on foreign key dependencies. Does not automatically resolve cycles, and will raise :class:`.CircularDependencyError` if cycles exist. .. seealso:: :meth:`_reflection.Inspector.get_sorted_table_and_fkc_names` :attr:`_schema.MetaData.sorted_tables` �get_table_namesr4 Z foreign_key�referred_table) r( r+ r6 r' r r& � table_names�get_foreign_keys�append�listr �sort)r r r5 �tnames�tuples�tname�fkeyr r r r6 � s ' � zInspector.get_table_namesc s: t | jd�r$| jj| j|| jd�}n | j�|�}t� }t� �i �|D ]N}| �||�}tdd� |D ���|< |D ]"}||d krn|� |d |f� qnqDzt t � ||��}W nn t j�y } zR|jD ].� |�� � ��� fdd��� d D �� q�t t � ||��}W Y d }~n d }~0 0 ��fd d�|D �d t ��fg S ) a� 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`. r6 r4 c S s g | ] }|d �qS )�namer )r Zfkr r r � <listcomp>� r z<Inspector.get_sorted_table_and_fkc_names.<locals>.<listcomp>r7 c 3 s | ]}� d |fV qdS )r Nr )r Zfkc)�edger r r s z;Inspector.get_sorted_table_and_fkc_names.<locals>.<genexpr>r Nc s g | ]}|� | � ��f�qS r )� difference)r r? )�fknames_for_table�remaining_fkcsr r rB s �)r( r+ r6 r' r r& r8 �setr9 �addr; r r< r ZCircularDependencyError�edges�remove�update) r r r= r> r? �fkeysr@ Zcandidate_sort�errr )rC rE rF r � get_sorted_table_and_fkc_names� s8 � � & � �z(Inspector.get_sorted_table_and_fkc_namesc C s | j j| j| jd�S )z�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 r4 )r+ �get_temp_table_namesr' r r2 r r r rO s �z Inspector.get_temp_table_namesc C s | j j| j| jd�S )z�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 r4 )r+ �get_temp_view_namesr' r r2 r r r rP s �z Inspector.get_temp_view_namesc K s0 t | jd�r,| jj| j||fd| ji|��S i S )a� 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`. �get_table_optionsr )r( r+ rQ r' r �r � table_namer r! r r r rQ ) s ���zInspector.get_table_optionsc C s | j j| j|| jd�S )z�Return all view names in `schema`. :param schema: Optional, retrieve names from a non-default schema. For special quoting, use :class:`.quoted_name`. r4 )r+ �get_view_namesr' r )r r r r r rT = s �zInspector.get_view_namesc C s | j j| j||| jd�S )z�Return definition for `view_name`. :param schema: Optional, retrieve names from a non-default schema. For special quoting, use :class:`.quoted_name`. r4 )r+ �get_view_definitionr' r )r Z view_namer r r r rU I s �z Inspector.get_view_definitionc K sJ | j j| j||fd| ji|��}|D ] }|d }t|t�s$|� |d< q$|S )a� 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. * ``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 �type)r+ � get_columnsr' r r r )r rS r r! Zcol_defsZcol_def�coltyper r r rW U s 1��� zInspector.get_columnsz0.7z�The :meth:`_reflection.Inspector.get_primary_keys` method is deprecated and will be removed in a future release. Please refer to the :meth:`_reflection.Inspector.get_pk_constraint` method.c K s$ | j j| j||fd| ji|��d S )z�Return information about primary keys in `table_name`. Given a string `table_name`, and an optional string `schema`, return primary key information as a list of column names. r �constrained_columns�r+ �get_pk_constraintr' r rR r r r �get_primary_keys� s ����zInspector.get_primary_keysc K s | j j| j||fd| ji|��S )a� 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 rZ rR r r r r[ � s ���zInspector.get_pk_constraintc K s | j j| j||fd| ji|��S )a� 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 )r+ r9 r' r rR r r r r9 � s ���zInspector.get_foreign_keysc K s | j j| j||fd| ji|��S )a 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``, ``nullsfirst``, ``nullslast``. .. 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 )r+ � get_indexesr' r rR r r r r] � s $���zInspector.get_indexesc K s | j j| j||fd| ji|��S )a 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 )r+ �get_unique_constraintsr' r rR r r r r^ s ���z Inspector.get_unique_constraintsc K s | j j| j||fd| ji|��S )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 dictionary with these keys: * ``text`` - text of the comment. Raises ``NotImplementedError`` for a dialect that does not support comments. .. versionadded:: 1.2 r )r+ �get_table_commentr' r rR r r r r_ s ���zInspector.get_table_commentc K s | j j| j||fd| ji|��S )ac 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 )r+ �get_check_constraintsr' r rR r r r r` 2 s ���z Inspector.get_check_constraintsr Tc sp |dur � |v rdS |� � � | jj}| j�� �}� j}t� fdd�|jD ��} | j||fi � j��} | rt� � | � t j r�t |t �r�|�|j�}t |t �r�|�|j�}d} i } | j||fi � j��D ]} d} | �� | ||| � q�| s�t�� j��| �||� | |� | �||� | |||| � | �||� | ||| � | �||� | ||| � | �||� | ||| � | �||� | � dS )a 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.engine.reflection import Inspector engine = create_engine('...') meta = MetaData() user_table = Table('user', meta) insp = Inspector.from_engine(engine) insp.reflecttable(user_table, None) :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 s( | ] }|� j v r|� j �|�fV qd S r )�dialect_kwargsr �r r ��tabler r r � s �z)Inspector.reflecttable.<locals>.<genexpr>FT)rH r' r+ Zschema_for_objectrA �dict�reflection_optionsrQ ra Z_validate_dialect_kwargsr Zpy2kr �str�decode�encodingrW �_reflect_columnr ZNoSuchTableError� _reflect_pk� _reflect_fk�_reflect_indexes�_reflect_unique_constraints�_reflect_check_constraints�_reflect_table_comment)r rd �include_columns�exclude_columns� resolve_fks� _extend_onr+ r rS rf Ztbl_optsZ found_table�cols_by_orig_name�col_dr rc r � reflecttableS s� ��� �� � �� � � � �zInspector.reflecttablec sV � d }|j �| |� � � d }|r,||vs8|r<||v r<d S � d }t� fdd�dD ��} d� v rp| �� d � g } � �d�d urֈ d } t| tjj�r�t j | dd �} n$t| t j �s�t j t� � d �dd �} | � | � d � v r�t jf i � d ��} | � | � d � v �r| �� | � t j||g| �R i | �� ||< } | j|jv �rHd| _|�| � d S ) NrA rV c 3 s" | ]}|� v r|� | fV qd S r r rb �rv r r r � s �z,Inspector._reflect_column.<locals>.<genexpr>)ZnullableZ autoincrement�quote�infor" �comment�dialect_options�defaultT)Z _reflected�computed�sequence)�dispatchZcolumn_reflectre rK r r r �elementsZ TextClause� sa_schemaZ DefaultClauseZ FetchedValue�textr: ZComputed�_reflect_col_sequence�Columnr" � primary_key� append_column)r rd rv rq rr ru Z orig_namerA rX Zcol_kw�colargsr} r~ �colr rx r rj � sP �� � � ���zInspector._reflect_columnc C sT d|v rP|d }t �|d dd�}d|v r4|d |_d|v rF|d |_|�|� d S )Nr rA r �start� increment)r� �Sequencer� r� r: )r rv r� �seqr r r r r� s z Inspector._reflect_col_sequencec sP | j ||fi |j��}|rL� �fdd�|d D �}|�d�|j_|j�|� d S )Nc s$ g | ] }|� v r|�vr� | �qS r r )r �pk�ru rr r r rB ( s �z)Inspector._reflect_pk.<locals>.<listcomp>rY rA )r[ ra r r� rA Z_reload)r rS r rd ru rr Zpk_consZpk_colsr r� r rk ! s �� �zInspector._reflect_pkc sB | j ||fi |j��} | D �] } | d } � fdd�| d D �} |rRt| ��|�rRq| d } | d }| d }g }| d ur�|r�tj||jfd| | j|d �|�� |D ]}|�d � | ||g�� q�nF|r�tj||jfd| jtj |d �|�� |D ]}|�d � ||g�� q�d | v �r| d }ni }|� tj | || fd di|��� qd S )NrA c s" g | ]}|� v r� | j n|�qS r )r" )r �c�ru r r rB G s �z)Inspector._reflect_fk.<locals>.<listcomp>rY �referred_schemar7 �referred_columnsT)�autoloadr � autoload_withrt �.)r� r� r rt �optionsZ link_to_name) r9 ra rG � intersectionr� �Table�metadatar' r: �joinZ BLANK_SCHEMA�append_constraintZForeignKeyConstraint)r rS r rd ru rr rs rt rf rL Zfkey_d�connamerY r� r7 r� Zrefspec�columnr� r r� r rl 5 s~ �� � ���� ���� ����zInspector._reflect_fk�asc�descZ nullsfirstZ nullslastc C sT | � ||�}|D �]<} | d } | d } | �di �} | d } | �dd�}| �di �}| �d�}|r�t| ��|�s�t�d |d �| �f � q|r�qg }| D ]�}z ||v r�|| n|j| }W n* ty� t�d |||f � Y q�Y n0 | �|d �}| j D ]\}}||v r�||�}q�|� |� q�t j | g|�R d |it t|�� �d| fg ��� qd S )NrA � column_names�column_sorting�uniquerV �indexr| Zduplicates_constraintz5Omitting %s key for (%s), key covers omitted columns.�, z5%s key '%s' was not located in columns for table '%s'r �_table)r] r rG �issubsetr �warnr� r� �KeyError�_index_sort_exprsr: r� �Indexre r; r )r rS r rd ru rq rr rf ZindexesZindex_drA �columnsr� r� Zflavorr| � duplicatesZidx_colsr� Zidx_colZ c_sortingr �opr r r rm � s\ ��� � �� ����zInspector._reflect_indexesc C s� z| � ||�}W n ty$ Y d S 0 |D ]�} | d } | d } | �d�} |rpt| ��|�spt�dd�| � � q*| rvq*g } | D ]R}z ||v r�|| n|j| }W n$ t y� t�d||f � Y q~0 | � |� q~|� t j | d| i�� q*d S )NrA r� Zduplicates_indexzDOmitting unique constraint key for (%s), key covers omitted columns.r� zDunique constraint key '%s' was not located in columns for table '%s')r^ �NotImplementedErrorr rG r� r r� r� r� r� r: r� r� ZUniqueConstraint)r rS r rd ru rq rr rf � constraints�const_dr� r� r� Zconstrained_colsr� Zconstrained_colr r r rn � sD ��� � �� �z%Inspector._reflect_unique_constraintsc C sJ z| � ||�}W n ty$ Y d S 0 |D ]} |�tjf i | ��� q*d S r )r` r� r� r� ZCheckConstraint) r rS r rd ru rq rr rf r� r� r r r ro � s z$Inspector._reflect_check_constraintsc C s8 z| � ||�}W n ty$ Y d S 0 |�dd �|_d S )Nr� )r_ r� r r{ )r rS r rd rf Z comment_dictr r r rp s z Inspector._reflect_table_comment)NN)N)N)N)N)N)N)N)N)N)N)N)N)r TN)/r � __module__� __qualname__�__doc__r, � classmethodr/ r Z _inspectsr r0 �propertyr1 r3 r Zdeprecated_paramsr6 rN rO rP rQ rT rU rW r r\ r[ r9 r] r^ r_ r` rw rj r� rk rl r Zasc_opZdesc_opZ nullsfirst_opZ nullslast_opr� rm rn ro rp r r r r r% 9 sb � + 8 ;� # ( % � = I�:3r% N)r� �baser � r r r r r r r� Z sql.type_apir r r � decoratorr$ �objectr% r r r r �<module> s
| ver. 1.1 | |
.
| PHP 8.3.30 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка