o ïÅ[há ã@s¨ddlmZddlmZddlmZddlmZddlmZddlmZddlmZe  d¡d d „ƒZ e  d¡d d „ƒZ e  d¡d d„ƒZ dd„Z e  d¡dd„ƒZdS)é)Ú create_engine)Úexc)Ú create_db)Údrop_db)Úlog)Ú run_reap_dbs)Úupdate_db_optsZmssqlcCs d|d<dS)NFZlegacy_schema_aliasing©)Zdb_urlZdb_optsr r úŠ/home/ubuntu/experiments/live_experiments/Pythonexperiments/Otree/venv/lib/python3.10/site-packages/sqlalchemy/dialects/mssql/provision.pyÚ_mssql_update_db_opts s r cCs‚| ¡jdd/}| d|¡| d|¡| d|¡| d|¡| d¡| d¡WdƒdS1s:wYdS) 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Úexecute©ÚcfgÚengÚidentÚconnr r r Ú_mssql_create_dbsÿÿ  "örcCs@| ¡jdd}t||ƒWdƒdS1swYdS)Nr r )rrÚ_mssql_drop_ignorerr r r Ú_mssql_drop_dbs "ÿrc CsVz| d|¡t d|¡WdStjy*}z t d|¡WYd}~dSd}~ww)Nzdrop database %sz Reaped db: %sTzcouldn't drop db: %sF)rrÚinforZ DatabaseErrorÚwarning)rrÚerrr r r r$s  €þrc CsÒt d|¡t|ƒ}| ¡jddM}t dd |¡¡| d¡}dd„|Dƒ}tƒ}|D] }||vr8| |¡q-d }} t |d ƒD] \} } t || ƒrO|d 7}qBt d || ¡WdƒdS1sbwYdS) 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)cSsh|]\}| ¡’qSr )Úlower)Ú.0Údbnamer r r Ú Dsz"_reap_mssql_dbs..ééz-Dropped %d out of %d stale databases detected) rrrrrÚjoinrÚsetÚaddÚ enumerater) ÚurlZidentsrrZto_reapZ all_namesZto_dropÚnameZdroppedÚtotalrr r r Ú_reap_mssql_dbs6s, ÿ € €ÿ"ìr)N)ÚrrZtesting.provisionrrrrrZfor_dbr rrrr)r r r r Ús