Файловый менеджер - Редактировать - /opt/imh-python/lib/python3.9/site-packages/sqlalchemy/dialects/oracle/__pycache__/provision.cpython-39.pyc
Ðазад
a _�h� � @ sP d dl mZ d dl mZ d dlmZ d dlmZ d dlmZ d dlm Z d dlm Z d dlm Z d d lm Z d d lm Z d d lmZ d d lmZ d d lmZ e�d�dd� �Ze�d�dd� �Zdd� Ze �d�dd� �Ze�d�dd� �Ze�d�dd� �Ze� Ze �d�dd � �Ze �d�d d � �Ze �d�d d � �Ze�d�d!d"� �Z d#S )$� )� create_engine)�exc)�url)�configure_follower)� create_db)�drop_db)�follower_url_from_main)�log)�post_configure_engine)� run_reap_dbs)�stop_test_class)�temp_table_keyword_args)�update_db_opts�oraclec C s� |� � �t}|�d| � |�d| � |�d| � |�d|f � |�d| � |�d| � |�d| � W d � n1 s�0 Y d S )Nz create user %s identified by xez#create user %s_ts1 identified by xez#create user %s_ts2 identified by xezgrant dba to %sz grant unlimited tablespace to %sz$grant unlimited tablespace to %s_ts1z$grant unlimited tablespace to %s_ts2)�connect�execute��cfg�eng�ident�conn� r ��/root/rpmbuild/BUILDROOT/imh-python39-modules-3.9.7-92.el8.x86_64/opt/imh-python/lib/python3.9/site-packages/sqlalchemy/dialects/oracle/provision.py�_oracle_create_db s r c C s d| | _ d| | _d S �N�%s_ts1�%s_ts2)Z test_schemaZ test_schema_2)�configr r r r �_oracle_configure_follower s r c C sZ z | � d| � t�d|� W dS tjyT } zt�d|� W Y d }~dS d }~0 0 d S )Nzdrop user %s cascadez Reaped db: %sTzcouldn't drop db: %sF)r r �infor Z DatabaseError�warning)r Zdbname�errr r r �_ora_drop_ignore% s r" c C sR |� � �6}t||� t|d| � t|d| � W d � n1 sD0 Y d S r )r r" r r r r �_oracle_drop_db/ s r# c C s d S �Nr )Zdb_urlZdb_optsr r r �_oracle_update_db_opts< s r% c C sx |� � �}|�d� W d � n1 s(0 Y tD ]4}z |j}W n |jjjy\ Y q60 d|_||_q6t�� dS )z�run magic command to get rid of identity sequences # https://floo.bar/2019/11/29/drop-the-underlying-sequence-of-an-identity-column/ zpurge recyclebinN� )�beginr � _all_connsZ stmtcachesize�dialectZdbapiZInterfaceError�clear)r �db�clsr Zcx_oracle_conn�scr r r r A s ( r c C s$ ddl m} |�|d�dd� �}d S )Nr& )�event�checkoutc S s t �| � d S r$ )r( �add)Z dbapi_conZ con_recordZ con_proxyr r r r/ b s z/_oracle_post_configure_engine.<locals>.checkout)Z sqlalchemyr. Z listens_for)r �engineZfollower_identr. r/ r r r � _oracle_post_configure_engine^ s r2 c C s t �d| � t| �}|�� ��}t �dd�|�� |�d�}dd� |D �}t� }|D ]b}|�d�sR|�d�rnqRqR||v rR|�|� d | |v r�|�d | � d | |v rR|�d | � qRd }} t |d �D ]\} } t || �r�|d 7 }q�t �d || � W d � n1 �s0 Y d S )Nzdb reaper connecting to %rzidentifiers in file: %sz, z�select u.username from all_users u where username like 'TEST_%' and not exists (select username from v$session where username=u.username)c S s h | ]\}|� � �qS r )�lower)�.0�usernamer r r � <setcomp>t � z#_reap_oracle_dbs.<locals>.<setcomp>Z_ts1Z_ts2r r r& � z-Dropped %d out of %d stale databases detected) r r r r �joinr �set�endswithr0 � enumerater" ) r Zidentsr r Zto_reapZ all_namesZto_drop�nameZdropped�totalr5 r r r �_reap_oracle_dbsg s2 � �r? c C s t �| �} || _d| _| S )NZxe)�sa_urlZmake_urlr5 �password)r r r r r � _oracle_follower_url_from_main� s rB c C s dgdd�S )NzGLOBAL TEMPORARYz PRESERVE ROWS)�prefixesZoracle_on_commitr )r r r r r � _oracle_temp_table_keyword_args� s �rD N) � r r r1 r r@ Ztesting.provisionr r r r r r r r r r Zfor_dbr r r" r# r% r: r( r2 r? rB rD r r r r �<module> s@ !
| ver. 1.1 | |
.
| PHP 8.3.30 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка