a
    8gf4                     @  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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rd
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 d6ddZ!G dd dZ"d7d d!Z#ej$d8d#d$d%d&d'd(d)d*Z%ej$d9d#d$d,d&d-d(d.d*Z%d:d/d*Z%d;d0d1Z&G d2d3 d3Z'G d4d5 d5Z(dS )<    )annotationsN)Any)Dict)Optional   )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#S )$ConnectionKillerc                 C  s"   t  | _tt| _t | _d S N)weakrefWeakKeyDictionary
proxy_refscollectionsdefaultdictsettesting_enginesdbapi_connectionsself r   w/var/www/vosh/data/www/fastworkle.ru/webshop-tgbot-v.1.0/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_validr7   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   )
r8   r   r9   r   r(   dbapi_connectionr7   _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 rE   prepare_for_drop_tablesr-   url)r   
connectionrE   r   r   r   rH   ^   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   r8   r   r9   _poolr   r7   r?   hasattrr   disposer@   )r   r.   Zengr<   Z	proxy_refr   r   r   _drop_testing_enginesg   s    



z&ConnectionKiller._drop_testing_enginesc                 C  s   |  d d S )Nr,   )rO   r   r   r   r   
after_testx   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   rF   	__class__Z"__leave_connections_for_teardown__rB   rG   rE   dbconnectrH   r-   rI   )r   testrE   connr   r   r   after_test_outside_fixtures{   s    z,ConnectionKiller.after_test_outside_fixturesc                 C  s    |    | d | d d S )Nr,   r*   )rB   rO   r   r   r   r   stop_test_class_inside_fixtures   s    
z0ConnectionKiller.stop_test_class_inside_fixturesc                 C  sB   t jjr>t  t jjr>tt jj}t jj  ds>J d| d S )NFz/%d connection recs not cleared after test suite)r   baseZ_strong_ref_connection_recordsr	   lenr@   )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   rO   )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   r9   r;   r   r   r   assert_all_closed   s    
z"ConnectionKiller.assert_all_closedN)__name__
__module____qualname__r    r&   r$   r%   r/   r7   r=   rB   rC   rH   rO   rP   rV   rW   r[   r\   r^   r   r   r   r   r   $   s"   	r   c                 O  s*   z| |i | W t   n
t   0 d S r   )testing_reaperr^   r5   argskwr   r   r   assert_conns_closed   s    rf   c                 O  s*   z| |i | W t   n
t   0 dS )zBDecorator that rolls back all open connections after fn execution.N)rb   r=   rc   r   r   r   rollback_open_connections   s    rg   c                 O  s   t   | |i | dS )z:Decorator that closes all connections before fn execution.Nrb   rB   rc   r   r   r   close_first   s    ri   c                 O  s*   z| |i | W t   n
t   0 dS )z9Decorator that closes all connections after fn execution.Nrh   rc   r   r   r   close_open_connections   s    rj   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    
rs   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 r]   )dbapiconnections
is_stopped)r   ru   r   r   r   r       s    zReconnectFixture.__init__c                 C  s   t | j|S r   )rl   ru   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)	ru   rS   rw   r7   r"   cursorexecuterv   append)r   rd   kwargsrU   Zcursr   r   r   rS      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: %sr0   r4   r   r   r   r7      s    
zReconnectFixture._safeFc                 C  s,   || _ t| jD ]}| |j qg | _d S r   )rw   r8   rv   r7   r"   )r   stopcr   r   r   shutdown   s    zReconnectFixture.shutdownc                 C  s
   d| _ d S r]   )rw   r   r   r   r   restart  s    zReconnectFixture.restartN)F)	r_   r`   ra   r    rz   rS   r7   r   r   r   r   r   r   rt      s   
rt   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 r]   )rn   ru   r   rw   r   Z_disposer-   r   r   rN     s    
z$reconnecting_engine.<locals>.dispose)r   rR   rI   rn   ru   rt   testing_enginerN   r   Ztest_shutdownr   Ztest_restart)rI   optionsru   rN   r   r   r   reconnecting_engine
  s    

r   FzOptional[URL]zOptional[Dict[str, Any]]zLiteral[False]boolr   )rI   r   asynciotransfer_staticpoolreturnc                 C  s   d S r   r   rI   r   r   r   r   r   r   r     s    r   TzLiteral[True]r   c                 C  s   d S r   r   r   r   r   r   r   '  s    c                 C  s  |r|rJ ddl m} nddlm} ddlm} |sDd}d}	d}
n$|dd}|d	d}	|d
d}
| prtjj	} || } tjd u s| j
tjj	j
krtjrtj }ni }|d ur|| || fi |}|
r|jdkrt|ddd }t|ddd }|rLddlm} tjd ur\ttjj|r\d}|jtjj n|r\tjj|_|	dkr||rvd|j_nd|_t|jtjrd|vrd|vrd|vrd|j_d|j_|rt||	 |S )Nr   )create_async_engine)create_engine)make_urlTr,   F
use_reaperr.   sqlite_savepointZsqliterS   c                 S  s
   d | _ d S r   )Zisolation_level)r>   Zconnection_recordr   r   r   
do_connect\  s    z"testing_engine.<locals>.do_connectbeginc                 S  s   |  d d S )NZBEGIN)Zexec_driver_sql)rU   r   r   r   do_begin`  s    z testing_engine.<locals>.do_begin)
StaticPoolr+   r   pool_timeoutZmax_overflow)Zsqlalchemy.ext.asyncior   
sqlalchemyr   Zsqlalchemy.engine.urlr   popr   rR   rI   Z
drivernameZdb_optscopyupdaterq   r   Zlistens_forZsqlalchemy.poolr   
isinstancer   Z_transfer_fromrK   Z_has_eventsZ	QueuePool_timeoutZ_max_overflowrb   r/   )rI   r   r   r   Z
share_poolZ_sqlite_savepointr   r   r   r.   r   Zuse_optionsr-   r   r   r   r   r   r   r   0  sn    







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are   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]rG   )resubstr.0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 ))rn   N)r   compiler   rp   r   r   	<genexpr>  r   z1mock_engine.<locals>.print_sql.<locals>.<genexpr>)rn   joinmockr   )r-   r   r   	print_sql  s    zmock_engine.<locals>.print_sqlz://r   )	r   r   r   rR   rq   rM   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-   rJ   r{   )r   r-   rU   rd   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
parametersre   r   r   r   r|     s    zDBAPIProxyCursor.executec                 K  s   | j j||fi |S r   )r{   executemany)r   r   paramsre   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   )rl   r{   rx   r   r   r   rz     s    zDBAPIProxyCursor.__getattr__)N)	r_   r`   ra   __doc__r    r|   r   r   rz   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   )rU   r-   
cursor_cls)r   r-   rU   r   r   r   r   r      s    zDBAPIProxyConnection.__init__c                 O  s   | j | j| jg|R i |S r   )r   r-   rU   )r   rd   r~   r   r   r   r{     s    zDBAPIProxyConnection.cursorc                 C  s   | j   d S r   )rU   r"   r   r   r   r   r"     s    zDBAPIProxyConnection.closec                 C  s   t | j|S r   )rl   rU   rx   r   r   r   rz     s    z DBAPIProxyConnection.__getattr__N)r_   r`   ra   r   r    r{   r"   rz   r   r   r   r   r     s
   r   )N)NN)NNFF)NNTF)NNFFFF)N))
__future__r   r   r   typingr   r   r   r2   r   rG   r   utilr   r	   r   r   r   Zutil.typingr   TYPE_CHECKINGr-   r   Z
engine.urlr   Zext.asyncior   r   rb   rf   rg   ri   rj   rs   rt   r   overloadr   r   r   r   r   r   r   r   <module>
   sn    

	


+
        	      
S
&