a
    •˜ëj3  ã                   @  s¨  d Z 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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�r*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  G dd„ deƒZ!G dd„ deƒZ"G dd„ dƒZ#G d d!„ d!ƒZ$G d"d#„ d#e$ƒZ%G d$d%„ d%eƒZ&G d&d'„ d'e&ƒZ'G d(d)„ d)ƒZ(dS )*z?generic asyncio-adapted versions of DBAPI connection and cursoré    )ÚannotationsN)ÚAny)ÚAsyncIterator)ÚDeque)ÚIterator)ÚNoReturn)ÚOptional)ÚSequence)ÚTuple)ÚType)ÚTYPE_CHECKINGé   )ÚAdaptedConnection)Ú
EMPTY_DICT)Úawait_fallback)Ú
await_only)Úin_greenlet)ÚProtocol)Ú_DBAPICursorDescription)Ú_DBAPIMultiExecuteParams)Ú_DBAPISingleExecuteParams)ÚDBAPIModule)ÚSelfc                   @  s`   e Zd ZdZddœdd„Zddddœd	d
„Zddœdd„Zdddœdd„Zddddœdd„ZdS )ÚAsyncIODBAPIConnectionz^protocol representing an async adapted version of a
    :pep:`249` database connection.


    ÚNone©Úreturnc                 Ã  s   d S ©N© ©Úselfr   r   ú\/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/connectors/asyncio.pyÚcommit3   ó    zAsyncIODBAPIConnection.commitr   ÚAsyncIODBAPICursor)ÚargsÚkwargsr   c                 O  s   d S r   r   )r    r%   r&   r   r   r!   Úcursor5   r#   zAsyncIODBAPIConnection.cursorc                 Ã  s   d S r   r   r   r   r   r!   Úrollback7   r#   zAsyncIODBAPIConnection.rollbackÚstr©Úkeyr   c                 C  s   d S r   r   ©r    r+   r   r   r!   Ú__getattr__9   r#   z"AsyncIODBAPIConnection.__getattr__)r+   Úvaluer   c                 C  s   d S r   r   )r    r+   r.   r   r   r!   Ú__setattr__;   r#   z"AsyncIODBAPIConnection.__setattr__N)	Ú__name__Ú
__module__Ú__qualname__Ú__doc__r"   r'   r(   r-   r/   r   r   r   r!   r   )   s   	r   c                   @  s  e Zd ZU dZddœdd„Zeddœdd„ƒZed	dœd
d„ƒZd	ed< d	ed< ddœdd„Z	d4ddddœdd„Z
ddddœdd„Zddœdd„Zd5dddœd d!„Zddœd"d#„Zddd$œd%d&„Zdddd'œd(d)„Zd6d*ddd+œd,d-„Zd.dœd/d0„Zd1dœd2d3„ZdS )7r$   zZprotocol representing an async adapted version
    of a :pep:`249` database cursor.


    r   r   c                 C  s   d S r   r   r   r   r   r!   Ú
__aenter__E   r#   zAsyncIODBAPICursor.__aenter__r   c                 C  s   dS )z(The description attribute of the Cursor.Nr   r   r   r   r!   ÚdescriptionG   s    zAsyncIODBAPICursor.descriptionÚintc                 C  s   d S r   r   r   r   r   r!   ÚrowcountN   s    zAsyncIODBAPICursor.rowcountÚ	arraysizeÚ	lastrowidr   c                 Ã  s   d S r   r   r   r   r   r!   ÚcloseU   r#   zAsyncIODBAPICursor.closeNú#Optional[_DBAPISingleExecuteParams]©Ú	operationÚ
parametersr   c                 Ã  s   d S r   r   ©r    r=   r>   r   r   r!   ÚexecuteW   s    zAsyncIODBAPICursor.executer   c                 Ã  s   d S r   r   r?   r   r   r!   Úexecutemany]   s    zAsyncIODBAPICursor.executemanyúOptional[Any]c                 Ã  s   d S r   r   r   r   r   r!   Úfetchonec   r#   zAsyncIODBAPICursor.fetchone.úOptional[int]úSequence[Any]©Úsizer   c                 Ã  s   d S r   r   ©r    rG   r   r   r!   Ú	fetchmanye   r#   zAsyncIODBAPICursor.fetchmanyc                 Ã  s   d S r   r   r   r   r   r!   Úfetchallg   r#   zAsyncIODBAPICursor.fetchall)Úsizesr   c                 Ã  s   d S r   r   )r    rK   r   r   r!   Úsetinputsizesi   r#   z AsyncIODBAPICursor.setinputsizes)rG   Úcolumnr   c                 C  s   d S r   r   )r    rG   rM   r   r   r!   Úsetoutputsizek   r#   z AsyncIODBAPICursor.setoutputsizer)   )Úprocnamer>   r   c                 Ã  s   d S r   r   )r    rO   r>   r   r   r!   Úcallprocm   s    zAsyncIODBAPICursor.callproczOptional[bool]c                 Ã  s   d S r   r   r   r   r   r!   Únextsetq   r#   zAsyncIODBAPICursor.nextsetzAsyncIterator[Any]c                 C  s   d S r   r   r   r   r   r!   Ú	__aiter__s   r#   zAsyncIODBAPICursor.__aiter__)N).).)r0   r1   r2   r3   r4   Úpropertyr5   r7   Ú__annotations__r:   r@   rA   rC   rI   rJ   rL   rN   rP   rQ   rR   r   r   r   r!   r$   >   s*   
 ý ÿr$   c                   @  s8   e Zd Zer4ejZejZejZejZdddœdd„Z	dS )ÚAsyncAdapt_dbapi_moduler)   r   r*   c                 C  s   d S r   r   r,   r   r   r!   r-   }   r#   z#AsyncAdapt_dbapi_module.__getattr__N)
r0   r1   r2   r   r   ÚErrorZOperationalErrorZInterfaceErrorZIntegrityErrorr-   r   r   r   r!   rU   v   s   rU   c                   @  s°  e Zd ZU dZdZdZded< ded< ded	< d
ed< ded< ddœdd„Zdddœdd„Zd
ddœdd„Z	e
ddœdd„ƒZe
ddœdd„ƒZe
ddœdd„ƒZejdd d!œd"d„ƒZe
ddœd#d$„ƒZd dœd%d&„Zd dœd'd(„ZdOd*d+d*d,œd-d.„Zd*d/d*d0œd1d2„Zd*d+d*d,œd3d4„Zd*d/d*d0œd5d6„Zd dœd7d8„Zd*d d9œd:d;„Zd<dœd=d>„Zd*d*d*d d?œd@dA„ZdBdœdCdD„ZdEdœdFdG„ZdPdHdIdJœdKdL„ZdIdœdMdN„Zd)S )QÚAsyncAdapt_dbapi_cursorF)Ú_adapt_connectionÚ_connectionÚawait_Ú_cursorÚ_rowsÚ_soft_closed_memoizedTÚboolÚ_awaitable_cursor_closer$   r[   ÚAsyncAdapt_dbapi_connectionrX   r   rY   z
Deque[Any]r\   )Úadapt_connectionc                 C  sH   || _ |j| _|j| _|  | j¡}|  |¡| _t| _| jsDt	 
¡ | _d S r   )rX   rY   rZ   Ú_make_new_cursorÚ_aenter_cursorr[   r   r]   Úserver_sideÚcollectionsÚdequer\   )r    ra   r'   r   r   r!   Ú__init__’   s    z AsyncAdapt_dbapi_cursor.__init__)r'   r   c                 C  s   |   | ¡ ¡S r   )rZ   r4   )r    r'   r   r   r!   rc   ž   s    z&AsyncAdapt_dbapi_cursor._aenter_cursor)Ú
connectionr   c                 C  s   |  ¡ S r   )r'   )r    rh   r   r   r!   rb   ¡   s    z(AsyncAdapt_dbapi_cursor._make_new_cursorz!Optional[_DBAPICursorDescription]r   c                 C  s   d| j v r| j d S | jjS )Nr5   )r]   r[   r5   r   r   r   r!   r5   ¦   s    

z#AsyncAdapt_dbapi_cursor.descriptionr6   c                 C  s   | j jS r   )r[   r7   r   r   r   r!   r7   ¬   s    z AsyncAdapt_dbapi_cursor.rowcountc                 C  s   | j jS r   ©r[   r8   r   r   r   r!   r8   °   s    z!AsyncAdapt_dbapi_cursor.arraysizer   )r.   r   c                 C  s   || j _d S r   ri   )r    r.   r   r   r!   r8   ´   s    c                 C  s   | j jS r   )r[   r9   r   r   r   r!   r9   ¸   s    z!AsyncAdapt_dbapi_cursor.lastrowidc                 Ã  s:   | j r| jrdS | j d| jji¡| _| j ¡ I dH  dS )zclose the cursor but keep the results pending, and memoize the
        description.

        .. versionadded:: 2.0.44

        Nr5   )r_   rd   r]   Úunionr[   r5   r:   r   r   r   r!   Ú_async_soft_close¼   s    ÿÿz)AsyncAdapt_dbapi_cursor._async_soft_closec                 C  sN   | j  ¡  | jd u st| jƒr"d S | js4| j ¡  ntƒ rJ|  | j ¡ ¡ d S r   )	r\   Úclearr[   r^   r]   r_   r:   r   rZ   r   r   r   r!   r:   Î   s    
zAsyncAdapt_dbapi_cursor.closeNr   r;   r<   c              
   C  sJ   z|   |  ||¡¡W S  tyD } z| j |¡ W Y d }~n
d }~0 0 d S r   )rZ   Ú_execute_asyncÚ	ExceptionrX   Ú_handle_exception)r    r=   r>   Úerrorr   r   r!   r@   Þ   s    zAsyncAdapt_dbapi_cursor.executer   )r=   Úseq_of_parametersr   c              
   C  sJ   z|   |  ||¡¡W S  tyD } z| j |¡ W Y d }~n
d }~0 0 d S r   )rZ   Ú_executemany_asyncrn   rX   ro   )r    r=   rq   rp   r   r   r!   rA   è   s    
ÿz#AsyncAdapt_dbapi_cursor.executemanyc              	   Ã  sš   | j j4 I d H šp |d u r.| j |¡I d H }n| j ||¡I d H }| jjrh| jsht | j ¡ I d H ¡| _	|W  d   ƒI d H  S 1 I d H sŒ0    Y  d S r   )
rX   Ú_execute_mutexr[   r@   r5   rd   re   rf   rJ   r\   )r    r=   r>   Úresultr   r   r!   rm   ô   s    z&AsyncAdapt_dbapi_cursor._execute_asyncc              	   Ã  sT   | j j4 I d H š* | j ||¡I d H W  d   ƒI d H  S 1 I d H sF0    Y  d S r   )rX   rs   r[   rA   )r    r=   rq   r   r   r!   rr     s    z*AsyncAdapt_dbapi_cursor._executemany_asyncc                 C  s:   |   | j ¡ ¡ | jjr6| js6t |   | j ¡ ¡¡| _d S r   )	rZ   r[   rQ   r5   rd   re   rf   rJ   r\   r   r   r   r!   rQ   	  s
    ÿzAsyncAdapt_dbapi_cursor.nextset)Ú
inputsizesr   c                 G  s   |   | jj|Ž ¡S r   )rZ   r[   rL   )r    ru   r   r   r!   rL     s    z%AsyncAdapt_dbapi_cursor.setinputsizesr   c                 C  s   | S r   r   r   r   r   r!   Ú	__enter__  s    z!AsyncAdapt_dbapi_cursor.__enter__)Útype_r.   Ú	tracebackr   c                 C  s   |   ¡  d S r   )r:   )r    rw   r.   rx   r   r   r!   Ú__exit__  s    z AsyncAdapt_dbapi_cursor.__exit__úIterator[Any]c                 c  s   | j r| j  ¡ V  q d S r   ©r\   Úpopleftr   r   r   r!   Ú__iter__  s    z AsyncAdapt_dbapi_cursor.__iter__rB   c                 C  s   | j r| j  ¡ S d S d S r   r{   r   r   r   r!   rC   !  s    
z AsyncAdapt_dbapi_cursor.fetchonerD   rE   rF   c                   s4   |d u r| j }| j‰ ‡ fdd„tt|tˆ ƒƒƒD ƒS )Nc                   s   g | ]}ˆ   ¡ ‘qS r   )r|   )Ú.0Ú_©Úrrr   r!   Ú
<listcomp>+  r#   z5AsyncAdapt_dbapi_cursor.fetchmany.<locals>.<listcomp>)r8   r\   ÚrangeÚminÚlenrH   r   r€   r!   rI   '  s    z!AsyncAdapt_dbapi_cursor.fetchmanyc                 C  s   t | jƒ}| j ¡  |S r   )Úlistr\   rl   )r    Úretvalr   r   r!   rJ   -  s    

z AsyncAdapt_dbapi_cursor.fetchall)N)N)r0   r1   r2   rd   Ú	__slots__r_   rT   rg   rc   rb   rS   r5   r7   r8   Úsetterr9   rk   r:   r@   rA   rm   rr   rQ   rL   rv   ry   r}   rC   rI   rJ   r   r   r   r!   rW   €   sF   
	 ý
rW   c                   @  s^   e Zd ZdZdZddœdd„Zddœdd	„Zddddœdd„Zddœdd„Zddœdd„Z	d
S )ÚAsyncAdapt_dbapi_ss_cursorr   Tr   r   c                 C  s$   | j d ur |  | j  ¡ ¡ d | _ d S r   )r[   rZ   r:   r   r   r   r!   r:   7  s    
z AsyncAdapt_dbapi_ss_cursor.closerB   c                 C  s   |   | j ¡ ¡S r   )rZ   r[   rC   r   r   r   r!   rC   <  s    z#AsyncAdapt_dbapi_ss_cursor.fetchoneNrD   r   rF   c                 C  s   |   | jj|d�¡S )N)rG   )rZ   r[   rI   rH   r   r   r!   rI   ?  s    z$AsyncAdapt_dbapi_ss_cursor.fetchmanyrE   c                 C  s   |   | j ¡ ¡S r   )rZ   r[   rJ   r   r   r   r!   rJ   B  s    z#AsyncAdapt_dbapi_ss_cursor.fetchallrz   c                 c  s<   | j  ¡ }z|  | ¡ ¡V  W q
 ty4   Y q8Y q
0 q
d S r   )r[   rR   rZ   Ú	__anext__ÚStopAsyncIteration)r    Úiteratorr   r   r!   r}   E  s
    
z#AsyncAdapt_dbapi_ss_cursor.__iter__)N)
r0   r1   r2   rˆ   rd   r:   rC   rI   rJ   r}   r   r   r   r!   rŠ   3  s   rŠ   c                   @  sš   e Zd ZU eZeZeeƒZ	dZ
ded< dddœdd„Zd d	d
dœdd„Zd!ddddœdd„Zdddœdd„Zddœdd„Zddœdd„Zddœdd„ZdS )"r`   )Údbapirs   r   rY   r   )rŽ   rh   c                 C  s   || _ || _t ¡ | _d S r   )rŽ   rY   ÚasyncioÚLockrs   )r    rŽ   rh   r   r   r!   rg   X  s    z$AsyncAdapt_dbapi_connection.__init__Fr^   rW   )rd   r   c                 C  s   |r|   | ¡S |  | ¡S d S r   )Ú_ss_cursor_clsÚ_cursor_cls)r    rd   r   r   r!   r'   ]  s    
z"AsyncAdapt_dbapi_connection.cursorNr;   r<   c                 C  s   |   ¡ }| ||¡ |S )z2lots of DBAPIs seem to provide this, so include it)r'   r@   )r    r=   r>   r'   r   r   r!   r@   c  s    z#AsyncAdapt_dbapi_connection.executern   r   )rp   r   c                 C  s   t  ¡ }| |d ¡‚d S )Nr   )ÚsysÚexc_infoÚwith_traceback)r    rp   r”   r   r   r!   ro   m  s    z-AsyncAdapt_dbapi_connection._handle_exceptionr   r   c              
   C  sH   z|   | j ¡ ¡ W n. tyB } z|  |¡ W Y d }~n
d }~0 0 d S r   )rZ   rY   r(   rn   ro   ©r    rp   r   r   r!   r(   r  s    z$AsyncAdapt_dbapi_connection.rollbackc              
   C  sH   z|   | j ¡ ¡ W n. tyB } z|  |¡ W Y d }~n
d }~0 0 d S r   )rZ   rY   r"   rn   ro   r–   r   r   r!   r"   x  s    z"AsyncAdapt_dbapi_connection.commitc                 C  s   |   | j ¡ ¡ d S r   )rZ   rY   r:   r   r   r   r!   r:   ~  s    z!AsyncAdapt_dbapi_connection.close)F)N)r0   r1   r2   rW   r’   rŠ   r‘   Ústaticmethodr   rZ   rˆ   rT   rg   r'   r@   ro   r(   r"   r:   r   r   r   r!   r`   N  s   
	 ý
r`   c                   @  s   e Zd ZdZeeƒZdS )Ú#AsyncAdaptFallback_dbapi_connectionr   N)r0   r1   r2   rˆ   r—   r   rZ   r   r   r   r!   r˜   ‚  s   r˜   c                   @  sL   e Zd ZdZdZddœdd„Zddœdd	„Zddœd
d„Zddœdd„ZdS )ÚAsyncAdapt_terminatezAMixin for a AsyncAdapt_dbapi_connection to add terminate support.r   r   r   c              
   C  sl   t ƒ r`z|  t |  ¡ ¡¡ W qh |  ¡ y\ } z"|  ¡  t|tjƒrH‚ W Y d }~qhd }~0 0 n|  ¡  d S r   )	r   rZ   r�   ZshieldÚ_terminate_graceful_closeÚ_terminate_handled_exceptionsÚ_terminate_force_closeÚ
isinstanceÚCancelledError)r    Úer   r   r!   Ú	terminate�  s    zAsyncAdapt_terminate.terminatezTuple[Type[BaseException], ...]c                 C  s   t jt jtfS )z\Returns the exceptions that should be handled when
        calling _graceful_close.
        )r�   ÚTimeoutErrorrž   ÚOSErrorr   r   r   r!   r›   ¡  s    z2AsyncAdapt_terminate._terminate_handled_exceptionsc                 Ã  s   t ‚dS )z"Try to close connection gracefullyN©ÚNotImplementedErrorr   r   r   r!   rš   §  s    z.AsyncAdapt_terminate._terminate_graceful_closec                 C  s   t ‚dS )zTerminate the connectionNr£   r   r   r   r!   rœ   «  s    z+AsyncAdapt_terminate._terminate_force_closeN)	r0   r1   r2   r3   rˆ   r    r›   rš   rœ   r   r   r   r!   r™   ˆ  s   r™   ))r3   Ú
__future__r   r�   re   r“   Útypingr   r   r   r   r   r   r	   r
   r   r   Zenginer   Úutilr   Zutil.concurrencyr   r   r   Zutil.typingr   Zengine.interfacesr   r   r   r   r   r   r$   rU   rW   rŠ   r`   r˜   r™   r   r   r   r!   Ú<module>   sF   8
 44