관리-도구
편집 파일: mysqldb.cpython-38.pyc
U -?�f % � @ s� d Z ddlZddlmZ ddlmZ ddlmZ ddlmZ ddlmZ d d lm Z d d lm Z G d d � d e�Z G dd� de�Z G dd� de�Z e ZdS )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:: mysql+mysqldb://root@/<dbname>?unix_socket=/cloudsql/<projectid>:<instancename> Server Side Cursors ------------------- The mysqldb dialect supports server-side cursors. See :ref:`mysql_ss_cursors`. � N� )� MySQLCompiler)� MySQLDialect)�MySQLExecutionContext)�MySQLIdentifierPreparer)�TEXT� )�sql)�utilc @ s e Zd ZdS )� MySQLExecutionContext_mysqldbN��__name__� __module__� __qualname__� r r �Q/opt/hc_python/lib64/python3.8/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyr c s r c @ s e Zd ZdS )�MySQLCompiler_mysqldbNr r r r r r g s r c s� e Zd ZdZdZdZdZdZdZdZ e Z e Z eZ� fdd�Zdd� Zejjdd � �Zed d � �Z� fd d �Zdd� Zd!dd�Z� fdd�Zd"dd�Z dd� Z dd� Z dd � Z d d � Z � fd d �Z!� Z"S )#�MySQLDialect_mysqldbZmysqldbT�formatc s< t � jf |� | jd k r2t| jd�r2| �| jj�nd| _d S )N� __version__�r r r )�super�__init__�dbapi�hasattr�_parse_dbapi_versionr Z_mysql_dbapi_version)�self�kwargs�� __class__r r r y s � ��z MySQLDialect_mysqldb.__init__c C s4 t �d|�}|r,tdd� |�ddd�D ��S dS d S )Nz(\d+)\.(\d+)(?:\.(\d+))?c s s | ]}|d k rt |�V qd S �N)�int)�.0�xr r r � <genexpr>� s z<MySQLDialect_mysqldb._parse_dbapi_version.<locals>.<genexpr>r � r r )�re�match�tuple�group)r �version�mr r r r � s z)MySQLDialect_mysqldb._parse_dbapi_versionc C s8 zt d�j}|j| _W dS ttfk r2 Y dS X d S )NzMySQLdb.cursorsTF)� __import__�cursorsZSSCursorZ _sscursor� ImportError�AttributeError)r r- r r r � supports_server_side_cursors� s z1MySQLDialect_mysqldb.supports_server_side_cursorsc C s t d�S )NZMySQLdb)r, )�clsr r r � import_dbapi� s z!MySQLDialect_mysqldb.import_dbapic s t � �� � � fdd�}|S )Nc sB � d k r� | � | � � }|d k r>| �� }|�d| � |�� d S )Nz SET NAMES %s)�character_set_name�cursor�execute�close)�connZ charset_namer4 �Zsuper_r r � on_connect� s z3MySQLDialect_mysqldb.on_connect.<locals>.on_connect)r r9 )r r9 r r8 r r9 � s z MySQLDialect_mysqldb.on_connectc C s |� � dS )NT)Zping�r �dbapi_connectionr r r �do_ping� s z MySQLDialect_mysqldb.do_pingNc C s |� ||�}|d k r||_d S r )Z executemanyZ _rowcount)r r4 Z statement� parameters�contextZrowcountr r r �do_executemany� s z#MySQLDialect_mysqldb.do_executemanyc sn |� d| j�d�| j�d�f ��� }| jdko2|}|r\t�t�t�d�t dd��d�g}ng }t � � ||�S ) Nz:show collation where %s = 'utf8mb4' and %s = 'utf8mb4_bin'�CharsetZ Collation)� z'test collated returns'Zutf8mb4)�charsetZ utf8mb4_bin) Zexec_driver_sqlZidentifier_preparer�quoteZscalarZserver_version_infor Zcollate�castZliteral_columnr r �_check_unicode_returns)r � connectionZ collationZhas_utf8mb4_binZadditional_testsr r r rE � s& ������ z+MySQLDialect_mysqldb._check_unicode_returnsc C sT |d krt dddd�}|jf |�}|�|j� t�|dt� t�|dt� t�|dt� t�|dt� t�|d t� t�|d t� t�|d t� t�|d t� i }d tfdtfdtfdtfdtfdtfg}|D ]@\}}||kr�|| ||dd � < t�||dd � |� ||= q�|�r ||d< |� d d�}| � � } | d k �rL|| O }||d < g |gS )N�db�user�passwd)Zdatabase�username�password�compress�connect_timeout� read_timeoutZ write_timeout� client_flagZ local_infileZ use_unicoderB Zssl_caZssl_keyZssl_certZ ssl_capathZ ssl_cipherZssl_check_hostname� �sslr ) �dictZtranslate_connect_args�update�queryr Zcoerce_kw_type�boolr! �str�get�_found_rows_client_flag) r �urlZ_translate_args�optsrQ �keys�keyZkw_typerO Zclient_flag_found_rowsr r r �create_connect_args� sJ � � z(MySQLDialect_mysqldb.create_connect_argsc C sN | j d k rFzt| j jd �jj}W n ttfk r< Y d S X |jS nd S d S )Nz.constants.CLIENT)r r, r � constantsZCLIENTr/ r. Z FOUND_ROWS)r Z CLIENT_FLAGSr r r rX � s � z,MySQLDialect_mysqldb._found_rows_client_flagc C s |j d S )Nr )�args)r � exceptionr r r �_extract_error_code s z(MySQLDialect_mysqldb._extract_error_codec C s8 z |j j}W n tk r, t�d� Y dS X |� S dS )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)rF r3 r/ r �warn)r rF Z cset_namer r r �_detect_charset s �z$MySQLDialect_mysqldb._detect_charsetc C s dS )N)Z SERIALIZABLEzREAD UNCOMMITTEDzREAD COMMITTEDzREPEATABLE READ� AUTOCOMMITr r: r r r �get_isolation_level_values s z/MySQLDialect_mysqldb.get_isolation_level_valuesc s0 |dkr|� d� n|� d� t� �||� d S )Nre TF)Z autocommitr �set_isolation_level)r r; �levelr r r rg ' s z(MySQLDialect_mysqldb.set_isolation_level)N)N)#r r r ZdriverZsupports_statement_cacheZsupports_unicode_statementsZsupports_sane_rowcountZ supports_sane_multi_rowcountZsupports_native_decimalZdefault_paramstyler Zexecution_ctx_clsr Zstatement_compilerr �preparerr r r Z langhelpersZmemoized_propertyr0 � classmethodr2 r9 r< r? rE r] rX ra rd rf rg � __classcell__r r r r r k s4 3 r )�__doc__r& �baser r r r r � r r r r r �dialectr r r r �<module> s N E