w 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