a
    •˜ëjï!  ã                   @  sÆ  d 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 ddlmZ ddlmZ ddlmZ ddlmZ e
�rZd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% G d d!„ d!eƒZ&G d"d#„ d#ee&ƒZ'G d$d%„ d%eeƒZ(G d&d'„ d'e(ƒZ)G d(d)„ d)eƒZ*G d*d+„ d+eƒZ+e+Z,d,S )-aÖ  
.. dialect:: mysql+aiomysql
    :name: aiomysql
    :dbapi: aiomysql
    :connectstring: mysql+aiomysql://user:password@host:port/dbname[?key=value&key=value...]
    :url: https://github.com/aio-libs/aiomysql

The aiomysql dialect is SQLAlchemy's second Python asyncio dialect.

Using a special asyncio mediation layer, the aiomysql dialect is usable
as the backend for the :ref:`SQLAlchemy asyncio <asyncio_toplevel>`
extension package.

This dialect should normally be used only with the
:func:`_asyncio.create_async_engine` engine creation function::

    from sqlalchemy.ext.asyncio import create_async_engine

    engine = create_async_engine(
        "mysql+aiomysql://user:pass@hostname/dbname?charset=utf8mb4"
    )

é    )Úannotations)Ú
ModuleType)ÚAny)ÚDict)ÚOptional)ÚTuple)ÚTYPE_CHECKING)ÚUnioné   )Ú _connection_ping_reconnects_true)ÚMySQLDialect_pymysqlé   )Úpool)Úutil)ÚAsyncAdapt_dbapi_connection)ÚAsyncAdapt_dbapi_cursor)ÚAsyncAdapt_dbapi_module)ÚAsyncAdapt_dbapi_ss_cursor)ÚAsyncAdapt_terminate)Úlanghelpers)Úawait_fallback)Ú
await_only)ÚAsyncIODBAPIConnection)ÚAsyncIODBAPICursor)ÚConnectArgsType)ÚDBAPIConnection)ÚDBAPICursor)ÚDBAPIModule)ÚPoolProxiedConnection)ÚURLc                   @  s    e Zd ZdZdddœdd„ZdS )ÚAsyncAdapt_aiomysql_cursor© r   r   ©Ú
connectionÚreturnc                 C  s   |  | jjj¡S ©N)ÚcursorÚ_adapt_connectionÚdbapiÚCursor©Úselfr#   r!   r!   úa/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/aiomysql.pyÚ_make_new_cursorF   s    z+AsyncAdapt_aiomysql_cursor._make_new_cursorN©Ú__name__Ú
__module__Ú__qualname__Ú	__slots__r-   r!   r!   r!   r,   r    C   s   r    c                   @  s    e Zd ZdZdddœdd„ZdS )ÚAsyncAdapt_aiomysql_ss_cursorr!   r   r   r"   c                 C  s   |  | jjjjj¡S r%   )r&   r'   r(   ÚaiomysqlZcursorsÚSSCursorr*   r!   r!   r,   r-   Q   s    ÿz.AsyncAdapt_aiomysql_ss_cursor._make_new_cursorNr.   r!   r!   r!   r,   r3   L   s   r3   c                   @  s€   e Zd ZdZeZeZddddœdd„Z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d	œdd„ZdS )ÚAsyncAdapt_aiomysql_connectionr!   FÚboolÚNone)Ú	reconnectr$   c                 C  s:   |rJ ‚| j jr&|  | jjdd�¡ n|  | j ¡ ¡ d S )NF)r9   )r(   Ú_send_false_to_pingÚawait_Ú_connectionÚping)r+   r9   r!   r!   r,   r=   a   s    z#AsyncAdapt_aiomysql_connection.pingzOptional[str]©r$   c                 C  s
   | j  ¡ S r%   )r<   Úcharacter_set_name©r+   r!   r!   r,   r?   h   s    z1AsyncAdapt_aiomysql_connection.character_set_namer   )Úvaluer$   c                 C  s   |   | j |¡¡ d S r%   )r;   r<   Ú
autocommit)r+   rA   r!   r!   r,   rB   k   s    z)AsyncAdapt_aiomysql_connection.autocommitc                 C  s
   | j  ¡ S r%   )r<   Úget_autocommitr@   r!   r!   r,   rC   n   s    z-AsyncAdapt_aiomysql_connection.get_autocommitc                 C  s   |   | j ¡ ¡ d S r%   )r;   r<   Úensure_closedr@   r!   r!   r,   Úcloseq   s    z$AsyncAdapt_aiomysql_connection.closec                 Ã  s   | j  ¡ I d H  d S r%   )r<   rD   r@   r!   r!   r,   Ú_terminate_graceful_closet   s    z8AsyncAdapt_aiomysql_connection._terminate_graceful_closec                 C  s   | j  ¡  d S r%   )r<   rE   r@   r!   r!   r,   Ú_terminate_force_closew   s    z5AsyncAdapt_aiomysql_connection._terminate_force_closeN)F)r/   r0   r1   r2   r    Z_cursor_clsr3   Z_ss_cursor_clsr=   r?   rB   rC   rE   rF   rG   r!   r!   r!   r,   r6   Y   s   r6   c                   @  s   e Zd ZdZeeƒZdS )Ú&AsyncAdaptFallback_aiomysql_connectionr!   N)r/   r0   r1   r2   Ústaticmethodr   r;   r!   r!   r!   r,   rH   |   s   rH   c                   @  s^   e Zd Zdddœdd„Zddœdd„Zd	d	d
dœdd„Zejddœdd„ƒZddœdd„Z	dS )ÚAsyncAdapt_aiomysql_dbapir   )r4   Úpymysqlc                 C  s.   || _ || _d| _|  ¡  |  ¡ \| _| _d S )NÚformat)r4   rK   Z
paramstyleÚ_init_dbapi_attributesÚ_init_cursors_subclassesr)   r5   )r+   r4   rK   r!   r!   r,   Ú__init__ƒ   s
    z"AsyncAdapt_aiomysql_dbapi.__init__r8   r>   c                 C  s@   dD ]}t | |t| j|ƒƒ qdD ]}t | |t| j|ƒƒ q"d S )N)ÚWarningÚErrorÚInterfaceErrorZ	DataErrorZDatabaseErrorZOperationalErrorrR   ZIntegrityErrorZProgrammingErrorZInternalErrorZNotSupportedError)ÚNUMBERÚSTRINGZDATETIMEÚBINARYÚ	TIMESTAMPÚBinary)ÚsetattrÚgetattrr4   rK   )r+   Únamer!   r!   r,   rM   Š   s    z0AsyncAdapt_aiomysql_dbapi._init_dbapi_attributesr   r6   )ÚargÚkwr$   c                 O  sZ   |  dd¡}|  d| jj¡}t |¡r>t| t||i |¤ŽƒƒS t| t||i |¤ŽƒƒS d S )NÚasync_fallbackFZasync_creator_fn)	Úpopr4   Úconnectr   ÚasboolrH   r   r6   r   )r+   r[   r\   r]   Z
creator_fnr!   r!   r,   r_   ¤   s    
þþz!AsyncAdapt_aiomysql_dbapi.connectr7   c              	   C  s6   zt dƒjj}W n ttfy(   Y dS 0 t|ƒS dS )z¨determine if aiomysql has deprecated, changed the default of,
        or removed the 'reconnect' argument of connection.ping().

        See #13306 and #10492

        zaiomysql.connectionTN)Ú
__import__r#   Ú
ConnectionÚImportErrorÚAttributeErrorr   )r+   rb   r!   r!   r,   r:   ³   s    	ÿz-AsyncAdapt_aiomysql_dbapi._send_false_to_pingz-Tuple[AsyncIODBAPICursor, AsyncIODBAPICursor]c                 C  s0   G dd„ d| j jƒ}G dd„ d| j jƒ}||fS )Nc                   @  s   e Zd Zdddœdd„ZdS )zBAsyncAdapt_aiomysql_dbapi._init_cursors_subclasses.<locals>.Cursorr   r8   ©Úconnr$   c                 Ó  s   d S r%   r!   ©r+   rf   r!   r!   r,   Ú_show_warningsÊ   s    zQAsyncAdapt_aiomysql_dbapi._init_cursors_subclasses.<locals>.Cursor._show_warningsN©r/   r0   r1   rh   r!   r!   r!   r,   r)   É   s   r)   c                   @  s   e Zd Zdddœdd„ZdS )zDAsyncAdapt_aiomysql_dbapi._init_cursors_subclasses.<locals>.SSCursorr   r8   re   c                 Ó  s   d S r%   r!   rg   r!   r!   r,   rh   Ð   s    zSAsyncAdapt_aiomysql_dbapi._init_cursors_subclasses.<locals>.SSCursor._show_warningsNri   r!   r!   r!   r,   r5   Ï   s   r5   )r4   r)   r5   )r+   r)   r5   r!   r!   r,   rN   Å   s    z2AsyncAdapt_aiomysql_dbapi._init_cursors_subclassesN)
r/   r0   r1   rO   rM   r_   r   Zmemoized_propertyr:   rN   r!   r!   r!   r,   rJ   ‚   s   rJ   c                      s¬   e Zd ZdZdZdZeZdZdZ	e
ddœdd„ƒZe
ddd	œd
d„ƒZdddœdd„Zd%ddddœ‡ fdd„Zdddddœ‡ fdd„Zddœdd „Zdd!d"œd#d$„Z‡  ZS )&ÚMySQLDialect_aiomysqlr4   TrJ   r>   c                 C  s   t tdƒtdƒƒS )Nr4   rK   )rJ   ra   )Úclsr!   r!   r,   Úimport_dbapiâ   s    ÿz"MySQLDialect_aiomysql.import_dbapir   Útype)Úurlr$   c                 C  s(   |j  dd¡}t |¡rtjS tjS d S )Nr]   F)ÚqueryÚgetr   r`   r   ZFallbackAsyncAdaptedQueuePoolZAsyncAdaptedQueuePool)rk   rn   r]   r!   r!   r,   Úget_pool_classè   s    
z$MySQLDialect_aiomysql.get_pool_classr   r8   )Údbapi_connectionr$   c                 C  s   |  ¡  d S r%   )Ú	terminate)r+   rr   r!   r!   r,   Údo_terminateñ   s    z"MySQLDialect_aiomysql.do_terminateNzOptional[Dict[str, Any]]r   )rn   Ú_translate_argsr$   c                   s   t ƒ j|tddd�d�S )NÚuserÚdb)ÚusernameZdatabase)ru   )ÚsuperÚcreate_connect_argsÚdict)r+   rn   ru   ©Ú	__class__r!   r,   rz   ô   s    ÿz)MySQLDialect_aiomysql.create_connect_argszDBAPIModule.Errorz7Optional[Union[PoolProxiedConnection, DBAPIConnection]]zOptional[DBAPICursor]r7   )Úer#   r&   r$   c                   s,   t ƒ  |||¡rdS t|ƒ ¡ }d|v S d S )NTznot connected)ry   Úis_disconnectÚstrÚlower)r+   r~   r#   r&   Zstr_er|   r!   r,   r   û   s    z#MySQLDialect_aiomysql.is_disconnectÚintc                 C  s   ddl m} |jS )Nr   )ÚCLIENT)Zpymysql.constantsrƒ   Z
FOUND_ROWS)r+   rƒ   r!   r!   r,   Ú_found_rows_client_flag  s    z-MySQLDialect_aiomysql._found_rows_client_flagr   r"   c                 C  s   |j S r%   )r<   r*   r!   r!   r,   Úget_driver_connection  s    z+MySQLDialect_aiomysql.get_driver_connection)N)r/   r0   r1   ZdriverZsupports_statement_cacheZsupports_server_side_cursorsr3   Z	_sscursorÚis_asyncZhas_terminateÚclassmethodrl   rq   rt   rz   r   r„   r…   Ú__classcell__r!   r!   r|   r,   rj   Ø   s     ÿrj   N)-Ú__doc__Ú
__future__r   Útypesr   Útypingr   r   r   r   r   r	   rK   r   r   Ú r   r   Zconnectors.asyncior   r   r   r   r   r   Zutil.concurrencyr   r   r   r   Zengine.interfacesr   r   r   r   r   Z
engine.urlr   r    r3   r6   rH   rJ   rj   Údialectr!   r!   r!   r,   Ú<module>   sP   	
ÿ
ÿ#V: