Dh\dZddlmZddlmZdZdZdZiddd d d d d d ddddddddddddddddddddddddddid dd!dd"dd#dd$dd%dd&dd'dd(dd)dd*dd+dd,dd-dd.dd/dZd0Z gd1Z d2Z Gd3d4e Z Gd5d6e ZGd7d8e ZGd9d:eZGd;deZGd?d@eZGdAdBe ZGdCdDe ZGdEdFe ZGdGdHe Zy)Iz+Various MySQL constants and character sets )ProgrammingError)MYSQL_CHARACTER_SETSi databaseNuserpasswordhostz 127.0.0.1porti unix_socket use_unicodeTcharsetutf8 collationconverter_class autocommitF time_zonesql_mode get_warningsraise_on_warningsconnection_timeout client_flagscompressbufferedrawssl_cassl_certssl_keyssl_verify_cert ssl_cipherpasswddbconnect_timeoutdsn force_ipv6 auth_pluginallow_local_infileconsume_results) pool_name pool_sizepool_reset_session) fabric_hostfabric_usernamefabric_password fabric_portfabric_connect_attemptsfabric_connect_delayfabric_report_errors fabric_ssl_cafabric_ssl_keyfabric_ssl_cert fabric_userc||zdkDryy)z.Checks if the flag is set Returns booleanrTF)flagflagss Y/var/www/html/civilisation/venv/lib/python3.12/site-packages/mysql/connector/constants.py flag_is_setr>Ms   cNeZdZdZdZiZdZedZedZ edZ y) _Constantsz" Base class for constants r c2td|jz)NzCan not instanciate from %s) TypeError__name__clss r=__new__z_Constants.__new__]s5 DEEr?c6 |j|dS#YyxYw)z!Get description of given constantrN)descrFnames r=get_descz_Constants.get_desc`s$ 88D>!$ $ sc`|jjD]\}}|d|k(s|cSy)z$Get information about given constantrN)rIitems)rFnumrKinfos r=get_infoz_Constants.get_infohs7((..* JD$Aw#~  r?cd} |jjDcgc]\}}|d|d}}}|Scc}}w#t$r}d|z}Yd}~|Sd}~wwxYw)z)get full information about given constantr:z : rz)No information found in constant class.%sN)rIrN Exception)rFreskverrs r= get_full_infoz_Constants.get_full_infopsh F58XX^^5EFTQ1Q4(FCF G F>DC  Fs%A:AA A AAN) rD __module__ __qualname____doc__prefixrIrG classmethodrLrQrXr:r?r=rArAVsUF DFr?rAc eZdZdZedZy)_Flagsz,Base class for classes describing flags cg}|jjD]\}}||dzs|j|!|S)z@Get the name of all bits set Returns a list of strings.r)rIrNappend)rFvaluerTrKrPs r= get_bit_infoz_Flags.get_bit_infosE ((..* !JD$tAw 4  ! r?N)rDrYrZr[r]rcr:r?r=r_r_|sr?r_c DeZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZiddd d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;dd?d@dAdBdCdDdEdFdGdHdIdJ Z e!dKZ"e!dLZ#e!dMZ$e!dNZ%yO)P FieldTypezMySQL Field Types FIELD_TYPE_rr DECIMAL)rrTINY)rrSHORT)rgrLONG)rhrFLOAT)rirDOUBLE)rjrNULL)rkr TIMESTAMP)rlrLONGLONG)rmrINT24)rnrDATE)rorTIME)rprDATETIME)rqrYEAR)rrrNEWDATE)rsrVARCHAR)rtrBIT)rur)rv NEWDECIMAL)rwENUM)rxSET)ry TINY_BLOB)rz MEDIUM_BLOB)r{ LONG_BLOB)r|BLOB)r} VAR_STRING)r~STRING)rGEOMETRY) rrrrrrrrrrc^|j|j|j|jgS)z Get the list of all string types)rrrrrEs r=get_string_typeszFieldType.get_string_typess) KK HH NNCJJ  r?c^|j|j|j|jgS)z Get the list of all binary types)rrrrrEs r=get_binary_typeszFieldType.get_binary_typess( MM3?? MM388  r?c |j|j|j|j|j|j |j |j|j|j|jg S)z Get the list of all number types) rrrrrrrrrrrrEs r=get_number_typeszFieldType.get_number_typessV KK HHcii IIszz LL#)) GG HH   r?c2|j|jgS)z#Get the list of all timestamp types)rrrEs r=get_timestamp_typeszFieldType.get_timestamp_typess LL#--  r?N)&rDrYrZr[r\rrrrrrrrrrrrrrrrrrrrrrrrrrrrIr]rrrrr:r?r=reres FG D E D E F DIH E D DH DGG CJ D CIKI DJ FH $           "     (  &        &    $  $! " }# $+(,(*"&7 D<          r?receZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZidddddddd d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;dd?d@dAZyB)C FieldFlagz_MySQL Field Flags Field flags as found in MySQL sources mysql-src/include/mysql_com.h r rrgrirmru @rr@ NOT_NULL)rzField can't be NULLPRI_KEY)rgzField is part of a primary key UNIQUE_KEY)rizField is part of a unique key MULTIPLE_KEY)rmzField is part of a keyr)ruzField is a blobUNSIGNED)rzField is unsignedZEROFILL)rzField is zerofillBINARY)rzField is binary r)rzfield is an enumAUTO_INCREMENT)rzfield is a autoincrement fieldr)rzField is a timestampr)rzfield is a setNO_DEFAULT_VALUE)rz Field doesn't have default value ON_UPDATE_NOW)rzField is set to NOW on UPDATENUM)rzField is num (for clients)PART_KEY)rzIntern; Part of some keyGROUP)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)UNIQUEBINCMPGET_FIXED_FIELDSFIELD_IN_PART_FUNCFIELD_IN_ADD_INDEXFIELD_IS_RENAMEDN)rDrYrZr[_prefixrrrrrrrrrrrrrrrrrrrrrrrrIr:r?r=rrsGHGJL DHH F DNI CM CH E F F   3 =  ?  :   +   1   1  /  ,  D  6  *  I  C  6 " 9# $ 1% &87HGJG1 Dr?rc"eZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZ dZ!d Z"d!Z#d"Z$id#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;d<d=d>d?d@dAdBdCdDdEdFdGdHdIdJdKdLdMdNdOdPdQdRdSdTZ%yU)V ServerCmdzMySQL Server Commands COM_rrrgrhrirjrkrlrmrnrorprqrrrsrtruSLEEP)rrQUIT)rrINIT_DB)rgrQUERY)rhr FIELD_LIST)rir CREATE_DB)rjrDROP_DB)rkrREFRESH)rlrSHUTDOWN)rmr STATISTICS)rnr PROCESS_INFO)rorCONNECT)rpr PROCESS_KILL)rqrDEBUG)rrrPING)rsrr)rtrDELAYED_INSERT)rur)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)rrrrrrrrrrrrrrrN)&rDrYrZr[rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrIr:r?r=rr,sG E DG EJIGGHJLGL E D DNKKJKNLLJJJJ F! !  !  >!   !  ' !  % !  >!  >!  O!  '!  ,!  ?!  ,!  !   !   !! " 0#! $+*(*0,,:(((( 44A! Dr?rc &eZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZidddd d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;d<d=d>d?d@dAdBdCdDdEdFdGdHdI Zeeee eeeee g Z e!dJZ"yK)L ClientFlagzgMySQL Client Flags Client options as found in the MySQL sources mysql-src/include/mysql_com.h rrgrirmrurrrrrrrrrrrrrrrrr@@ LONG_PASSWD)rzNew more secure passwords FOUND_ROWS)rgzFound instead of affected rows LONG_FLAG)rizGet all column flagsCONNECT_WITH_DB)rmzOne can specify db on connect NO_SCHEMA)ruz!Don't allow database.table.columnCOMPRESS)rzCan use compression protocolODBC)rz ODBC client LOCAL_FILES)rzCan use LOAD DATA LOCAL IGNORE_SPACE)rzIgnore spaces before '' PROTOCOL_41)rzNew 4.1 protocol INTERACTIVE)rzThis is an interactive clientSSL)rzSwitch to SSL after handshakeIGNORE_SIGPIPE)rzIGNORE sigpipes TRANSACTIONS)rzClient knows about transactionsRESERVED)rzOld flag for 4.1 protocolSECURE_CONNECTION)rzNew 4.1 authenticationMULTI_STATEMENTS)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)rr )rr ) MULTI_RESULTSPS_MULTI_RESULTS PLUGIN_AUTH CONNECT_ARGSPLUGIN_AUTH_LENENC_CLIENT_DATACAN_HANDLE_EXPIRED_PASSWORDS SESION_TRACK DEPRECATE_EOFSSL_VERIFY_SERVER_CERTREMEMBER_OPTIONSc6d}|jD]}||z} |S)zbGet the default client options set Returns a flag with all the default client options setr)default)rFr<options r= get_defaultzClientFlag.get_defaults* kk F VOE  r?N)#rDrYrZr[rrrrrrrrr r r r r rrrrrrrrrrrrrrrIrr]rr:r?r=rrusKJIOIH DKLKK CNLHMKL%,"#* LM$ < @  5  D   B   <   '  :  ;  3  A  9  6  D  :  @! " J# $CEIJ+p(vXG"/)9 D@  Gr?rc PeZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d d dddddddd Zy) ServerFlagzeMySQL Server Flags Server flags as found in the MySQL sources mysql-src/include/mysql_com.h SERVER_rrgrmrurrrrr)rzTransaction has started)rgzServer in auto_commit mode)rmzMulti query - next query exists)rur )rr )rr )rr )rzA database was dropped)rr ) 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_ESCAPESN)rDrYrZr[rSTATUS_IN_TRANSSTATUS_AUTOCOMMITMORE_RESULTS_EXISTSQUERY_NO_GOOD_INDEX_USEDQUERY_NO_INDEX_USEDSTATUS_CURSOR_EXISTSSTATUS_LAST_ROW_SENTSTATUS_DB_DROPPEDSTATUS_NO_BACKSLASH_ESCAPESrIr:r?r=r!r!snGO % !!"(#>%C'<,8&2'3'3$F.: Dr?r!cDeZdZdZdZdZdZdZdZdZ dZ d Z d d d d ddddZ y) RefreshOptionzaMySQL Refresh command options Options used when sending the COM_REFRESH server command. REFRESH_rrgrirmrurr)rzRefresh grant tables)rgzStart on new log file)rizclose all tables)rmzFlush host cache)ruzFlush status variables)rzFlush thread cache)rz*Reset master info and restart slave thread)GRANTLOGTABLESHOSTSSTATUSTHREADSSLAVEN) rDrYrZr[rr8r9r:HOSTr<r=r>rIr:r?r=r6r6sOG E C F D FG E20.-41G Dr?r6c jeZdZdZdZdZdZdZdZdZ dZ d Z d Z ed fed fed fedfe dfe dfe dfe dfdZ y) ShutdownTypezVMySQL Shutdown types Shutdown types used by the COM_SHUTDOWN server command. r rrrgrmrurr~rz%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)rDrYrZr[rrBrCrDrErFrGrHrIrIr:r?r=rArAsG !!" "%'"JO  35 & 5&7 ' /'1 " 1"3 & ;&= + 3+4      / Dr?rAcjeZdZdZeZdZedZedZ edZ ed dZ edZ y) 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. )rrrrTWXcv |j|ddS#t$rtdj|wxYw)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. rrgzCharacter set '{0}' unsupported)rI IndexErrorrformatrFsetids r=rQzCharacterSet.get_infoAsK A88E?1Q' ' A"188?A A As$8c8 d|j|zS#xYw)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/%s)rQrRs r=rLzCharacterSet.get_descRs% S\\%00 0  sct|tr |j|}|d|d|fSt |jD]%\}}| |d|k(s|ddus|d|d|fcStd|z#td|zY]xYw)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.rgTzCharacter set '%s' unsupported.) isinstanceintrIr enumerate)rFrrPcids r=get_default_collationz"CharacterSet.get_default_collation`s gs # xx(AwQ00 #388, -IC|Aw'!d1goAwQ,,  - @GLMM  !E"s A77B NcFt|tr |j|}||d|dfS|!||j |}|d|d|dfS|Q|Ot|jD]\}}| ||dk(s||d|dfcSt dj |t|jD]&\}}| |d|k(s|d|k(s||d|dfcSt dj |#t$rt dj |YwxYw)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.rgzCollation '{0}' unknown.zCharacter set '{0}' unknown.)rVrWrIrPrrQrZrX)rFrrrPrYs r=get_charset_infozCharacterSet.get_charset_infoxsn" gs # xx(a$q'22  9#4,,W5DGT!Wd1g. . _!6&sxx0 3 T<Q'a$q'22  3 ##=#D#DY#OP P&sxx0 3 T<7g%$q'Y*>a$q'22  3 ##A#H#H$ )  !@!G!G" sC::#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)rIratuple)rFrTrPs r= get_supportedzCharacterSet.get_supportedsF HH $DQs* 47# $Szr?)NN) rDrYrZr[rrIslash_charsetsr]rQrLrZr\r_r:r?r=rKrK2s| D-NAA   NN.))V  r?rKceZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZ dZ!d Z"d!Z#d"Z$e%d#Z&e%d$Z'e%d%Z(y&)'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 MODE_ REAL_AS_FLOATPIPES_AS_CONCAT ANSI_QUOTESr NOT_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_LENGTHctNNotImplementedErrorrJs r=rLzSQLMode.get_desc!!r?ctrr)rFnumbers r=rQzSQLMode.get_inforr?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. ___call__)varskeys startswithhasattrgetattrrar^sorted)rFrTkeys r=rXzSQLMode.get_full_infos\9>># C>>#&#GC$5zB 3 VC[!!r?N))rDrYrZr[rrdrerfr rgrhrirjrkrlrmrnrorprqrrrsrtrurvrwrxryrzr{r|r}r~rrrrr]rLrQrXr:r?r=rbrbsG#M'OK!LH-7)J F E C E%N))HG D31/+'O!L#M!=K//57"""" " "r?rb)r[errorsrcharsetsrMAX_PACKET_LENGTHNET_BUFFER_LENGTHMAX_MYSQL_TABLE_COLUMNSDEFAULT_CONFIGURATION CNX_POOL_ARGSCNX_FABRIC_ARGSr>objectrAr_rerrrr!r6rArKrbr:r?r=rsc0%*"" B"" K "  D " 4 "4"v""t"%"""E"" $!""A#"$%"&'"( 5)"* d+",-".t/"0u1"2$3"4 d5"6 $7"8t9": 4;"<%=">4?"@$A"BuC"HA " ##L Z  ` ` F::zF FRTTnBJ2):)X|:|~A"jA"r?