?????????? ????????? - ??????????????? - /home/agenciai/.local/lib/python3.9/site-packages/sqlalchemy/dialects/mssql/__pycache__/provision.cpython-39.pyc
???????
a ��Jh� � @ s� d dl mZ d dl mZ ddlmZ ddlmZ ddlmZ ddlmZ ddlm Z dd lm Z dd lm Z dd l m Z dd l mZ dd l mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ ddl mZ e�d�dd� �Ze�d�dd� �Ze �d�dd� �Ze�d�d d � �Zd d � Ze�d�d d!� �Ze�d�d"d#� �Z e�d�d$d%� �Z e�d�d&d'� �Ze�d�d(d)� �Zd*S )+� )�inspect)�Integer� )� create_engine)�exc)�Column)�DropConstraint)�ForeignKeyConstraint)�MetaData)�Table)� create_db)�"drop_all_schema_objects_pre_tables)�drop_db)�generate_driver_url)�get_temp_table_name)�log)�normalize_sequence)�post_configure_engine)� run_reap_dbs)�temp_table_keyword_argsZmssqlc C s |j dkrd|jj_d S )N�pyodbcF)�driver�dialectZdbapiZpooling)�urlZengineZfollower_ident� r �X/home/agenciai/.local/lib/python3.9/site-packages/sqlalchemy/dialects/mssql/provision.pyr s r c C s� | � � }| jd||f d�}|dvr0|jdd�}|dkrF|�ddi�}|rT|�|�}z |�� W n tjyv Y d S 0 |S d S ) Nz%s+%s)Z drivername)r �aioodbc� )�queryr ZMARS_ConnectionZYes)Zget_backend_name�setZupdate_query_dictZupdate_query_string� get_dialectr ZNoSuchModuleError)r r Z query_str�backend�new_urlr r r r $ s r c C s� |� � jdd��\}|�d| � |�d| � |�d| � |�d| � |�d� |�d� W d � n1 sr0 Y d S ) N� AUTOCOMMIT�Zisolation_levelzcreate database %sz1ALTER DATABASE %s SET ALLOW_SNAPSHOT_ISOLATION ONz0ALTER DATABASE %s SET READ_COMMITTED_SNAPSHOT ONzuse %szcreate schema test_schemazcreate schema test_schema_2)�connect�execution_options�exec_driver_sql��cfg�eng�ident�connr r r �_mssql_create_db; s �� r- c C s> |� � jdd��}t||� W d � n1 s00 Y d S )Nr# r$ )r% r& �_mssql_drop_ignorer( r r r �_mssql_drop_dbJ s r/ c C sZ z | � d| � t�d|� W dS tjyT } zt�d|� W Y d }~dS d }~0 0 d S )Nzdrop database %sz Reaped db: %sTzcouldn't drop db: %sF)r' r �infor Z DatabaseError�warning)r, r+ �errr r r r. P s r. c C s� t �d| � t| �}|�� jdd���}t �dd�|�� |�d�}dd� |D �}t� }|D ]}||v rZ|�|� qZd }} t |d �D ]\} } t || �r�|d 7 }q�t �d || � W d � n1 s�0 Y d S ) Nzdb reaper connecting to %rr# r$ zidentifiers in file: %sz, z�select d.name from sys.databases as d where name like 'TEST_%' and not exists (select session_id from sys.dm_exec_sessions where database_id=d.database_id)c S s h | ]\}|� � �qS r )�lower)�.0�dbnamer r r � <setcomp>n � z"_reap_mssql_dbs.<locals>.<setcomp>r � z-Dropped %d out of %d stale databases detected) r r0 r r% r& �joinr' r �add� enumerater. ) r Zidentsr* r, Zto_reapZ all_namesZto_drop�nameZdropped�totalr5 r r r �_reap_mssql_dbsa s& � �r> c C s i S )Nr )r) r* r r r � _mssql_temp_table_keyword_args} s r? c C s d| S )Nz##r )r) r* � base_namer r r �_mssql_get_temp_table_name� s rA c C s� |� � jdd���}t|�}d d| j| jfD ]v}|j|d�D ]d}t|t� tdt �tdt �|d�}t|�j ||d�D ],}|� t t |jjg|jjg|d d��� qpq:q*W d � n1 s�0 Y d S ) Nr# r$ Zdbo)�schema�x�yr< )r< )r% r& r Z test_schemaZ test_schema_2Zget_table_namesr r r r Zget_foreign_keys�executer r �crC rD )r) r* r, Z inspectorrB Ztname�tbZfkr r r r � s& ����r c C s |j d u rd|_ |S )Nr8 )�start)r) �sequencer r r r � s r N) Z sqlalchemyr r r r r rB r r r r r Ztesting.provisionr r r r r r r r r r Zfor_dbr- r/ r. r> r? rA r r r r �<module> sJ
| ver. 1.6 |
Github
|
.
| PHP 8.2.30 | ??????????? ?????????: 0 |
proxy
|
phpinfo
|
???????????