a
    •˜ëj?  ã                   @   sh  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 e d¡dd„ ƒZe d¡dd„ ƒZe d¡dd„ ƒZe d¡dd„ ƒZe
 d¡dd„ ƒZ
e	 d¡dd„ ƒZ	e d¡dd„ ƒZe d¡dd dd!œd"d#„ƒZd$d%gZe d¡d&d'„ ƒZdS )(é    Né   )Úexc)Úinspect)Útext)Úwarn_test_suite)Ú	create_db)Ú#drop_all_schema_objects_post_tables)Ú"drop_all_schema_objects_pre_tables)Údrop_db)Úlog)Úpost_configure_engine)Úprepare_for_drop_tables)Ú set_default_schema_on_connection)Útemp_table_keyword_args)ÚupsertÚ
postgresqlc                 C   sÚ   | j j}|jdd� ¡ �®}|s,| d¡ ¡ }d}z| d||f ¡ W q¸ tjy¦ } zF|d7 }|dkrj‚ dt|ƒv r’t	 
d	||j|¡ t d
¡ W Y d }~q0d }~0    ‚ Y q00 q¸q0W d   ƒ n1 sÌ0    Y  d S )NÚ
AUTOCOMMIT©Zisolation_levelzselect current_database()r   zCREATE DATABASE %s TEMPLATE %sé   r   zaccessed by other userszFWaiting to create %s, URI %r, template DB %s is in use sleeping for .5g      à?)ÚoptionsZpostgresql_templatedbÚexecution_optionsÚbeginÚexec_driver_sqlZscalarr   ZOperationalErrorÚstrr   ÚinfoÚurlÚtimeÚsleep)ÚcfgÚengÚidentZtemplate_dbÚconnÚattemptÚerr© r$   úg/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/dialects/postgresql/provision.pyÚ_pg_create_db   s4    ÿ
ÿûr&   c              	   C   s€   |  ¡ jdd��\}| ¡ �4 | tdƒt|d�¡ | d| ¡ W d   ƒ n1 sT0    Y  W d   ƒ n1 sr0    Y  d S )Nr   r   z€select pg_terminate_backend(pid) from pg_stat_activity where usename=current_user and pid != pg_backend_pid() and datname=:dname)ZdnamezDROP DATABASE %s)Úconnectr   r   Úexecuter   Údictr   )r   r   r    r!   r$   r$   r%   Ú_pg_drop_db>   s    
ÿúr*   c                 C   s
   ddgiS )NÚprefixesÚ	TEMPORARYr$   )r   r   r$   r$   r%   Ú#_postgresql_temp_table_keyword_argsM   s    r-   c                 C   s4   |j }d|_ | ¡ }| d| ¡ | ¡  ||_ d S )NTzSET SESSION search_path='%s')Z
autocommitÚcursorr(   Úclose)r   Zdbapi_connectionZschema_nameZexisting_autocommitr.   r$   r$   r%   Ú,_postgresql_set_default_schema_on_connectionR   s    r0   c                 C   sZ   |  ¡ jdd��6}| d¡ ¡ D ]}|jj||dd� q W d   ƒ n1 sL0    Y  d S )Nr   r   zESELECT gid FROM pg_prepared_xacts WHERE database = current_database()T)Zrecover)r'   r   r   ZscalarsÚdialectZdo_rollback_twophase)r   r   r!   Úxidr$   r$   r%   r	   ^   s
    ÿr	   c              
   C   sr   ddl m} t|ƒ}| ¡ �B}| d¡D ]&}| | |j|d |d d�¡¡ q(W d   ƒ n1 sd0    Y  d S )Nr   )r   Ú*ÚnameÚschema)r4   r5   )Zsqlalchemy.dialectsr   r   r   Z	get_enumsr(   ZDropEnumTypeZENUM)r   r   r   Z	inspectorr!   Úenumr$   r$   r%   r   h   s    
ÿÿr   c                 C   s6   |  d¡}| ¡ }|r2tdd dd„ |D ƒ¡ ƒ dS )z;Ensure there are no locks on the current username/database.zµselect pid, state, wait_event_type, query from pg_stat_activity where usename=current_user and datname=current_database() and state='idle in transaction' and pid != pg_backend_pid()zHPostgreSQL may not be able to DROP tables due to idle in transaction: %sz; c                 s   s   | ]}|j d  V  qdS )ÚqueryN)Ú_mapping)Ú.0Úrowr$   r$   r%   Ú	<genexpr>‡   ó    z*prepare_for_drop_tables.<locals>.<genexpr>N)r   Úallr   Újoin)ÚconfigÚ
connectionÚresultÚrowsr$   r$   r%   r   v   s    ÿþÿr   F)Ú
set_lambdaÚsort_by_parameter_orderÚindex_elementsc          	      C   sb   ddl m} ||ƒ}t|ƒj}|rF|d u r0|j}|j|||jƒd�}n| ¡ }|j|d|iŽ}|S )Nr   )Úinsert)rE   Úset_rD   )	Zsqlalchemy.dialects.postgresqlrF   r   Z
selectableZprimary_keyZon_conflict_do_updateZexcludedZon_conflict_do_nothingÚ	returning)	r   ÚtablerH   rC   rD   rE   rF   ÚstmtZtable_pkr$   r$   r%   Ú_upsert‹   s     


ÿÿÿrK   )Zcitext©é   )ZhstorerL   c                 C   sb   |  ¡ �F}tD ]0\}}|jj|kr| td|› �ƒ¡ | ¡  qW d   ƒ n1 sT0    Y  d S )NzCREATE EXTENSION IF NOT EXISTS )r'   Ú_extensionsr1   Zserver_version_infor(   r   Úcommit)r   ZengineZfollower_identr!   Ú	extensionÚmin_versionr$   r$   r%   Ú_create_citext_extension°   s    
ÿrR   )r   Ú r   r   r   Ztestingr   Ztesting.provisionr   r   r	   r
   r   r   r   r   r   r   Zfor_dbr&   r*   r-   r0   rK   rN   rR   r$   r$   r$   r%   Ú<module>	   sL   
"



	

ùþ