a
    •˜ëj96  ã                   @  sÆ  d dl mZ d dlZ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	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 ejrâddlmZ ddlmZ ddlmZ G dd„ dƒZeƒ Zedd„ ƒZedd„ ƒZedd„ ƒZ edd„ ƒZ!d9dd„Z"G dd „ d ƒZ#d:d!d"„Z$ej%d;d$d%d&d'd(œd)d*„ƒZ&ej%d<d$d%d+d,d(œd-d*„ƒZ&d=d.d/œd$d%d0d1d(œd2d*„Z&d>d3d4„Z'G d5d6„ d6ƒZ(G d7d8„ d8ƒZ)dS )?é    )ÚannotationsN)ÚAny)ÚDict)ÚOptional)ÚUnioné   )Úconfig)Ú	decorator)Ú
gc_collecté   )Úevent)Úpool)Ú
await_only)ÚLiteral)ÚEngine)ÚURL)ÚAsyncEnginec                   @  sœ   e Zd Zdd„ Zdd„ Zdd„ Zdd„ Zd	d
„ Zdd„ Zdd„ Z	dd„ Z
dd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd „ Zd!d"„ Zd#d$„ Zd%S )&ÚConnectionKillerc                 C  s"   t  ¡ | _t t¡| _tƒ | _d S ©N)ÚweakrefÚWeakKeyDictionaryÚ
proxy_refsÚcollectionsÚdefaultdictÚsetÚtesting_enginesÚdbapi_connections©Úself© r   úY/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/testing/engines.pyÚ__init__%   s    
zConnectionKiller.__init__c                 C  sD   t  |d| j¡ t  |d| j¡ t  |d| j¡ t  |d| j¡ d S )NÚcheckoutZcheckinÚcloseZclose_detached)r   ÚlistenÚ	_add_connÚ_remove_conn)r   r   r   r   r    Úadd_pool*   s    zConnectionKiller.add_poolc                 C  s   | j  |¡ d| j|< d S )NT)r   Úaddr   )r   Z	dbapi_conZ
con_recordZ	con_proxyr   r   r    r%   2   s    zConnectionKiller._add_connc                 G  s   | j  |¡ d S r   )r   Údiscard)r   Z
dbapi_connÚargr   r   r    r&   6   s    zConnectionKiller._remove_connc                 C  s,   |   |j¡ |dv sJ ‚| j|  |¡ d S )N)ÚclassÚglobalÚfunctionZfixture)r'   r   r   r(   )r   ÚengineÚscoper   r   r    Ú
add_engine9   s    zConnectionKiller.add_enginec              
   C  sB   z
|ƒ  W n2 t y< } zt d| ¡ W Y d }~n
d }~0 0 d S )Nz5testing_reaper couldn't rollback/close connection: %s©Ú	ExceptionÚwarningsÚwarn©r   ÚfnÚer   r   r    Ú_safe?   s    
ÿzConnectionKiller._safec                 C  s.   t | jƒD ]}|d ur
|jr
|  |j¡ q
d S r   )Úlistr   Úis_validr8   Úrollback©r   Úrecr   r   r    Úrollback_allG   s    zConnectionKiller.rollback_allc                 C  s^   t | jƒD ],}|d ur
|jr
| j |j¡ |  |j¡ q
| jD ]}|  |j¡ q>| j 	¡  d S r   )
r9   r   r:   r   r)   Zdbapi_connectionr8   Ú_checkinr;   Úclear)r   r=   Úconr   r   r    Úcheckin_allL   s    
zConnectionKiller.checkin_allc                 C  s   |   ¡  d S r   )rB   r   r   r   r    Ú	close_all[   s    zConnectionKiller.close_allc                 C  s*   t js
d S ddlm} | |jj|¡ d S ©Nr   ©Ú	provision)r   Úbootstrapped_as_sqlalchemyÚ rF   Úprepare_for_drop_tablesr.   Úurl)r   Ú
connectionrF   r   r   r    rI   ^   s    z(ConnectionKiller.prepare_for_drop_tablesc                 C  s„   | j | }t|ƒD ]d}t| jƒD ]4}|d ur |jr |jd ur |j|ju r |  |j¡ q t|dƒrnt	| 
¡ ƒ q| 
¡  q| ¡  d S ©NÚsync_engine)r   r9   r   r:   Ú_poolr   r8   r?   Úhasattrr   Údisposer@   )r   r/   Úengr=   Z	proxy_refr   r   r    Ú_drop_testing_enginesg   s    
ÿ
þ

z&ConnectionKiller._drop_testing_enginesc                 C  s<   | j | }t|ƒD ]$}t|dƒr.t| ¡ ƒ q| ¡  qd S rL   )r   r9   rO   r   rP   )r   r/   rQ   r=   r   r   r    Ú_dispose_testing_enginesy   s
    

z)ConnectionKiller._dispose_testing_enginesc                 C  s   |   d¡ d S )Nr-   )rR   r   r   r   r    Ú
after_test�   s    zConnectionKiller.after_testc                 C  sh   t js
d S |jjrd S |  ¡  ddlm} t j ¡ � }| 	|j
j|¡ W d   ƒ n1 sZ0    Y  d S rD   )r   rG   Ú	__class__Z"__leave_connections_for_teardown__rB   rH   rF   ÚdbÚconnectrI   r.   rJ   )r   ÚtestrF   Úconnr   r   r    Úafter_test_outside_fixtures„   s    z,ConnectionKiller.after_test_outside_fixturesc                 C  s    |   ¡  |  d¡ |  d¡ d S )Nr-   r+   )rB   rR   r   r   r   r    Ústop_test_class_inside_fixtures–   s    
z0ConnectionKiller.stop_test_class_inside_fixturesc                 C  sb   t jjrFtƒ  t jjrFtt jjƒ}t jj ¡  |dkrFdsFJ d| ƒ‚tjr^tjjr^|  	d¡ d S )Nr   Fz/%d connection recs not cleared after test suiter,   )
r   ÚbaseZ_strong_ref_connection_recordsr
   Úlenr@   r   ÚoptionsÚlow_connectionsrS   )r   Úlnr   r   r    Ú stop_test_class_outside_fixtures›   s    ÿþz1ConnectionKiller.stop_test_class_outside_fixturesc                 C  s"   |   ¡  | jD ]}|  |¡ qd S r   )rB   r   rR   )r   r/   r   r   r    Úfinal_cleanup±   s    
zConnectionKiller.final_cleanupc                 C  s   | j D ]}|jrdsJ ‚qd S ©NF)r   r:   r<   r   r   r    Úassert_all_closed¶   s    
z"ConnectionKiller.assert_all_closedN)Ú__name__Ú
__module__Ú__qualname__r!   r'   r%   r&   r0   r8   r>   rB   rC   rI   rR   rS   rT   rZ   r[   ra   rb   rd   r   r   r   r    r   $   s$   	r   c                 O  s*   z| |i |¤Ž W t  ¡  n
t  ¡  0 d S r   )Útesting_reaperrd   ©r6   ÚargsÚkwr   r   r    Úassert_conns_closed¿   s    rl   c                 O  s*   z| |i |¤Ž W t  ¡  n
t  ¡  0 dS )zBDecorator that rolls back all open connections after fn execution.N)rh   r>   ri   r   r   r    Úrollback_open_connectionsÇ   s    rm   c                 O  s   t  ¡  | |i |¤Ž dS )z:Decorator that closes all connections before fn execution.N©rh   rB   ri   r   r   r    Úclose_firstÑ   s    ro   c                 O  s*   z| |i |¤Ž W t  ¡  n
t  ¡  0 dS )z9Decorator that closes all connections after fn execution.Nrn   ri   r   r   r    Úclose_open_connectionsÙ   s    rp   c                 c  sX   dd l m} |jD ]@}| r$|| v r$qt||d ƒ}|sHttd| ƒj|ƒ}| ¡ V  qd S )Nr   zsqlalchemy.dialects.%s)Zsqlalchemy.dialectsZdialectsÚ__all__ÚgetattrÚ
__import__Údialect)ÚexcludeÚdÚnameÚmodr   r   r    Úall_dialectsâ   s    
ÿry   c                   @  s>   e Zd Zdd„ Zdd„ Zdd„ Zdd„ Zdd
d„Zdd„ ZdS )ÚReconnectFixturec                 C  s   || _ g | _d| _d S rc   )ÚdbapiÚconnectionsÚ
is_stopped)r   r{   r   r   r    r!   ò   s    zReconnectFixture.__init__c                 C  s   t | j|ƒS r   )rr   r{   ©r   Úkeyr   r   r    Ú__getattr__÷   s    zReconnectFixture.__getattr__c                 O  sX   | j j|i |¤Ž}| jrD|  |j¡ | ¡ }| d¡ dsTJ dƒ‚n| j |¡ |S d S )Nzselect 1Fz%simulated connect failure didn't work)	r{   rW   r}   r8   r#   ÚcursorÚexecuter|   Úappend)r   rj   ÚkwargsrY   Zcursr   r   r    rW   ú   s    
zReconnectFixture.connectc              
   C  sB   z
|ƒ  W n2 t y< } zt d| ¡ W Y d }~n
d }~0 0 d S )Nz.ReconnectFixture couldn't close connection: %sr1   r5   r   r   r    r8     s    
zReconnectFixture._safeFc                 C  s,   || _ t| jƒD ]}|  |j¡ qg | _d S r   )r}   r9   r|   r8   r#   )r   ÚstopÚcr   r   r    Úshutdown  s    zReconnectFixture.shutdownc                 C  s
   d| _ d S rc   )r}   r   r   r   r    Úrestart  s    zReconnectFixture.restartN)F)	re   rf   rg   r!   r€   rW   r8   r‡   rˆ   r   r   r   r    rz   ñ   s   
rz   c                   sj   | p
t jj} t jjj}|si }t|ƒ|d< t| |ƒ‰ˆj‰ ‡ ‡fdd„}ˆjjjˆ_	ˆjjj
ˆ_|ˆ_ˆS )NÚmodulec                     s    ˆj j ¡  dˆj j_ˆ ƒ  d S rc   )rt   r{   r‡   r}   r   ©Z_disposer.   r   r    rP   %  s    
z$reconnecting_engine.<locals>.dispose)r   rV   rJ   rt   r{   rz   Útesting_enginerP   r‡   Ztest_shutdownrˆ   Ztest_restart)rJ   r^   r{   rP   r   rŠ   r    Úreconnecting_engine  s    

rŒ   .zOptional[URL]zOptional[Dict[str, Any]]zLiteral[False]r   )rJ   r^   ÚasyncioÚreturnc                C  s   d S r   r   ©rJ   r^   r�   r   r   r    r‹   0  s    r‹   zLiteral[True]r   c                C  s   d S r   r   r�   r   r   r    r‹   9  s    F)r�   ÚboolzUnion[Engine, AsyncEngine]c                C  sF  |rddl m} nddlm} ddlm} || r4| ntjjƒ} |sFi }i }tj	|fD ]"}|s^qT| 
dd„ | ¡ D ƒ¡ qT|| fi |¤Ž}tjr tjjr t d¡ | dd	¡}|dkrÈ|rÂd
|j_nd
|_ddlm}	 |	 |j|||¡ | dd
¡}
|
�rt ||¡ t|jtjƒ�rBd|v�rBd|v�rBd|v�rBd|j_d|j_|S )Nr   )Úcreate_async_engine)Úcreate_engine)Úmake_urlc                 S  s(   i | ] \}}|d vr|  d¡s||“qS ))r/   Ú
use_reaperZsqlite_)Ú
startswith)Ú.0ÚoptÚvaluer   r   r    Ú
<dictcomp>\  s   
ýz"testing_engine.<locals>.<dictcomp>r,   r/   r-   Tr   rE   r”   r   Úpool_timeoutZmax_overflow)Zsqlalchemy.ext.asyncior‘   Ú
sqlalchemyr’   Zsqlalchemy.engine.urlr“   r   rV   rJ   Zdb_optsÚupdateÚitemsr^   r_   rh   rS   ÚgetrM   Z_has_eventsrH   rF   Zpost_configure_testing_enginer0   Ú
isinstancer   Z	QueuePoolÚ_timeoutZ_max_overflow)rJ   r^   r�   r’   r“   Zuse_optionsÚopt_dictr.   r/   rF   r”   r   r   r    r‹   B  sR    þÿ	

ÿÿþýüc                   sr   ddl m} | stjj} g ‰ ‡ fdd„}‡ fdd„}‡fdd„}|| d	 |ƒ‰tˆd
ƒr\J ‚ˆ ˆ_|ˆ_|ˆ_ˆS )a'  Provides a mocking engine based on the current testing.db.

    This is normally used to test DDL generation flow as emitted
    by an Engine.

    It should not be used in other cases, as assert_compile() and
    assert_sql_execution() are much better choices with fewer
    moving parts.

    r   )Úcreate_mock_enginec                   s   ˆ   | ¡ d S r   )rƒ   )ZsqlÚark   ©Úbufferr   r    Úexecutorž  s    zmock_engine.<locals>.executorc                   s"   dd„ ˆ D ƒ}|| ksJ |ƒ‚d S )Nc                 S  s   g | ]}t  d dt|ƒ¡‘qS )z[\n\t]rH   )ÚreÚsubÚstr©r–   Úsr   r   r    Ú
<listcomp>¢  ó    z3mock_engine.<locals>.assert_sql.<locals>.<listcomp>r   )ZstmtsÚrecvr¤   r   r    Ú
assert_sql¡  s    zmock_engine.<locals>.assert_sqlc                     s    ˆj ‰ d ‡ fdd„ˆjD ƒ¡S )NÚ
c                 3  s   | ]}t |jˆ d �ƒV  qdS ))rt   N)r©   Úcompilerª   ©rv   r   r    Ú	<genexpr>§  r­   z1mock_engine.<locals>.print_sql.<locals>.<genexpr>)rt   ÚjoinÚmockr   )r.   r²   r    Ú	print_sql¥  s    zmock_engine.<locals>.print_sqlz://rµ   )	r›   r¢   r   rV   rw   rO   rµ   r¯   r¶   )Zdialect_namer¢   r¦   r¯   r¶   r   )r¥   r.   r    Úmock_engine‹  s    r·   c                   @  s:   e Zd ZdZdd„ Zddd„Zdd„ Zd	d
„ Zdd„ ZdS )ÚDBAPIProxyCursorzuProxy a DBAPI cursor.

    Tests can provide subclasses of this to intercept
    DBAPI-level cursor operations.

    c                 O  s"   || _ || _|j|i |¤Ž| _d S r   )r.   rK   r�   )r   r.   rY   rj   r„   r   r   r    r!   ¹  s    zDBAPIProxyCursor.__init__Nc                 K  s2   |r| j j||fi |¤ŽS | j j|fi |¤ŽS d S r   )r�   r‚   )r   ÚstmtÚ
parametersrk   r   r   r    r‚   ¾  s    zDBAPIProxyCursor.executec                 K  s   | j j||fi |¤ŽS r   )r�   Úexecutemany)r   r¹   Úparamsrk   r   r   r    r»   Ä  s    zDBAPIProxyCursor.executemanyc                 C  s
   t | jƒS r   )Úiterr�   r   r   r   r    Ú__iter__Ç  s    zDBAPIProxyCursor.__iter__c                 C  s   t | j|ƒS r   )rr   r�   r~   r   r   r    r€   Ê  s    zDBAPIProxyCursor.__getattr__)N)	re   rf   rg   Ú__doc__r!   r‚   r»   r¾   r€   r   r   r   r    r¸   ±  s   
r¸   c                   @  s0   e Zd ZdZdd„ Zdd„ Zdd„ Zdd	„ Zd
S )ÚDBAPIProxyConnectionz}Proxy a DBAPI connection.

    Tests can provide subclasses of this to intercept
    DBAPI-level connection operations.

    c                 C  s   || _ || _|| _d S r   )rY   r.   Ú
cursor_cls)r   r.   rY   rÁ   r   r   r    r!   Ö  s    zDBAPIProxyConnection.__init__c                 O  s   | j | j| jg|¢R i |¤ŽS r   )rÁ   r.   rY   )r   rj   r„   r   r   r    r�   Û  s    zDBAPIProxyConnection.cursorc                 C  s   | j  ¡  d S r   )rY   r#   r   r   r   r    r#   Þ  s    zDBAPIProxyConnection.closec                 C  s   t | j|ƒS r   )rr   rY   r~   r   r   r    r€   á  s    z DBAPIProxyConnection.__getattr__N)re   rf   rg   r¿   r!   r�   r#   r€   r   r   r   r    rÀ   Î  s
   rÀ   )N)NN)..)..)NN)N)*Ú
__future__r   r   r§   Útypingr   r   r   r   r3   r   rH   r   Úutilr	   r
   r   r   r   Zutil.typingr   ÚTYPE_CHECKINGr.   r   Z
engine.urlr   Zext.asyncior   r   rh   rl   rm   ro   rp   ry   rz   rŒ   Úoverloadr‹   r·   r¸   rÀ   r   r   r   r    Ú<module>
   sd    

	


+
  þ  þ	  þüI
&