a
    •˜ëjø  ã                   @  s*  d Z ddlmZ ddl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 G dd„ deƒZG dd„ deƒZ G dd„ deeƒZ!e!Z"dS )aH  

.. dialect:: mysql+pyodbc
    :name: PyODBC
    :dbapi: pyodbc
    :connectstring: mysql+pyodbc://<username>:<password>@<dsnname>
    :url: https://pypi.org/project/pyodbc/

.. note::

    The PyODBC for MySQL dialect is **not tested as part of
    SQLAlchemy's continuous integration**.
    The recommended MySQL dialects are mysqlclient and PyMySQL.
    However, if you want to use the mysql+pyodbc dialect and require
    full support for ``utf8mb4`` characters (including supplementary
    characters like emoji) be sure to use a current release of
    MySQL Connector/ODBC and specify the "ANSI" (**not** "Unicode")
    version of the driver in your DSN or connection string.

Pass through exact pyodbc connection string::

    import urllib

    connection_string = (
        "DRIVER=MySQL ODBC 8.0 ANSI Driver;"
        "SERVER=localhost;"
        "PORT=3307;"
        "DATABASE=mydb;"
        "UID=root;"
        "PWD=(whatever);"
        "charset=utf8mb4;"
    )
    params = urllib.parse.quote_plus(connection_string)
    connection_uri = "mysql+pyodbc:///?odbc_connect=%s" % params

é    )ÚannotationsN)ÚAny)ÚCallable)ÚOptional)ÚTuple)ÚTYPE_CHECKING)ÚUnioné   )ÚMySQLDialect)ÚMySQLExecutionContext)ÚTIMEé   )Úexc)Úutil)ÚPyODBCConnector)ÚTime)Ú
Connection)ÚDBAPIConnection)ÚDialect)Ú_ResultProcessorTypec                   @  s   e Zd Zddddœdd„ZdS )Ú_pyodbcTIMEr   Úobjectz#_ResultProcessorType[datetime.time])ÚdialectÚcoltypeÚreturnc                 C  s   dddœdd„}|S )Nr   zUnion[datetime.time, None])Úvaluer   c                 S  s   | S ©N© )r   r   r   ú_/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/pyodbc.pyÚprocessL   s    z-_pyodbcTIME.result_processor.<locals>.processr   )Úselfr   r   r   r   r   r   Úresult_processorI   s    z_pyodbcTIME.result_processorN)Ú__name__Ú
__module__Ú__qualname__r!   r   r   r   r   r   H   s   r   c                   @  s   e Zd Zddœdd„ZdS )ÚMySQLExecutionContext_pyodbcÚint©r   c                 C  s*   |   ¡ }| d¡ | ¡ d }| ¡  |S )NzSELECT LAST_INSERT_ID()r   )Zcreate_cursorÚexecuteZfetchoneÚclose)r    ÚcursorZ	lastrowidr   r   r   Úget_lastrowidT   s
    
z*MySQLExecutionContext_pyodbc.get_lastrowidN)r"   r#   r$   r+   r   r   r   r   r%   S   s   r%   c                      st   e Zd ZdZe ejee	i¡ZdZ
eZdZdddœdd„Zdddœd	d
„Zdddœdd„Zddœ‡ fdd„Z‡  ZS )ÚMySQLDialect_pyodbcTZMySQLr   Ústr)Ú
connectionr   c                 C  sD   d| _ z|  |d¡}|r|W S W n tjy4   Y n0 t d¡ dS )z:Sniff out the character set in use for connection results.NZcharacter_set_clientz@Could not detect the connection character set.  Assuming latin1.Úlatin1)Z_connection_charsetZ_fetch_settingr   Z
DBAPIErrorr   Úwarn)r    r.   r   r   r   r   Ú_detect_charsetd   s    
ÿz#MySQLDialect_pyodbc._detect_charsetzTuple[int, ...]c                 C  s   t  | |¡S r   )r
   Ú_get_server_version_info)r    r.   r   r   r   r2   }   s    z,MySQLDialect_pyodbc._get_server_version_infoÚBaseExceptionzOptional[int])Ú	exceptionr   c                 C  s@   t  d¡ t|jƒ¡}|d u r"d S | d¡}|r8t|ƒS d S d S )Nz	\((\d+)\)r	   )ÚreÚcompileÚsearchr-   ÚargsÚgroupr&   )r    r4   ÚmÚcr   r   r   Ú_extract_error_code‚   s    
z'MySQLDialect_pyodbc._extract_error_codez!Callable[[DBAPIConnection], None]r'   c                   s"   t ƒ  ¡ ‰ dddœ‡ fdd„}|S )Nr   ÚNone)Úconnr   c                   sD   ˆ d urˆ | ƒ d}d}| j |dd� | j |dd� | jdd� d S )Nr	   iøÿÿÿzutf-8)Úencoding)ZsetdecodingZsetencoding)r>   Zpyodbc_SQL_CHARZpyodbc_SQL_WCHAR©Zsuper_r   r   Ú
on_connect�   s    z2MySQLDialect_pyodbc.on_connect.<locals>.on_connect)ÚsuperrA   )r    rA   ©Ú	__class__r@   r   rA   Œ   s    
zMySQLDialect_pyodbc.on_connect)r"   r#   r$   Zsupports_statement_cacher   Zupdate_copyr
   Zcolspecsr   r   Zsupports_unicode_statementsr%   Zexecution_ctx_clsZpyodbc_driver_namer1   r2   r<   rA   Ú__classcell__r   r   rC   r   r,   \   s   
r,   )#Ú__doc__Ú
__future__r   Údatetimer5   Útypingr   r   r   r   r   r   Úbaser
   r   Útypesr   Ú r   r   Zconnectors.pyodbcr   Zsql.sqltypesr   Zenginer   Zengine.interfacesr   r   Zsql.type_apir   r   r%   r,   r   r   r   r   r   Ú<module>	   s2   %	B