a
    xˆc‹  ã                   @   s„   d 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
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

é    Né   )ÚMySQLCompiler)ÚMySQLDialect)ÚMySQLExecutionContexté   )Úsql)Úutil)r   r   r   c                   @   s0   e Zd ZdZdd„ Zdd„ Zdd„ Zdd	„ ZdS )
Ú&MySQLExecutionContext_mariadbconnectorNc                 C   s   | j jdd�S )NF©Zbuffered©Z_dbapi_connectionÚcursor©Úself© r   úm/home/yuhw/wc/wire-cell-python/wcpy/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/mariadbconnector.pyÚcreate_server_side_cursor,   s    z@MySQLExecutionContext_mariadbconnector.create_server_side_cursorc                 C   s   | j jdd�S )NTr
   r   r   r   r   r   Úcreate_default_cursor/   s    z<MySQLExecutionContext_mariadbconnector.create_default_cursorc                 C   s   | j r| jjr| jj| _d S ©N)ZisinsertZcompiledZpostfetch_lastrowidr   Z	lastrowidÚ
_lastrowidr   r   r   r   Ú	post_exec2   s    z0MySQLExecutionContext_mariadbconnector.post_execc                 C   s   | j S r   )r   r   r   r   r   Úget_lastrowid6   s    z4MySQLExecutionContext_mariadbconnector.get_lastrowid)Ú__name__Ú
__module__Ú__qualname__r   r   r   r   r   r   r   r   r   r	   )   s
   r	   c                   @   s   e Zd ZdS )ÚMySQLCompiler_mariadbconnectorN)r   r   r   r   r   r   r   r   :   s   r   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jdd„ ƒZ‡ fdd„Zed	d
„ ƒZ‡ fdd„Zdd„ Zdd„ Zdd„ Zeg d¢ƒZ‡ fdd„Zdd„ Zdd„ Zddd„Z d dd„Z!‡  Z"S )!ÚMySQLDialect_mariadbconnectorZmariadbconnectorTÚutf8mb4Úqmarkc                 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   )Úint©Ú.0Úxr   r   r   Ú
<listcomp>\   s   ÿz@MySQLDialect_mariadbconnector._dbapi_version.<locals>.<listcomp>z(\d+)(?:[-\.]?|$))éc   r$   r$   )ÚdbapiÚhasattrÚtupleÚreÚfindallr   r   r   r   r   Ú_dbapi_versionX   s    ÿþÿ	z,MySQLDialect_mariadbconnector._dbapi_versionc                    sP   t t| ƒjf i |¤Ž d| _| jd urL| jtk rLtdd dd„ tD ƒ¡ ƒ‚d S )Nr   z?The minimum required version for MariaDB Connector/Python is %sÚ.c                 s   s   | ]}t |ƒV  qd S r   )Ústrr    r   r   r   Ú	<genexpr>n   ó    z9MySQLDialect_mariadbconnector.__init__.<locals>.<genexpr>)	Úsuperr   Ú__init__Z
paramstyler%   r*   Úmariadb_cpy_minimum_versionÚNotImplementedErrorÚjoin)r   Úkwargs©Ú	__class__r   r   r0   f   s    

þÿz&MySQLDialect_mariadbconnector.__init__c                 C   s   t dƒS )NZmariadb)Ú
__import__)Úclsr   r   r   r%   q   s    z#MySQLDialect_mariadbconnector.dbapic                    sJ   t t| ƒ |||¡rdS t|| jjƒrBt|ƒ ¡ }d|v p@d|v S dS d S )NTznot connectedzisn't validF)r/   r   Úis_disconnectÚ
isinstancer%   ÚErrorr,   Úlower)r   ÚeÚ
connectionr   Zstr_er5   r   r   r9   u   s    
ÿz+MySQLDialect_mariadbconnector.is_disconnectc              	   C   s®   |  ¡ }g d¢}g d¢}|D ]}t ||t¡ q|D ]}t ||t¡ q4| 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 |gS )N)Úconnect_timeoutÚread_timeoutZwrite_timeoutÚclient_flagÚportZ	pool_size)Zlocal_infileZssl_verify_certÚsslZpool_reset_connectionrA   r   z.constants.CLIENTF)Ztranslate_connect_argsr   Zcoerce_kw_typer   ÚboolÚgetr%   r7   r   Ú	constantsZCLIENTZ
FOUND_ROWSÚAttributeErrorÚImportErrorÚsupports_sane_rowcount)r   ÚurlÚoptsZ
int_paramsZbool_paramsÚkeyrA   ZCLIENT_FLAGSr   r   r   Úcreate_connect_args€   s$    

ÿz1MySQLDialect_mariadbconnector.create_connect_argsc                 C   s    z
|j }W n   d}Y n0 |S )Néÿÿÿÿ)Úerrno)r   Ú	exceptionÚrcr   r   r   Ú_extract_error_code¥   s
    

z1MySQLDialect_mariadbconnector._extract_error_codec                 C   s   dS )Nr   r   )r   r>   r   r   r   Ú_detect_charset¬   s    z-MySQLDialect_mariadbconnector._detect_charset)ZSERIALIZABLEzREAD UNCOMMITTEDzREAD COMMITTEDzREPEATABLE READÚ
AUTOCOMMITc                    s,   |dkrd|_ nd|_ tt| ƒ ||¡ d S )NrT   TF)Z
autocommitr/   r   Ú_set_isolation_level)r   r>   Úlevelr5   r   r   rU   ¹   s    
ÿz2MySQLDialect_mariadbconnector._set_isolation_levelc              	   C   s&   |  t d¡ tjd|dd�¡¡ d S )NzXA BEGIN :xidÚxidT©Zliteral_execute©Úexecuter   ÚtextÚ
bindparamsÚ	bindparam©r   r>   rW   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 :xidrW   TrX   zXA PREPARE :xidrY   r^   r   r   r   Údo_prepare_twophaseÉ   s    
ÿÿ
ÿÿz1MySQLDialect_mariadbconnector.do_prepare_twophaseFc              	   C   sL   |s&|  t d¡ tjd|dd�¡¡ |  t d¡ tjd|dd�¡¡ d S )Nr`   rW   TrX   zXA ROLLBACK :xidrY   ©r   r>   rW   Zis_preparedZrecoverr   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 :xidrW   TrX   )ra   rZ   r   r[   r\   r]   rb   r   r   r   Údo_commit_twophaseä   s    
ÿÿz0MySQLDialect_mariadbconnector.do_commit_twophase)TF)TF)#r   r   r   ZdriverZsupports_statement_cacheZsupports_unicode_statementsÚencodingZconvert_unicoderI   Zsupports_sane_multi_rowcountZsupports_native_decimalZdefault_paramstyler	   Zexecution_ctx_clsr   Zstatement_compilerZsupports_server_side_cursorsr   Zmemoized_propertyr*   r0   Úclassmethodr%   r9   rM   rR   rS   ÚsetZ_isolation_lookuprU   r_   ra   rc   rd   Ú__classcell__r   r   r5   r   r   >   s>   

%ÿ
	 ÿ
 ÿr   )Ú__doc__r(   Úbaser   r   r   Ú r   r   r1   r	   r   r   Údialectr   r   r   r   Ú<module>   s    3