a
    •˜ëj6  ã                   @   sž  d dl Z 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 h 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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*dd+œd,d-„ƒZ!dS ).é    Né   ©Úevent)Úexc)Úurl)Úconfig)Ú	create_db)Údrop_db)Úfollower_url_from_main)Úgenerate_driver_url)Úlog)Úpost_configure_engine)Úpost_configure_testing_engine)Úrun_reap_dbs)Ú stop_test_class_outside_fixtures)Útemp_table_keyword_args)Úupsert>   ZpysqliteZ	aiosqliteÚpysqlcipherZpysqlite_dollarZpysqlite_numericc           	      C   s
  t  | ¡} |du r|  ¡ }| j}|dk}d}|rä|dkräd|vsDJ ‚t d|¡}|D ]:}|tv rp|du rT|}qTqT|dv r|qTqT|du rT| d¡}qT|s¤J d| j› �ƒ‚|› d|› �}|rÄ|d|› �7 }|d	7 }|rØ|d
7 }| j|d�} |rô| jdd�} | jd|f d�} | S )zUgiven a sqlite url + desired driver + ident, make a canonical
    URL out of it

    Nr   ú:memory:Ztest_schemaz[_\.])ÚdbÚencÚ_z#sqlite filename has no name token: ú.dbz.enc)ÚdatabaseÚtest)Úpasswordz	sqlite+%s)Ú
drivername)	Úsa_urlÚmake_urlZget_driver_namer   ÚreÚsplitÚ_drivernamesÚstripÚset)	r   ÚdriverÚidentÚfilenameZ	needs_encZ
name_tokenÚtokensÚtokenZnew_filename© r)   úc/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/dialects/sqlite/provision.pyÚ_format_url&   s<    
r+   Úsqlitec                 C   s8   t | |d ƒ} z|  ¡  W n tjy.   Y d S 0 | S d S ©N)r+   Úget_dialectr   ZNoSuchModuleError)r   r$   Z	query_strr)   r)   r*   r   U   s    r   c                 C   s   t | d |ƒS r-   )r+   )r   r%   r)   r)   r*   Ú_sqlite_follower_url_from_maina   s    r/   c                    sd   ddl m} |r$|› d|j› d�‰ n|j› d�‰ | |d¡‡ fdd„ƒ}| |d¡‡ fd	d
„ƒ}d S )Nr   r   r   z_test_schema.dbÚconnectc                    s   |   dˆ › d�¡ d S )NzATTACH DATABASE "z" AS test_schema)Úexecute©Zdbapi_connectionZconnection_record©Zattach_pathr)   r*   r0   o   s    

ÿz._sqlite_post_configure_engine.<locals>.connectZengine_disposedc                    sD   t j ˆ ¡rt  ˆ ¡ | jj}|r@|dkr@t j |¡r@t  |¡ dS )z¼most databases should be dropped using
        stop_test_class_outside_fixtures

        however a few tests like AttachedDBTest might not get triggered on
        that main hook

        r   N)ÚosÚpathÚexistsÚremover   r   )Úenginer&   r3   r)   r*   Údispose}   s
    

z._sqlite_post_configure_engine.<locals>.dispose)Z
sqlalchemyr   r$   Úlistens_for)r   r8   Zfollower_identr   r0   r9   r)   r3   r*   Ú_sqlite_post_configure_enginef   s    

r;   c                 C   sz   |  dd¡}|  dd¡}|rN|jdkrNt |d¡dd„ ƒ}t |d¡d	d
„ ƒ}|rvt|jdƒrvd|d< |j tjj¡ d S )NÚsqlite_savepointFÚsqlite_share_poolr,   r0   c                 S   s
   d | _ d S r-   )Zisolation_levelr2   r)   r)   r*   Ú
do_connect˜   s    z9_sqlite_post_configure_testing_engine.<locals>.do_connectÚbeginc                 S   s   |   d¡ d S )NZBEGIN)Zexec_driver_sql)Úconnr)   r)   r*   Údo_beginœ   s    z7_sqlite_post_configure_testing_engine.<locals>.do_beginÚ_transfer_fromZ
use_reaper)	ÚgetÚnamer   r:   ÚhasattrÚpoolrB   r   r   )r   r8   ÚoptionsZscoper<   r=   r>   rA   r)   r)   r*   Ú%_sqlite_post_configure_testing_engine�   s    



rH   c                 C   s   d S r-   r)   ©ÚcfgÚengr%   r)   r)   r*   Ú_sqlite_create_db©   s    rL   c                 C   s   t |jj|j|ƒ d S r-   )Ú_drop_dbs_w_identr   r   r$   rI   r)   r)   r*   Ú_sqlite_drop_db®   s    rN   c                 C   sJ   t  d¡D ]:}t j |¡\}}||v r
|dv r
t d|¡ t  |¡ q
d S )NÚ.)r   z.db.encz!deleting SQLite database file: %s)r4   Úlistdirr5   r    r   Úinfor7   )Zdatabasenamer$   r%   r5   ÚfnameÚextr)   r)   r*   rM   ³   s
    rM   c                 C   s   |  ¡  d S r-   )r9   )r   r   Úclsr)   r)   r*   r   »   s    r   c                 C   s
   ddgiS )NÚprefixesÚ	TEMPORARYr)   )rJ   rK   r)   r)   r*   Ú_sqlite_temp_table_keyword_argsÀ   s    rW   c                 C   sN   t  d| ¡ t  dd |¡¡ t | ¡} |D ]}tD ]}t| j||ƒ q4q,d S )Nzdb reaper connecting to %rzidentifiers in file: %sz, )r   rQ   Újoinr   r   r!   rM   r   )r   Zidentsr%   r   r)   r)   r*   Ú_reap_sqlite_dbsÅ   s    
rY   F)Ú
set_lambdaÚsort_by_parameter_orderÚindex_elementsc                C   sH   ddl m} ||ƒ}|r,|j||jƒd�}n| ¡ }|j|d|iŽ}|S )Nr   )Úinsert)Úset_r[   )Zsqlalchemy.dialects.sqliter]   Zon_conflict_do_updateZexcludedZon_conflict_do_nothingÚ	returning)rJ   Útabler_   rZ   r[   r\   r]   Ústmtr)   r)   r*   Ú_upsertÏ   s    
ÿÿrb   )"r4   r   Ú r   r   r8   r   r   Ztestingr   Ztesting.provisionr   r	   r
   r   r   r   r   r   r   r   r   r!   r+   Zfor_dbr/   r;   rH   rL   rN   rM   rW   rY   rb   r)   r)   r)   r*   Ú<module>	   sT   	/


)





	ù