,h 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#eedS<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%jQe&jQdWZ)eee efedY<dZed[ed\e fd]Z*d^ed_ed`ed\efdaZ+GdbdceZ,Gdddee,Z-Gdfdge,Z.Gdhdie-Z/GdjdkeZ0Gdldme,e0nZ1Gdodpe-Z2Gdqdre-Z3GdsdteZ4Gdudve,e4nZ5Gdwdxe,Z6GdydzZ7Gd{d|e,Z8y(}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_DNzH The property counterpart '{property_name}' should be used instead. DEPRECATED_METHOD_WARNING 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||zdkDryy)z.Checks if the flag is set Returns booleanrTF)rrs [/var/www/html/Resume-Scraper/venv/lib/python3.12/site-packages/mysql/connector/constants.py flag_is_setr s   namenew_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)s- MM tf8 *M# Lrc eZdZUdZdZeed<iZeee e effed<e dede efdZ e de dee ee eefffd Ze deeeeffd Zy ) _ConstantszBase class for constants.rprefixdescrrcR |j|dS#ttf$rYywxYw)z!Get description of given constantr N)r IndexErrorKeyErrorclsrs rget_descz_Constants.get_descAs1 88D>!$ $H%  s &&setidc`|jjD]\}}|d|k(s|cSy)z$Get information about given constantrN)ritems)r r rinfos rget_infoz_Constants.get_infoIs8((..* JD$Aw%  rcg} |jjDcgc]\}}|d|d}}}|Scc}}w#ttf$r}d|}Yd}~|Sd}~wwxYw)z)get full information about given constantz : r z(No information found in constant class. N)rrAttributeErrorr)r reskverrs r get_full_infoz_Constants.get_full_infoQst&( C/2xx~~/?@tq!aSAaD6?@C@ A + C Z%e&ee'eeffed?<e(d@e)efdAZ*e(d@e)efdBZ+e(d@e)efdCZ,e(d@e)efdDZ-yE)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 TINYSHORTLONGFLOATDOUBLENULL TIMESTAMPrLONGLONG INT24 DATE TIME DATETIME YEARNEWDATEVARCHARBITVECTORJSON NEWDECIMALENUMSET TINY_BLOB MEDIUM_BLOB LONG_BLOBBLOB VAR_STRINGSTRINGrGEOMETRY) rIrKrMrOrQrSrUrWrYr[r]r^rrc^|j|j|j|jgS)z Get the list of all string types)rErOr[r]r s rget_string_typeszFieldType.get_string_typess* KK HH NN JJ   rc^|j|j|j|jgS)z Get the list of all binary types)rSrUrWrYr`s rget_binary_typeszFieldType.get_binary_typess* MM OO MM HH   rc |j|j|j|j|j|j |j |j|j|j|jg S)z Get the list of all number types) r)rMr*r,r.r0r2r7r9rGrAr`s rget_number_typeszFieldType.get_number_typess[ KK NN HH II HH II JJ LL II GG HH  rc2|j|jgS)z#Get the list of all timestamp types)r?r6r`s rget_timestamp_typeszFieldType.get_timestamp_typess LL MM  rN).rrrrrrrr)rr*r,r.r0r2r4r6r7r9r;r=r?rArCrErGrIrKrMrOrQrSrUrWrYr[r]r^rrr r rrarcrergrrrr'r'lsJ"H FCGSD#E3D#E3FCD#IsHcE3D#D#HcD#GSGSCOFCD#JD#COIsKIsD#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  rr'ceZdZUdZdZeed<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<yJ)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_KEYrFrY UNSIGNED@ZEROFILLBINARYrOAUTO_INCREMENTr6rQrNO_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)rFzField is a blob)rozField is unsigned)rqzField is zerofill)rszField is binary )ruzfield is an enum)rvzfield is a autoincrement field)rxzField is a timestamp)ryzfield is a set)rz Field doesn't have default value)rzField is set to NOW on UPDATE)r|zField is num (for clients))r~zIntern; Part of some key)r|zIntern: 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)"rrrrrjrrrkrrlrmrnrYrprrrtrOrwr6rQrzr{r}rrrrrrrrrrr rrrriris 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# $rric,eZdZdZdedeffd ZxZS) ServerCmdMetazClientFlag Metaclass.rrcld}||vrtjd|dtt||S)N) FIELD_LISTREFRESHSHUTDOWN PROCESS_INFO PROCESS_KILLzThe option 'ServerCmd.z8' is deprecated and will be removed in a future release.r)rrrsuper__getattribute__)r rdeprecated_options __class__s rrzServerCmdMeta.__getattribute__>sH  % % MM(/$$+  w'--r)rrrrrrr __classcell__)rs@rrr;s.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<yf)g ServerCmdzMySQL Server CommandsCOM_rjrSLEEPr QUITr+INIT_DBr-QUERYr/rr1 CREATE_DBr3DROP_DBr5rrrr8 STATISTICSr:rr<CONNECTr>rr@DEBUGrBPINGrDr=rFDELAYED_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)r1r)r3r)r5r)rr)r8r)r:r)r<r)r>r)r@r)rBr)rDr=)rFr)rr)rr)rr)rr)rr)rr)rr)rr)rr)rr)rr)rr)rr)rr)rr)rrrrrrrrrrrrrrrrN)+rrrrrjrrrrrrrrrrrrrrrrrrr=rrrrrrrrrrrrrrrrrrr rrrrrOspGSE3ND#MGSE3NJIsGSGSHcJL#GSL#E3OD#ND#NNCKKJKcL#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+y^)_ 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_DBrF NO_SCHEMAroCOMPRESSrqODBCrs LOCAL_FILESru IGNORE_SPACErv PROTOCOL_41rx INTERACTIVErySSLrIGNORE_SIGPIPEr TRANSACTIONSr|RESERVEDr~SECURE_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)rFz!Don't allow database.table.column)rozCan use compression protocol)rqz ODBC client)rszCan use LOAD DATA LOCAL)ruzIgnore spaces before '')rvzNew 4.1 protocol)rxzThis is an interactive client)ryzSwitch to SSL after handshake)rzIGNORE sigpipes)rzClient knows about transactions)r|zOld flag for 4.1 protocol)r~zNew 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) rrrrrrrrrrrrrdefaultrc6d}|jD]}||z} |S)zbGet the default client options set Returns a flag with all the default client options setr)r)r roptions r get_defaultzClientFlag.get_defaults* kk F VOE  rN),rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr rrr rrrrrrs$KJIs!OS!IsHcD#KL#KKC!NC!L#Hc$s$#c# M3 #c#KL#*1"C1(/ #/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 Crrc$eZdZUdZdZeed<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/<y0)1 ServerFlagzeMySQL Server Flags Server flags as found in the MySQL sources mysql-src/include/mysql_com.h SERVER_rjr STATUS_IN_TRANSr+STATUS_AUTOCOMMITrMORE_RESULTS_EXISTSrFQUERY_NO_GOOD_INDEX_USEDroQUERY_NO_INDEX_USEDrqSTATUS_CURSOR_EXISTSrsSTATUS_LAST_ROW_SENTruSTATUS_DB_DROPPEDrvSTATUS_NO_BACKSLASH_ESCAPESrxSERVER_STATUS_METADATA_CHANGEDrySERVER_QUERY_WAS_SLOWrSERVER_PS_OUT_PARAMSrSERVER_STATUS_IN_TRANS_READONLYr|SERVER_SESSION_STATE_CHANGED)r zTransaction has started)r+zServer in auto_commit mode)rzMulti query - next query exists)rFr)ror)rqzESet when server opened a read-only non-scrollable cursor for a query.)rsz(Set when a read-only cursor is exhausted)ruzA database was dropped)rvr)rxzSet if after a prepared statement reprepare we discovered that the new statement returns a different number of result set columns.)ryr)rz5To mark ResultSet containing output parameter values.)rz>Set if multi-statement transaction is a read-only transaction.)r|zVSession 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)rrrrrjrrrrrrrrrrrrrrrrrrrr rrrrrs GS!OS!#s#%%$*c*%% &#& &#&#s#'--*1"C1!(3( '#'+2#S2(/ #/#F$J' ,8&2( ( %G.:+ ",! , ) G)(D$sE#s(O# $)rrc&eZdZdZedefdZy)RefreshOptionMetazRefreshOption Metaclass.rc8tddtjS)zzReturn the deprecated alias of RefreshOption.REPLICA. Raises a warning about this attribute deprecation. zRefreshOption.SLAVEzRefreshOption.REPLICA)r RefreshOptionREPLICAselfs rSLAVEzRefreshOptionMeta.SLAVEVs  ! #  ! !  rN)rrrrpropertyrrrrrr r Ss"   s    rr ceZdZUdZdZeed<dZeed<dZ eed<dZ eed <d Z eed <d Z eed <dZ eed<ddddddddZeeeeeffed<y)rzbMySQL Refresh command options. Options used when sending the COM_REFRESH server command. REFRESH_rjr GRANTr+LOGr/TABLESrHOSTrFSTATUSrqr)r zRefresh grant tables)r+zStart on new log file)r/zclose all tables)rzFlush host cache)rFzFlush status variables)rqz,Reset source info and restart replica thread)rqz'Deprecated option; use REPLICA instead.)rrrrrrrrN)rrrrrjrrrrrrrrrrrr rrrrrcs 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<y) ShutdownTypezVMySQL Shutdown types Shutdown types used by the COM_SHUTDOWN server command. rrjrSHUTDOWN_DEFAULTr SHUTDOWN_WAIT_CONNECTIONSr+SHUTDOWN_WAIT_TRANSACTIONSrSHUTDOWN_WAIT_UPDATESrFSHUTDOWN_WAIT_ALL_BUFFERSrSHUTDOWN_WAIT_CRITICAL_BUFFERSr\ 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))rrr r!r"r#r$r%rN)rrrrrjrrrrrr r!r"r#r$r%rrr rrrrr|s GSc%&s&&''!"3"%'s'*,"C,JOS  3 & 5& ' /' " 1" & ;& + N+ "#56+-?@5(D$sE#s(O# $rrc eZdZUdZdZeedfed<ddZdeedfddfd Z d edee e ffd Z d ede fd Z de ee fdee e effdZ ddee ee fdee deee e ffdZdee dffdZy) 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 r@rTWX.slash_charsetsrNc(t|_d|_y)N)r1r5)r_desc_mysql_versionrs r__init__zCharacterSet.__init__st|tr |j|}|d|d|fSt |jD]%\}}| |d|k(s|ddus|d|d|fcSt d|d#ttf$r}t d|d|d}~wwxYw) 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 'r6Nr+Tr5) isinstancerr-rr r enumerate)rr'rrcids rget_default_collationz"CharacterSet.get_default_collations gs # zz'*AwQ00 #4::. -IC|Aw'!d1goAwQ,,  -  GHH) &( ? sA88BBBr)cZd}t|tr |j|}||d|dfS|dvr|j dk\rd}|!||j |}|d |d|dfS|F|Dt|jD]\}}| ||dk(s||d|dfcSt d |d t|jD]&\}}| |d|k(s|d|k(s||d|dfcS|j |}t d |d #t$r}t d|d|d}~wwxYw) 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-8r2r(r+z Collation 'z ' unknown)r:rr-rrr.r=r;)rr'r)rrr<_s rget_charset_infozCharacterSet.get_charset_infos$NR gs # Wzz'*a$q'22 ' 'D,?,?6,IG  9#4--g6DGT!Wd1g. . ?y4&tzz2 3 T<Q'a$q'22  3 #[ 9#EF F"4::. /IC|Aw'!d1g&:T!Wd1g..  /  & &w /YKyABB+ W&):7)8'LMSVV WsD D*D%%D*c|g}|jD]!}|s|d|vs|j|d#t|S)z^Retrieves a list with names of all supproted character sets Returns a tuple. r)r-r$tuple)rrrs r get_supportedzCharacterSet.get_supported'sF JJ $DQs* 47# $Szr)rN)NN)rrrrr+r rrr/r3rrr r r=rrArDrrrr'r's'>NE#s(O=6 .sCx.T. Uc UeCHo U (S (S (IU38_IsCQT}AUI2UY,Cc3h0,CDLSM,C sC} ,C\ uS#X rr'c@eZdZUdZdZeed<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-y+),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_rj 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_LENGTHrrctNNotImplementedErrorr s rr zSQLMode.get_desca!!rr ctrhri)r r s rrzSQLMode.get_infoerkr.cg}t|jD]<}|jdrtt ||dr,|j |>t 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. r@__call__)varskeys startswithhasattrgetattrr$rCsorted)r rkeys rrzSQLMode.get_full_infois[9>># C>>#&wwsC7H*/U 3 VC[!!rN).rrrrrjrrrHrIrJrrKrLrMrNrOrPrQrRrSrTrUrVrWrXrYrZr[r\r]r^r_r`rarbrcrdrerfr rr rrr rrrrrFrF3s GS(M3(,OS,$K$&L#&Hc22#<S<.c."J"FCE3CE3*NC*.c..c.HcGSD#!838 6#6440s0,OS,&L#&(M3(&BB$K$4444":C:#<S<"C"HSM"""S"Xc]"" "eCHo " "rrF)9rrabcrrtypingrrrrr r r r charsetsrrerrorsr tls_ciphersrrrrrrrMYSQL_VECTOR_TYPE_CODEMYSQL_DEFAULT_CHARSET_ID_57MYSQL_DEFAULT_CHARSET_ID_80rTrboolrXrcrdrerrrvaluesrrrrr"r'rirrrrr rrr'rFrrrrs :2PPPC$G3##!"3"I!!7E7E B7E7E 7E  7E  7E K7E D7E47E47Ey7E7Et7Ee7E%7E !7E"#7E$E%7E&'7E($)7E*D+7E,T-7E.A/7E017E237E4 557E6 d77E897E:t;7E<u=7E>5?7E@$A7EBC7EDEE7EFDG7EH dI7EJ $K7ELtM7EN 4O7EP%Q7ER4S7ET%U7EV!$W7EXuY7EZ$[7E\u]7E^_7E`Ta7Ebtc7Ed$e7Efg7Ehm7EtC%T3*?!@@A7r'W uS#s]#V " uS#X "302II d3iIQG) G)%G)&G)&': G) &': G) )*@ G))*@G))*DG))*DG))*@G))*@G))*DG))*DG)*+BG)*+BG) *+F!G)"*+F#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)FLGG)H 4IG)J 4KG)LmMG)NmOG)P!"7QG)R!"7SG)T#$