B [\"@sJdZddlmZddlmZdZdZdZdddd d dd d ddd ddd d ddd d d dddd dddddd dd d d!ZdZ dddddddddddg Z ddZ Gddde Z Gd d!d!e ZGd"d#d#e ZGd$d%d%eZGd&d'd'e ZGd(d)d)eZGd*d+d+eZGd,d-d-e ZGd.d/d/e ZGd0d1d1e ZGd2d3d3e ZdS)4z+Various MySQL constants and character sets )ProgrammingError)MYSQL_CHARACTER_SETSii iNz 127.0.0.1i Tutf8F)!ZdatabaseuserpasswordhostportZ unix_socketZ use_unicodecharset collationZconverter_classZ autocommitZ time_zoneZsql_modeZ get_warningsZraise_on_warningsZconnection_timeoutZ client_flagscompressZbufferedrawZssl_caZssl_certZssl_keyZssl_verify_certZ ssl_cipherpasswddbconnect_timeoutZdsnZ force_ipv6Z auth_pluginZallow_local_infileZconsume_results)Z pool_nameZ pool_sizeZpool_reset_sessionZ fabric_hostZfabric_usernameZfabric_passwordZ fabric_portZfabric_connect_attemptsZfabric_connect_delayZfabric_report_errorsZ fabric_ssl_caZfabric_ssl_keyZfabric_ssl_certZ fabric_usercCs||@dkrdSdS)z.Checks if the flag is set Returns booleanrTF)flagflagsrrC:\Users\HIRONO~1\AppData\Local\Temp\pip-install-ioykiiwb\mysql-connector-python-rf\mysql_connector_python_rf-2.2.2.data\purelib\mysql\connector\constants.py flag_is_setMs rc@sDeZdZdZdZiZddZeddZeddZ ed d Z d S) _Constantsz" Base class for constants rcCstd|jdS)NzCan not instanciate from %s) TypeError__name__)clsrrr__new__]sz_Constants.__new__cCsy|j|dSdSdS)z!Get description of given constantrN)desc)rnamerrrget_desc`sz_Constants.get_desccCs,x&|jD]\}}|d|kr |Sq WdS)z$Get information about given constantrN)ritems)rnumrinforrrget_infohs z_Constants.get_infoc CsLd}ydd|jD}Wn*tk rF}z d|}Wdd}~XYnX|S)z)get full information about given constantrcSs g|]\}}d||dfqS)z%s : %srr).0kvrrr usz,_Constants.get_full_info..z)No information found in constant class.%sN)rr Exception)rreserrrrr get_full_infops z_Constants.get_full_infoN) r __module__ __qualname____doc__prefixrr classmethodrr"r*rrrrrVs  rc@seZdZdZeddZdS)_Flagsz,Base class for classes describing flags cCs6g}x,|jD]\}}||d@r||qW|S)z@Get the name of all bits set Returns a list of strings.r)rrappend)rvaluer(rr!rrr get_bit_infos  z_Flags.get_bit_infoN)rr+r,r-r/r3rrrrr0|sr0c@seZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZddd d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9Z e!d:d;Z"e!dd?Z$e!d@dAZ%dBS)C FieldTypezMySQL Field Types Z FIELD_TYPE_rr )rDECIMAL)rTINY)r5SHORT)r6LONG)r7FLOAT)r8DOUBLE)r9NULL)r: TIMESTAMP)r;LONGLONG)r<INT24)r=DATE)r>TIME)r?DATETIME)r@YEAR)rANEWDATE)rBVARCHAR)rCBIT)rD NEWDECIMAL)rEENUM)rFSET)rG TINY_BLOB)rH MEDIUM_BLOB)rI LONG_BLOB)rJBLOB)rK VAR_STRING)rLSTRING)rMGEOMETRY)rNrOrPrQrRrSrTrUrVrWrXrYrZr[r\r]r^r_r`rarbrcrdrerfrgrhcCs|j|j|j|jgS)z Get the list of all string types)r]r`rfrg)rrrrget_string_typesszFieldType.get_string_typescCs|j|j|j|jgS)z Get the list of all binary types)rbrcrdre)rrrrget_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) rNr_rOrPrQrRrSrVrWr^r[)rrrrget_number_typess  zFieldType.get_number_typescCs |j|jgS)z#Get the list of all timestamp types)rZrU)rrrrget_timestamp_typesszFieldType.get_timestamp_typesN)&rr+r,r-r.rNrOrPrQrRrSrTrUrVrWrXrYrZr[r\r]r^r_r`rarbrcrdrerfrgrhrr/rirjrkrlrrrrr4sx  r4c@seZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdddddddd d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0Zd1S)2 FieldFlagz_MySQL Field Flags Field flags as found in MySQL sources mysql-src/include/mysql_com.h rrr5r7r;rC @iiiii i@iiiiiii )rzField can't be NULL)r5zField is part of a primary key)r7zField is part of a unique key)r;zField is part of a key)rCzField is a blob)rnzField is unsigned)rozField is zerofill)rpzField is binary )rqzfield is an enum)izfield is a autoincrement field)izField is a timestamp)izfield is a set)iz Field doesn't have default value)i zField is set to NOW on UPDATE)i@zField is num (for clients))izIntern; Part of some key)i@zIntern: Group field)izIntern: Used by sql_yacc)izIntern: Used by sql_yacc)izUsed to get fields in item tree)izField part of partition func)izIntern: Field used in ADD INDEX)i zIntern: Field is being renamed)NOT_NULLPRI_KEY UNIQUE_KEY MULTIPLE_KEYreUNSIGNEDZEROFILLBINARYr`AUTO_INCREMENTrUraNO_DEFAULT_VALUE ON_UPDATE_NOWNUMPART_KEYGROUPUNIQUEBINCMPGET_FIXED_FIELDSFIELD_IN_PART_FUNCFIELD_IN_ADD_INDEXFIELD_IS_RENAMEDN)rr+r,r-_prefixrrrsrtrurervrwrxr`ryrUrarzr{r|r}r~rrrrrrrrrrrrms`rmc!@seZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZ dZ!d Z"d!Z#d"Z$d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;dd?d@dAdBdC Z%dDS)E ServerCmdzMySQL Server Commands ZCOM_rrr5r6r7r8r9r:r;r<r=r>r?r@rArBrC)rSLEEP)rQUIT)r5INIT_DB)r6QUERY)r7 FIELD_LIST)r8 CREATE_DB)r9DROP_DB)r:REFRESH)r;SHUTDOWN)r< STATISTICS)r= PROCESS_INFO)r>CONNECT)r? PROCESS_KILL)r@DEBUG)rAPING)rBrY)rCDELAYED_INSERT)r CHANGE_USER)r BINLOG_DUMP)r TABLE_DUMP)r CONNECT_OUT)rREGISTER_SLAVE)r STMT_PREPARE)r STMT_EXECUTE)rSTMT_SEND_LONG_DATA)r STMT_CLOSE)r STMT_RESET)r SET_OPTION)r STMT_FETCH)rDAEMON)rBINLOG_DUMP_GTID)rRESET_CONNECTION) rrrrrrrrrrrrrrrrYrrrrrrrrrrrrrrrrN)&rr+r,r-rrrrrrrrrrrrrrrrrYrrrrrrrrrrrrrrrrrrrrrr,src@seZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdddd d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8Zeeee eeeee g Z e!d9d:Z"d;S)< ClientFlagzgMySQL Client Flags Client options as found in the MySQL sources mysql-src/include/mysql_com.h rr5r7r;rCrnrorprqiiiii i@iiiiiii i@iii@l)rzNew more secure passwords)r5zFound instead of affected rows)r7zGet all column flags)r;zOne can specify db on connect)rCz!Don't allow database.table.column)rnzCan use compression protocol)roz ODBC client)rpzCan use LOAD DATA LOCAL)rqzIgnore spaces before '')izNew 4.1 protocol)izThis is an interactive client)izSwitch to SSL after handshake)izIGNORE sigpipes)i zClient knows about transactions)i@zOld flag for 4.1 protocol)izNew 4.1 authentication)iz!Enable/disable multi-stmt support)izEnable/disable multi-results)izMulti-results in PS-protocol)iz%Client supports plugin authentication)iz%Client supports connection attributes)i zAEnable authentication response packet to be larger than 255 bytes)i@zADon't close the connection for a connection with expired password)iz3Capable of handling server state change information)iz!Client no longer needs EOF packet)i@r)lr) 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 DEPRECATE_EOFSSL_VERIFY_SERVER_CERTREMEMBER_OPTIONScCs d}x|jD] }||O}q W|S)zbGet the default client options set Returns a flag with all the default client options setr)default)rroptionrrr get_defaults  zClientFlag.get_defaultN)#rr+r,r-rrrrrrrrrrrrrrrrrrrrrrrrrrrrrr/rrrrrrusrc @sPeZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d d dddddddd ZdS) ServerFlagzeMySQL Server Flags Server flags as found in the MySQL sources mysql-src/include/mysql_com.h ZSERVER_rr5r;rCrnrorprqi)rzTransaction has started)r5zServer in auto_commit mode)r;zMulti query - next query exists)rCr)rnr)ror)rpr)rqzA database was dropped)ir) 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_ESCAPESN)rr+r,r-rZSTATUS_IN_TRANSZSTATUS_AUTOCOMMITZMORE_RESULTS_EXISTSZQUERY_NO_GOOD_INDEX_USEDZQUERY_NO_INDEX_USEDZSTATUS_CURSOR_EXISTSZSTATUS_LAST_ROW_SENTZSTATUS_DB_DROPPEDZSTATUS_NO_BACKSLASH_ESCAPESrrrrrrs(rc@sDeZdZdZdZdZdZdZdZdZ dZ d Z d d d d ddddZ dS) RefreshOptionzaMySQL Refresh command options Options used when sending the COM_REFRESH server command. ZREFRESH_rr5r7r;rCrnro)rzRefresh grant tables)r5zStart on new log file)r7zclose all tables)r;zFlush host cache)rCzFlush status variables)rnzFlush thread cache)roz*Reset master info and restart slave thread)GRANTLOGTABLESZHOSTSSTATUSTHREADSSLAVEN) rr+r,r-rrrrZHOSTrrrrrrrrrs rc @sjeZdZdZdZdZdZdZdZdZ dZ d Z d Z ed fed fed fedfe dfe dfe dfe dfdZ dS) ShutdownTypezVMySQL Shutdown types Shutdown types used by the COM_SHUTDOWN server command. rrrr5r;rCrrLrMz%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)rr+r,r-rrrrrrrrrrrrrrrs4rc@sVeZdZdZeZdZeddZeddZ eddZ edd d Z ed d Z d 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. )rr@rTWXcCs:y|j|ddStk r4td|YnXdS)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. rr5zCharacter set '{0}' unsupportedN)r IndexErrorrformat)rsetidrrrr"As zCharacterSet.get_infocCs"yd||SYnXdS)zRetrieves character set information as string using an ID Retrieves character set and collation information based on the given MySQL ID. Returns a tuple. z%s/%sN)r")rrrrrrRs zCharacterSet.get_desccCst|tr@y|j|}|d|d|fStd|YnXxJt|jD]<\}}|dkr^qL|d|krL|ddkrL|d|d|fSqLWtd|dS)zRetrieves the default collation for given character set Raises ProgrammingError when character set is not supported. Returns list (collation, charset, index) rrz"Character set ID '%s' unsupported.Nr5TzCharacter set '%s' unsupported.) isinstanceintrr enumerate)rr r!cidrrrget_default_collation`s  z"CharacterSet.get_default_collationNcCs8t|trJy|j|}||d|dfStk rHtd|YnX|dk rz|dkrz||}|d|d|dfS|dkr|dk rx>t|jD]0\}}|dkrq||dkr||d|dfSqWtd|nZxJt|jD]<\}}|dkrq|d|kr|d|kr||d|dfSqWtd|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) rrzCharacter set ID {0} unknown.Nr5zCollation '{0}' unknown.zCharacter set '{0}' unknown.)rrrrrrrr)rr r r!rrrrget_charset_infoxs0    zCharacterSet.get_charset_infocCs:g}x,|jD]"}|r |d|kr ||dq Wt|S)z^Retrieves a list with names of all supproted character sets Returns a tuple. r)rr1tuple)rr(r!rrr get_supporteds  zCharacterSet.get_supported)NN) rr+r,r-rrZslash_charsetsr/r"rrrrrrrrr2s     +rc@seZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZ dZ!d Z"d!Z#d"Z$e%d#d$Z&e%d%d&Z'e%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_LENGTHcCstdS)N)NotImplementedError)rrrrrrszSQLMode.get_desccCstdS)N)r)rnumberrrrr"szSQLMode.get_infocCsJg}x8t|D](}|dstt||ds||qWtt|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. ___call__)varskeys startswithhasattrgetattrr1rsorted)rr(keyrrrr*s  zSQLMode.get_full_infoN))rr+r,r-rrrrrrrrrrrrrrrrrrrrrrr r r r r rrrrrrr/rr"r*rrrrrsJ  r)r-errorsrZcharsetsrZMAX_PACKET_LENGTHZNET_BUFFER_LENGTHZMAX_MYSQL_TABLE_COLUMNSZDEFAULT_CONFIGURATIONZ CNX_POOL_ARGSZCNX_FABRIC_ARGSrobjectrr0r4rmrrrrrrrrrrrsp   &c=IW!,