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d
lm	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+mysqlconnector
    :name: MySQL Connector/Python
    :dbapi: myconnpy
    :connectstring: mysql+mysqlconnector://<user>:<password>@<host>[:<port>]/<dbname>
    :url: https://pypi.org/project/mysql-connector-python/

.. note::

    The MySQL Connector/Python DBAPI has had many issues since its release,
    some of which may remain unresolved, and the mysqlconnector dialect is
    **not tested as part of SQLAlchemy's continuous integration**.
    The recommended MySQL dialects are mysqlclient and PyMySQL.

é    Né   )ÚBIT)ÚMySQLCompiler)ÚMySQLDialect)ÚMySQLIdentifierPrepareré   )Ú
processors)Úutilc                   @   s$   e Zd Zdd„ Zdd„ Zdd„ ZdS )ÚMySQLCompiler_mysqlconnectorc                 K   sd   | j jr4| j|jfi |¤Žd | j|jfi |¤Ž S | j|jfi |¤Žd | j|jfi |¤Ž S d S )Nz %% z % )ÚdialectÚ_mysqlconnector_double_percentsÚprocessÚleftÚright)ÚselfÚbinaryÚoperatorÚkw© r   úk/home/yuhw/wc/wire-cell-python/wcpy/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/mysqlconnector.pyÚvisit_mod_binary#   s    ÿþÿÿþÿz-MySQLCompiler_mysqlconnector.visit_mod_binaryc                 C   s   | j jr| dd¡S |S d S ©Nú%z%%©r   r   Úreplace©r   Útextr   r   r   Úpost_process_text1   s    z.MySQLCompiler_mysqlconnector.post_process_textc                 C   s   | j jr| dd¡S |S d S r   r   r   r   r   r   Úescape_literal_column7   s    z2MySQLCompiler_mysqlconnector.escape_literal_columnN)Ú__name__Ú
__module__Ú__qualname__r   r   r   r   r   r   r   r
   "   s   r
   c                   @   s.   e Zd Zedd„ ƒZejdd„ ƒZdd„ ZdS )Ú&MySQLIdentifierPreparer_mysqlconnectorc                 C   s   | j jS ©N)r   r   ©r   r   r   r   Ú_double_percents?   s    z7MySQLIdentifierPreparer_mysqlconnector._double_percentsc                 C   s   d S r#   r   ©r   Úvaluer   r   r   r%   C   s    c                 C   s,   |  | j| j¡}| jjr$|  dd¡S |S d S r   )r   Zescape_quoteZescape_to_quoter   r   r&   r   r   r   Ú_escape_identifierG   s    z9MySQLIdentifierPreparer_mysqlconnector._escape_identifierN)r   r    r!   Úpropertyr%   Úsetterr(   r   r   r   r   r"   >   s
   

r"   c                   @   s   e Zd Zdd„ ZdS )Ú_myconnpyBITc                 C   s   dS )z0MySQL-connector already converts mysql bits, so.Nr   )r   r   Zcoltyper   r   r   Úresult_processorP   s    z_myconnpyBIT.result_processorN)r   r    r!   r,   r   r   r   r   r+   O   s   r+   c                       sð   e Zd ZdZdZdZdZdZdZdZ	e
ZeZe ejeei¡Z‡ fdd„Zdd„ Zedd	„ ƒZejd
d„ ƒZedd„ ƒZdd„ Zdd„ Zejdd„ ƒZejdd„ ƒZdd„ Z dd„ Z!dd„ Z"d$dd„Z#d%dd „Z$e%g d!¢ƒZ&‡ fd"d#„Z'‡  Z(S )&ÚMySQLDialect_mysqlconnectorZmysqlconnectorTÚformatc                    s(   t t| ƒj|i |¤Ž t | j¡| _d S r#   )Úsuperr-   Ú__init__r   Z(to_conditional_unicode_processor_factoryÚdescription_encodingZ_description_decoder)r   Úargr   ©Ú	__class__r   r   r0   h   s
    ÿþz$MySQLDialect_mysqlconnector.__init__c                 C   s   dS )NFr   ©r   Ú
connectionr   r   r   Ú_check_unicode_descriptionq   s    z6MySQLDialect_mysqlconnector._check_unicode_descriptionc                 C   s   dS )Nzlatin-1r   r$   r   r   r   r1   v   s    z0MySQLDialect_mysqlconnector.description_encodingc                 C   s   t jp| jdkS ©N)é   r   ©r	   Zpy3kÚ_mysqlconnector_version_infor$   r   r   r   Úsupports_unicode_statements{   s    z7MySQLDialect_mysqlconnector.supports_unicode_statementsc                 C   s   ddl m} |S )Nr   )Ú	connector)Zmysqlr=   )Úclsr=   r   r   r   Údbapi   s    z!MySQLDialect_mysqlconnector.dbapic              
   C   s^   z|  d¡ W nF | jjyT } z*|  ||d ¡r>W Y d }~dS ‚ W Y d }~nd }~0 0 dS d S )NFT)Zpingr?   ÚErrorÚis_disconnect)r   Zdbapi_connectionÚerrr   r   r   Údo_ping…   s    z#MySQLDialect_mysqlconnector.do_pingc                 C   s`  |j dd�}| |j¡ t |dt¡ t |dt¡ t |dt¡ t |dt¡ t |dt¡ t |dt¡ t |d	t¡ t |d
t¡ t |dt¡ t |dt¡ t |dt¡ t |dt¡ t |dt¡ t |dt¡ t |dt¡ t |dt¡ | dd¡ | jd u�rXz2ddl	m
} | d| ¡ ¡}||jO }||d< W n t�yV   Y n0 g |gS )NÚuser)ÚusernameZallow_local_infileÚ
autocommitZbufferedÚcompressZconnection_timeoutÚconnect_timeoutZconsume_resultsZ
force_ipv6Zget_warningsZpool_reset_sessionZ	pool_sizeZraise_on_warningsÚrawZssl_verify_certZuse_pureZuse_unicodeTr   )Ú
ClientFlagÚclient_flags)Ztranslate_connect_argsÚupdateÚqueryr	   Zcoerce_kw_typeÚboolÚintÚ
setdefaultr?   Zmysql.connector.constantsrJ   ÚgetÚget_defaultZ
FOUND_ROWSÚ	Exception)r   ÚurlÚoptsrJ   rK   r   r   r   Úcreate_connect_args�   s<    ÿ
z/MySQLDialect_mysqlconnector.create_connect_argsc                 C   sF   | j rBt| j dƒrBt d| j j¡}|rBtdd„ | ddd¡D ƒƒS d S )NÚ__version__z(\d+)\.(\d+)(?:\.(\d+))?c                 s   s   | ]}|d urt |ƒV  qd S r#   )rO   )Ú.0Úxr   r   r   Ú	<genexpr>¾   ó    zKMySQLDialect_mysqlconnector._mysqlconnector_version_info.<locals>.<genexpr>r   r9   r   )r?   ÚhasattrÚreÚmatchrW   ÚtupleÚgroup)r   Úmr   r   r   r;   ¹   s    z8MySQLDialect_mysqlconnector._mysqlconnector_version_infoc                 C   s   t j o| jdk S r8   r:   r$   r   r   r   r   À   s    z;MySQLDialect_mysqlconnector._mysqlconnector_double_percentsc                 C   s   |j jS r#   )r6   Úcharsetr5   r   r   r   Ú_detect_charsetÄ   s    z+MySQLDialect_mysqlconnector._detect_charsetc                 C   s   |j S r#   )Úerrno)r   Ú	exceptionr   r   r   Ú_extract_error_codeÇ   s    z/MySQLDialect_mysqlconnector._extract_error_codec                 C   sH   d}| j j| j jf}t||ƒr@|j|v p>dt|ƒv p>dt|ƒv S dS d S )N)iÖ  iÝ  iÞ  iý  i  i   zMySQL Connection not available.z$Connection to MySQL is not availableF)r?   ZOperationalErrorZInterfaceErrorÚ
isinstancerd   Ústr)r   Úer6   ÚcursorZerrnosÚ
exceptionsr   r   r   rA   Ê   s    


ÿ
ýz)MySQLDialect_mysqlconnector.is_disconnectNc                 C   s   |  ¡ S r#   )Zfetchall©r   Úrprb   r   r   r   Ú_compat_fetchallÖ   s    z,MySQLDialect_mysqlconnector._compat_fetchallc                 C   s   |  ¡ S r#   )Zfetchonerl   r   r   r   Ú_compat_fetchoneÙ   s    z,MySQLDialect_mysqlconnector._compat_fetchone)ZSERIALIZABLEzREAD UNCOMMITTEDzREAD COMMITTEDzREPEATABLE READÚ
AUTOCOMMITc                    s,   |dkrd|_ nd|_ tt| ƒ ||¡ d S )Nrp   TF)rF   r/   r-   Ú_set_isolation_level)r   r6   Úlevelr3   r   r   rq   æ   s    
ÿz0MySQLDialect_mysqlconnector._set_isolation_level)N)N))r   r    r!   ZdriverZsupports_statement_cacheZsupports_unicode_bindsZsupports_sane_rowcountZsupports_sane_multi_rowcountZsupports_native_decimalZdefault_paramstyler
   Zstatement_compilerr"   Úpreparerr	   Zupdate_copyr   Zcolspecsr   r+   r0   r7   r)   r1   Zmemoized_propertyr<   Úclassmethodr?   rC   rV   r;   r   rc   rf   rA   rn   ro   ÚsetZ_isolation_lookuprq   Ú__classcell__r   r   r3   r   r-   V   sB   	


)



ÿ
r-   )Ú__doc__r]   Úbaser   r   r   r   Ú r   r	   r
   r"   r+   r-   r   r   r   r   r   Ú<module>   s    