HEX
Server: LiteSpeed
System: Linux us-phx-web1284.main-hosting.eu 4.18.0-553.109.1.lve.el8.x86_64 #1 SMP Thu Mar 5 20:23:46 UTC 2026 x86_64
User: u300739242 (300739242)
PHP: 8.2.30
Disabled: system, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail
Upload Files
File: //opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/provision.pyc
�
���ec@s�ddlmZddlmZddlmZddlmZddlmZddlmZddlm	Z	dd	lm
Z
dd
lmZddlm
Z
ddlmZdd
lmZddlmZddlmZddlmZddlmZe
jd�d��Zejd�d��Zd�Zejd�d��Zejd�d��Zejd�d��Zejd�d��ZdS(i����(tinspect(tIntegeri(t
create_engine(texc(tColumn(tDropConstraint(tForeignKeyConstraint(tMetaData(tTable(t	create_db(t"drop_all_schema_objects_pre_tables(tdrop_db(tget_temp_table_name(tlog(trun_reap_dbs(ttemp_table_keyword_argstmssqlcCs�|j�jdd��e}|jd|�|jd|�|jd|�|jd|�|jd�|jd�WdQXdS(	Ntisolation_levelt
AUTOCOMMITscreate database %ss1ALTER DATABASE %s SET ALLOW_SNAPSHOT_ISOLATION ONs0ALTER DATABASE %s SET READ_COMMITTED_SNAPSHOT ONsuse %sscreate schema test_schemascreate schema test_schema_2(tconnecttexecution_optionstexec_driver_sql(tcfgtengtidenttconn((sT/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/provision.pyt_mssql_create_dbs
cCs2|j�jdd��}t||�WdQXdS(NRR(RRt_mssql_drop_ignore(RRRR((sT/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/provision.pyt_mssql_drop_db(scCsWy)|jd|�tjd|�tSWn'tjk
rR}tjd|�tSXdS(Nsdrop database %ss
Reaped db: %sscouldn't drop db: %s(RR
tinfotTrueRt
DatabaseErrortwarningtFalse(RRterr((sT/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/provision.pyR.scCstjd|�t|�}|j�jdd���}tjddj|��|jd�}d�|D�}t�}x*|D]"}||kr|j|�qqWd}}	x9t	|d	�D](\}	}
t
||
�r�|d	7}q�q�Wtjd
||	�WdQXdS(Nsdb reaper connecting to %rRRsidentifiers in file: %ss, s�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)cSsh|]\}|j��qS((tlower(t.0tdbname((sT/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/provision.pys	<setcomp>Ms	iis-Dropped %d out of %d stale databases detected(R
RRRRtjoinRtsettaddt	enumerateR(turltidentsRRtto_reapt	all_namestto_droptnametdroppedttotalR%((sT/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/provision.pyt_reap_mssql_dbs?s"		

cCsiS(N((RR((sT/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/provision.pyt_mssql_temp_table_keyword_args\scCsd|S(Ns##((RRt	base_name((sT/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/provision.pyt_mssql_get_temp_table_nameascCs�|j�jdd���}t|�}x�dd|j|jfD]�}x�|jd|�D]�}t|t�t	dt
�t	dt
�d|�}x[t|�j|d|�D]>}|jt
t|jjg|jjgd|d���q�WqYWq@WWdQXdS(NRRtdbotschematxtyR/(RRRtNonettest_schemat
test_schema_2tget_table_namesRRRRtget_foreign_keystexecuteRRtcR8R9(RRRt	inspectorR7ttnamettbtfk((sT/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/provision.pyR
fs	"N(t
sqlalchemyRRtRRR7RRRRRttesting.provisionR	R
RRR
RRtfor_dbRRRR2R3R5(((sT/opt/alt/python27/lib/python2.7/site-packages/sqlalchemy/dialects/mssql/provision.pyt<module>s,