Ë
    ðmxi÷  ã                  óÐ  — 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 e
r0d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e«      Z$ G d „ d!ee$«      Z% G d"„ d#ee«      Z& G d$„ d%e&«      Z' G d&„ d'e«      Z( G d(„ d)e«      Z)e)Z*y*)+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)ÚAsyncAdapt_terminate)Úawait_fallback)Ú
await_only)ÚAsyncIODBAPIConnection)ÚAsyncIODBAPICursor)ÚConnectArgsType)ÚDBAPIConnection)ÚDBAPICursor)ÚDBAPIModule)ÚPoolProxiedConnection)ÚURLc                  ó    — e Zd ZdZ	 	 	 	 dd„Zy)ÚAsyncAdapt_aiomysql_cursor© c                ó`   — |j                  | j                  j                  j                  «      S ©N)ÚcursorÚ_adapt_connectionÚdbapiÚCursor©ÚselfÚ
connections     úY/home/htdocs/ttos/venv/lib/python3.12/site-packages/sqlalchemy/dialects/mysql/aiomysql.pyÚ_make_new_cursorz+AsyncAdapt_aiomysql_cursor._make_new_cursorC   s'   € ð × Ñ  ×!7Ñ!7×!=Ñ!=×!DÑ!DÓEÐEó    N©r*   r   Úreturnr   ©Ú__name__Ú
__module__Ú__qualname__Ú	__slots__r,   r!   r-   r+   r    r    @   s   „ Ø€IðFØ0ðFà	ôFr-   r    c                  ó    — e Zd ZdZ	 	 	 	 dd„Zy)ÚAsyncAdapt_aiomysql_ss_cursorr!   c                óˆ   — |j                  | j                  j                  j                  j                  j
                  «      S r#   )r$   r%   r&   ÚaiomysqlÚcursorsÚSSCursorr(   s     r+   r,   z.AsyncAdapt_aiomysql_ss_cursor._make_new_cursorN   s8   € ð × Ñ Ø×"Ñ"×(Ñ(×1Ñ1×9Ñ9×BÑBó
ð 	
r-   Nr.   r0   r!   r-   r+   r6   r6   I   s   „ ð €Ið
Ø0ð
à	ô
r-   r6   c                  óP   — e Zd ZdZeZeZd
d„Zdd„Z	dd„Z
dd„Zdd„Zdd„Zdd„Zy	)ÚAsyncAdapt_aiomysql_connectionr!   c                ó`   — |rJ ‚| j                  | j                  j                  |«      «       y r#   )Úawait_Ú_connectionÚping)r)   Ú	reconnects     r+   r@   z#AsyncAdapt_aiomysql_connection.ping^   s'   € ÙÐˆ}Ø�‰�D×$Ñ$×)Ñ)¨)Ó4Õ5r-   c                ó6   — | j                   j                  «       S r#   )r?   Úcharacter_set_name©r)   s    r+   rC   z1AsyncAdapt_aiomysql_connection.character_set_nameb   s   € Ø×Ñ×2Ñ2Ó4Ð4r-   c                óX   — | j                  | j                  j                  |«      «       y r#   )r>   r?   Ú
autocommit)r)   Úvalues     r+   rF   z)AsyncAdapt_aiomysql_connection.autocommite   s   € Ø�‰�D×$Ñ$×/Ñ/°Ó6Õ7r-   c                ó6   — | j                   j                  «       S r#   )r?   Úget_autocommitrD   s    r+   rI   z-AsyncAdapt_aiomysql_connection.get_autocommith   s   € Ø×Ñ×.Ñ.Ó0Ð0r-   c                óV   — | j                  | j                  j                  «       «       y r#   )r>   r?   Úensure_closedrD   s    r+   Úclosez$AsyncAdapt_aiomysql_connection.closek   s   € Ø�‰�D×$Ñ$×2Ñ2Ó4Õ5r-   c              ƒ  óT   K  — | j                   j                  «       ƒ d {  –—†  y 7 Œ­wr#   )r?   rK   rD   s    r+   Ú_terminate_graceful_closez8AsyncAdapt_aiomysql_connection._terminate_graceful_closen   s   è ø€ Ø×Ñ×,Ñ,Ó.×.Ò.ús   ‚( &¡(c                ó8   — | j                   j                  «        y r#   )r?   rL   rD   s    r+   Ú_terminate_force_closez5AsyncAdapt_aiomysql_connection._terminate_force_closeq   s   € à×Ñ×ÑÕ r-   N)rA   Úboolr/   ÚNone)r/   zOptional[str])rG   r   r/   rR   )r/   rQ   ©r/   rR   )r1   r2   r3   r4   r    Ú_cursor_clsr6   Ú_ss_cursor_clsr@   rC   rF   rI   rL   rN   rP   r!   r-   r+   r<   r<   V   s6   „ ð €Ià,€KØ2€Nó6ó5ó8ó1ó6ó/ô!r-   r<   c                  ó    — e Zd ZdZ ee«      Zy)Ú&AsyncAdaptFallback_aiomysql_connectionr!   N)r1   r2   r3   r4   Ústaticmethodr   r>   r!   r-   r+   rW   rW   v   s   „ Ø€Iá˜.Ó)�Fr-   rW   c                  ó0   — e Zd Zdd„Zdd„Zdd„Z	 	 d	d„Zy)
ÚAsyncAdapt_aiomysql_dbapic                óˆ   — || _         || _        d| _        | j                  «        | j	                  «       \  | _        | _        y )NÚformat)r8   ÚpymysqlÚ
paramstyleÚ_init_dbapi_attributesÚ_init_cursors_subclassesr'   r:   )r)   r8   r]   s      r+   Ú__init__z"AsyncAdapt_aiomysql_dbapi.__init__}   s:   € Ø ˆŒØˆŒØ"ˆŒØ×#Ñ#Ô%Ø%)×%BÑ%BÓ%DÑ"ˆŒ�T•]r-   c           	     ó¤   — dD ]#  }t        | |t        | j                  |«      «       Œ% dD ]#  }t        | |t        | j                  |«      «       Œ% y )N)ÚWarningÚErrorÚInterfaceErrorÚ	DataErrorÚDatabaseErrorÚOperationalErrorre   ÚIntegrityErrorÚProgrammingErrorÚInternalErrorÚNotSupportedError)ÚNUMBERÚSTRINGÚDATETIMEÚBINARYÚ	TIMESTAMPÚBinary)ÚsetattrÚgetattrr8   r]   )r)   Únames     r+   r_   z0AsyncAdapt_aiomysql_dbapi._init_dbapi_attributes„   sV   € ð
ò 	>ˆDô �D˜$¤¨¯©°tÓ <Õ=ð	>ð
ò 	=ˆDô �D˜$¤¨¯©°dÓ ;Õ<ñ	=r-   c           
     ó  — |j                  dd«      }|j                  d| j                  j                  «      }t        j                  |«      rt        | t         ||i |¤Ž«      «      S t        | t         ||i |¤Ž«      «      S )NÚasync_fallbackFÚasync_creator_fn)	Úpopr8   Úconnectr   ÚasboolrW   r   r<   r   )r)   ÚargÚkwrw   Ú
creator_fns        r+   rz   z!AsyncAdapt_aiomysql_dbapi.connectž   s€   € ØŸ™Ð 0°%Ó8ˆØ—V‘VÐ.°·±×0EÑ0EÓFˆ
ä�;‰;�~Ô&Ü9ØÜ™z¨3Ð5°"Ñ5Ó6óð ô
 2ØÜ™: sÐ1¨bÑ1Ó2óð r-   c                ó†   —  G d„ d| j                   j                  «      } G d„ d| j                   j                  «      }||fS )Nc                  ó   — e Zd Z	 	 	 	 dd„Zy)úBAsyncAdapt_aiomysql_dbapi._init_cursors_subclasses.<locals>.Cursorc              “  ó   K  — y ­wr#   r!   ©r)   Úconns     r+   Ú_show_warningszQAsyncAdapt_aiomysql_dbapi._init_cursors_subclasses.<locals>.Cursor._show_warnings²   ó   è ø€ ð ùó   ‚N©r„   r   r/   rR   ©r1   r2   r3   r…   r!   r-   r+   r'   r�   ±   ó   „ ðØ2ðàôr-   r'   c                  ó   — e Zd Z	 	 	 	 dd„Zy)úDAsyncAdapt_aiomysql_dbapi._init_cursors_subclasses.<locals>.SSCursorc              “  ó   K  — y ­wr#   r!   rƒ   s     r+   r…   zSAsyncAdapt_aiomysql_dbapi._init_cursors_subclasses.<locals>.SSCursor._show_warnings¸   r†   r‡   Nrˆ   r‰   r!   r-   r+   r:   rŒ   ·   rŠ   r-   r:   )r8   r'   r:   )r)   r'   r:   s      r+   r`   z2AsyncAdapt_aiomysql_dbapi._init_cursors_subclasses­   s;   € ô	�T—]‘]×)Ñ)ô 	ô	�t—}‘}×-Ñ-ô 	ð �xÐÐr-   N)r8   r   r]   r   rS   )r|   r   r}   r   r/   r<   )r/   z-Tuple[AsyncIODBAPICursor, AsyncIODBAPICursor])r1   r2   r3   ra   r_   rz   r`   r!   r-   r+   rZ   rZ   |   s   „ óEó=ó4ð à	6ô r-   rZ   c                  ó¦   ‡ — e Zd ZdZdZdZeZdZdZ	e
d
d„«       Ze
dd„«       Zdd„Z	 d	 	 	 	 	 dˆ fd„Z	 	 	 	 	 	 	 	 dˆ fd„Zdd„Z	 	 	 	 dd	„Zˆ xZS )ÚMySQLDialect_aiomysqlr8   Tc                ó>   — t        t        d«      t        d«      «      S )Nr8   r]   )rZ   Ú
__import__)Úclss    r+   Úimport_dbapiz"MySQLDialect_aiomysql.import_dbapiÊ   s   € ä(Ü�zÓ"¤J¨yÓ$9ó
ð 	
r-   c                ó¤   — |j                   j                  dd«      }t        j                  |«      rt        j
                  S t        j                  S )Nrw   F)ÚqueryÚgetr   r{   r   ÚFallbackAsyncAdaptedQueuePoolÚAsyncAdaptedQueuePool)r’   Úurlrw   s      r+   Úget_pool_classz$MySQLDialect_aiomysql.get_pool_classÐ   s;   € àŸ™Ÿ™Ð'7¸Ó?ˆä�;‰;�~Ô&Ü×5Ñ5Ð5ä×-Ñ-Ð-r-   c                ó$   — |j                  «        y r#   )Ú	terminate)r)   Údbapi_connections     r+   Údo_terminatez"MySQLDialect_aiomysql.do_terminateÙ   s   € Ø×"Ñ"Õ$r-   c                ó<   •— t         ‰| �  |t        dd¬«      ¬«      S )NÚuserÚdb)ÚusernameÚdatabase)Ú_translate_args)ÚsuperÚcreate_connect_argsÚdict)r)   r™   r¤   Ú	__class__s      €r+   r¦   z)MySQLDialect_aiomysql.create_connect_argsÜ   s(   ø€ ô ‰wÑ*Ø¤¨vÀÔ!Eð +ó 
ð 	
r-   c                ób   •— t         ‰| �  |||«      ryt        |«      j                  «       }d|v S )NTznot connected)r¥   Úis_disconnectÚstrÚlower)r)   Úer*   r$   Ústr_er¨   s        €r+   rª   z#MySQLDialect_aiomysql.is_disconnectã   s3   ø€ ô ‰7Ñ   J°Ô7Øä˜“F—L‘L“NˆEØ" eÐ+Ð+r-   c                ó&   — ddl m} |j                  S )Nr   )ÚCLIENT)Úpymysql.constantsr°   Ú
FOUND_ROWS)r)   r°   s     r+   Ú_found_rows_client_flagz-MySQLDialect_aiomysql._found_rows_client_flagï   s   € Ý,à× Ñ Ð r-   c                ó   — |j                   S r#   )r?   r(   s     r+   Úget_driver_connectionz+MySQLDialect_aiomysql.get_driver_connectionô   s   € ð ×%Ñ%Ð%r-   )r/   rZ   )r™   r   r/   Útype)r�   r   r/   rR   r#   )r™   r   r¤   zOptional[Dict[str, Any]]r/   r   )r­   zDBAPIModule.Errorr*   z7Optional[Union[PoolProxiedConnection, DBAPIConnection]]r$   zOptional[DBAPICursor]r/   rQ   )r/   Úint)r*   r   r/   r   )r1   r2   r3   ÚdriverÚsupports_statement_cacheÚsupports_server_side_cursorsr6   Ú	_sscursorÚis_asyncÚhas_terminateÚclassmethodr“   rš   rž   r¦   rª   r³   rµ   Ú__classcell__)r¨   s   @r+   r�   r�   À   s¸   ø„ Ø€FØ#Ðà#'Ð Ø-€Ià€HØ€Màò
ó ð
ð
 ò.ó ð.ó%ð EIð
Øð
Ø)Að
à	õ
ð
,àð
,ð Lð
,ð &ð	
,ð
 
õ
,ó!ð
&Ø)ð&à	÷&r-   r�   N)+Ú__doc__Ú
__future__r   Útypesr   Útypingr   r   r   r   r	   r
   r]   r   Ú r   r   Úconnectors.asyncior   r   r   r   r   Úutil.concurrencyr   r   r   r   Úengine.interfacesr   r   r   r   r   Ú
engine.urlr   r    r6   r<   rW   rZ   r�   Údialectr!   r-   r+   ú<module>rÊ      s¿   ðñõ. #å Ý Ý Ý Ý Ý  Ý å )Ý Ý Ý =Ý 9Ý 9Ý <Ý 6Ý .Ý *áå<Ý8Ý4Ý4Ý0Ý0Ý:Ý!ôFÐ!8ô Fô

ØÐ :ô

ô!ØÐ5ô!ô@*Ð-Kô *ôA Ð 7ô A ôH7&Ð0ô 7&ðt  �r-   