o \#f¡/ã@s„dZddlZddlmZmZddlmZmZmZm Z m Z m Z m Z m Z mZmZddddd d œZe d ¡Zd d „ZGdd„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)Úutf8mb4Úutf8mb3Úlatin1Úkoi8rÚkoi8uz^(\d+)cCs t |¡}|rt| d¡ƒSdS)zšReturns the leading numeric part of a string. >>> numeric_part("20-alpha") 20 >>> numeric_part("foo") >>> numeric_part("16b") 16 rN)Úre_numeric_partÚmatchÚintÚgroup)ÚsÚm©rúI/home/ubuntu/dev/venv/lib/python3.10/site-packages/MySQLdb/connections.pyÚ numeric_part#s r cs¶eZdZdZejZ‡fdd„Zdd„Zdd„Z dd „Z dd d „Z d d„Z dd„Z dd„Zdd„Zdd„Zd‡fdd„ Zdd„Zdd„ZeZeZeZeZeZeZeZeZeZeZ‡ZS)Ú Connectionz MySQL Database Connection Objectcs:ddlm}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¡}tƒj|i|¤Ž| |_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)r|d ur| *|¡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ÚdbÚdatabaseÚpasswdÚpasswordÚconvNÚ cursorclassÚcharsetÚÚ collationÚ use_unicodeTÚsql_modeÚ binary_prefixFÚ client_flagÚmulti_statementsÚ autocommitcSs"i|] \}}t|ƒtur||“qSr)Útyper)Ú.0ÚkÚvrrrÚ Ås  þz'Connection.__init__..cSsg|]}t|ƒ‘qSr)r )r6ÚnrrrÚ Ìsz'Connection.__init__..Ú.éÚascii),ÚMySQLdb.constantsr"r#ÚMySQLdb.convertersr$r%ÚcopyÚpopÚitemsÚ isinstancerÚlistÚdefault_cursorÚgetÚ_binary_prefixÚ MULTI_RESULTSÚMULTI_STATEMENTSÚsuperÚ__init__r+ÚencodersÚtupleÚget_server_infoÚsplitÚ_server_versionÚencodingÚcharacter_set_nameÚset_character_setÚ set_sql_modeÚSTRINGÚ VAR_STRINGÚVARCHARÚ TINY_BLOBÚ MEDIUM_BLOBÚ LONG_BLOBÚBLOBÚ converterÚstrÚJSONÚserver_capabilitiesÚ TRANSACTIONSÚ_transactionalr4Úmessages)ÚselfÚargsÚkwargsr"r#r$r%Úkwargs2r*Úconv2r7r8r+r,r.r/r0r2r3r4Út©Ú __class__rrrL8svc           þÿ  ù    zConnection.__init__cCs|S©Nr©rdrrrÚ __enter__íszConnection.__enter__cCs | ¡dSrl)Úclose)rdÚexc_typeÚ exc_valueÚ tracebackrrrÚ__exit__ðs zConnection.__exit__cCs*t|ƒ}| ¡|krtj ||¡dSdSrl)ÚboolÚget_autocommitrÚ connectionr4)rdÚonrrrr4ós ÿzConnection.autocommitNcCs|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+)rdr+rrrÚcursorøszConnection.cursorcCs$t|tƒr t|ƒ}tj ||¡dSrl)rDÚ bytearrayÚbytesrrvÚquery)rdr{rrrr{s zConnection.querycCs.t|ttfƒs J‚| |¡}|jrd|S|S)Ns_binary)rDrzryÚstring_literalrH)rdÚbsÚxrrrÚ_bytes_literals  zConnection._bytes_literalcCsdd t|j|ƒ¡S)Ns(%s)ó,)ÚjoinÚmapÚliteral)rdrirrrÚ_tuple_literalszConnection._tuple_literalcCsšt|tƒr| | |j¡¡}n5t|tƒr| |¡}n*t|tƒr%| |¡}nt|tt fƒr2|  |¡}n|  ||j ¡}t|tƒrD| |j¡}t|tƒsKJ‚|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. ) rDr^r|ÚencoderRryrrzrNrEr„ÚescaperM)rdÚorrrrrƒs        zConnection.literalcCs| d¡dS)ziExplicitly begin a connection. This method is not used when autocommit=False (default). sBEGINN)r{rmrrrÚbegin(szConnection.begincsDtƒ |¡t ||¡|_|r | d|›d|›¡| ¡dSdS)z,Set the connection character set to charset.z SET NAMES z COLLATE N)rKrTÚ_charset_to_encodingrGrRr{Ú store_result)rdr,r.rjrrrT/s  þ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)rQr r{rŠ)rdr0rrrrU7s  zConnection.set_sql_modecCs.|jdkrdS| 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.r‹rz SHOW WARNINGSr)rQr{rŠÚ fetch_row)rdÚrÚwarningsrrrÚ show_warnings?s   zConnection.show_warningsrl)Ú__name__Ú __module__Ú __qualname__Ú__doc__rÚCursorrFrLrnrsr4rxr{rr„rƒrˆrTrUrrrrr rr r r rr Ú __classcell__rrrjrr!3s6 6    r!)r”Úrer-rrÚ _exceptionsrrrrr r r r r rr‰Úcompilerr rvr!rrrrÚs0û