a
    •˜ëj+  ã                   @   s0  d dl Z ddlmZ ddlmZ ddlmZ ddlmZ ddlm	Z	 ddlm
Z
 dd	lmZ dd
lmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ e d¡dd„ ƒZe
 d¡dd„ ƒZe	 d¡dd„ ƒZdd „ Ze d¡d!d"„ ƒZ e d¡d#d$„ ƒZ!e d¡d%d&„ ƒZ"e d¡d'd(„ ƒZ#d=d)d*„Z$e d¡d+d,„ ƒZ%d-d.„ Z&e d¡d/d0„ ƒZ'e d¡d1d2„ ƒZ(e d¡d3d4„ ƒZ)e d¡d5d6„ ƒZ*e d¡d7d8„ ƒZ+e d¡d9d:„ ƒZ,e d¡d;d<„ ƒZ-dS )>é    Né   )Úcreate_engine)Úexc)Úinspect)Úurl)Úconfigure_follower)Ú	create_db)Ú#drop_all_schema_objects_post_tables)Ú"drop_all_schema_objects_pre_tables)Údrop_db)Úfollower_url_from_main)Úgenerate_driver_url)Úis_preferred_driver)Úlog)Úpost_configure_engine)Úpost_configure_testing_engine)Úrun_reap_dbs)Ú set_default_schema_on_connection)Ú stop_test_class_outside_fixtures)Útemp_table_keyword_args)Úupdate_db_opts)Úwarn_test_suiteÚoraclec                 C   sn   |   ¡ }| jd||f d�}|dv r4| ddg¡}n| ddg¡}z| ¡  W n tjyd   Y d S 0 |S d S )Nz%s+%s)Z
drivername)ÚoracledbZoracledb_async)Úretry_countÚ5)Úretry_delayÚ2r   r   )Zget_backend_nameÚsetZupdate_query_pairsZdifference_update_queryÚget_dialectr   ZNoSuchModuleError)r   ÚdriverZ	query_strÚbackendÚnew_url© r#   úc/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/dialects/oracle/provision.pyÚ_oracle_generate_driver_url"   s     
ÿÿÿr%   c                 C   sº   |  ¡ �ž}| d| ¡ | d| ¡ | d| ¡ | d|f ¡ | d| ¡ | d| ¡ | d| ¡ | d| ¡ | d	| ¡ | d
| ¡ W d   ƒ n1 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 xezgrant dba to %sz grant unlimited tablespace to %sz$grant unlimited tablespace to %s_ts1z$grant unlimited tablespace to %s_ts2zgrant create table to %szgrant create table to %s_ts1zgrant create table to %s_ts2)ÚbeginÚexec_driver_sql©ÚcfgÚengÚidentÚconnr#   r#   r$   Ú_oracle_create_dbC   s    
r-   c                 C   s   d| | _ d| | _d S ©Nú%s_ts1ú%s_ts2)Útest_schemaZtest_schema_2)Úconfigr+   r#   r#   r$   Ú_oracle_configure_followerV   s    
r3   c              
   C   sZ   z |   d| ¡ t d|¡ W dS  tjyT } zt d|¡ W Y d }~dS d }~0 0 d S )Nzdrop user %s cascadezReaped db: %sTzcouldn't drop db: %sF)r'   r   Úinfor   ÚDatabaseErrorÚwarning)r,   ZdbnameÚerrr#   r#   r$   Ú_ora_drop_ignore\   s    r8   c                 C   s   t |ƒ t || jƒ d S )N)Ú_purge_recyclebinr1   ©r)   r*   r#   r#   r$   Ú'_ora_drop_all_schema_objects_pre_tablesf   s    r;   c              	   C   s°   |  ¡ �”}|j |d d d ¡D ]}| d|d › �¡ q|j || jd d ¡D ] }| d| j› d|d › �¡ qJt|ƒ ¡ D ]}| d|› �¡ qxW d   ƒ n1 s¢0    Y  d S )Nzdrop synonym Zsynonym_nameÚ.zdrop table )r&   ÚdialectZ_get_synonymsr'   r1   r   Zget_temp_table_names)r)   r*   r,   ZsynZ	tmp_tabler#   r#   r$   Ú(_ora_drop_all_schema_objects_post_tablesl   s    

ÿÿr>   c                 C   sR   |  ¡ �6}t||ƒ t|d| ƒ t|d| ƒ W d   ƒ n1 sD0    Y  d S r.   )r&   r8   r(   r#   r#   r$   Ú_oracle_drop_db}   s    

r?   c              
   C   sD   zt |ƒ W n2 tjy> } zt d|¡ W Y d }~n
d }~0 0 d S )Nz#purge recyclebin command failed: %s)r9   r   r5   r   r6   )r2   ÚdbÚclsr7   r#   r#   r$   Ú%_ora_stop_test_class_outside_fixturesŠ   s    rB   c                 C   s†   |   ¡ �j}|d u r| d¡ nF| dd|j |¡i¡ ¡ D ](\}}}| d|› d|› d|› d�¡ q:W d   ƒ n1 sx0    Y  d S )Nzpurge recyclebinzWselect owner, object_name,type from dba_recyclebin where owner=:schema and type='TABLE'Úschemazpurge ú z."ú")r&   r'   r=   Zdenormalize_nameÚall)r*   rC   r,   ÚownerZobject_nameÚtype_r#   r#   r$   r9   ’   s    
ýr9   c                 C   s   |j jdko|j j S )ztestablish oracledb as the preferred driver to use for tests, even
    though cx_Oracle is still the "default" driverr   )r=   r    Úis_async)r)   Úenginer#   r#   r$   Ú_oracle_is_preferred_driver¢   s    rK   c                 C   s¶   | j dksJ ‚dd„ }d }tdƒD ]|}z| jj|i |¤ŽW   S  | jj| jjfyœ } z:|}||ƒr†tdƒ t d¡ W Y d }~q"n‚ W Y d }~q"d }~0 0 q"|d ur²t	dƒ|‚d S )NÚ	cx_oraclec                 S   s   dt | ƒv pdt | ƒv S )NzDPY-6005z	ORA-12516)Ústr)r7   r#   r#   r$   Ú_is_couldnt_connect­   s    z0_connect_with_retry.<locals>._is_couldnt_connecté   zOracle database reconnecting...é   z"connect failed after five attempts)
r    ÚrangeZloaded_dbapiÚconnectr5   ZOperationalErrorr   ÚtimeÚsleepÚ	Exception)r=   Zconn_recZcargsZcparamsrN   Zerr_Ú_r7   r#   r#   r$   Ú_connect_with_retryª   s$    þ
rW   c                 C   s*   ddl m} |jjdkr&| |dt¡ d S )Nr   ©ÚeventrL   Z
do_connect)Ú rY   r=   r    ÚlistenrW   )r   rJ   ÚoptionsZscoperY   r#   r#   r$   Ú%_oracle_post_configure_testing_engineÃ   s    r]   c                 C   s$   ddl m} | |d¡dd„ ƒ}d S )Nr   rX   Úcheckinc                 S   s(   z
| j }W n   Y n0 d| _ || _ d S )Nr   )Zstmtcachesize)Údbapi_connectionZconnection_recordZscr#   r#   r$   r^   Ð   s    
z._oracle_post_configure_engine.<locals>.checkin)rZ   rY   Zlistens_for)r   rJ   Zfollower_identrY   r^   r#   r#   r$   Ú_oracle_post_configure_engineË   s    
r`   c                 C   s  t  d| ¡ t| ƒ}| ¡ �ä}t  dd |¡¡ | d¡}dd„ |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   ƒ n1 �s0    Y  d S )Nzdb reaper connecting to %rzidentifiers 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 | ]\}|  ¡ ’qS r#   )Úlower)Ú.0Úusernamer#   r#   r$   Ú	<setcomp>ö   ó    z#_reap_oracle_dbs.<locals>.<setcomp>Z_ts1Z_ts2r/   r0   r   é   z-Dropped %d out of %d stale databases detected)r   r4   r   r&   Újoinr'   r   ÚendswithÚaddÚ	enumerater8   )r   Zidentsr*   r,   Zto_reapZ	all_namesZto_dropÚnameZdroppedÚtotalrc   r#   r#   r$   Ú_reap_oracle_dbsê   s2    
ÿ


ÿrm   c                 C   s   t  | ¡} | j|dd�S )NZxe)rc   Úpassword)Úsa_urlÚmake_urlr   )r   r+   r#   r#   r$   Ú_oracle_follower_url_from_main  s    
rq   c                 C   s   dgddœS )NzGLOBAL TEMPORARYzPRESERVE ROWS)ÚprefixesZoracle_on_commitr#   r:   r#   r#   r$   Ú_oracle_temp_table_keyword_args  s    þrs   c                 C   s"   |  ¡ }| d| ¡ | ¡  d S )Nz#ALTER SESSION SET CURRENT_SCHEMA=%s)ÚcursorÚexecuteÚclose)r)   r_   Zschema_namert   r#   r#   r$   Ú(_oracle_set_default_schema_on_connection  s    rw   c                 C   s$   |j r t | ¡ ¡ dkr d|d< dS )zCSet database options (db_opts) for a test database that we created.r   TZ
thick_modeN)Zoracledb_thick_modero   rp   Zget_driver_name)Zdb_urlZdb_optsr\   r#   r#   r$   Ú_update_db_opts"  s
    ÿþrx   )N).rS   rZ   r   r   r   rJ   r   ro   Ztesting.provisionr   r   r	   r
   r   r   r   r   r   r   r   r   r   r   r   r   Ztesting.warningsr   Zfor_dbr%   r-   r3   r8   r;   r>   r?   rB   r9   rK   rW   r]   r`   rm   rq   rs   rw   rx   r#   r#   r#   r$   Ú<module>	   sl   
 











 


