?????????? ????????? - ??????????????? - /home/agenciai/.local/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/__pycache__/mysqldb.cpython-39.pyc
???????
a ��Jh6% � @ 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: .. 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`. � N� )� MySQLCompiler)� MySQLDialect)�MySQLExecutionContext)�MySQLIdentifierPreparer)�TEXT� )�sql)�utilc @ s e Zd ZdS )� MySQLExecutionContext_mysqldbN��__name__� __module__� __qualname__� r r �V/home/agenciai/.local/lib/python3.9/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyr e s r c @ s e Zd ZdS )�MySQLCompiler_mysqldbNr r r r r r i 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 i |�� | jd ur6t| jd�r6| �| 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 { 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 urt |�V qd S �N)�int)�.0�xr r r � <genexpr>� � 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 s6 zt d�j}|j| _W dS ttfy0 Y dS 0 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 ur� | � | � � }|d ur>| �� }|�d| � |�� d S )Nz SET NAMES %s)�character_set_name�cursor�execute�close)�conn� charset_namer5 �Zsuper_r r � on_connect� s z3MySQLDialect_mysqldb.on_connect.<locals>.on_connect)r r; )r r; r r: r r; � 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 ur||_d S r )Z executemanyZ _rowcount)r r5 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 rG � s& ������ z+MySQLDialect_mysqldb._check_unicode_returnsc C sX |d u rt dddd�}|jf i |��}|�|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 ]@\}}||v r�|| ||dd � < t�||dd � |� ||= q�|�r"||d< |� d d�}| � � } | d u�rP|| O }||d < g |gS )N�db�user�passwd)Zdatabase�username�password�compress�connect_timeout� read_timeoutZ write_timeout� client_flagZ local_infileZ use_unicoderD 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�optsrS �keys�keyZkw_typerQ Zclient_flag_found_rowsr r r �create_connect_args� sF � � z(MySQLDialect_mysqldb.create_connect_argsc C sL | j d urDzt| j jd �jj}W n ttfy: Y d S 0 |jS nd S d S )Nz.constants.CLIENT)r r- r � constantsZCLIENTr0 r/ Z FOUND_ROWS)r Z CLIENT_FLAGSr r r rZ � 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 s6 z |j j}W n ty* t�d� Y dS 0 |� 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)rH r4 r0 r �warn)r rH 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 )Nrg TF)Z autocommitr �set_isolation_level)r r= �levelr r r ri ) 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_propertyr1 � classmethodr3 r; r> rA rG r_ rZ rc rf rh ri � __classcell__r r r r r m s4 3 r )�__doc__r' �baser r r r r � r r r r r �dialectr r r r �<module> s P E
| ver. 1.6 |
Github
|
.
| PHP 8.2.30 | ??????????? ?????????: 0 |
proxy
|
phpinfo
|
???????????