a
    •˜ëjt  ã                   @  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 e	�rNd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+asyncmy
    :name: asyncmy
    :dbapi: asyncmy
    :connectstring: mysql+asyncmy://user:password@host:port/dbname[?key=value&key=value...]
    :url: https://github.com/long2ice/asyncmy

Using a special asyncio mediation layer, the asyncmy 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+asyncmy://user:pass@hostname/dbname?charset=utf8mb4"
    )

é    )Úannotations)Ú
ModuleType)ÚAny)ÚNoReturn)ÚOptional)Ú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S )ÚAsyncAdapt_asyncmy_cursor© N)Ú__name__Ú
__module__Ú__qualname__Ú	__slots__r    r    r    ú`/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/asyncmy.pyr   ?   s   r   c                   @  s    e Zd ZdZdddœdd„ZdS )ÚAsyncAdapt_asyncmy_ss_cursorr    r   r   ©Ú
connectionÚreturnc                 C  s   |  | jjjjj¡S ©N)ÚcursorZ_adapt_connectionÚdbapiÚasyncmyZcursorsZSSCursor©Úselfr(   r    r    r%   Ú_make_new_cursorH   s    ÿz-AsyncAdapt_asyncmy_ss_cursor._make_new_cursorN)r!   r"   r#   r$   r0   r    r    r    r%   r&   C   s   r&   c                   @  sž   e Zd ZdZeZeZdddœdd„Zd dd	d
œdd„Z	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_asyncmy_connectionr    Ú	Exceptionr   )Úerrorr)   c                 C  s    t |tƒr| j d¡|‚|‚d S )Nz7network operation failed due to asyncmy attribute error)Ú
isinstanceÚAttributeErrorr,   ÚInternalError©r/   r3   r    r    r%   Ú_handle_exceptionX   s    
ÿþz/AsyncAdapt_asyncmy_connection._handle_exceptionFÚboolÚNone)Ú	reconnectr)   c                 C  s   |rJ ‚|   |  ¡ ¡S r*   )Úawait_Ú_do_ping)r/   r;   r    r    r%   Úping`   s    z"AsyncAdapt_asyncmy_connection.ping©r)   c              
   Ã  s    zl| j 4 I d H šD | jjr0| jjdd�I d H  n| j ¡ I d H  W d   ƒI d H  qj1 I d H s`0    Y  W n. tyš } z|  |¡ W Y d }~n
d }~0 0 d S )NF)r;   )Z_execute_mutexr,   Ú_send_false_to_pingÚ_connectionr>   r2   r8   r7   r    r    r%   r=   d   s    >z&AsyncAdapt_asyncmy_connection._do_pingzOptional[str]c                 C  s
   | j  ¡ S r*   )rA   Úcharacter_set_name©r/   r    r    r%   rB   n   s    z0AsyncAdapt_asyncmy_connection.character_set_namer   )Úvaluer)   c                 C  s   |   | j |¡¡ d S r*   )r<   rA   Ú
autocommit)r/   rD   r    r    r%   rE   q   s    z(AsyncAdapt_asyncmy_connection.autocommitc                 C  s
   | j  ¡ S r*   )rA   Úget_autocommitrC   r    r    r%   rF   t   s    z,AsyncAdapt_asyncmy_connection.get_autocommitc                 C  s   |   | j ¡ ¡ d S r*   )r<   rA   Úensure_closedrC   r    r    r%   Úclosew   s    z#AsyncAdapt_asyncmy_connection.closec                 Ã  s   | j  ¡ I d H  d S r*   )rA   rG   rC   r    r    r%   Ú_terminate_graceful_closez   s    z7AsyncAdapt_asyncmy_connection._terminate_graceful_closec                 C  s   | j  ¡  d S r*   )rA   rH   rC   r    r    r%   Ú_terminate_force_close}   s    z4AsyncAdapt_asyncmy_connection._terminate_force_closeN)F)r!   r"   r#   r$   r   Z_cursor_clsr&   Z_ss_cursor_clsr8   r>   r=   rB   rE   rF   rH   rI   rJ   r    r    r    r%   r1   P   s   
r1   c                   @  s   e Zd ZdZeeƒZdS )Ú%AsyncAdaptFallback_asyncmy_connectionr    N)r!   r"   r#   r$   Ústaticmethodr   r<   r    r    r    r%   rK   ‚   s   rK   c                   @  sˆ   e Zd Zddœdd„Zddœdd„Ze d	¡Ze d
¡Ze d¡Z	e d¡Z
e d¡ZeeƒZddddœdd„Zejddœdd„ƒZdS )ÚAsyncAdapt_asyncmy_dbapir   )r-   c                 C  s   || _ d| _|  ¡  d S )NÚformat)r-   Z
paramstyleÚ_init_dbapi_attributes)r/   r-   r    r    r%   Ú__init__‰   s    z!AsyncAdapt_asyncmy_dbapi.__init__r:   r?   c                 C  s$   dD ]}t | |t| jj|ƒƒ qd S )N)ÚWarningÚErrorÚInterfaceErrorZ	DataErrorZDatabaseErrorZOperationalErrorrS   ZIntegrityErrorZProgrammingErrorr6   ZNotSupportedError)ÚsetattrÚgetattrr-   Úerrors)r/   Únamer    r    r%   rO   Ž   s    z/AsyncAdapt_asyncmy_dbapi._init_dbapi_attributesÚSTRINGÚNUMBERÚBINARYÚDATETIMEÚ	TIMESTAMPr   r1   )Ú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)	Úpopr-   Úconnectr   ÚasboolrK   r   r1   r   )r/   r]   r^   r_   Z
creator_fnr    r    r%   ra   ¥   s    
þþz AsyncAdapt_asyncmy_dbapi.connectr9   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 asyncmy has deprecated, changed the default of,
        or removed the 'reconnect' argument of connection.ping().

        See #13306 and #10492

        zasyncmy.connectionTN)Ú
__import__r(   Ú
ConnectionÚImportErrorr5   r
   )r/   rd   r    r    r%   r@   ´   s
    	z,AsyncAdapt_asyncmy_dbapi._send_false_to_pingN)r!   r"   r#   rP   rO   r   ÚsymbolrX   rY   rZ   r[   r\   rL   ÚbytesÚBinaryra   r   Zmemoized_propertyr@   r    r    r    r%   rM   ˆ   s   




rM   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	œ‡ 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_asyncmyr-   Tr   r?   c                 C  s   t tdƒƒS )Nr-   )rM   rc   )Úclsr    r    r%   Úimport_dbapiÏ   s    z!MySQLDialect_asyncmy.import_dbapir   Útype)Úurlr)   c                 C  s(   |j  dd¡}t |¡rtjS tjS d S )Nr_   F)ÚqueryÚgetr   rb   r   ZFallbackAsyncAdaptedQueuePoolZAsyncAdaptedQueuePool)rj   rm   r_   r    r    r%   Úget_pool_classÓ   s    
z#MySQLDialect_asyncmy.get_pool_classr   r:   )Údbapi_connectionr)   c                 C  s   |  ¡  d S r*   )Ú	terminate)r/   rq   r    r    r%   Údo_terminateÜ   s    z!MySQLDialect_asyncmy.do_terminater   c                   s   t ƒ j|tddd�d�S )NÚuserÚdb)ÚusernameZdatabase)Z_translate_args)ÚsuperÚcreate_connect_argsÚdict)r/   rm   ©Ú	__class__r    r%   rx   ß   s    ÿz(MySQLDialect_asyncmy.create_connect_argszDBAPIModule.Errorz7Optional[Union[PoolProxiedConnection, DBAPIConnection]]zOptional[DBAPICursor]r9   )Úer(   r+   r)   c                   s4   t ƒ  |||¡rdS t|ƒ ¡ }d|v p.d|v S d S )NTznot connectedznetwork operation failed)rw   Úis_disconnectÚstrÚlower)r/   r|   r(   r+   Zstr_erz   r    r%   r}   ä   s
    ÿz"MySQLDialect_asyncmy.is_disconnectÚintc                 C  s   ddl m} |jS )Nr   )ÚCLIENT)Zasyncmy.constantsr�   Z
FOUND_ROWS)r/   r�   r    r    r%   Ú_found_rows_client_flagò   s    z,MySQLDialect_asyncmy._found_rows_client_flagr   r'   c                 C  s   |j S r*   )rA   r.   r    r    r%   Úget_driver_connection÷   s    z*MySQLDialect_asyncmy.get_driver_connection)r!   r"   r#   ZdriverZsupports_statement_cacheZsupports_server_side_cursorsr&   Z	_sscursorÚis_asyncZhas_terminateÚclassmethodrk   rp   rs   rx   r}   r‚   rƒ   Ú__classcell__r    r    rz   r%   ri   Å   s   ri   N),Ú__doc__Ú
__future__r   Útypesr   Útypingr   r   r   r   r   Zpymysqlr
   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   r&   r1   rK   rM   ri   Údialectr    r    r    r%   Ú<module>   sN   
ÿ
ÿ2=8