U
    h0                     @  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 e
r6d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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   )MySQLDialect_pymysql   )pool)util)AsyncAdapt_dbapi_connection)AsyncAdapt_dbapi_cursor)AsyncAdapt_dbapi_module)AsyncAdapt_dbapi_ss_cursor)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   F/tmp/pip-unpacked-wheel-y9ln43lq/sqlalchemy/dialects/mysql/aiomysql.py_make_new_cursorB   s    z+AsyncAdapt_aiomysql_cursor._make_new_cursorN__name__
__module____qualname__	__slots__r*   r   r   r   r)   r   ?   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*   M   s    z.AsyncAdapt_aiomysql_ss_cursor._make_new_cursorNr+   r   r   r   r)   r0   H   s   r0   c                   @  sp   e Zd ZdZeZeZ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S )AsyncAdapt_aiomysql_connectionr   boolNone)	reconnectr!   c                 C  s   |rt | | j| d S r"   )AssertionErrorawait__connectionping)r(   r6   r   r   r)   r:   [   s    z#AsyncAdapt_aiomysql_connection.pingzOptional[str]r!   c                 C  s
   | j  S r"   )r9   character_set_namer(   r   r   r)   r<   _   s    z1AsyncAdapt_aiomysql_connection.character_set_namer   )valuer!   c                 C  s   |  | j| d S r"   )r8   r9   
autocommit)r(   r>   r   r   r)   r?   b   s    z)AsyncAdapt_aiomysql_connection.autocommitc                 C  s
   | j  S r"   )r9   get_autocommitr=   r   r   r)   r@   e   s    z-AsyncAdapt_aiomysql_connection.get_autocommitc                 C  s   | j   d S r"   )r9   closer=   r   r   r)   	terminateh   s    z(AsyncAdapt_aiomysql_connection.terminatec                 C  s   |  | j  d S r"   )r8   r9   Zensure_closedr=   r   r   r)   rA   l   s    z$AsyncAdapt_aiomysql_connection.closeN)r,   r-   r.   r/   r   Z_cursor_clsr0   Z_ss_cursor_clsr:   r<   r?   r@   rB   rA   r   r   r   r)   r3   U   s   r3   c                   @  s   e Zd ZdZeeZdS )&AsyncAdaptFallback_aiomysql_connectionr   N)r,   r-   r.   r/   staticmethodr   r8   r   r   r   r)   rC   p   s   rC   c                   @  sJ   e Zd ZdddddZddddZd	d	d
dddZddddZdS )AsyncAdapt_aiomysql_dbapir   )r1   pymysqlc                 C  s.   || _ || _d| _|   |  \| _| _d S )Nformat)r1   rF   Z
paramstyle_init_dbapi_attributes_init_cursors_subclassesr&   r2   )r(   r1   rF   r   r   r)   __init__w   s
    z"AsyncAdapt_aiomysql_dbapi.__init__r5   r;   c                 C  s@   dD ]}t | |t| j| qdD ]}t | |t| j| q"d S )N)WarningErrorInterfaceErrorZ	DataErrorZDatabaseErrorZOperationalErrorrM   ZIntegrityErrorZProgrammingErrorZInternalErrorZNotSupportedError)NUMBERSTRINGZDATETIMEZBINARY	TIMESTAMPBinary)setattrgetattrr1   rF   )r(   namer   r   r)   rH   ~   s    z0AsyncAdapt_aiomysql_dbapi._init_dbapi_attributesr   r3   )argkwr!   c                 O  sR   | dd}| d| jj}t|r:t| t|||S t| t|||S d S )Nasync_fallbackFZasync_creator_fn)	popr1   connectr   asboolrC   r   r3   r   )r(   rU   rV   rW   Z
creator_fnr   r   r)   rY      s    
z!AsyncAdapt_aiomysql_dbapi.connectz-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   r5   connr!   c                   s   d S r"   r   r(   r\   r   r   r)   _show_warnings   s    zQAsyncAdapt_aiomysql_dbapi._init_cursors_subclasses.<locals>.Cursor._show_warningsNr,   r-   r.   r^   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   r5   r[   c                   s   d S r"   r   r]   r   r   r)   r^      s    zSAsyncAdapt_aiomysql_dbapi._init_cursors_subclasses.<locals>.SSCursor._show_warningsNr_   r   r   r   r)   r2      s   r2   )r1   r&   r2   )r(   r&   r2   r   r   r)   rI      s    z2AsyncAdapt_aiomysql_dbapi._init_cursors_subclassesN)r,   r-   r.   rJ   rH   rY   rI   r   r   r   r)   rE   v   s   rE   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_aiomysqlr1   TrE   r;   c                 C  s   t tdtdS )Nr1   rF   )rE   
__import__)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 )NrW   F)querygetr   rZ   r   ZFallbackAsyncAdaptedQueuePoolZAsyncAdaptedQueuePool)rb   re   rW   r   r   r)   get_pool_class   s    
z$MySQLDialect_aiomysql.get_pool_classr   r5   )dbapi_connectionr!   c                 C  s   |   d S r"   )rB   )r(   ri   r   r   r)   do_terminate   s    z"MySQLDialect_aiomysql.do_terminateNzOptional[Dict[str, Any]]r   )re   _translate_argsr!   c                   s   t  j|tddddS )Nuserdb)usernameZdatabase)rk   )supercreate_connect_argsdict)r(   re   rk   	__class__r   r)   rp      s     
z)MySQLDialect_aiomysql.create_connect_argszDBAPIModule.Errorz7Optional[Union[PoolProxiedConnection, DBAPIConnection]]zOptional[DBAPICursor]r4   )er    r#   r!   c                   s,   t  |||rdS t| }d|kS d S )NTznot connected)ro   is_disconnectstrlower)r(   rt   r    r#   Zstr_err   r   r)   ru      s    z#MySQLDialect_aiomysql.is_disconnectintc                 C  s   ddl m} |jS )Nr   )CLIENT)Zpymysql.constantsry   Z
FOUND_ROWS)r(   ry   r   r   r)   _found_rows_client_flag   s    z-MySQLDialect_aiomysql._found_rows_client_flagr   r   c                 C  s   |j S r"   )r9   r'   r   r   r)   get_driver_connection   s    z+MySQLDialect_aiomysql.get_driver_connection)N)r,   r-   r.   ZdriverZsupports_statement_cacheZsupports_server_side_cursorsr0   Z	_sscursorZis_asyncZhas_terminateclassmethodrc   rh   rj   rp   ru   rz   r{   __classcell__r   r   rr   r)   r`      s     r`   N)*__doc__
__future__r   typesr   typingr   r   r   r   r   r	   rF   r    r   r   Zconnectors.asyncior   r   r   r   Zutil.concurrencyr   r   r   r   Zengine.interfacesr   r   r   r   r   Z
engine.urlr   r   r0   r3   rC   rE   r`   dialectr   r   r   r)   <module>   sH   	
 D: