3 deJ@s\UdZddlZddlmZmZddlmZmZmZm Z m Z m Z m Z m Z ddlmZmZddlmZdZed Zed Zed Zedd d d d d d ddddddddddddddddddddddddddddddddddddddddddddd3Zeee e eeeffdZe eeefddgZeeddgZeeeeedddZeeeedddZGd d!d!eZ Gd"d#d#e Z!Gd$d%d%e Z"Gd&d'd'e!Z#Gd(d)d)eZ$Gd*d+d+e e$d,Z%Gd-d.d.e!Z&Gd/d0d0e!Z'Gd1d2d2eZ(Gd3d4d4e e(d,Z)Gd5d6d6e Z*Gd7d8d8e Z+Gd9d:d:e Z,d;dd?d@dAdBdCdDg Z-ee-dEdFdGdHdIdJdKdKdLdMdNdOdPdQdRdSdTdUdVdWdXdYdZd[d\d]d^d_d`dadbdcdddedfdgdhdidjdkdldmdndodpdqdr.Z.eeef.e.Z/eeef/dsdtdudvdwdxdydzd{d|d}d~dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddZ0eeef0ddddddZ1eeef1e.e/e0e1dZ2eeeeeff2e.j3e/j3e0j3e1j3dZ4eee ef4dS)z+Various MySQL constants and character sets.N)ABCABCMeta)AnyDictListOptionalSequenceTupleUnion ValuesView)MYSQL_CHARACTER_SETSMYSQL_CHARACTER_SETS_57)ProgrammingErrorii iz 127.0.0.1i Tutf8mb4F)3ZdatabaseuserpasswordZ password1Z password2Z password3hostportZ unix_socketZ use_unicodecharset collationZconverter_classZconverter_str_fallbackZ autocommitZ time_zoneZsql_modeZ get_warningsZraise_on_warningsZconnection_timeoutZ client_flagscompressZbufferedrawZssl_caZssl_certZssl_keyZssl_verify_certZssl_verify_identityZ ssl_cipherZtls_ciphersuitesZ ssl_disabledZ tls_versionspasswddbconnect_timeoutZdsnZ force_ipv6Z auth_pluginZallow_local_infileZallow_local_infile_in_pathZconsume_resultsZ conn_attrsZdns_srvZuse_pureZkrb_service_principalZoci_config_fileZoci_config_profileZ fido_callbackZkerberos_auth_modeZ init_command pool_name pool_sizepool_reset_sessionzTLSv1.2zTLSv1.3TLSv1zTLSv1.1)flagflagsreturncCs||@dkrdSdS)z.Checks if the flag is set Returns booleanrTF)r"r#r%r%P/var/www/agendate/envp3/lib/python3.6/site-packages/mysql/connector/constants.py flag_is_setjs r')namenew_namevaluer$cCs tjd|d|dtd|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)r(r)r*r%r%r&_obsolete_optionss r/c@seZdZUdZdZeiZeeee effe ee edddZ e e e e eeeeffdddZe e eeefd d d Zd S) _ConstantszBase class for constants.r)r(r$c Cs,y|j|dSttfk r&dSXdS)z!Get description of given constantr N)desc IndexErrorKeyError)clsr(r%r%r&get_descsz_Constants.get_desc)setidr$cCs,x&|jjD]\}}|d|kr |Sq WdS)z$Get information about given constantrN)r1items)r4r6r(infor%r%r&get_infos z_Constants.get_info)r$cCsRg}ydd|jjD}Wn0ttfk rL}zd|}WYdd}~XnX|S)z)get full information about given constantcSs"g|]\}}|d|dqS)z : r r%).0kvr%r%r& sz,_Constants.get_full_info..z(No information found in constant class. N)r1r7AttributeErrorr2)r4reserrr%r%r& get_full_infos z_Constants.get_full_infoN)__name__ __module__ __qualname____doc__prefixstrr1rr int classmethodrr5r r9rrAr%r%r%r&r0s &r0c@s(eZdZdZeeeedddZdS)_Flagsz'Base class for classes describing flags)r*r$cCs6g}x,|jjD]\}}||d@r|j|qW|S)z@Get the name of all bits set Returns a list of strings.r)r1r7append)r4r*r?r(r8r%r%r& get_bit_infos  z_Flags.get_bit_infoN) rBrCrDrErIrHrrGrLr%r%r%r&rJsrJc@seZdZUdZdZedZedZedZ e dZ e dZ e dZ e d Z e d Zed Zed Zed ZedZedZedZedZedZedZedZedZedZedZedZedZedZedZedZ e dZ!e!dZ"e"dFdGdHdIdJdKdLdMdNdOdPdQdRdSdTdUdVdWdXdYdZd[d\d]d^d_d`dad;Z#e$ee%eeff#e&e'ed<d=d>Z(e&e'ed<d?d@Z)e&e'ed<dAdBZ*e&e'ed<dCdDZ+dES)b FieldTypezMySQL Field TypesZ FIELD_TYPE_rr r DECIMALTINYSHORTLONGFLOATDOUBLENULL TIMESTAMPLONGLONGINT24DATETIMEDATETIMEYEARNEWDATEVARCHARBITJSON NEWDECIMALENUMSET TINY_BLOB MEDIUM_BLOB LONG_BLOBBLOB VAR_STRINGSTRINGGEOMETRY)rgrhrirjrkrlrmrnrorprqrrrsrtrurvrwrxryrzr{r|r}r~rrrr)r$cCs|j|j|j|jgS)z Get the list of all string types)rvrzrr)r4r%r%r&get_string_typesszFieldType.get_string_typescCs|j|j|j|jgS)z Get the list of all binary types)r|r}r~r)r4r%r%r&get_binary_typesszFieldType.get_binary_typesc Cs0|j|j|j|j|j|j|j|j|j|j |j g S)z Get the list of all number types) rgryrhrirjrkrlrorprwrt)r4r%r%r&get_number_types szFieldType.get_number_typescCs |j|jgS)z#Get the list of all timestamp types)rsrn)r4r%r%r&get_timestamp_typesszFieldType.get_timestamp_typesN)rrg)r rh)rNri)rOrj)rPrk)rQrl)rRrm)rSrn)rro)rTrp)rUrq)rVrr)rWrs)rXrt)rYru)rZrv)r[rw)r\rx)r]ry)r^rz)r_r{)r`r|)rar})rbr~)rcr)rdr)rer)rfr),rBrCrDrErFrGrgrHrhrirjrkrlrmrnrorprqrrrsrtrurvrwrxryrzr{r|r}r~rrrrr1rr rIrrrrrr%r%r%r&rMs   rMc@seZdZUdZdZed1Zed2Zed3Z e d4Z e d5Z e d6Z e d7Z e d8Zed9Zed:Zed;ZedZed?Zed@ZedAZedBZedCZedDZedEZedFZedGZedIdKdMdOdQdSdUdWdYd[d]d_dadcdedgdidkdmdodqdsdud/Zeee eeffd0S)v FieldFlagz_MySQL Field Flags Field flags as found in MySQL sources mysql-src/include/mysql_com.h rr rrNrOrPrQrRrSrrTrUrVrWrXrYrZr[Field can't be NULLField is part of a primary keyField is part of a unique keyField is part of a keyField is a blobField is unsignedField is zerofillField is binary field is an enumfield is a autoincrement fieldField is a timestampfield is a set Field doesn't have default valueField is set to NOW on UPDATEField is num (for clients)Intern; Part of some keyIntern: Group fieldIntern: Used by sql_yaccUsed to get fields in item treeField part of partition funcIntern: Field used in ADD INDEXIntern: Field is being renamed)NOT_NULLPRI_KEY UNIQUE_KEY MULTIPLE_KEYrUNSIGNEDZEROFILLBINARYrzAUTO_INCREMENTrnr{NO_DEFAULT_VALUE ON_UPDATE_NOWNUMPART_KEYGROUPUNIQUEBINCMPGET_FIXED_FIELDSFIELD_IN_PART_FUNCFIELD_IN_ADD_INDEXFIELD_IS_RENAMEDNr rNrPrr[ @iiiii i@ii@iiiiii r )r rrN)rNrrP)rPrr)rrr[)r[rr)rrr)rrr)rrr)rr)rr)rr)rr)rr )rr@)rr)rr@)rr)rr)rr)rr)rr)rr )rr)!rBrCrDrE_prefixrGrrHrrrrrrrrzrrnr{rrrrrrrrrrrr1rr r%r%r%r&r$s` rcs(eZdZdZeedfdd ZZS) ServerCmdMetazClientFlag Metaclass.)r(r$cs.d }||kr"tjd|dtdtj|S) N FIELD_LISTREFRESHSHUTDOWN PROCESS_INFO PROCESS_KILLzThe option 'ServerCmd.z8' is deprecated and will be removed in a future release.)r+)rrrrr)r,r-r.super__getattribute__)r4r(Zdeprecated_options) __class__r%r&rds zServerCmdMeta.__getattribute__)rBrCrDrErGrr __classcell__r%r%)rr&rasrc!@steZdZUdZdZedZedZedZ e dZ e dZ e dZ e d Z e d Zed Zed Zed ZedZedZedZedZedZedZedZedZedZedZedZedZedZedZedZ e dZ!e!dZ"e"dZ#e#d Z$e$d!Z%e%d"Z&e&dEdFdGdHdIdJdKdLdMdNdOdPdQdRdSdTdUdVdWdXdYdZd[d\d]d^d_d`dadbdcdddC Z'e(ee)eeff'dDS)e ServerCmdzMySQL Server CommandsZCOM_rr rNrOrPrQrRrSrrTrUrVrWrXrYrZr[rrrrrSLEEPQUITINIT_DBQUERYr CREATE_DBDROP_DBrr STATISTICSrCONNECTrDEBUGPINGrrDELAYED_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) rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrN)rr)r r)rNr)rOr)rPr)rQr)rRr)rSr)rr)rTr)rUr)rVr)rWr)rXr)rYr)rZrr)r[r)rr)rr)rr)rr)rr)rr)rr)rr)rr)rr)rr)rr)rr)rr)rr)*rBrCrDrErrGrrHrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr1rr r%r%r%r&rus r) metaclassc@seZdZUdZd?Zed@ZedAZedBZedCZ e dDZ e dEZ e dFZ e dGZ e dHZedIZedJZedKZedLZedMZedNZedOZedPZedQZedRZedSZedTZedUZedVZedWZedXZedYZedZZ e d[Z!e!d\Z"e"d^d`dbdddfdhdjdldndpdrdtdvdxdzd|d~ddddddddddddd:Z#e$e%e&ee%ff#eeeeeeeeeg Z'e(e'e)ed;dS) ClientFlagzgMySQL Client Flags Client options as found in the MySQL sources mysql-src/include/mysql_com.h r rrNrOrPrQrRrSrrTrUrVrWrXrYrZr[rrrrrrrrrrrrNew more secure passwordsFound instead of affected rowsGet all column flagsOne can specify db on connect!Don't allow database.table.columnCan use compression protocol ODBC clientCan use LOAD DATA LOCALIgnore spaces before ''New 4.1 protocolThis is an interactive clientSwitch to SSL after handshakeIGNORE sigpipesClient knows about transactionsOld flag for 4.1 protocolNew 4.1 authentication!Enable/disable multi-stmt supportEnable/disable multi-resultsMulti-results in PS-protocol%Client supports plugin authentication%Client supports connection attributesAEnable authentication response packet to be larger than 255 bytesADon't close the connection for a connection with expired password3Capable of handling server state change information!Client no longer needs EOF packet/Support optional extension for query parametersr) LONG_PASSWD FOUND_ROWS LONG_FLAGCONNECT_WITH_DB NO_SCHEMACOMPRESSODBC LOCAL_FILES IGNORE_SPACE PROTOCOL_41 INTERACTIVESSLIGNORE_SIGPIPE TRANSACTIONSRESERVEDSECURE_CONNECTIONMULTI_STATEMENTS MULTI_RESULTSPS_MULTI_RESULTS PLUGIN_AUTH CONNECT_ARGSPLUGIN_AUTH_LENENC_CLIENT_DATACAN_HANDLE_EXPIRED_PASSWORDS SESION_TRACK SESSION_TRACK DEPRECATE_EOFCLIENT_QUERY_ATTRIBUTESSSL_VERIFY_SERVER_CERTREMEMBER_OPTIONS)r$cCs d}x|jD] }||O}q W|S)zbGet the default client options set Returns a flag with all the default client options setr)default)r4r#optionr%r%r& get_defaults  zClientFlag.get_defaultNr rNrPrr[rrrriiiii i@iiiiiii i@iiiii@lir )r rrN)rNrrP)rPrr)rrr[)r[rr)rrr)rrr)rrr)rr)r4r)r5r)r6r)r7r )r8r@)r9r)r:r )r;r )r<r )r=r )r>r )r?r )r@r@)rAr)rBr)rCr)rDr)rEr@)rFr)rGr)+rBrCrDrErrHrrrrrrrrrrrr r!r"r#r$r%r&r'r(r)r*r+r,r-r.r/r0ZMULTI_FACTOR_AUTHENTICATIONr1rrGr r1rrIr3r%r%r%r&rs rc@seZdZUdZdZed"Zed#Zed$Z e d%Z e d&Z e d'Z e d(Z e d)Zed*Zed+Zed,Zed-Zed.Zed/Zed1d3d5d7d9d;d=d?dAdBdCdDdEdGd Zeeeeeffd!S)H ServerFlagzeMySQL Server Flags Server flags as found in the MySQL sources mysql-src/include/mysql_com.h ZSERVER_r rrOrPrQrRrSrrTrUrVrWrXrYTransaction has startedServer in auto_commit modeMulti query - next query existsrESet when server opened a read-only non-scrollable cursor for a query.(Set when a read-only cursor is exhaustedA database was droppedSet if after a prepared statement reprepare we discovered that the new statement returns a different number of result set columns.5To mark ResultSet containing output parameter values. >Set if multi-statement transaction is a read-only transaction.VSession state has changed on the server because of the execution of the last statement)ZSERVER_STATUS_IN_TRANSZSERVER_STATUS_AUTOCOMMITZSERVER_MORE_RESULTS_EXISTSZSERVER_QUERY_NO_GOOD_INDEX_USEDZSERVER_QUERY_NO_INDEX_USEDZSERVER_STATUS_CURSOR_EXISTSZSERVER_STATUS_LAST_ROW_SENTZSERVER_STATUS_DB_DROPPEDZ"SERVER_STATUS_NO_BACKSLASH_ESCAPESSERVER_STATUS_METADATA_CHANGEDSERVER_QUERY_WAS_SLOWSERVER_PS_OUT_PARAMSSERVER_STATUS_IN_TRANS_READONLYSERVER_SESSION_STATE_CHANGEDNr rNrr[rrrriiiii i@r )r rIrN)rNrJr)rrKr[)r[rr)rrr)rrLr)rrMr)rrN)r\r)rOrP)rQr)rRrS)rTrU@)r]rV)rBrCrDrErrGZSTATUS_IN_TRANSrHZSTATUS_AUTOCOMMITZMORE_RESULTS_EXISTSZQUERY_NO_GOOD_INDEX_USEDZQUERY_NO_INDEX_USEDZSTATUS_CURSOR_EXISTSZSTATUS_LAST_ROW_SENTZSTATUS_DB_DROPPEDZSTATUS_NO_BACKSLASH_ESCAPESrWrXrYrZr[r1rr r%r%r%r&rH)sJ rHc@s"eZdZdZeedddZdS)RefreshOptionMetazRefreshOption Metaclass.)r$cCstddtjS)zzReturn the deprecated alias of RefreshOption.REPLICA. Raises a warning about this attribute deprecation. zRefreshOption.SLAVEzRefreshOption.REPLICA)r/ RefreshOptionREPLICA)selfr%r%r&SLAVEnszRefreshOptionMeta.SLAVEN)rBrCrDrEpropertyrHrbr%r%r%r&r^ksr^c @s|eZdZUdZdZedZedZedZ e dZ e dZ e dZ e dZ e ddd d"d$d&d(d*dZeeeeeffdS)+r_zbMySQL Refresh command options. Options used when sending the COM_REFRESH server command. ZREFRESH_r rrNrOrPrQrRRefresh grant tablesStart on new log fileclose all tablesFlush host cacheFlush status variablesFlush thread cache,Reset source info and restart replica thread'Deprecated option; use REPLICA instead.)GRANTLOGTABLESHOSTSTATUSTHREADSr`rbNr rNrPrr[rrr )r rdrN)rNrerP)rPrfr)rrgr[)r[rhr)rrir)rrjr)rrk)rBrCrDrErrGrlrHrmrnrorprqr`r1rr r%r%r%r&r_{s" r_c @seZdZUdZdZedZedZedZ e dZ e dZ e dZ e d Z e d Zeed fed fe d fe dfe dfe dfe dfedfdZeeeeeffdS) ShutdownTypezVMySQL Shutdown types Shutdown types used by the COM_SHUTDOWN server command. rrr rNrr[rrerfz%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))SHUTDOWN_DEFAULTSHUTDOWN_WAIT_CONNECTIONSSHUTDOWN_WAIT_TRANSACTIONSSHUTDOWN_WAIT_UPDATESSHUTDOWN_WAIT_ALL_BUFFERSSHUTDOWN_WAIT_CRITICAL_BUFFERS KILL_QUERYKILL_CONNECTIONN)rBrCrDrErrGrsrHrtrurvrwrxryrzr1rr r%r%r%r&rrs0 rrc@s eZdZUdZeZeeee e e fdZ ee df dZ ee df eee dfd d d dZee ee e fdddZee e dddZeee e fee e e fdddZed eee e fee ee e e fdddZeee dfdddZd S)! 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. rQrS.r rXrTWXN)versionr$cCs"|dd|_|jdkrt|_dS)zSet the MySQL major version and change the charset mapping if is 5.7. Args: version (tuple): MySQL version tuple. NrNrr)rr) mysql_versionr r1)r4rr%r%r&set_mysql_versions zCharacterSet.set_mysql_version)r6r$c Cs>y|j|ddStk r8td|ddYnXdS)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. rrNzCharacter set 'z ' unsupportedN)r1r2r)r4r6r%r%r&r9s zCharacterSet.get_info)r(r$cCs|j|\}}|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. /)r9)r4r(rrr%r%r&r5s zCharacterSet.get_desc)rr$cCst|tr`y|j|}|d|d|fSttfk r^}ztd|d|WYdd}~XnXxJt|jD]<\}}|dkr~ql|d|krl|ddkrl|d|d|fSqlWtd|ddS) 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 'z ' unsupportedNrNTzCharacter set ') isinstancerHr1r2r3r enumerate)r4rr8r@cidr%r%r&get_default_collations   z"CharacterSet.get_default_collation)rrr$cCs|d}t|tr`y|j|}||d|dfStk r^}ztd|d|WYdd}~XnX|d krv|jdkrvd }|dk r|dkr|j|}|d |d|dfS|dko|dk rx>t|jD]0\}}|dkrq||dkr||d|dfSqWtd |d xTt|jD]F\}}|dkr*q|d|kr|d|kr||d|dfSqW|j|}td |d dS)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 unknownutf8utf-8rrrNz Collation 'z ' unknown)rr)rr)rrHr1r2rrrr)r4rrr8r@r_r%r%r&get_charset_infos4  $    zCharacterSet.get_charset_info)r$cCs:g}x,|jD]"}|r |d|kr |j|dq Wt|S)z^Retrieves a list with names of all supproted character sets Returns a tuple. r)r1rKtuple)r4r?r8r%r%r& get_supportedGs  zCharacterSet.get_supported)rQrS)r rXrr|r}r~)NN)rBrCrDrErr1rrr rGboolrrHZslash_charsetsrIrr9r5r rrrr%r%r%r&r{s"   $,r{c@sdeZdZUdZdZedZedZedZedZ e dZ e dZ e d Z e d Z e d Zed Zed ZedZedZedZedZedZedZedZedZedZedZedZedZedZedZedZedZ e dZ!e!dZ"e"d Z#e#d!Z$e$d"Z%e%e&ee'ed#d$d%Z(e&e)e'ed&d'd(Z*e&e+ed)fd*d+d,Z,d-S).SQLModezMySQL 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. See http://dev.mysql.com/doc/refman/5.6/en/server-sql-mode.html ZMODE_ 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_LENGTH)r(r$cCstdS)N)NotImplementedError)r4r(r%r%r&r5szSQLMode.get_desc)r6r$cCstdS)N)r)r4r6r%r%r&r9szSQLMode.get_info.)r$cCsNg}xs.( " "n=IkB.E