a
    •˜ëj’(  ã                   @  s’  d Z ddlm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 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 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Z&G dd „ d ejej' ƒ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+mariadbconnector
    :name: MariaDB Connector/Python
    :dbapi: mariadb
    :connectstring: mariadb+mariadbconnector://<user>:<password>@<host>[:<port>]/<dbname>
    :url: https://pypi.org/project/mariadb/

Driver Status
-------------

MariaDB Connector/Python enables Python programs to access MariaDB and MySQL
databases using an API which is compliant with the Python DB API 2.0 (PEP-249).
It is written in C and uses MariaDB Connector/C client library for client server
communication.

Note that the default driver for a ``mariadb://`` connection URI continues to
be ``mysqldb``. ``mariadb+mariadbconnector://`` is required to use this driver.

.. mariadb: https://github.com/mariadb-corporation/mariadb-connector-python

é    )ÚannotationsN)ÚAny)ÚOptional)ÚSequence)ÚTuple)ÚTYPE_CHECKING)ÚUnion)ÚUUIDé   )ÚMySQLCompiler)ÚMySQLDialect)ÚMySQLExecutionContexté   )Úsql)Úutil)Úsqltypes)Ú
Connection)ÚConnectArgsType)ÚDBAPIConnection)ÚDBAPICursor)ÚDBAPIModule)ÚDialect)ÚIsolationLevel)ÚPoolProxiedConnection)ÚURL)ÚSQLCompiler)Ú_ResultProcessorType)r
   r   r
   c                   @  s   e Zd Zddddœdd„ZdS )Ú_MariaDBUUIDr   Úobjectz#Optional[_ResultProcessorType[Any]])ÚdialectÚcoltypeÚreturnc                 C  s2   | j rdddœdd„}|S dddœdd„}|S d S )Nr   )Úvaluer!   c                 S  s(   | d ur$t | dƒr|  d¡} t| ƒ} | S ©NÚdecodeÚascii)Úhasattrr$   Ú_python_UUID©r"   © r)   úi/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/mariadbconnector.pyÚprocessK   s
    

z._MariaDBUUID.result_processor.<locals>.processc                 S  s,   | d ur(t | dƒr|  d¡} tt| ƒƒ} | S r#   )r&   r$   Ústrr'   r(   r)   r)   r*   r+   U   s
    

)Zas_uuid)Úselfr   r    r+   r)   r)   r*   Úresult_processorF   s
    z_MariaDBUUID.result_processorN)Ú__name__Ú
__module__Ú__qualname__r.   r)   r)   r)   r*   r   B   s   r   c                      sZ   e Zd ZU dZded< ddœdd„Zddœdd	„Zd
dœ‡ fdd„Zddœdd„Z‡  Z	S )Ú&MySQLExecutionContext_mariadbconnectorNzOptional[int]Ú
_lastrowidr   ©r!   c                 C  s   | j jdd�S )NF©Zbuffered©Z_dbapi_connectionÚcursor©r-   r)   r)   r*   Úcreate_server_side_cursorb   s    z@MySQLExecutionContext_mariadbconnector.create_server_side_cursorc                 C  s   | j jdd�S )NTr5   r6   r8   r)   r)   r*   Úcreate_default_cursore   s    z<MySQLExecutionContext_mariadbconnector.create_default_cursorÚNonec                   sD   t ƒ  ¡  | jj| _tr(t| jtƒs(J ‚| j	r@| jj
r@| jj| _d S ©N)ÚsuperÚ	post_execr7   ZrowcountZ	_rowcountr   Ú
isinstanceZcompiledr   ZisinsertZpostfetch_lastrowidZ	lastrowidr3   r8   ©Ú	__class__r)   r*   r>   h   s    

z0MySQLExecutionContext_mariadbconnector.post_execÚintc                 C  s   t r| jd usJ ‚| jS r<   )r   r3   r8   r)   r)   r*   Úget_lastrowidr   s    z4MySQLExecutionContext_mariadbconnector.get_lastrowid)
r/   r0   r1   r3   Ú__annotations__r9   r:   r>   rC   Ú__classcell__r)   r)   r@   r*   r2   _   s
   

r2   c                   @  s   e Zd ZdS )ÚMySQLCompiler_mariadbconnectorN)r/   r0   r1   r)   r)   r)   r*   rF   x   s   rF   c                      s`  e Zd ZdZdZdZdZdZdZdZ	dZ
dZeZeZdZe ejejei¡Zejddœdd„ƒZd	d
dœ‡ fdd„Zeddœdd„ƒZdddddœ‡ fdd„Zdddœdd„Zdddœdd „Zd!d"d#œd$d%„Z d&d'd(œd)d*„Z!d&dd(œd+d,„Z"d&d-d
d.œ‡ fd/d0„Z#d!d	d
d1œd2d3„Z$d!d	d
d1œd4d5„Z%d<d!d	ddd
d7œd8d9„Z&d=d!d	ddd
d7œd:d;„Z'‡  Z(S )>ÚMySQLDialect_mariadbconnectorZmariadbconnectorTÚutf8mb4ÚqmarkzTuple[int, ...]r4   c                 C  s8   | j r0t| j dƒr0tdd„ t d| j j¡D ƒƒS dS d S )NÚ__version__c                 S  s   g | ]}t |ƒ‘qS r)   )rB   ©Ú.0Úxr)   r)   r*   Ú
<listcomp>ž   s   ÿz@MySQLDialect_mariadbconnector._dbapi_version.<locals>.<listcomp>z(\d+)(?:[-\.]?|$))éc   rO   rO   )Údbapir&   ÚtupleÚreÚfindallrJ   r8   r)   r)   r*   Ú_dbapi_versionš   s    ÿþÿ	z,MySQLDialect_mariadbconnector._dbapi_versionr   r;   )Úkwargsr!   c                   sL   t ƒ jf i |¤Ž d| _| jd urH| jtk rHtdd dd„ tD ƒ¡ ƒ‚d S )NrI   z?The minimum required version for MariaDB Connector/Python is %sÚ.c                 s  s   | ]}t |ƒV  qd S r<   )r,   rK   r)   r)   r*   Ú	<genexpr>°   ó    z9MySQLDialect_mariadbconnector.__init__.<locals>.<genexpr>)r=   Ú__init__Z
paramstylerP   rT   Úmariadb_cpy_minimum_versionÚNotImplementedErrorÚjoin)r-   rU   r@   r)   r*   rY   ¨   s    

þÿz&MySQLDialect_mariadbconnector.__init__r   c                 C  s   t dƒS )NZmariadb)Ú
__import__)Úclsr)   r)   r*   Úimport_dbapi³   s    z*MySQLDialect_mariadbconnector.import_dbapizDBAPIModule.Errorz7Optional[Union[PoolProxiedConnection, DBAPIConnection]]zOptional[DBAPICursor]Úbool)ÚeÚ
connectionr7   r!   c                   sF   t ƒ  |||¡rdS t|| jjƒr>t|ƒ ¡ }d|v p<d|v S dS d S )NTznot connectedzisn't validF)r=   Úis_disconnectr?   Zloaded_dbapiÚErrorr,   Úlower)r-   ra   rb   r7   Zstr_er@   r)   r*   rc   ·   s    z+MySQLDialect_mariadbconnector.is_disconnectr   r   )Úurlr!   c              	   C  sº   |  ¡ }| |j¡ g d¢}g d¢}|D ]}t ||t¡ q(|D ]}t ||t¡ q@| dd¡}| jd ur²z"t	| jj
d ƒjj}||jO }W n ttfy¨   d| _Y n0 ||d< g |fS )N)Úconnect_timeoutÚread_timeoutZwrite_timeoutÚclient_flagÚportZ	pool_size)Zlocal_infileZssl_verify_certÚsslZpool_reset_connectionÚcompressri   r   z.constants.CLIENTF)Ztranslate_connect_argsÚupdateÚqueryr   Zcoerce_kw_typerB   r`   ÚgetrP   r]   r/   Ú	constantsZCLIENTZ
FOUND_ROWSÚAttributeErrorÚImportErrorÚsupports_sane_rowcount)r-   rf   ÚoptsZ
int_paramsZbool_paramsÚkeyri   ZCLIENT_FLAGSr)   r)   r*   Úcreate_connect_argsÅ   s&    

ÿz1MySQLDialect_mariadbconnector.create_connect_argsrB   )Ú	exceptionr!   c                 C  s    z
|j }W n   d}Y n0 |S )Néÿÿÿÿ)Úerrno)r-   rw   Úrcr)   r)   r*   Ú_extract_error_codeì   s
    

z1MySQLDialect_mariadbconnector._extract_error_coder   r,   )rb   r!   c                 C  s   dS )NrH   r)   )r-   rb   r)   r)   r*   Ú_detect_charsetó   s    z-MySQLDialect_mariadbconnector._detect_charsetr   zSequence[IsolationLevel])Ú
dbapi_connr!   c                 C  s   dS )N)ZSERIALIZABLEzREAD UNCOMMITTEDzREAD COMMITTEDzREPEATABLE READÚ
AUTOCOMMITr)   ©r-   r}   r)   r)   r*   Úget_isolation_level_valuesö   s    z8MySQLDialect_mariadbconnector.get_isolation_level_valuesc                 C  s
   t |jƒS r<   )r`   Ú
autocommitr   r)   r)   r*   Údetect_autocommit_setting  s    z7MySQLDialect_mariadbconnector.detect_autocommit_settingr   )Údbapi_connectionÚlevelr!   c                   s(   |dkrd|_ nd|_ tƒ  ||¡ d S )Nr~   TF)r�   r=   Úset_isolation_level)r-   rƒ   r„   r@   r)   r*   r…     s    z1MySQLDialect_mariadbconnector.set_isolation_level)rb   Úxidr!   c              	   C  s&   |  t d¡ tjd|dd�¡¡ d S )NzXA BEGIN :xidr†   T©Zliteral_execute©Úexecuter   ÚtextÚ
bindparamsÚ	bindparam©r-   rb   r†   r)   r)   r*   Údo_begin_twophase  s
    
ÿÿz/MySQLDialect_mariadbconnector.do_begin_twophasec              	   C  sH   |  t d¡ tjd|dd�¡¡ |  t d¡ tjd|dd�¡¡ d S )NúXA END :xidr†   Tr‡   zXA PREPARE :xidrˆ   r�   r)   r)   r*   Údo_prepare_twophase  s    
ÿÿ
ÿÿz1MySQLDialect_mariadbconnector.do_prepare_twophaseF)rb   r†   Úis_preparedÚrecoverr!   c              	   C  sL   |s&|  t d¡ tjd|dd�¡¡ |  t d¡ tjd|dd�¡¡ d S )Nr�   r†   Tr‡   zXA ROLLBACK :xidrˆ   ©r-   rb   r†   r‘   r’   r)   r)   r*   Údo_rollback_twophase   s    
ÿÿ
ÿÿz2MySQLDialect_mariadbconnector.do_rollback_twophasec              	   C  s6   |s|   ||¡ | t d¡ tjd|dd�¡¡ d S )NzXA COMMIT :xidr†   Tr‡   )r�   r‰   r   rŠ   r‹   rŒ   r“   r)   r)   r*   Údo_commit_twophase3  s    
ÿÿz0MySQLDialect_mariadbconnector.do_commit_twophase)TF)TF))r/   r0   r1   ZdriverZsupports_statement_cacheZsupports_unicode_statementsÚencodingZconvert_unicoders   Zsupports_sane_multi_rowcountZsupports_native_decimalZdefault_paramstyler2   Zexecution_ctx_clsrF   Zstatement_compilerZsupports_server_side_cursorsr   Zupdate_copyr   Zcolspecsr   ZUuidr   Zmemoized_propertyrT   rY   Úclassmethodr_   rc   rv   r{   r|   r€   r‚   r…   rŽ   r�   r”   r•   rE   r)   r)   r@   r*   rG   |   sF   ÿ'	  û  ûrG   )-Ú__doc__Ú
__future__r   rR   Útypingr   r   r   r   r   r   Úuuidr	   r'   Úbaser   r   r   Ú r   r   r   Zengine.baser   Zengine.interfacesr   r   r   r   r   r   r   Z
engine.urlr   Zsql.compilerr   Zsql.type_apir   rZ   Z_UUID_RETURNr   r2   rF   rG   r   r)   r)   r)   r*   Ú<module>   sD    H