관리-도구
편집 파일: provision.cpython-311.pyc
� �܋f� � �( � d dl mZ d dl mZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ ej d� � d � � � Z ej d� � d � � � Z ej d� � d � � � Z d � Z ej d� � d � � � ZdS )� )� create_engine)�exc)� create_db)�drop_db)�log)� run_reap_dbs)�update_db_opts�mssqlc � � d|d< d S )NF�legacy_schema_aliasing� )�db_url�db_optss �v/builddir/build/BUILD/cloudlinux-venv-1.0.6/venv/lib64/python3.11/site-packages/sqlalchemy/dialects/mssql/provision.py�_mssql_update_db_optsr s � �(-�G� $�%�%�%� c � � |� � � � d�� � 5 }|� d|z � � |� d|z � � |� d|z � � |� d|z � � |� d� � |� d� � d d d � � d S # 1 swxY w Y d S ) N� AUTOCOMMIT��isolation_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�conns r �_mssql_create_dbr s � � ��� � � (� (� � (� F� F� 4�$� � � �)�E�1�2�2�2� � � � ?�%� G� � � � � � � >�� F� � � � � � �X��%�&�&�&� � � �0�1�1�1� � � �2�3�3�3� 4� 4� 4� 4� 4� 4� 4� 4� 4� 4� 4� 4���� 4� 4� 4� 4� 4� 4s �B C�C�Cc � � |� � � � d�� � 5 }t ||� � d d d � � d S # 1 swxY w Y d S )Nr r )r r �_mssql_drop_ignorer s r �_mssql_drop_dbr" s� � � ��� � � (� (� � (� F� F� (�$��4��'�'�'�(� (� (� (� (� (� (� (� (� (� (� (���� (� (� (� (� (� (s �A�A �A c �� � | � d|z � � t j d|� � dS # t j $ r }t j d|� � Y d }~dS d }~ww xY w)Nzdrop database %sz Reaped db: %sTzcouldn't drop db: %sF)r r �infor � DatabaseError�warning)r r �errs r r! r! $ sz � �� � � �'�%�/�0�0�0� �� �%�(�(�(��t�� � � � � � � �*�C�0�0�0��u�u�u�u�u��������s �-1 �A � A�A c �D � t j d| � � t | � � }|� � � � d�� � 5 }t j dd� |� � � � |� d� � }d� |D � � }t � � }|D ]}||v r|� |� � � dx}} t |d � � D ]\ } } t || � � r|d z }�t j d || � � d d d � � d S # 1 swxY w Y d S ) 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)c �: � h | ]\ }|� � � ��S r )�lower)�.0�dbnames r � <setcomp>z"_reap_mssql_dbs.<locals>.<setcomp>D s" � �=�=�=� ��V�\�\�^�^�=�=�=r � � z-Dropped %d out of %d stale databases detected) r r$ r r r �joinr �set�add� enumerater! ) �url�identsr r �to_reap� all_names�to_drop�name�dropped�totalr, s r �_reap_mssql_dbsr< 6 s� � ��H� )�3�/�/�/� �� � �C� ��� � � (� (� � (� F� F� �$� ��*�D�I�I�f�,=�,=�>�>�>��,�,� /� � �� >�=�W�=�=�=� ��%�%�� � "� "�D��v�~�~�� � �D�!�!�!�����%� &�w�� 2� 2� � �M�E�6�!�$��/�/� ��1� ��� �� ;�W�e� � � �) � � � � � � � � � � � ���� � � � � � s � B;D�D� DN)� r r �testing.provisionr r r r r �for_dbr r r" r! r< r r r �<module>r@ s? �� � � � � � � � � � � � � *� *� *� *� *� *� (� (� (� (� (� (� $� $� $� $� $� $� -� -� -� -� -� -� /� /� /� /� /� /� � ��w� � �.� .� � �.� ���'��� 4� 4� �� 4� �� ����(� (� ��(� � � �$ � ��W� � � � � � � � � r