o i4@sdZddlZddlmZmZddlmZmZmZm Z m Z m Z m Z m Z mZmZddddd d Zed Zd d ZGdddejZdS)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) WarningErrorInterfaceError DataError DatabaseErrorOperationalErrorIntegrityError InternalErrorNotSupportedErrorProgrammingErrorutf8cp1252koi8_rkoi8_u)Zutf8mb4Zutf8mb3latin1Zkoi8rZkoi8uz^(\d+)cCs t|}|rt|dSdS)zReturns the leading numeric part of a string. >>> numeric_part("20-alpha") 20 >>> numeric_part("foo") >>> numeric_part("16b") 16 rN)re_numeric_partmatchintgroup)smr]C:\Users\psant\Downloads\Anu Raj Backend\school\venv\Lib\site-packages\MySQLdb/connections.py numeric_part#s rcseZdZdZejZfddZ  d!ddZd d Z d d Z d dZ d"ddZ ddZ ddZddZddZddZd"fdd ZddZdd ZeZeZeZeZeZeZeZeZeZeZZS)# Connectionz MySQL Database Connection ObjectcsJddlm}m}ddlm}m}|}d|vr|d|d<d|vr*|d|d<d|vr3|d}n|}i} |D]\} } t | t rRt | t rR| d d | | <q;| | | <q;| |d<|d |j } | d d } |d d }|dd}|dd }|dd|_| dd}||jO}|dd}|r||jO}||d<|dd}|j|i|tj|i|| |_dd|D|_tdd|dd dD|_d|_| s|} || ||r|||r |j|j|j |j!|j"|j#|j$fD]}||j%|<qt&|j%|j'<|j(|j)@|_*|j*r |d ur |+|g|_,d S)a 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 str server_public_key_path: specify the path to a file RSA public key file for caching_sha2_password. See https://dev.mysql.com/doc/refman/9.0/en/caching-sha2-pluggable-authentication.html :param bool local_infile: sets ``MYSQL_OPT_LOCAL_INFILE`` in ``mysql_options()`` enabling LOAD LOCAL INFILE from any path; zero disables; :param str local_infile_dir: sets ``MYSQL_OPT_LOAD_DATA_LOCAL_DIR`` in ``mysql_options()`` enabling LOAD LOCAL INFILE from any path; if ``local_infile`` is set to ``True`` then this is ignored; supported for mysql version >= 8.0.21 :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_strdbdatabasepasswdpasswordconvN cursorclasscharset collation use_unicodeTsql_modeZ binary_prefixF client_flagmulti_statements autocommitcSs"i|] \}}t|tur||qSr)typer).0kvrrr s  z'Connection.__init__..cSsg|]}t|qSr)r)r1nrrr sz'Connection.__init__...ascii)-ZMySQLdb.constantsrrZMySQLdb.convertersr r!copypopitems isinstancerlistdefault_cursorget_binary_prefixZ MULTI_RESULTSZMULTI_STATEMENTS_set_attributessuper__init__r'encoderstupleZget_server_infosplit_server_versionencodingZcharacter_set_nameset_character_set set_sql_modeSTRINGZ VAR_STRINGZVARCHARZ TINY_BLOBZ MEDIUM_BLOBZ LONG_BLOBZBLOB converterstrZJSONZserver_capabilitiesZ TRANSACTIONSZ_transactionalr/messages)selfargskwargsrrr r!Zkwargs2r&Zconv2r2r3r'r(r*r+r,r-r.r/t __class__rrrD8sxm                 zConnection.__init__Nr) cKs(|r|sd}||_||_||_||_dS)zset some attributes for otel localhostN)hostuserr#r")rPrXrYr%r#portZ unix_socketrRrrrrBs  zConnection._set_attributescCs|SNrrPrrr __enter__szConnection.__enter__cCs |dSr[)close)rPexc_type exc_value tracebackrrr__exit__ s zConnection.__exit__cCs*t|}||krtj||dSdSr[)boolZget_autocommitr connectionr/)rPonrrrr/ s zConnection.autocommitcCs|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. N)r')rPr'rrrcursorszConnection.cursorcCs$t|tr t|}tj||dSr[)r= bytearraybytesrrdquery)rPrirrrris zConnection.querycCs.t|ttfs J||}|jrd|S|S)Ns_binary)r=rhrgstring_literalrA)rPbsxrrr_bytes_literal s  zConnection._bytes_literalcCsddt|j|S)Ns(%s),)joinmapliteral)rPrSrrr_tuple_literal'szConnection._tuple_literalcCst|tr|||j}n5t|tr||}n*t|tr%||}nt|tt fr2| |}n| ||j }t|trD||j}t|tsKJ|S)aIf 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. N) r=rNrjencoderIrgrmrhrFr>rrescaperE)rPorrrrrq*s        zConnection.literalcCs|ddS)ziExplicitly begin a connection. This method is not used when autocommit=False (default). sBEGINN)rir\rrrbeginAszConnection.begincsDt|t|||_|r |d|d||dSdS)z,Set the connection character set to charset.z SET NAMES z COLLATE N)rCrJ_charset_to_encodingr@rIri store_result)rPr(r*rTrrrJHs  zConnection.set_character_setcCs,|jdkr td|d||dS)zNSet the connection sql_mode. See MySQL documentation for legal values.rz!server is too old to set sql_modezSET SESSION sql_mode='%s'N)rHr rirx)rPr,rrrrKPs  zConnection.set_sql_modecCs.|jdkrdS|d|}|d}|S)zReturn 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.ryrz SHOW WARNINGSrN)rHrirxZ fetch_row)rPrwarningsrrr show_warningsXs   zConnection.show_warnings)NNNr)rVNr[) __name__ __module__ __qualname____doc__rCursorr?rDrBr]rbr/rfrirmrrrqrvrJrKr}rrrr rr r r rr __classcell__rrrTrr3s< @     r)rrer)rr _exceptionsrrrrr r r r r rrwcompilerrrdrrrrrs0