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  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+mysqldb
    :name: mysqlclient (maintained fork of MySQL-Python)
    :dbapi: mysqldb
    :connectstring: mysql+mysqldb://<user>:<password>@<host>[:<port>]/<dbname>
    :url: https://pypi.org/project/mysqlclient/

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

The mysqlclient DBAPI is a maintained fork of the
`MySQL-Python <https://sourceforge.net/projects/mysql-python>`_ DBAPI
that is no longer maintained.  `mysqlclient`_ supports Python 2 and Python 3
and is very stable.

.. _mysqlclient: https://github.com/PyMySQL/mysqlclient-python

.. _mysqldb_unicode:

Unicode
-------

Please see :ref:`mysql_unicode` for current recommendations on unicode
handling.

.. _mysqldb_ssl:

SSL Connections
----------------

The mysqlclient and PyMySQL DBAPIs accept an additional dictionary under the
key "ssl", which may be specified using the
:paramref:`_sa.create_engine.connect_args` dictionary::

    engine = create_engine(
        "mysql+mysqldb://scott:tiger@192.168.0.134/test",
        connect_args={
            "ssl": {
                "ca": "/home/gord/client-ssl/ca.pem",
                "cert": "/home/gord/client-ssl/client-cert.pem",
                "key": "/home/gord/client-ssl/client-key.pem",
            }
        },
    )

For convenience, the following keys may also be specified inline within the URL
where they will be interpreted into the "ssl" dictionary automatically:
"ssl_ca", "ssl_cert", "ssl_key", "ssl_capath", "ssl_cipher",
"ssl_check_hostname". An example is as follows::

    connection_uri = (
        "mysql+mysqldb://scott:tiger@192.168.0.134/test"
        "?ssl_ca=/home/gord/client-ssl/ca.pem"
        "&ssl_cert=/home/gord/client-ssl/client-cert.pem"
        "&ssl_key=/home/gord/client-ssl/client-key.pem"
    )

.. seealso::

    :ref:`pymysql_ssl` in the PyMySQL dialect


Using MySQLdb with Google Cloud SQL
-----------------------------------

Google Cloud SQL now recommends use of the MySQLdb dialect.  Connect
using a URL like the following:

.. sourcecode:: text

    mysql+mysqldb://root@/<dbname>?unix_socket=/cloudsql/<projectid>:<instancename>

Server Side Cursors
-------------------

The mysqldb dialect supports server-side cursors. See :ref:`mysql_ss_cursors`.

é    )ÚannotationsN)ÚAny)ÚCallable)Úcast)ÚDict)ÚOptional)ÚTuple)ÚTYPE_CHECKINGé   )ÚMySQLCompiler)ÚMySQLDialect)ÚMySQLExecutionContext)ÚMySQLIdentifierPrepareré   )Úutil)ÚLiteral)Ú
Connection)Ú_DBAPIMultiExecuteParams)ÚConnectArgsType)ÚDBAPIConnection)ÚDBAPICursor)ÚDBAPIModule)ÚExecutionContext)ÚIsolationLevel)ÚURLc                   @  s   e Zd ZdS )ÚMySQLExecutionContext_mysqldbN©Ú__name__Ú
__module__Ú__qualname__© r    r    ú`/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyr   w   s   r   c                   @  s   e Zd ZdS )ÚMySQLCompiler_mysqldbNr   r    r    r    r!   r"   {   s   r"   c                      s>  e Zd ZU dZdZdZdZdZdZdZ	e
ZeZeZded< ddœ‡ fdd	„Zd
ddœdd„Zejjddœdd„ƒZeddœdd„ƒZddœ‡ fdd„Zdddœdd„ZdAdd
dd d!d"œd#d$„ZdBd%d&d'd(œd)d*„Zd+dœd,d-„Zd.d/d0œd1d2„Zd3d
d4œd5d6„Zdd7d8œd9d:„Z ddd8œd;d<„Z!dd=d!d>œ‡ fd?d@„Z"‡  Z#S )CÚMySQLDialect_mysqldbZmysqldbTÚformatzTuple[int, ...]Zserver_version_infor   )Úkwargsc                   s@   t ƒ jf i |¤Ž | jd ur6t| jdƒr6|  | jj¡nd| _d S )NÚ__version__©r   r   r   )ÚsuperÚ__init__ÚdbapiÚhasattrÚ_parse_dbapi_versionr&   Z_mysql_dbapi_version)Úselfr%   ©Ú	__class__r    r!   r)   Ž   s    ÿ
ÿýzMySQLDialect_mysqldb.__init__Ústr)ÚversionÚreturnc                 C  s4   t  d|¡}|r,tdd„ | ddd¡D ƒƒS dS d S )Nz(\d+)\.(\d+)(?:\.(\d+))?c                 s  s   | ]}|d urt |ƒV  qd S ©N)Úint)Ú.0Úxr    r    r!   Ú	<genexpr>™   ó    z<MySQLDialect_mysqldb._parse_dbapi_version.<locals>.<genexpr>r
   é   r   r'   )ÚreÚmatchÚtupleÚgroup)r-   r1   Úmr    r    r!   r,   –   s    z)MySQLDialect_mysqldb._parse_dbapi_versionÚbool)r2   c              	   C  s6   zt dƒj}|j| _W dS  ttfy0   Y dS 0 d S )NzMySQLdb.cursorsTF)Ú
__import__ÚcursorsZSSCursorZ	_sscursorÚImportErrorÚAttributeError)r-   rA   r    r    r!   Úsupports_server_side_cursors�   s    
z1MySQLDialect_mysqldb.supports_server_side_cursorsr   c                 C  s   t dƒS )NZMySQLdb)r@   )Úclsr    r    r!   Úimport_dbapi¦   s    z!MySQLDialect_mysqldb.import_dbapiz!Callable[[DBAPIConnection], None]c                   s"   t ƒ  ¡ ‰ dddœ‡ fdd„}|S )Nr   ÚNone)Úconnr2   c                   sB   ˆ d urˆ | ƒ |   ¡ }|d ur>|  ¡ }| d| ¡ | ¡  d S )NzSET NAMES %s)Úcharacter_set_nameÚcursorÚexecuteÚclose)rH   Úcharset_namerJ   ©Zsuper_r    r!   Ú
on_connect­   s    z3MySQLDialect_mysqldb.on_connect.<locals>.on_connect)r(   rO   )r-   rO   r.   rN   r!   rO   ª   s    
zMySQLDialect_mysqldb.on_connectr   zLiteral[True])Údbapi_connectionr2   c                 C  s   |  ¡  dS )NT)Zping)r-   rP   r    r    r!   Údo_pingº   s    zMySQLDialect_mysqldb.do_pingNr   r   zOptional[ExecutionContext]rG   )rJ   Ú	statementÚ
parametersÚcontextr2   c                 C  s$   |  ||¡}|d ur |tt|ƒ_d S r3   )Zexecutemanyr   r   Z	_rowcount)r-   rJ   rR   rS   rT   Zrowcountr    r    r!   Údo_executemany¾   s    z#MySQLDialect_mysqldb.do_executemanyr   zOptional[Dict[str, Any]]r   )ÚurlÚ_translate_argsr2   c           
      C  sX  |d u rt dddd�}|jf i |¤Ž}| |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¡ i }dtfdtfdtfdtfdtfdtfg}|D ]@\}}||v rÒ|| ||dd … < t ||dd … |¡ ||= qÒ|�r"||d< | 	d	d¡}|  
¡ }	|	d u�rP||	O }||d	< g |fS )NÚdbÚuserÚpasswd)ZdatabaseÚusernameÚpasswordÚcompressÚconnect_timeoutÚread_timeoutZwrite_timeoutÚclient_flagZlocal_infileZuse_unicodeÚcharsetZssl_caZssl_keyZssl_certZ
ssl_capathZ
ssl_cipherZssl_check_hostnameé   Ússlr   )ÚdictZtranslate_connect_argsÚupdateÚqueryr   Zcoerce_kw_typer?   r4   r0   ÚgetÚ_found_rows_client_flag)
r-   rV   rW   Úoptsrc   ÚkeysÚkeyZkw_typer`   Zclient_flag_found_rowsr    r    r!   Úcreate_connect_argsÉ   sF    ÿú
z(MySQLDialect_mysqldb.create_connect_argszOptional[int]c              	   C  sL   | j d urDzt| j jd ƒjj}W n ttfy:   Y d S 0 |jS nd S d S )Nz.constants.CLIENT)r*   r@   r   Ú	constantsZCLIENTrC   rB   Z
FOUND_ROWS)r-   ZCLIENT_FLAGSr    r    r!   rh   þ   s    

ÿz,MySQLDialect_mysqldb._found_rows_client_flagzDBAPIModule.Errorr4   )Ú	exceptionr2   c                 C  s
   |j d S )Nr   )Úargs)r-   rn   r    r    r!   Ú_extract_error_code  s    z(MySQLDialect_mysqldb._extract_error_coder   )Ú
connectionr2   c                 C  s6   z|j j}W n ty*   t d¡ Y dS 0 |ƒ S dS )z:Sniff out the character set in use for connection results.z�No 'character_set_name' can be detected with this MySQL-Python version; please upgrade to a recent version of MySQL-Python.  Assuming latin1.Úlatin1N)rq   rI   rC   r   Úwarn)r-   rq   Z	cset_namer    r    r!   Ú_detect_charset  s    ÿÿz$MySQLDialect_mysqldb._detect_charsetzTuple[IsolationLevel, ...])Ú
dbapi_connr2   c                 C  s   dS )N)ZSERIALIZABLEzREAD UNCOMMITTEDzREAD COMMITTEDzREPEATABLE READÚ
AUTOCOMMITr    ©r-   ru   r    r    r!   Úget_isolation_level_values#  s    z/MySQLDialect_mysqldb.get_isolation_level_valuesc                 C  s   |  ¡ S r3   )Zget_autocommitrw   r    r    r!   Údetect_autocommit_setting.  s    z.MySQLDialect_mysqldb.detect_autocommit_settingr   )rP   Úlevelr2   c                   s0   |dkr|  d¡ n|  d¡ tƒ  ||¡ d S )Nrv   TF)Z
autocommitr(   Úset_isolation_level)r-   rP   rz   r.   r    r!   r{   1  s    
z(MySQLDialect_mysqldb.set_isolation_level)N)N)$r   r   r   ZdriverZsupports_statement_cacheZsupports_unicode_statementsZsupports_sane_rowcountZsupports_sane_multi_rowcountZsupports_native_decimalZdefault_paramstyler   Zexecution_ctx_clsr"   Zstatement_compilerr   ÚpreparerÚ__annotations__r)   r,   r   ZlanghelpersZmemoized_propertyrD   ÚclassmethodrF   rO   rQ   rU   rl   rh   rp   rt   rx   ry   r{   Ú__classcell__r    r    r.   r!   r#      s:   
	 û ÿ5r#   )%Ú__doc__Ú
__future__r   r:   Útypingr   r   r   r   r   r   r	   Úbaser   r   r   r   Ú r   Zutil.typingr   Zengine.baser   Zengine.interfacesr   r   r   r   r   r   r   Z
engine.urlr   r   r"   r#   Údialectr    r    r    r!   Ú<module>   s<   P =