c9[S(ddlmZddlmZddlmZddlmZddlmZddlmZddlmZej dd Z ej dd Z ej dd Z d Z ej dd ZdS)) create_engine)exc) create_db)drop_db)log) run_reap_dbs)update_db_optsmssqlcd|d<dS)NFlegacy_schema_aliasing)db_urldb_optss w/builddir/build/BUILD/cloudlinux-venv-1.0.10/venv/lib64/python3.11/site-packages/sqlalchemy/dialects/mssql/provision.py_mssql_update_db_optsr s(-G $%%%c|d5}|d|z|d|z|d|z|d|z|d|dddddS#1swxYwYdS) N AUTOCOMMITisolation_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)connectexecution_optionsexecutecfgengidentconns r_mssql_create_dbrs  ( ( ( F F 4$ )E1222 ?% G    > F    X%&&& 0111 2333 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4sB CCCc|d5}t||ddddS#1swxYwYdS)Nrr)rr_mssql_drop_ignorers r_mssql_drop_dbr"s  ( ( ( F F($4'''((((((((((((((((((sAA A c |d|ztjd|dS#tj$r }tjd|Yd}~dSd}~wwxYw)Nzdrop database %sz Reaped db: %sTzcouldn't drop db: %sF)rrinfor DatabaseErrorwarning)rrerrs rr!r!$sz '%/000 %(((t   *C000uuuuus-1A AA cDtjd|t|}|d5}tjdd||d}d|D}t}|D]}||vr||dx}} t|d D]\} } t|| r|d z }tjd || ddddS#1swxYwYdS) Nzdb reaper connecting to %rrrzidentifiers in file: %sz, zselect 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:h|]\}|Sr )lower).0dbnames r z"_reap_mssql_dbs..Ds"=== V\\^^===rz-Dropped %d out of %d stale databases detected) rr$rrrjoinrsetadd enumerater!) urlidentsrrto_reap all_namesto_dropnamedroppedtotalr,s r_reap_mssql_dbsr<6sH )3///   C  ( ( ( F F $ *DIIf,=,=>>>,, /   >=W=== %% " "Dv~~ D!!!%&w22  ME6!$// 1   ;We   )                  s B;DDDN)rrtesting.provisionrrrrr for_dbrrr"r!r<r rrr@s?******(((((($$$$$$------//////w.. .' 4 4 4((( $W     r