관리-도구
편집 파일: connections.cpython-38.pyc
U )�e�/ � @ s� d Z ddlZddlmZmZ ddlmZmZmZm Z m Z m Z m Z m Z mZmZ ddddd d �Ze�d �Zd d � ZG dd� dej�ZdS )a This module implements connections for MySQLdb. Presently there is only one class: Connection. Others are unlikely. However, you might want to make your own subclasses. In most cases, you will probably override Connection.default_cursor with a non-standard Cursor class. � N� )�cursors�_mysql) �Warning�Error�InterfaceError� DataError� DatabaseError�OperationalError�IntegrityError� InternalError�NotSupportedError�ProgrammingError�utf8�cp1252�koi8_r�koi8_u)Zutf8mb4Zutf8mb3�latin1Zkoi8rZkoi8uz^(\d+)c C s t �| �}|r t|�d��S dS )z�Returns the leading numeric part of a string. >>> numeric_part("20-alpha") 20 >>> numeric_part("foo") >>> numeric_part("16b") 16 r N)�re_numeric_part�match�int�group)�s�m� r �C/opt/hc_python/lib64/python3.8/site-packages/MySQLdb/connections.py� numeric_part# s r c s� e Zd ZdZejZ� fdd�Zdd� Zdd� Z dd � Z d d d �Z d d� Z dd� Z dd� Zdd� Zdd� Zd � fdd� Zdd� Zdd � ZeZeZeZeZeZeZeZeZe Z e Z � Z S ) � Connectionz MySQL Database Connection Objectc s> ddl m}m} ddlm}m} |�� }d|kr>|�d�|d< d|krT|�d�|d< d|krf|d }n|}i } |�� D ]6\} } t | t �r�t | t �r�| d d � | | < qv| | | < qv| |d< |�d | j �} |� d d �} |�d d �}|�dd�}|�dd �}|�dd�| _|� dd�}||jO }|�dd�}|�r4||jO }||d< |�dd�}t� j||� | | _dd� |�� D �| _tdd� | �� �d�d d� D ��| _d | _| �s�| �� } | �| |� |�r�| � |� |�r |j |j |j |j |j!|j"|j#fD ]}|| j$|< �q�t%| j$|j&< | j'|j(@ | _)| j)�r4|d k �r4| �*|� g | _+d S ) au Create a connection to the database. It is strongly recommended that you only use keyword parameters. Consult the MySQL C API documentation for more information. :param str host: host to connect :param str user: user to connect as :param str password: password to use :param str passwd: alias of password (deprecated) :param str database: database to use :param str db: alias of database (deprecated) :param int port: TCP/IP port to connect to :param str unix_socket: location of unix_socket to use :param dict conv: conversion dictionary, see MySQLdb.converters :param int connect_timeout: number of seconds to wait before the connection attempt fails. :param bool compress: if set, compression is enabled :param str named_pipe: if set, a named pipe is used to connect (Windows only) :param str init_command: command which is run once the connection is created :param str read_default_file: file from which default client values are read :param str read_default_group: configuration group to use from the default file :param type cursorclass: class object, used to create cursors (keyword only) :param bool use_unicode: If True, text-like columns are returned as unicode objects using the connection's character set. Otherwise, text-like columns are returned as bytes. Unicode objects will always be encoded to the connection's character set regardless of this setting. Default to True. :param str charset: If supplied, the connection character set will be changed to this character set. :param str collation: If ``charset`` and ``collation`` are both supplied, the character set and collation for the current connection will be set. If omitted, empty string, or None, the default collation for the ``charset`` is implied. :param str auth_plugin: If supplied, the connection default authentication plugin will be changed to this value. Example values: `mysql_native_password` or `caching_sha2_password` :param str sql_mode: If supplied, the session SQL mode will be changed to this setting. For more details and legal values, see the MySQL documentation. :param int client_flag: flags to use or 0 (see MySQL docs or constants/CLIENTS.py) :param bool multi_statements: If True, enable multi statements for clients >= 4.1. Defaults to True. :param str ssl_mode: specify the security settings for connection to the server; see the MySQL documentation for more details (mysql_option(), MYSQL_OPT_SSL_MODE). Only one of 'DISABLED', 'PREFERRED', 'REQUIRED', 'VERIFY_CA', 'VERIFY_IDENTITY' can be specified. :param dict ssl: dictionary or mapping contains SSL connection parameters; see the MySQL documentation for more details (mysql_ssl_set()). If this is set, and the client does not support SSL, NotSupportedError will be raised. Since mysqlclient 2.2.4, ssl=True is alias of ssl_mode=REQUIRED for better compatibility with PyMySQL and MariaDB. :param bool local_infile: enables LOAD LOCAL INFILE; zero disables :param bool autocommit: If False (default), autocommit is disabled. If True, autocommit is enabled. If None, autocommit isn't set and server default is used. :param bool binary_prefix: If set, the '_binary' prefix will be used for raw byte query arguments (e.g. Binary). This is disabled by default. There are a number of undocumented, non-standard methods. See the documentation for the MySQL C API for some hints on what they do. r )�CLIENT� FIELD_TYPE)� conversions� _bytes_or_str�dbZdatabase�passwd�password�convN� cursorclass�charset� � collation� use_unicodeT�sql_mode� binary_prefixF� client_flag�multi_statements� autocommitc S s" i | ]\}}t |�tk r||�qS r )�typer )�.0�k�vr r r � <dictcomp>� s � z'Connection.__init__.<locals>.<dictcomp>c S s g | ] }t |��qS r )r )r1 �nr r r � <listcomp>� s z'Connection.__init__.<locals>.<listcomp>�.� �ascii),ZMySQLdb.constantsr r ZMySQLdb.convertersr r! �copy�pop�items� isinstancer �list�default_cursor�get�_binary_prefixZ MULTI_RESULTSZMULTI_STATEMENTS�super�__init__r& �encoders�tupleZget_server_info�split�_server_version�encodingZcharacter_set_name�set_character_set� set_sql_mode�STRINGZ VAR_STRINGZVARCHARZ TINY_BLOBZ MEDIUM_BLOBZ LONG_BLOBZBLOB� converter�str�JSONZserver_capabilitiesZ TRANSACTIONSZ_transactionalr/ �messages)�self�args�kwargsr r r r! Zkwargs2r% Zconv2r2 r3 r& r' r) r* r+ r- r. r/ �t�� __class__r r rC 8 sv c � � � zConnection.__init__c C s | S �Nr �rP r r r � __enter__� s zConnection.__enter__c C s | � � d S rV )�close)rP �exc_type� exc_value� tracebackr r r �__exit__� s zConnection.__exit__c C s& t |�}| �� |kr"tj�| |� d S rV )�boolZget_autocommitr � connectionr/ )rP �onr r r r/ � s zConnection.autocommitNc C s |p| j | �S )z� Create a cursor on which queries may be performed. The optional cursorclass parameter is used to create the Cursor. By default, self.cursorclass=cursors.Cursor is used. )r& )rP r& r r r �cursor� s zConnection.cursorc C s$ t |t�rt|�}tj�| |� d S rV )r= � bytearray�bytesr r_ �query)rP rd r r r rd s zConnection.queryc C s. t |ttf�st�| �|�}| jr*d| S |S )Ns _binary)r= rc rb �AssertionError�string_literalrA )rP �bs�xr r r �_bytes_literal s zConnection._bytes_literalc C s dd� t| j|�� S )Ns (%s)� ,)�join�map�literal)rP rS r r r �_tuple_literal s zConnection._tuple_literalc C s� t |t�r | �|�| j��}njt |t�r4| �|�}nTt |t�rJ| �|�}n>t |tt f�rd| � |�}n$| � || j �}t |t�r�|�| j�}t |t�s�t �|S )a If o is a single object, returns an SQL literal as a string. If o is a non-string sequence, the items of the sequence are converted and returned as a sequence. Non-standard. For internal use; do not use this in your applications. )r= rM rf �encoderH rb ri rc rE r> rn �escaperD re )rP �or r r r rm s zConnection.literalc C s | � d� dS )ziExplicitly begin a connection. This method is not used when autocommit=False (default). s BEGINN)rd rW r r r �begin( s zConnection.beginc s@ t � �|� t�||�| _|r<| �d|� d|� �� | �� dS )z,Set the connection character set to charset.z SET NAMES z COLLATE N)rB rI �_charset_to_encodingr@ rH rd � store_result)rP r' r) rT r r rI / s z Connection.set_character_setc C s, | j dk rtd��| �d| � | �� dS )zNSet the connection sql_mode. See MySQL documentation for legal values.�� r z!server is too old to set sql_modezSET SESSION sql_mode='%s'N)rG r rd rt )rP r+ r r r rJ 7 s zConnection.set_sql_modec C s. | j dk rdS | �d� | �� }|�d�}|S )z�Return detailed information about warnings as a sequence of tuples of (Level, Code, Message). This is only supported in MySQL-4.1 and up. If your server is an earlier version, an empty sequence is returned.ru r z SHOW WARNINGSr )rG rd rt Z fetch_row)rP �r�warningsr r r � show_warnings? s zConnection.show_warnings)N)N) �__name__� __module__� __qualname__�__doc__r ZCursorr? rC rX r] r/ ra rd ri rn rm rr rI rJ ry r r r r r r r r r r � __classcell__r r rT r r 3 s4 6 r )r} �rer( r r � _exceptionsr r r r r r r r r r rs �compiler r r_ r r r r r �<module> s 0�