관리-도구
편집 파일: constants.cpython-38.pyc
U )�e�\ � " @ sJ d Z ddlmZ ddlmZ dZdZdZdddd d dd d ddd ddd d ddd d d dddd dddddd dd d d�!ZdZ dddddddddddg Z d d � Z G d d � d e �Z G d d!� d!e �ZG d"d#� d#e �ZG d$d%� d%e�ZG d&d'� d'e �ZG d(d)� d)e�ZG d*d+� d+e�ZG d,d-� d-e �ZG d.d/� d/e �ZG d0d1� d1e �ZG d2d3� d3e �ZdS )4z+Various MySQL constants and character sets � )�ProgrammingError)�MYSQL_CHARACTER_SETSi��� � � N� z 127.0.0.1i� T�utf8F� )!Zdatabase�user�password�host�portZ unix_socketZ use_unicode�charset� collationZconverter_classZ autocommitZ time_zoneZsql_modeZ get_warningsZraise_on_warningsZconnection_timeoutZ client_flags�compress�buffered�rawZssl_caZssl_certZssl_keyZssl_verify_certZ ssl_cipher�passwd�db�connect_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_userc C s || @ dkrdS dS )z.Checks if the flag is set Returns booleanr TF� )�flag�flagsr r �n/opt/hc_python/lib64/python3.8/site-packages/../../../lib/python3.8/site-packages/mysql/connector/constants.py� flag_is_setM s r c @ sD e Zd ZdZdZi Zdd� Zedd� �Zedd� �Z ed d � �Z d S ) � _Constantsz" Base class for constants r c C s t d| j ��d S )NzCan not instanciate from %s)� TypeError�__name__��clsr r r �__new__] s z_Constants.__new__c C s$ z| j | d W S Y dS X dS )z!Get description of given constantr N)�desc�r �namer r r �get_desc` s z_Constants.get_descc C s, | j �� D ] \}}|d |kr | S q dS )z$Get information about given constantr N)r �items)r �numr" �infor r r �get_infoh s z_Constants.get_infoc C sL d}zdd� | j �� D �}W n* tk rF } z d| }W 5 d}~X Y nX |S )z)get full information about given constantr c S s g | ]\}}d ||d f �qS )z%s : %sr r )�.0�k�vr r r � <listcomp>u s z,_Constants.get_full_info.<locals>.<listcomp>z)No information found in constant class.%sN)r r$ � Exception)r �res�errr r r � get_full_infop s z_Constants.get_full_infoN) r � __module__� __qualname__�__doc__�prefixr r � classmethodr# r' r/ r r r r r V s r c @ s e Zd ZdZedd� �ZdS )�_Flagsz,Base class for classes describing flags c C s2 g }| j �� D ] \}}||d @ r|�|� q|S )z@Get the name of all bits set Returns a list of strings.r )r r$ �append)r �valuer- r" r& r r r � get_bit_info� s z_Flags.get_bit_infoN)r r0 r1 r2 r4 r8 r r r r r5 | s r5 c @ s� e Zd ZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdZ dZ d Z d Z d d d d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9�Z e!d:d;� �Z"e!d<d=� �Z#e!d>d?� �Z$e!d@dA� �Z%dBS )C� FieldTypezMySQL Field Types Z FIELD_TYPE_r r � � � � � � � � � � � � � � � � � � � � � � � � � )r �DECIMAL)r �TINY)r: �SHORT)r; �LONG)r< �FLOAT)r= �DOUBLE)r> �NULL)r? � TIMESTAMP)r@ �LONGLONG)rA �INT24)rB �DATE)rC �TIME)rD �DATETIME)rE �YEAR)rF �NEWDATE)rG �VARCHAR)rH �BIT)rI � NEWDECIMAL)rJ �ENUM)rK �SET)rL � TINY_BLOB)rM � MEDIUM_BLOB)rN � LONG_BLOB)rO �BLOB)rP � VAR_STRING)rQ �STRING)rR �GEOMETRY)rS rT rU rV rW rX rY rZ r[ r\ r] r^ r_ r` ra rb rc rd re rf rg rh ri rj rk rl rm c C s | j | j| j| jgS )z Get the list of all string types)rb re rk rl r r r r �get_string_types� s �zFieldType.get_string_typesc C s | j | j| j| jgS )z Get the list of all binary types)rg rh ri rj r r r r �get_binary_types� s �zFieldType.get_binary_typesc C s0 | j | j| j| j| j| j| j| j| j| j | j g S )z Get the list of all number types) rS rd rT rU rV rW rX r[ r\ rc r` r r r r �get_number_types� s �zFieldType.get_number_typesc C s | j | jgS )z#Get the list of all timestamp types)r_ rZ r r r r �get_timestamp_types� s �z FieldType.get_timestamp_typesN)&r r0 r1 r2 r3 rS rT rU rV rW rX rY rZ r[ r\ r] r^ r_ r` ra rb rc rd re rf rg rh ri rj rk rl rm r r4 rn ro rp rq r r r r r9 � s� � r9 c @ s� e Zd ZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdddd d d d d d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0�Z d1S )2� FieldFlagz_MySQL Field Flags Field flags as found in MySQL sources mysql-src/include/mysql_com.h r r r: r< r@ rH � �@ � � � � � r r � @ � � � � � � � � )r zField can't be NULL)r: z Field is part of a primary key)r< z Field is part of a unique key)r@ zField is part of a key)rH zField is a blob)rs zField is unsigned)rt zField is zerofill)ru zField is binary )rv zfield is an enum)rw z field is a autoincrement field)rx zField is a timestamp)ry zfield is a set)r z Field doesn't have default value)r z Field is set to NOW on UPDATE)rz zField is num (for clients))r{ zIntern; Part of some key)rz zIntern: Group field)r| �Intern: Used by sql_yacc)r} r� )r~ z Used to get fields in item tree)r z Field part of partition func)r� z Intern: Field used in ADD INDEX)r� z Intern: Field is being renamed)�NOT_NULL�PRI_KEY� UNIQUE_KEY� MULTIPLE_KEYrj �UNSIGNED�ZEROFILL�BINARYre �AUTO_INCREMENTrZ rf �NO_DEFAULT_VALUE� ON_UPDATE_NOW�NUM�PART_KEY�GROUP�UNIQUE�BINCMP�GET_FIXED_FIELDS�FIELD_IN_PART_FUNC�FIELD_IN_ADD_INDEX�FIELD_IS_RENAMEDN) r r0 r1 r2 �_prefixr� r� r� r� rj r� r� r� re r� rZ rf r� r� r� r� r� r� r� r� r� r� r� r r r r r rr � sb �rr c ! @ s� e Zd ZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Z!d Z"d!Z#d"Z$d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;d<d=d>d?d@dAdBdC� Z%dDS )E� ServerCmdzMySQL Server Commands ZCOM_r r r: r; r< r= r> r? r@ rA rB rC rD rE rF rG rH � � � � � � � � � � � � � � � )r �SLEEP)r �QUIT)r: �INIT_DB)r; �QUERY)r< � FIELD_LIST)r= � CREATE_DB)r> �DROP_DB)r? �REFRESH)r@ �SHUTDOWN)rA � STATISTICS)rB � PROCESS_INFO)rC �CONNECT)rD � PROCESS_KILL)rE �DEBUG)rF �PING)rG r^ )rH �DELAYED_INSERT)r� � CHANGE_USER)r� � BINLOG_DUMP)r� � TABLE_DUMP)r� � CONNECT_OUT)r� �REGISTER_SLAVE)r� � STMT_PREPARE)r� � STMT_EXECUTE)r� �STMT_SEND_LONG_DATA)r� � STMT_CLOSE)r� � STMT_RESET)r� � SET_OPTION)r� � STMT_FETCH)r� �DAEMON)r� �BINLOG_DUMP_GTID)r� �RESET_CONNECTION) r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r^ r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� N)&r r0 r1 r2 r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r^ r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r r r r r r� , s� �r� c @ s� e Zd ZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdZ dZ d Z d d d d d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8�Z eeee 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 r r: r< r@ rH rs rt ru rv rw rx ry r r rz r{ r| r} r~ r r� r� � @ � � � � @� )r zNew more secure passwords)r: z Found instead of affected rows)r< zGet all column flags)r@ z One can specify db on connect)rH z!Don't allow database.table.column)rs z Can use compression protocol)rt z ODBC client)ru zCan use LOAD DATA LOCAL)rv zIgnore spaces before '')rw zNew 4.1 protocol)rx z This is an interactive client)ry z Switch to SSL after handshake)r zIGNORE sigpipes)r z Client knows about transactions)rz zOld flag for 4.1 protocol)r{ zNew 4.1 authentication)r| z!Enable/disable multi-stmt support)r} z Enable/disable multi-results)r~ z Multi-results in PS-protocol)r z%Client supports plugin authentication)r� z%Client supports connection attributes)r� zAEnable authentication response packet to be larger than 255 bytes)r� zADon't close the connection for a connection with expired password)r� z3Capable of handling server state change information)r� z!Client no longer needs EOF packet)r� r )r� r )� LONG_PASSWD� FOUND_ROWS� LONG_FLAG�CONNECT_WITH_DB� NO_SCHEMA�COMPRESS�ODBC� LOCAL_FILES� IGNORE_SPACE� PROTOCOL_41� INTERACTIVE�SSL�IGNORE_SIGPIPE� TRANSACTIONS�RESERVED�SECURE_CONNECTION�MULTI_STATEMENTS� MULTI_RESULTS�PS_MULTI_RESULTS� PLUGIN_AUTH� CONNECT_ARGS� PLUGIN_AUTH_LENENC_CLIENT_DATA� CAN_HANDLE_EXPIRED_PASSWORDS� SESION_TRACK� DEPRECATE_EOF�SSL_VERIFY_SERVER_CERT�REMEMBER_OPTIONSc C s d}| j D ] }||O }q |S )zbGet the default client options set Returns a flag with all the default client options setr )�default)r r �optionr r r � get_default� s zClientFlag.get_defaultN)#r r0 r1 r2 r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r r� r4 r� r r r r r� u s� � � r� c @ sP e Zd ZdZdZdZdZdZdZdZ 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_r r: r@ rH rs rt ru rv rw )r zTransaction has started)r: zServer in auto_commit mode)r@ z Multi query - next query exists)rH r )rs r )rt r )ru r )rv zA database was dropped)rw r ) ZSERVER_STATUS_IN_TRANSZSERVER_STATUS_AUTOCOMMITZSERVER_MORE_RESULTS_EXISTSZ SERVER_QUERY_NO_GOOD_INDEX_USEDZSERVER_QUERY_NO_INDEX_USEDZSERVER_STATUS_CURSOR_EXISTSZSERVER_STATUS_LAST_ROW_SENTZSERVER_STATUS_DB_DROPPEDZ"SERVER_STATUS_NO_BACKSLASH_ESCAPESN)r r0 r1 r2 r� ZSTATUS_IN_TRANSZSTATUS_AUTOCOMMITZMORE_RESULTS_EXISTSZQUERY_NO_GOOD_INDEX_USEDZQUERY_NO_INDEX_USEDZSTATUS_CURSOR_EXISTSZSTATUS_LAST_ROW_SENTZSTATUS_DB_DROPPEDZSTATUS_NO_BACKSLASH_ESCAPESr r r r r r� � s* �r� c @ sD e Zd ZdZdZdZdZdZdZdZ dZ d Z d d d d dddd�Z dS )� RefreshOptionzaMySQL Refresh command options Options used when sending the COM_REFRESH server command. ZREFRESH_r r: r< r@ rH rs rt )r zRefresh grant tables)r: zStart on new log file)r< zclose all tables)r@ zFlush host cache)rH zFlush status variables)rs zFlush thread cache)rt z*Reset master info and restart slave thread)�GRANT�LOG�TABLESZHOSTS�STATUS�THREADS�SLAVEN) r r0 r1 r2 r� r� r� r� ZHOSTr� r� r� r r r r r r� � s" �r� c @ sj e Zd ZdZdZdZdZdZdZdZ dZ d Z d Z ed fed fed fedfe dfe dfe dfe dfd�Z dS )� ShutdownTypezVMySQL Shutdown types Shutdown types used by the COM_SHUTDOWN server command. r r r r: r@ rH r� rQ rR z%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_DEFAULT�SHUTDOWN_WAIT_CONNECTIONS�SHUTDOWN_WAIT_TRANSACTIONS�SHUTDOWN_WAIT_UPDATES�SHUTDOWN_WAIT_ALL_BUFFERS� SHUTDOWN_WAIT_CRITICAL_BUFFERS� KILL_QUERY�KILL_CONNECTIONN)r r0 r1 r2 r� r� r� r� r� r� r� r� r� r r r r r r� sF ���������r� c @ sV e Zd ZdZeZdZedd� �Zedd� �Z edd� �Z edd d ��Z ed d � �Z d S )� CharacterSetaL MySQL 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 rE r� �T �W �X c C s< z| j | dd� W S tk r6 td�|���Y nX dS )a Retrieves 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. r r: z Character set '{0}' unsupportedN)r � IndexErrorr �format�r Zsetidr r r r' A s �zCharacterSet.get_infoc C s$ zd| � |� W S � Y nX dS )z�Retrieves 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' r r r r r# R s zCharacterSet.get_descc C s� t |t�rBz | j| }|d |d |fW S td| � Y nX t| j�D ]@\}}|dkr^qL|d |krL|d dkrL|d |d |f S qLtd| ��dS )z�Retrieves the default collation for given character set Raises ProgrammingError when character set is not supported. Returns list (collation, charset, index) r r z"Character set ID '%s' unsupported.Nr: Tz Character set '%s' unsupported.)� isinstance�intr r � enumerate)r r r& �cidr r r �get_default_collation` s � z"CharacterSet.get_default_collationNc C s: t |t�rLz | j| }||d |d fW S tk rJ td�|�� Y nX |dk r||dkr|| �|�}|d |d |d fS |dkr�|dk r�t| j�D ]4\}}|dkr�q�||d kr�||d |d f S q�td�|���nZt| j�D ]@\}}|dkr�q�|d |kr�|d |kr�||d |d f S q�td�|���dS )aE Get 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) r r z Character set ID {0} unknown.Nr: zCollation '{0}' unknown.z Character set '{0}' unknown.)r r r r� r r r r )r r r r& r r r r �get_charset_infox s4 � �z CharacterSet.get_charset_infoc C s6 g }| j D ]"}|r |d |kr |�|d � q t|�S )z^Retrieves a list with names of all supproted character sets Returns a tuple. r )r r6 �tuple)r r- r& r r r � get_supported� s zCharacterSet.get_supported)NN) r r0 r1 r2 r r Zslash_charsetsr4 r' r# r r r r r r r r� 2 s +r� c @ s� e Zd ZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Z!d Z"d!Z#d"Z$e%d#d$� �Z&e%d%d&� �Z'e%d'd(� �Z(d)S )*�SQLModez�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. See http://dev.mysql.com/doc/refman/5.6/en/server-sql-mode.html ZMODE_� REAL_AS_FLOAT�PIPES_AS_CONCAT� ANSI_QUOTESr� �NOT_USED�ONLY_FULL_GROUP_BY�NO_UNSIGNED_SUBTRACTION�NO_DIR_IN_CREATE� POSTGRESQL�ORACLE�MSSQL�DB2�MAXDB�NO_KEY_OPTIONS�NO_TABLE_OPTIONS�NO_FIELD_OPTIONS�MYSQL323�MYSQL40�ANSI�NO_AUTO_VALUE_ON_ZERO�NO_BACKSLASH_ESCAPES�STRICT_TRANS_TABLES�STRICT_ALL_TABLES�NO_ZERO_IN_DATE� NO_ZERO_DATE� INVALID_DATES�ERROR_FOR_DIVISION_BY_ZERO� TRADITIONAL�NO_AUTO_CREATE_USER�HIGH_NOT_PRECEDENCE�NO_ENGINE_SUBSTITUTION�PAD_CHAR_TO_FULL_LENGTHc C s t �d S �N��NotImplementedErrorr! r r r r# � s zSQLMode.get_descc C s t �d S r* r+ )r �numberr r r r' � s zSQLMode.get_infoc C sF g }t | ��� D ](}|�d�stt| |�d�s|�|� qtt|��S )z�Returns 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__)�vars�keys� startswith�hasattr�getattrr6 r �sorted)r r- �keyr r r r/ � s � zSQLMode.get_full_infoN))r r0 r1 r2 r� r r r r� r r r r r r r r r r r r r r r r r r r r! r" r# r$ r% r& r' r( r) r4 r# r' r/ r r r r r � sP r )r2 �errorsr Zcharsetsr ZMAX_PACKET_LENGTHZNET_BUFFER_LENGTHZMAX_MYSQL_TABLE_COLUMNSZDEFAULT_CONFIGURATIONZ CNX_POOL_ARGSZCNX_FABRIC_ARGSr �objectr r5 r9 rr r� r� r� r� r� r� r r r r r �<module> s| �$ � &c=IW!,