a
    xˆcŸ  ã                   @   s8  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 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 d¡dd„ ƒZe d¡dd„ ƒZdd„ Ze d¡dd„ ƒZe d¡dd„ ƒZe d¡dd„ ƒZe d¡dd „ ƒZd!S )"é    )Úinspect)ÚIntegeré   )Úcreate_engine)Úexc)ÚColumn)ÚDropConstraint)ÚForeignKeyConstraint)ÚMetaData)ÚTable)Ú	create_db)Ú"drop_all_schema_objects_pre_tables)Údrop_db)Úget_temp_table_name)Úlog)Úrun_reap_dbs)Útemp_table_keyword_argsZmssqlc                 C   s€   |  ¡ jdd��\}| d| ¡ | d| ¡ | d| ¡ | d| ¡ | d¡ | d¡ W d   ƒ n1 sr0    Y  d S )	NÚ
AUTOCOMMIT©Zisolation_levelzcreate database %sz1ALTER DATABASE %s SET ALLOW_SNAPSHOT_ISOLATION ONz0ALTER DATABASE %s SET READ_COMMITTED_SNAPSHOT ONzuse %szcreate schema test_schemazcreate schema test_schema_2)ÚconnectÚexecution_optionsÚexec_driver_sql©ÚcfgÚengÚidentÚconn© r   úf/home/yuhw/wc/wire-cell-python/wcpy/lib/python3.9/site-packages/sqlalchemy/dialects/mssql/provision.pyÚ_mssql_create_db   s    ÿÿ
r   c                 C   s>   |  ¡ jdd��}t||ƒ W d   ƒ n1 s00    Y  d S )Nr   r   )r   r   Ú_mssql_drop_ignorer   r   r   r   Ú_mssql_drop_db"   s    r!   c              
   C   sZ   z |   d| ¡ t d|¡ W dS  tjyT } zt d|¡ W Y d }~dS d }~0 0 d S )Nzdrop database %szReaped db: %sTzcouldn't drop db: %sF)r   r   Úinfor   ZDatabaseErrorÚwarning)r   r   Úerrr   r   r   r    (   s    r    c                 C   sÐ   t  d| ¡ t| ƒ}| ¡ jdd��˜}t  dd |¡¡ | d¡}dd„ |D ƒ}tƒ }|D ]}||v rZ| |¡ qZd	 }}	t	|d
ƒD ]\}	}
t
||
ƒr„|d
7 }q„t  d||	¡ W d   ƒ n1 sÂ0    Y  d S )Nzdb reaper connecting to %rr   r   zidentifiers 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 | ]\}|  ¡ ’qS r   )Úlower)Ú.0Údbnamer   r   r   Ú	<setcomp>G   ó    z"_reap_mssql_dbs.<locals>.<setcomp>r   é   z-Dropped %d out of %d stale databases detected)r   r"   r   r   r   Újoinr   ÚsetÚaddÚ	enumerater    )ÚurlZidentsr   r   Zto_reapZ	all_namesZto_dropÚnameZdroppedÚtotalr'   r   r   r   Ú_reap_mssql_dbs9   s&    ÿ

ÿr2   c                 C   s   i S )Nr   )r   r   r   r   r   Ú_mssql_temp_table_keyword_argsV   s    r3   c                 C   s   d| S )Nz##r   )r   r   Ú	base_namer   r   r   Ú_mssql_get_temp_table_name[   s    r5   c                 C   sÄ   |  ¡ jdd�� }t|ƒ}d d| j| jfD ]v}|j|d�D ]d}t|tƒ tdt	ƒtdt	ƒ|d�}t|ƒj
||d�D ],}| tt|jjg|jjg|d d�ƒ¡ qpq:q*W d   ƒ n1 s¶0    Y  d S )	Nr   r   Zdbo)ÚschemaÚxÚyr0   )r0   )r   r   r   Ztest_schemaZtest_schema_2Zget_table_namesr   r
   r   r   Zget_foreign_keysÚexecuter   r	   Úcr7   r8   )r   r   r   Z	inspectorr6   ZtnameÚtbZfkr   r   r   r   `   s&    ûÿÿÿr   N)Z
sqlalchemyr   r   Ú r   r   r6   r   r   r	   r
   r   Ztesting.provisionr   r   r   r   r   r   r   Zfor_dbr   r!   r    r2   r3   r5   r   r   r   r   Ú<module>   s8   




