\)i4SrSSKrSSKJrJr SSKJrJrJrJ r J r J r J r J r JrJr SSSSS S .r\R""S 5rS r"S S\R(5rg)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)utf8mb4utf8mb3latin1koi8rkoi8uz^(\d+)cp[RU5nU(a[URS55$g)zReturns the leading numeric part of a string. >>> numeric_part("20-alpha") 20 >>> numeric_part("foo") >>> numeric_part("16b") 16 rN)re_numeric_partmatchintgroup)sms R/var/www/surfInsights/venv3-11/lib/python3.13/site-packages/MySQLdb/connections.py numeric_partr!#s, a A1771: c^\rSrSrSr\R rU4SjrSSjr Sr Sr Sr SSjr S rS rS rS rS rSU4SjjrSrSr\r\r\r\r\r\r\r\r\r\rSr U=r!$) Connection3z MySQL Database Connection Objectc>SSKJnJn SSKJnJn UR 5nSU;aURS5US'SU;aURS5US'SU;aUSnOUn0n UR5H<up[U [5(a[U [5(a U S S X'M8XU 'M> XS'URS UR5n URS S 5n URS S 5nURSS5nURSS 5nURSS5UlURSS5nUUR-nURSS5nU(aUUR -nUUS'URSS5nUR""U0UD6 [$TU]L"U0UD6 XlUR5V V s0sHup[+U 5[LdMX_M sn n Ul[/UR15R3S5S SVs/sHn[5U5PM sn5UlSUlU (dUR;5n UR=X5 U(aUR?U5 U(aUR@URBURDURFURHURJURL4HnX`RNU'M [PURNURR'URTURV-Ul,URX(aUbUR[U5 /Ul.g s sn n fs snf)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_mode binary_prefixF client_flagmulti_statements autocommit.ascii)/MySQLdb.constantsr'r(MySQLdb.convertersr)r*copypopitems isinstancerlistdefault_cursorget_binary_prefix MULTI_RESULTSMULTI_STATEMENTS_set_attributessuper__init__r0typeencoderstupleget_server_infosplitr!_server_versionencodingcharacter_set_nameset_character_set set_sql_modeSTRING VAR_STRINGVARCHAR TINY_BLOB MEDIUM_BLOB LONG_BLOBBLOB converterstrJSONserver_capabilities TRANSACTIONS_transactionalr9messages)selfargskwargsr'r(r)r*kwargs2r/conv2kvr0r1r3r4r5r7r8r9nt __class__s r rKConnection.__init__8s Z 9A++- 7?")++d"3GJ  w ")++h"7GJ  V &>DDJJLDA!S!!jD&9&9Q4a !  kk-1D1DE ++i,KK R0 kk-6 ;;z2.%kk/5Ajj2 v+++ ";;'94@  622 2K!, [[u5  d.g. $*'*&  $Awc! AD$  %&*&:&:&<&B&B3&G&K L&K\!_&K L   --/G w2    h ' !!%%""$$&&$$%2q!/2DNN:?? +"669L9LL   % + I MsM,M$M%c TU(a U(dSnXlX lX@lX@lg)zset some attributes for otel localhostN)hostuserr,r+)rdrqrrr.r,port unix_socketrfs r rIConnection._set_attributess" tD   r"cU$Nrds r __enter__Connection.__enter__s r"c$UR5 grw)close)rdexc_type exc_value tracebacks r __exit__Connection.__exit__ s  r"c[U5nUR5U:wa [RR X5 ggrw)boolget_autocommitr connectionr9)rdons r r9Connection.autocommit s5 "X    B &    ( ( 2 'r"c8U=(d UR"U5$)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. )r0)rdr0s r cursorConnection.cursors/t///66r"c[U[5(a [U5n[RR X5 grw)rB bytearraybytesrrquery)rdrs r rConnection.querys, eY ' '%LE,r"c[U[[45(deURU5nUR(aSU-$U$)Ns_binary)rBrrstring_literalrF)rdbsxs r _bytes_literalConnection._bytes_literal sB"ui01111    #   > !r"cRSSR[URU55-$)Ns(%s),)joinmapliteral)rdrls r _tuple_literalConnection._tuple_literal's!$))C a$89::r"c@[U[5(a+URURUR55nO[U[ 5(aUR U5nO[U[5(aUR U5nOx[U[[45(aURU5nOKURXR5n[U[5(aURUR5n[U[5(deU$)zIf 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. ) rBr^rencoderRrrrrNrCrescaperM)rdors r rConnection.literal*s a  ##AHHT]]$;[TU]U5 [RX5UlU(a(UR SUSU35 UR 5 gg)z,Set the connection character set to charset.z SET NAMES z COLLATE N)rJrT_charset_to_encodingrErRr store_result)rdr1r3rms r rTConnection.set_character_setHsO !'*,00B  JJG9Ii[A B     r"cURS:a [S5eURSU-5 UR5 g)zFSet the connection sql_mode. See MySQL documentation for legal values.rz!server is too old to set sql_modezSET SESSION sql_mode='%s'N)rQrrr)rdr5s r rUConnection.set_sql_modePs<   & (#$GH H .9: r"cURS:agURS5 UR5nURS5nU$)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.rrxz SHOW WARNINGSr)rQrr fetch_row)rdrwarningss r show_warningsConnection.show_warningsXsA   & ( ?#    ;;q>r") rFrQrbr0r,r+rMrRrqrcrr)NNNr2i Nrw)"__name__ __module__ __qualname____firstlineno____doc__rCursorrDrKrIrzrr9rrrrrrrTrUrrrrr r r r r rr__static_attributes__ __classcell__)rms@r r$r$3s*^^N}~VZ$( 3 7- ;.  G E#N!MI'#N!M')r"r$)rrer2rr _exceptionsrrrr r r r r rrrcompilerr!rr$rxr"r rsc        **Y'  z*""z*r"