>ijgߧ X UdZddlZddlmZmZddlmZmZmZm Z m Z m Z m Z m Z ddlmZmZddlmZddlmZmZd Zeed <d Zeed <d Zeed< dZ dZdZiddddddddddddddddddddd d!d"dd#dd$d%d&d%d'dd(did)d%d*d%d+dd,dd-dd.dd/d%d0d%d1d%d2dd3dd4dd5d%d6d%d7dd8dd9d%id:dd;dddd?d%d@ddAd%dBddCd%dDddEd%dFd%dGddHddIddJdddddKZeee e ee effedL<dMZ!e eeefedN<dOZ"e edPfedQ<dRZ#e edPfedS<eezZ$eeedT< idUdVdWdXdYdZd[d\d]d^d_d`dadbdcdddedfdgdhdidjdkdldmdndodpdqdrdsdtdudvidwdxdydzd{d|d}d~ddddddddddddddddddddddddddiddddddddddddddddddddddddddddddddddidddddddd“ddēddƓddȓddʓdd̓ddΓddГddғddԓdd֓ddؓddړddܓiddޓddddddddddddddddddddddddddddddddiddddddddddd d d d d ddddddddddddddddddd id!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;d<d=d>d?d@dAdBdCdDdEdFdGdHdIdJdKdLdMdN Z%eeefedO<dPdQdRdSdTdUZ&eeefedV<e%e&dWZ'eeeeeffedX<e%(e&(dWZ)eee efedY<dZed[ed\e fd]Z*d^ed_ed`ed\efdaZ+dbed\dfdcZ,GdddeeZ-Gdfdge-Z.Gdhdie-Z/Gdjdke.Z0GdldmeZ1Gdndoe-e1pZ2Gdqdre.Z3Gdsdte.Z4GdudveZ5Gdwdxe-e5pZ6Gdydze-Z7Gd{d|Z8Gd}d~e-Z9dS(z+Various MySQL constants and character sets.N)ABCABCMeta)AnyDictListOptionalSequenceTupleUnion ValuesView)MYSQL_CHARACTER_SETSMYSQL_CHARACTER_SETS_57)ProgrammingError)APPROVED_TLS_VERSIONSDEPRECATED_TLS_VERSIONS NET_BUFFER_LENGTHMAX_MYSQL_TABLE_COLUMNSPARAMETER_COUNT_AVAILABLEf-databaseuserpassword password1 password2 password3hostz 127.0.0.1porti unix_socket use_unicodeTcharsetutf8mb4 collationconverter_classconverter_str_fallbackF autocommit time_zonesql_mode get_warningsraise_on_warningsconnection_timeout read_timeout write_timeout client_flagscompressbufferedrawssl_cassl_certssl_keyssl_verify_certssl_verify_identity ssl_ciphertls_ciphersuites ssl_disabled tls_versionspasswddbconnect_timeoutdsn force_ipv6 auth_pluginallow_local_infileallow_local_infile_in_pathconsume_results conn_attrsdns_srvuse_purekrb_service_principaloci_config_fileoci_config_profilewebauthn_callback)kerberos_auth_mode init_commandopenid_token_fileDEFAULT_CONFIGURATION) pool_name pool_sizepool_reset_session CNX_POOL_ARGS) _pid _platform _source_host _client_name_client_license_client_version_os_connector_name_connector_license_connector_version. CONN_ATTRS_DN)MySQLCursorPreparedRawMySQLCursorNamedTupleMySQLCursorBufferedNamedTupleMySQLCursorPreparedNamedTupleCMySQLCursorPreparedRawCMySQLCursorNamedTupleCMySQLCursorBufferedNamedTupleCMySQLCursorPreparedNamedTupleDEPRECATED_CURSOR_CLASS_NAMES TLS_VERSIONSTLS_RSA_WITH_NULL_SHA256z NULL-SHA256TLS_RSA_WITH_AES_128_CBC_SHA256z AES128-SHA256TLS_RSA_WITH_AES_256_CBC_SHA256z AES256-SHA256TLS_RSA_WITH_AES_128_GCM_SHA256zAES128-GCM-SHA256TLS_RSA_WITH_AES_256_GCM_SHA384zAES256-GCM-SHA384"TLS_DH_RSA_WITH_AES_128_CBC_SHA256zDH-RSA-AES128-SHA256"TLS_DH_RSA_WITH_AES_256_CBC_SHA256zDH-RSA-AES256-SHA256"TLS_DH_RSA_WITH_AES_128_GCM_SHA256zDH-RSA-AES128-GCM-SHA256"TLS_DH_RSA_WITH_AES_256_GCM_SHA384zDH-RSA-AES256-GCM-SHA384"TLS_DH_DSS_WITH_AES_128_CBC_SHA256zDH-DSS-AES128-SHA256"TLS_DH_DSS_WITH_AES_256_CBC_SHA256zDH-DSS-AES256-SHA256"TLS_DH_DSS_WITH_AES_128_GCM_SHA256zDH-DSS-AES128-GCM-SHA256"TLS_DH_DSS_WITH_AES_256_GCM_SHA384zDH-DSS-AES256-GCM-SHA384#TLS_DHE_RSA_WITH_AES_128_CBC_SHA256zDHE-RSA-AES128-SHA256#TLS_DHE_RSA_WITH_AES_256_CBC_SHA256zDHE-RSA-AES256-SHA256#TLS_DHE_RSA_WITH_AES_128_GCM_SHA256zDHE-RSA-AES128-GCM-SHA256#TLS_DHE_RSA_WITH_AES_256_GCM_SHA384zDHE-RSA-AES256-GCM-SHA384#TLS_DHE_DSS_WITH_AES_128_CBC_SHA256zDHE-DSS-AES128-SHA256#TLS_DHE_DSS_WITH_AES_256_CBC_SHA256zDHE-DSS-AES256-SHA256#TLS_DHE_DSS_WITH_AES_128_GCM_SHA256zDHE-DSS-AES128-GCM-SHA256#TLS_DHE_DSS_WITH_AES_256_GCM_SHA384zDHE-DSS-AES256-GCM-SHA384%TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256zECDHE-RSA-AES128-SHA256%TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384zECDHE-RSA-AES256-SHA384%TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256zECDHE-RSA-AES128-GCM-SHA256%TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384zECDHE-RSA-AES256-GCM-SHA384'TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256zECDHE-ECDSA-AES128-SHA256'TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA384zECDHE-ECDSA-AES256-SHA384'TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256zECDHE-ECDSA-AES128-GCM-SHA256'TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384zECDHE-ECDSA-AES256-GCM-SHA384#TLS_DH_anon_WITH_AES_128_CBC_SHA256zADH-AES128-SHA256#TLS_DH_anon_WITH_AES_256_CBC_SHA256zADH-AES256-SHA256#TLS_DH_anon_WITH_AES_128_GCM_SHA256zADH-AES128-GCM-SHA256#TLS_DH_anon_WITH_AES_256_GCM_SHA384zADH-AES256-GCM-SHA384RSA_WITH_AES_128_CCMz AES128-CCMRSA_WITH_AES_256_CCMz AES256-CCMDHE_RSA_WITH_AES_128_CCMzDHE-RSA-AES128-CCMDHE_RSA_WITH_AES_256_CCMzDHE-RSA-AES256-CCMRSA_WITH_AES_128_CCM_8z AES128-CCM8RSA_WITH_AES_256_CCM_8z AES256-CCM8DHE_RSA_WITH_AES_128_CCM_8zDHE-RSA-AES128-CCM8DHE_RSA_WITH_AES_256_CCM_8zDHE-RSA-AES256-CCM8ECDHE_ECDSA_WITH_AES_128_CCMzECDHE-ECDSA-AES128-CCMECDHE_ECDSA_WITH_AES_256_CCMzECDHE-ECDSA-AES256-CCMECDHE_ECDSA_WITH_AES_128_CCM_8zECDHE-ECDSA-AES128-CCM8ECDHE_ECDSA_WITH_AES_256_CCM_8zECDHE-ECDSA-AES256-CCM8 TLS_RSA_WITH_ARIA_128_GCM_SHA256zARIA128-GCM-SHA256 TLS_RSA_WITH_ARIA_256_GCM_SHA384zARIA256-GCM-SHA384$TLS_DHE_RSA_WITH_ARIA_128_GCM_SHA256zDHE-RSA-ARIA128-GCM-SHA256$TLS_DHE_RSA_WITH_ARIA_256_GCM_SHA384zDHE-RSA-ARIA256-GCM-SHA384$TLS_DHE_DSS_WITH_ARIA_128_GCM_SHA256zDHE-DSS-ARIA128-GCM-SHA256$TLS_DHE_DSS_WITH_ARIA_256_GCM_SHA384zDHE-DSS-ARIA256-GCM-SHA384(TLS_ECDHE_ECDSA_WITH_ARIA_128_GCM_SHA256zECDHE-ECDSA-ARIA128-GCM-SHA256(TLS_ECDHE_ECDSA_WITH_ARIA_256_GCM_SHA384zECDHE-ECDSA-ARIA256-GCM-SHA384&TLS_ECDHE_RSA_WITH_ARIA_128_GCM_SHA256zECDHE-ARIA128-GCM-SHA256&TLS_ECDHE_RSA_WITH_ARIA_256_GCM_SHA384zECDHE-ARIA256-GCM-SHA384 TLS_PSK_WITH_ARIA_128_GCM_SHA256zPSK-ARIA128-GCM-SHA256 TLS_PSK_WITH_ARIA_256_GCM_SHA384zPSK-ARIA256-GCM-SHA384$TLS_DHE_PSK_WITH_ARIA_128_GCM_SHA256zDHE-PSK-ARIA128-GCM-SHA256$TLS_DHE_PSK_WITH_ARIA_256_GCM_SHA384zDHE-PSK-ARIA256-GCM-SHA384$TLS_RSA_PSK_WITH_ARIA_128_GCM_SHA256zRSA-PSK-ARIA128-GCM-SHA256$TLS_RSA_PSK_WITH_ARIA_256_GCM_SHA384zRSA-PSK-ARIA256-GCM-SHA384,TLS_ECDHE_ECDSA_WITH_CAMELLIA_128_CBC_SHA256zECDHE-ECDSA-CAMELLIA128-SHA256,TLS_ECDHE_ECDSA_WITH_CAMELLIA_256_CBC_SHA384zECDHE-ECDSA-CAMELLIA256-SHA384*TLS_ECDHE_RSA_WITH_CAMELLIA_128_CBC_SHA256zECDHE-RSA-CAMELLIA128-SHA256*TLS_ECDHE_RSA_WITH_CAMELLIA_256_CBC_SHA384zECDHE-RSA-CAMELLIA256-SHA384PSK_WITH_NULL_SHAz PSK-NULL-SHADHE_PSK_WITH_NULL_SHAzDHE-PSK-NULL-SHARSA_PSK_WITH_NULL_SHAzRSA-PSK-NULL-SHAPSK_WITH_RC4_128_SHAz PSK-RC4-SHAPSK_WITH_3DES_EDE_CBC_SHAzPSK-3DES-EDE-CBC-SHAPSK_WITH_AES_128_CBC_SHAzPSK-AES128-CBC-SHAPSK_WITH_AES_256_CBC_SHAzPSK-AES256-CBC-SHADHE_PSK_WITH_RC4_128_SHAzDHE-PSK-RC4-SHADHE_PSK_WITH_3DES_EDE_CBC_SHAzDHE-PSK-3DES-EDE-CBC-SHADHE_PSK_WITH_AES_128_CBC_SHAzDHE-PSK-AES128-CBC-SHADHE_PSK_WITH_AES_256_CBC_SHAzDHE-PSK-AES256-CBC-SHARSA_PSK_WITH_RC4_128_SHAzRSA-PSK-RC4-SHARSA_PSK_WITH_3DES_EDE_CBC_SHAzRSA-PSK-3DES-EDE-CBC-SHARSA_PSK_WITH_AES_128_CBC_SHAzRSA-PSK-AES128-CBC-SHARSA_PSK_WITH_AES_256_CBC_SHAzRSA-PSK-AES256-CBC-SHAPSK_WITH_AES_128_GCM_SHA256zPSK-AES128-GCM-SHA256PSK_WITH_AES_256_GCM_SHA384zPSK-AES256-GCM-SHA384DHE_PSK_WITH_AES_128_GCM_SHA256zDHE-PSK-AES128-GCM-SHA256DHE_PSK_WITH_AES_256_GCM_SHA384zDHE-PSK-AES256-GCM-SHA384RSA_PSK_WITH_AES_128_GCM_SHA256zRSA-PSK-AES128-GCM-SHA256RSA_PSK_WITH_AES_256_GCM_SHA384zRSA-PSK-AES256-GCM-SHA384PSK_WITH_AES_128_CBC_SHA256zPSK-AES128-CBC-SHA256PSK_WITH_AES_256_CBC_SHA384zPSK-AES256-CBC-SHA384PSK_WITH_NULL_SHA256zPSK-NULL-SHA256PSK_WITH_NULL_SHA384zPSK-NULL-SHA384DHE_PSK_WITH_AES_128_CBC_SHA256zDHE-PSK-AES128-CBC-SHA256DHE_PSK_WITH_AES_256_CBC_SHA384zDHE-PSK-AES256-CBC-SHA384DHE_PSK_WITH_NULL_SHA256zDHE-PSK-NULL-SHA256DHE_PSK_WITH_NULL_SHA384zDHE-PSK-NULL-SHA384RSA_PSK_WITH_AES_128_CBC_SHA256zRSA-PSK-AES128-CBC-SHA256RSA_PSK_WITH_AES_256_CBC_SHA384zRSA-PSK-AES256-CBC-SHA384RSA_PSK_WITH_NULL_SHA256zRSA-PSK-NULL-SHA256RSA_PSK_WITH_NULL_SHA384zRSA-PSK-NULL-SHA384ECDHE_PSK_WITH_RC4_128_SHAzECDHE-PSK-RC4-SHAECDHE_PSK_WITH_3DES_EDE_CBC_SHAzECDHE-PSK-3DES-EDE-CBC-SHAECDHE_PSK_WITH_AES_128_CBC_SHAzECDHE-PSK-AES128-CBC-SHAECDHE_PSK_WITH_AES_256_CBC_SHAzECDHE-PSK-AES256-CBC-SHA!ECDHE_PSK_WITH_AES_128_CBC_SHA256zECDHE-PSK-AES128-CBC-SHA256!ECDHE_PSK_WITH_AES_256_CBC_SHA384zECDHE-PSK-AES256-CBC-SHA384ECDHE_PSK_WITH_NULL_SHAzECDHE-PSK-NULL-SHAECDHE_PSK_WITH_NULL_SHA256zECDHE-PSK-NULL-SHA256ECDHE_PSK_WITH_NULL_SHA384zECDHE-PSK-NULL-SHA384 PSK_WITH_CAMELLIA_128_CBC_SHA256zPSK-CAMELLIA128-SHA256 PSK_WITH_CAMELLIA_256_CBC_SHA384zPSK-CAMELLIA256-SHA384$DHE_PSK_WITH_CAMELLIA_128_CBC_SHA256zDHE-PSK-CAMELLIA128-SHA256$DHE_PSK_WITH_CAMELLIA_256_CBC_SHA384zDHE-PSK-CAMELLIA256-SHA384$RSA_PSK_WITH_CAMELLIA_128_CBC_SHA256zRSA-PSK-CAMELLIA128-SHA256$RSA_PSK_WITH_CAMELLIA_256_CBC_SHA384zRSA-PSK-CAMELLIA256-SHA384&ECDHE_PSK_WITH_CAMELLIA_128_CBC_SHA256zECDHE-PSK-CAMELLIA128-SHA256&ECDHE_PSK_WITH_CAMELLIA_256_CBC_SHA384zECDHE-PSK-CAMELLIA256-SHA384PSK_WITH_AES_128_CCMzPSK-AES128-CCMPSK_WITH_AES_256_CCMzPSK-AES256-CCMDHE_PSK_WITH_AES_128_CCMzDHE-PSK-AES128-CCMDHE_PSK_WITH_AES_256_CCMzDHE-PSK-AES256-CCMzPSK-AES128-CCM8zPSK-AES256-CCM8zDHE-PSK-AES128-CCM8zDHE-PSK-AES256-CCM8zECDHE-RSA-CHACHA20-POLY1305zECDHE-ECDSA-CHACHA20-POLY1305zDHE-RSA-CHACHA20-POLY1305zPSK-CHACHA20-POLY1305zECDHE-PSK-CHACHA20-POLY1305zDHE-PSK-CHACHA20-POLY1305zRSA-PSK-CHACHA20-POLY1305) PSK_WITH_AES_128_CCM_8PSK_WITH_AES_256_CCM_8DHE_PSK_WITH_AES_128_CCM_8DHE_PSK_WITH_AES_256_CCM_8+TLS_ECDHE_RSA_WITH_CHACHA20_POLY1305_SHA256-TLS_ECDHE_ECDSA_WITH_CHACHA20_POLY1305_SHA256)TLS_DHE_RSA_WITH_CHACHA20_POLY1305_SHA256%TLS_PSK_WITH_CHACHA20_POLY1305_SHA256+TLS_ECDHE_PSK_WITH_CHACHA20_POLY1305_SHA256)TLS_DHE_PSK_WITH_CHACHA20_POLY1305_SHA256)TLS_RSA_PSK_WITH_CHACHA20_POLY1305_SHA256TLSV1_2_CIPHER_SUITESTLS_AES_128_GCM_SHA256TLS_AES_256_GCM_SHA384TLS_CHACHA20_POLY1305_SHA256TLS_AES_128_CCM_SHA256TLS_AES_128_CCM_8_SHA256)rrrrrTLSV1_3_CIPHER_SUITES)zTLSv1.2zTLSv1.3TLS_CIPHER_SUITESOPENSSL_CS_NAMESflagflagsreturnc||zdkrdSdS)z.Checks if the flag is set Returns booleanrTF)rrs W/var/www/html/mpstechhub/venv/lib/python3.11/site-packages/mysql/connector/constants.py flag_is_setr(s  t 5namenew_namevaluecJtjd|d|dt|S)aRaise a deprecation warning and advise a new option name. Args: name (str): The name of the option. new_name (str): The new option name. value (int): The value of the option. Returns: int: The value of the option. z The option 'z' has been deprecated, use 'z ' instead.category)warningswarnDeprecationWarning)rrrs r_obsolete_optionr 1s= MMtMMMMM# Lr cursor_namec\|tvr"tjd|dtddSdS)a!Raise a deprecation warning if the cursor class name matches against any of DEPRECATED_CURSOR_CLASS_NAMES list. Args: cursor_name (str): cursor class name to be checked against DEPRECATED_CURSOR_CLASS_NAMES list. Returns: None zWARNING: Cursor type zU is now deprecated and will be removed in a future release of MySQL Connector/Python.)messager stacklevelN)rlrrr )r s r-raise_warning_against_deprecated_cursor_classrCsY333 &K&&&(       43rc eZdZUdZdZeed<iZeee e effed<e dede efdZ e de dee ee eefffd Ze deeeeffd Zd S) _ConstantszBase class for constants.rprefixdescrrcZ |j|dS#ttf$rYdSwxYw)z!Get description of given constantr N)r IndexErrorKeyErrorclsrs rget_descz_Constants.get_desc_s? 8D>!$ $H%   44 s **setidcd|jD]\}}|d|kr|cSdS)z$Get information about given constantrN)ritems)rrrinfos rget_infoz_Constants.get_infogsE(..**  JD$Aw%  trcg} d|jD}n##ttf$r}d|}Yd}~nd}~wwxYw|S)z)get full information about given constantc.g|]\}}|d|dS)z : r r).0kvs r z,_Constants.get_full_info..ts*@@@tq!a??AaD??@@@rz(No information found in constant class. N)rrAttributeErrorr)rreserrs r get_full_infoz_Constants.get_full_infoosv&( C@@sx~~/?/?@@@CC + C C CBSBBCCCCCC C s#(AAAN)__name__ __module__ __qualname____doc__rstr__annotations__rrr int classmethodrrr rr r)rrrrrYs##FC')D$sE#s(O# $)))CHSM[SU8C=%S/+I%J[eC#$67[rrc>eZdZdZededeefdZdS)_Flagsz'Base class for classes describing flagsrrcg}|jD]%\}}||dzr||&|S)z@Get the name of all bits set Returns a list of strings.r)rrappend)rrr'rrs r get_bit_infoz_Flags.get_bit_info~sP (..** ! !JD$tAw ! 4    rN) r*r+r,r-r1r0rr.r6rrrr3r3{sJ11c[rr3c~eZdZUdZdZeed<dZeed<dZ eed<dZ eed <d Z eed <d Z eed <dZ eed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<d Zeed!<d"Zeed#<d$Zeed%<d&Zeed'<d(Zeed)<d*Zeed+<d,Zeed-<d.Zeed/<d0Zeed1<d2Zeed3<d4Z eed5<d6Z!eed7<d8Z"eed9<d:Z#eed;<d Z%e&ee'eeffed?<e(d@e)efdAZ*e(d@e)efdBZ+e(d@e)efdCZ,e(d@e)efdDZ-dES)F FieldTypeaYMySQL Field Types. This class provides all supported MySQL field or data types. They can be useful when dealing with raw data or defining your own converters. The field type is stored with every cursor in the description for each column. The `FieldType` class shouldn't be instantiated. Examples: The following example shows how to print the name of the data type for each column in a result set. ``` from __future__ import print_function import mysql.connector from mysql.connector import FieldType cnx = mysql.connector.connect(user='scott', database='test') cursor = cnx.cursor() cursor.execute( "SELECT DATE(NOW()) AS `c1`, TIME(NOW()) AS `c2`, " "NOW() AS `c3`, 'a string' AS `c4`, 42 AS `c5`") rows = cursor.fetchall() for desc in cursor.description: colname = desc[0] coltype = desc[1] print("Column {} has type {}".format( colname, FieldType.get_info(coltype))) cursor.close() cnx.close() ``` FIELD_TYPE_rrDECIMALr TINYSHORTr LONGFLOATDOUBLENULL TIMESTAMPrLONGLONG INT24 DATE TIME DATETIME YEARNEWDATEVARCHARBITVECTORJSON NEWDECIMALENUMSET TINY_BLOB MEDIUM_BLOB LONG_BLOBBLOB VAR_STRINGSTRINGrGEOMETRY) rYr[r]r_rarcrergrirkrmrnrrc6|j|j|j|jgS)z Get the list of all string types)rUr_rkrmrs rget_string_typeszFieldType.get_string_typess" K H N J   rc6|j|j|j|jgS)z Get the list of all binary types)rcrergrirps rget_binary_typeszFieldType.get_binary_typess" M O M H   rc |j|j|j|j|j|j|j|j|j|j |j g S)z Get the list of all number types) r:r]r;r=r>r@rBrGrIrWrQrps rget_number_typeszFieldType.get_number_typessE K N H I H I J L I G H  rc|j|jgS)z#Get the list of all timestamp types)rOrFrps rget_timestamp_typeszFieldType.get_timestamp_typess L M  rN).r*r+r,r-rr.r/r:r0r;r=r>r@rBrDrFrGrIrKrMrOrQrSrUrWrYr[r]r_rarcrergrirkrmrnrrr r1rrqrsrurwrrrr8r8sW""H FCGSD#E3D#E3FCD#IsHcE3D#D#HcD#GSGSCOOOFCD#JD#COOOIsKIsD#JFCHc(GY'(v( %!( v ( %! ( 68$ ( v( i-( Xz*( %!( v( v( Xz*( v( GY'( GY'!(" U|#($8$v!<0vU|-#]3-v!<08$z*;(((D$sE#s(O# $@ c   [  c   [  c   [  DI   [   rr8c eZdZUdZdZeed<dZeed<dZ eed<dZ eed <d Z eed <d Z eed <dZ eed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<d Zeed!<d"Zeed#<d Zeed$<d%Zeed&<d'Zeed(<d)Zeed*<d+Zeed,<d-Zeed.<d/Zeed0<idd1dd2d d3d d4d d5dd6dd7dd8dd9dd:dd;dd<dd=dd>d!d?d#d@d$dAdBdCdDdEdFdGdHZe ee!eeffedI<dJS)K FieldFlagz_MySQL Field Flags Field flags as found in MySQL sources mysql-src/include/mysql_com.h r_prefixr NOT_NULLr<PRI_KEYr? UNIQUE_KEYr MULTIPLE_KEYrVri UNSIGNED@ZEROFILLBINARYr_AUTO_INCREMENTrFrarNO_DEFAULT_VALUEr ON_UPDATE_NOW@NUMPART_KEYGROUPUNIQUEBINCMPGET_FIXED_FIELDSFIELD_IN_PART_FUNCFIELD_IN_ADD_INDEX FIELD_IS_RENAMED)r zField can't be NULL)r<zField is part of a primary key)r?zField is part of a unique key)rzField is part of a key)rVzField is a blob)rzField is unsigned)rzField is zerofill)rzField is binary )rzfield is an enum)rzfield is a autoincrement field)rzField is a timestamp)rzfield is a set)rz Field doesn't have default value)rzField is set to NOW on UPDATE)rzField is num (for clients))rzIntern; Part of some key)rzIntern: Group field)rIntern: Used by sql_yacc)rr)rzUsed to get fields in item tree)rzField part of partition func)rzIntern: Field used in ADD INDEX)rzIntern: Field is being renamed)rrrrrrrN)"r*r+r,r-rzr.r/r{r0r|r}r~rirrrr_rrFrarrrrrrrrrrrrrr rrrryrys GSHcGSJL#D#HcHcFCD# NC   IsC#c### M3   CHcE3FCFC#c###%%%%%%%%#c###(3(=( ?( : ( + ( 1 ( 1( /( ,( D( 6( *( I( C( 6( 9!(" 1#($87HGJG/(((D$sE#s(O# $rryc,eZdZdZdedeffd ZxZS) ServerCmdMetazClientFlag Metaclass.rrcd}||vrtjd|dtt|S)N) FIELD_LISTREFRESHSHUTDOWN PROCESS_INFO PROCESS_KILLzThe option 'ServerCmd.z8' is deprecated and will be removed in a future release.r)rrr super__getattribute__)rrdeprecated_options __class__s rrzServerCmdMeta.__getattribute__\se  % % % M$$$$+     ww''---r)r*r+r,r-r.rr __classcell__)rs@rrrYsQ.C.C..........rrceZdZUdZdZeed<dZeed<dZ eed<dZ eed <d Z eed <d Z eed <dZ eed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<d Zeed!<d"Zeed#<d$Zeed%<d&Zeed'<d(Zeed)<d*Zeed+<d,Zeed-<d.Zeed/<d0Zeed1<d2Zeed3<d4Z eed5<d6Z!eed7<d8Z"eed9<d:Z#eed;<dZ%eed?<d@Z&eedA<dBZ'eedC<iddDddEd dFd dGd dHddIddJddKddLddMddNddOddPddQd!dRd#dSd%dTdUdVdWdXdYdZd[d\d]d^d_d`dadbdcddZ(e)ee*eeffede<dfS)g ServerCmdzMySQL Server CommandsCOM_rzrSLEEPr QUITr<INIT_DBr QUERYr?rrA CREATE_DBrCDROP_DBrErrrrH STATISTICSrJrrLCONNECTrNrrPDEBUGrRPINGrTrMrVDELAYED_INSERT CHANGE_USER BINLOG_DUMP TABLE_DUMP CONNECT_OUTREGISTER_REPLICA STMT_PREPARE STMT_EXECUTESTMT_SEND_LONG_DATA STMT_CLOSE STMT_RESET SET_OPTION STMT_FETCHDAEMONBINLOG_DUMP_GTIDRESET_CONNECTION)rr)r r)r<r)r r)r?r)rAr)rCr)rEr)rr)rHr)rJr)rLr)rNr)rPr)rRr)rTrM)rVr)rr)rr)rr)rr)rr)rr)rr)rr)rr)rr)rr)rr)rr)rr)rr)rrrrrrrrrrrrrrrrN)+r*r+r,r-rzr.r/rr0rrrrrrrrrrrrrrrMrrrrrrrrrrrrrrrrrrr rrrrrmsUGSE3NNND#MMMGSE3NNNJIsGSGSHcJL#GSL#E3OOOD#NNND#NNNNCKKJKcL#L#!!!!JJJJFCcc!(!( !( >!(  !( ' !( % !( >!( >!( O!( '!( ,!( ?!( ,!( !(  !(  !!(" 0#!($+*(*4,,:(((( 44A!(!(!(D$sE#s(O# $!!!!!rr) metaclassceZdZUdZdZeed<dZeed<dZeed<dZ eed <d Z eed <d Z eed <dZ eed<dZ eed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<d Zeed!<d"Zeed#<d$Zeed%<d&Zeed'<d(Zeed)<d*Zeed+<d,Zeed-<d.Zeed/<d0Zeed1<d0Zeed2<d3Zeed4<d5Z eed6<d7Z!eed8<d9Z"eed:<d;Z#eed<<idd=dd>dd?d d@d dAd dBddCddDddEddFddGddHddIddJddKd!dLd#dMdNdOdPdQdRdSdTdTdUdVdWdXdY Z$e%e&e'ee&ffedZ<eee eeeeeeeg Z(e)eed[<e*d\efd]Z+d^S)_ ClientFlagaMySQL Client Flags. Client options as found in the MySQL sources mysql-src/include/mysql_com.h. This class provides constants defining MySQL client flags that can be used when the connection is established to configure the session. The `ClientFlag` class is available when importing mysql.connector. The `ClientFlag` class shouldn't be instantiated. Examples: ``` >>> import mysql.connector >>> mysql.connector.ClientFlag.FOUND_ROWS 2 ``` r LONG_PASSWDr< FOUND_ROWSr? LONG_FLAGrCONNECT_WITH_DBrV NO_SCHEMArCOMPRESSrODBCr LOCAL_FILESr IGNORE_SPACEr PROTOCOL_41r INTERACTIVErSSLrIGNORE_SIGPIPEr TRANSACTIONSrRESERVEDrSECURE_CONNECTIONrMULTI_STATEMENTSr MULTI_RESULTSrPS_MULTI_RESULTSr PLUGIN_AUTHr CONNECT_ARGSrPLUGIN_AUTH_LENENC_CLIENT_DATA@CAN_HANDLE_EXPIRED_PASSWORDS SESION_TRACK SESSION_TRACK DEPRECATE_EOFCLIENT_QUERY_ATTRIBUTES@SSL_VERIFY_SERVER_CERTREMEMBER_OPTIONSiMULTI_FACTOR_AUTHENTICATION)r zNew more secure passwords)r<zFound instead of affected rows)r?zGet all column flags)rzOne can specify db on connect)rVz!Don't allow database.table.column)rzCan use compression protocol)rz ODBC client)rzCan use LOAD DATA LOCAL)rzIgnore spaces before '')rzNew 4.1 protocol)rzThis is an interactive client)rzSwitch to SSL after handshake)rzIGNORE sigpipes)rzClient knows about transactions)rzOld flag for 4.1 protocol)rzNew 4.1 authentication)rz!Enable/disable multi-stmt support)rzEnable/disable multi-results)rzMulti-results in PS-protocol)rz%Client supports plugin authentication)rz%Client supports connection attributes)rzAEnable authentication response packet to be larger than 255 bytes)rzADon't close the connection for a connection with expired password)rz3Capable of handling server state change information)rz!Client no longer needs EOF packet)rz/Support optional extension for query parameters)rr)rr) rrrrrrrrrrrrrdefaultrc(d}|jD]}||z}|S)zbGet the default client options set Returns a flag with all the default client options setr)r)rroptions r get_defaultzClientFlag.get_default$s* k  F VOEE rN),r*r+r,r-rr0r/rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr.r rrr1rrrrrrs$KJIs!OS!!!IsHcD#KL#KKC!NC!!!L#Hc$s$$$#c### M3   #c###KL#*1"C111(/ #///L# M3    M3   #*S***")C)))#c###'....-(<-(@-( 5-( D -( B -( < -( '-( :-( ;-( 3-( A-( 9-( 6-( D-( :-( @!-(" J#-($CEIJ+ )   H$ #0)Y-(-(-(D$sE#s(O# $---` & GT#Y   C[rrc2eZdZUdZdZeed<dZeed<dZ eed<dZ eed <d Z eed <d Z eed <dZ eed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<d d!d"d#d$d%d&d'd(d)d*d+d,d-d.Zeeeeeffed/<d0S)1 ServerFlagzeMySQL Server Flags Server flags as found in the MySQL sources mysql-src/include/mysql_com.h SERVER_rzr STATUS_IN_TRANSr<STATUS_AUTOCOMMITrMORE_RESULTS_EXISTSrVQUERY_NO_GOOD_INDEX_USEDrQUERY_NO_INDEX_USEDrSTATUS_CURSOR_EXISTSrSTATUS_LAST_ROW_SENTrSTATUS_DB_DROPPEDrSTATUS_NO_BACKSLASH_ESCAPESrSERVER_STATUS_METADATA_CHANGEDrSERVER_QUERY_WAS_SLOWrSERVER_PS_OUT_PARAMSrSERVER_STATUS_IN_TRANS_READONLYrSERVER_SESSION_STATE_CHANGED)r zTransaction has started)r<zServer in auto_commit mode)rzMulti query - next query exists)rVr)rr)rzESet when server opened a read-only non-scrollable cursor for a query.)rz(Set when a read-only cursor is exhausted)rzA database was dropped)rr)rzSet if after a prepared statement reprepare we discovered that the new statement returns a different number of result set columns.)rr)rz5To mark ResultSet containing output parameter values.)rz>Set if multi-statement transaction is a read-only transaction.)rzVSession state has changed on the server because of the execution of the last statement)SERVER_STATUS_IN_TRANSSERVER_STATUS_AUTOCOMMITSERVER_MORE_RESULTS_EXISTSSERVER_QUERY_NO_GOOD_INDEX_USEDSERVER_QUERY_NO_INDEX_USEDSERVER_STATUS_CURSOR_EXISTSSERVER_STATUS_LAST_ROW_SENTSERVER_STATUS_DB_DROPPED"SERVER_STATUS_NO_BACKSLASH_ESCAPESrrrrrrN)r*r+r,r-rzr.r/rr0rrrr r r r r rrrrrrrr rrrrr/s GS!OS!!!#s###%%%%$*c***%%%% &#&&& &#&&&#s###'----*1"C111!(3((( '#'''+2#S222(/ #///#F$J' ,8&2( ( %G.:+ ",! , ) G)()(D$sE#s(O# $)))))rrc.eZdZdZedefdZdS)RefreshOptionMetazRefreshOption Metaclass.rc8tddtjS)zzReturn the deprecated alias of RefreshOption.REPLICA. Raises a warning about this attribute deprecation. zRefreshOption.SLAVEzRefreshOption.REPLICA)r  RefreshOptionREPLICAselfs rSLAVEzRefreshOptionMeta.SLAVEts"  ! #  !   rN)r*r+r,r-propertyr0r#rrrrrqs?""   s    X    rrceZdZUdZdZeed<dZeed<dZ eed<dZ eed <d Z eed <d Z eed <dZ eed<ddddddddZeeeeeffed<dS)rzbMySQL Refresh command options. Options used when sending the COM_REFRESH server command. REFRESH_rzr GRANTr<LOGr?TABLESrHOSTrVSTATUSrr )r zRefresh grant tables)r<zStart on new log file)r?zclose all tables)rzFlush host cache)rVzFlush status variables)rz,Reset source info and restart replica thread)rz'Deprecated option; use REPLICA instead.)r'r(r)r*r+r r#rN)r*r+r,r-rzr.r/r'r0r(r)r*r+r rrr rrrrrs GSE3CFCD#FCGS20.,4KD((D$sE#s(O# $rrc eZdZUdZdZeed<dZeed<dZ eed<dZ eed <d Z eed <d Z eed <dZ eed<dZeed<dZeed<edfe dfe dfe dfe dfe dfedfedfdZeeeeeffed<dS) ShutdownTypezVMySQL Shutdown types Shutdown types used by the COM_SHUTDOWN server command. rrzrSHUTDOWN_DEFAULTr SHUTDOWN_WAIT_CONNECTIONSr<SHUTDOWN_WAIT_TRANSACTIONSrSHUTDOWN_WAIT_UPDATESrVSHUTDOWN_WAIT_ALL_BUFFERSrSHUTDOWN_WAIT_CRITICAL_BUFFERSrl KILL_QUERYrKILL_CONNECTIONz%defaults to SHUTDOWN_WAIT_ALL_BUFFERSz'wait for existing connections to finishz!wait for existing trans to finishz#wait for existing updates to finishz-flush InnoDB and other storage engine buffersz@don't flush InnoDB buffers, flush other storage engines' buffersz(no description))r.r/r0r1r2r3r4r5rN)r*r+r,r-rzr.r/r.r0r/r0r1r2r3r4r5rrr rrrr-r-sI GSc%&s&&&&''''!"3"""%'s'''*,"C,,,JOS  3 & 5& ' /' " 1" & ;& + N+ "#56+-?@5((D$sE#s(O# $rr-c *eZdZUdZdZeedfed<ddZdeedfddfd Z d edee e ffd Z d ede fd Z de ee fdee e effdZ ddee ee fdee deee e ffdZdee dffdZdS) CharacterSetaLMySQL supported character sets and collations List of character sets with their collations supported by MySQL. This maps to the character set we get from the server within the handshake packet. The list is hardcode so we avoid a database query when getting the name of the used character set or collation. )r rPrTWX.slash_charsetsrNc,t|_d|_dS)N)rArE)r_desc_mysql_versionr!s r__init__zCharacterSet.__init__srr=)r"r@s rset_mysql_versionzCharacterSet.set_mysql_versions5 &bqbk  & ( (-DJJJ ) (rrcr |j|ddS#t$rtd|ddwxYw)aRetrieves character set information as tuple using an ID Retrieves character set and collation information based on the given MySQL ID. Raises ProgrammingError when character set is not supported. Returns a tuple. rr<Character set ' ' unsupportedN)r=rr)r"rs rrzCharacterSet.get_infosZ U:e$QqS) ) U U U"#IU#I#I#IJJPT T Us6rc@||\}}|d|S)zRetrieves character set information as string using an ID Retrieves character set and collation information based on the given MySQL ID. Returns a tuple. /)r)r"rr'r)s rrzCharacterSet.get_descs."]]400''I'''rr'cvt|trL |j|}|d|d|fS#ttf$r}t d|d|d}~wwxYwt |jD]1\}}||d|kr|ddur|d|d|fcS2t d|d) zRetrieves the default collation for given character set Raises ProgrammingError when character set is not supported. Returns list (collation, charset, index) r rzCharacter set ID 'rFNr<TrE) isinstancer0r=rrr enumerate)r"r'rr(cids rget_default_collationz"CharacterSet.get_default_collations gs # #  z'*AwQ00)   &????  #4:.. - -IC|Aw'!!d1gooAwQ,,,,GGGGHHHs5AAAr)cd}t|trE |j|}||d|dfS#t$r}t d|d|d}~wwxYw|dvr |jdkrd}|.|,||}|d |d|dfS|Q|Ot|jD]'\}}|||dkr||d|dfcS(t d |d t|jD]3\}}||d|kr|d|kr||d|dfcS4||}t d |d ) aEGet character set information using charset name and/or collation Retrieves character set and collation information given character set name and/or a collation name. If charset is an integer, it will look up the character set based on the MySQL's ID. For example: get_charset_info('utf8',None) get_charset_info(collation='utf8_general_ci') get_charset_info(47) Raises ProgrammingError when character set is not supported. Returns a tuple with (id, characterset name, collation) Nrr zCharacter set ID z unknown)utf8zutf-8rBr(r<z Collation 'z ' unknown)rJr0r=rrr>rMrK)r"r'r)rr(rL_s rget_charset_infozCharacterSet.get_charset_infos$NR gs # # W Wz'*a$q'22 W W W&'L7'L'L'LMMSVV W ' ' 'D,?6,I,IG  9#4--g66DGT!Wd1g. . ?y4&tz22 3 3 T<Q''a$q'2222("#E#E#E#EFF F"4:.. / /IC|Aw'!!d1g&:&:T!Wd1g....  & &w / /AYAAABBBs7 AAAcg}|jD])}|r%|d|vr||d*t|S)z^Retrieves a list with names of all supproted character sets Returns a tuple. r)r=r5tuple)r"r'rs r get_supportedzCharacterSet.get_supportedEsS J $ $D $Qs** 47###Szzr)rN)NN)r*r+r,r-r;r r0r/r?rCr.rrr rMrrQrTrrrr7r7s'>NE#s(O===6666 .sCx.T.... Uc UeCHo U U U U (S (S ( ( ( (IU38_IsCQT}AUIIII2UY,C,Cc3h0,CDLSM,C sC} ,C,C,C,C\ uS#X      rr7cfeZdZUdZdZeed<dZeed<dZeed<dZ eed<dZ eed<dZ eed<d Z eed <d Z eed <d Zeed <d Zeed <d Zeed <dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<dZeed<dZ eed<dZ!eed<dZ"eed<d Z#eed <d!Z$eed!<d"Z%eed"<d#Z&eed#<e'd$ed%e(efd&Z)e'd'e*d%e(efd(Z+e'd%e,ed)ffd*Z-d+S),SQLModea.MySQL SQL Modes The numeric values of SQL Modes are not interesting, only the names are used when setting the SQL_MODE system variable using the MySQL SET command. The `SQLMode` class shouldn't be instantiated. See http://dev.mysql.com/doc/refman/5.6/en/server-sql-mode.html MODE_rz REAL_AS_FLOATPIPES_AS_CONCAT ANSI_QUOTESrNOT_USEDONLY_FULL_GROUP_BYNO_UNSIGNED_SUBTRACTIONNO_DIR_IN_CREATE POSTGRESQLORACLEMSSQLDB2MAXDBNO_KEY_OPTIONSNO_TABLE_OPTIONSNO_FIELD_OPTIONSMYSQL323MYSQL40ANSINO_AUTO_VALUE_ON_ZERONO_BACKSLASH_ESCAPESSTRICT_TRANS_TABLESSTRICT_ALL_TABLESNO_ZERO_IN_DATE NO_ZERO_DATE INVALID_DATESERROR_FOR_DIVISION_BY_ZERO TRADITIONALNO_AUTO_CREATE_USERHIGH_NOT_PRECEDENCENO_ENGINE_SUBSTITUTIONPAD_CHAR_TO_FULL_LENGTHrrctNNotImplementedErrorrs rrzSQLMode.get_desc!!rrctrxry)rrs rrzSQLMode.get_infor{r.cg}t|D]J}|ds3tt ||ds||Kt t|S)zReturns a sequence of all available SQL Modes This class method returns a tuple containing all SQL Mode names. The names will be alphabetically sorted. Returns a tuple. rP__call__)varskeys startswithhasattrgetattrr5rSsorted)rr'keys rr)zSQLMode.get_full_infos{99>>##  C>>#&& wwsC7H7H*/U/U  3VC[[!!!rN).r*r+r,r-rzr.r/rXrYrZrr[r\r]r^r_r`rarbrcrdrerfrgrhrirjrkrlrmrnrorprqrrrsrtrurvr1rrr0rr r)rrrrVrVQs  GS(M3(((,OS,,,$K$$$&L#&&&Hc2222#<S<<<.c..."J"""FCE3CE3*NC***.c....c...HcGSD#!83888 6#66644440s000,OS,,,&L#&&&(M3(((&BBBB$K$$$44444444":C:::#<S<<<"C"HSM"""[""S"Xc]"""[" "eCHo " " "[ " " "rrV):r-rabcrrtypingrrrrr r r r charsetsrrerrorsr tls_ciphersrrrr0r/rrMYSQL_VECTOR_TYPE_CODEMYSQL_DEFAULT_CHARSET_ID_57MYSQL_DEFAULT_CHARSET_ID_80rTr.boolrXrcrlrmrrrvaluesrrr rrr3r8ryrrrrrrr-r7rVrrrrs:211PPPPPPPPPPPPPPPPPPPPCCCCCCCC$$$$$$GGGGGGGG3####!"3"""I!!7E7E B7E7E 7E  7E  7E K7E D7E47E47Ey7E7Et7Ee7E%7E !7E"#7E7E$E%7E&'7E($)7E*D+7E,T-7E.A/7E017E237E4 557E6 d77E897E:t;7E<u=7E>5?7E@$A7EBC7EDEE7E7E7EFDG7EH dI7EJ $K7ELtM7EN 4O7EP%Q7ER4S7ET%U7EV!$W7EXuY7EZ$[7E\u]7E^_7E`Ta7Ebtc7Ed$e7Efg7E7Ehm7E7E7EtC%T3*?!@@A777r'W uS#s]#VVV " uS#X    2uS#X   02II d3iIIIQG) G)%G)&G)&': G) &': G) )*@ G))*@G))*DG))*DG))*@G))*@G))*DG))*DG)*+BG)*+BG) *+F!G)"*+F#G)G)$*+B%G)&*+B'G)(*+F)G)**+F+G),,-F-G).,-F/G)0,-J1G)2,-J3G)4./J5G)6./J7G)8./N9G):./N;G)<*+>=G)>*+>?G)@*+BAG)B*+BCG)DLEG)G)G)FLGG)H 4IG)J 4KG)LmMG)NmOG)P!"7QG)R!"7SG)T#$