U
    e                     @   s  U d Z ddlZddlmZmZ ddlmZmZmZm	Z	m
Z
mZmZ ddlmZmZ ddlmZ dZeed	< d
Zeed< dZeed< dZeed< ddddddddddddddddddddddddddddddddddddddddddddddddddd2Zeeeeeeef  f ed< dZe
eeef ed< ddgZee ed< ddgZee ed< eeed d!d"Zeeeed#d$d%ZG d&d' d'eZ G d(d) d)e Z!G d*d+ d+e Z"G d,d- d-e!Z#G d.d/ d/e Z$G d0d1 d1e!Z%G d2d3 d3e!Z&G d4d5 d5eZ'G d6d7 d7e e'd8Z(G d9d: d:e Z)G d;d< d<e Z*G d=d> d>e Z+d?d@dAdBdCdDdEdFdGdHg
Z,ee edI< dJdKdLdMdNdOdPdPdQdRdSdTdUdVdWdXdYdZd[d\d]d^d_d`dadbdcdddedfdgdhdidjdkdldmdndodpdqdrdsdtdudvdw.Z-eeef edx< e-Z.eeef edy< dzd{d|d}d~ddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddZ/eeef ed< ddd dddZ0eeef ed< e-e.e/e0dZ1eeeeef f ed< e-2 e.2 e/2 e02 dZ3eeee f ed< dS (  z+Various MySQL constants and character sets.    N)ABCABCMeta)DictListOptionalSequenceTupleUnion
ValuesView   )MYSQL_CHARACTER_SETSMYSQL_CHARACTER_SETS_57)ProgrammingErrori MAX_PACKET_LENGTH    NET_BUFFER_LENGTH   MAX_MYSQL_TABLE_COLUMNS   PARAMETER_COUNT_AVAILABLE z	127.0.0.1i  Tutf8mb4F)2ZdatabaseuserpasswordZ	password1Z	password2Z	password3hostportZunix_socketZuse_unicodecharset	collationZconverter_classZconverter_str_fallbackZ
autocommitZ	time_zoneZsql_modeZget_warningsZraise_on_warningsZconnection_timeoutZclient_flagscompressbufferedrawZssl_caZssl_certZssl_keyZssl_verify_certZssl_verify_identityZ
ssl_cipherZtls_ciphersuitesZssl_disabledZtls_versionspasswddbconnect_timeoutZdsnZ
force_ipv6Zauth_pluginZallow_local_infileZallow_local_infile_in_pathZconsume_resultsZ
conn_attrsZdns_srvZuse_pureZkrb_service_principalZoci_config_fileZfido_callbackZkerberos_auth_modeZinit_commandDEFAULT_CONFIGURATION)Z	pool_nameZ	pool_sizeZpool_reset_sessionCNX_POOL_ARGSTLSv1.2TLSv1.3TLS_VERSIONSTLSv1TLSv1.1DEPRECATED_TLS_VERSIONS)flagflagsreturnc                 C   s   || @ dkrdS dS )z.Checks if the flag is set

    Returns booleanr   TF )r,   r-   r/   r/   Z/var/www/html/assets/scripts/venv/lib/python3.8/site-packages/mysql/connector/constants.pyflag_is_seti   s    r1   )namenew_namevaluer.   c                 C   s    t jd|  d| dtd |S )NzThe option "z" has been deprecated, use "z
" instead.)category)warningswarnDeprecationWarning)r2   r3   r4   r/   r/   r0   _obsolete_optionr   s
    r9   c                   @   s   e Zd ZU dZdZeed< i Zeee	e
ef f ed< eeee dddZee
eee e	eef f dd	d
Zeeeee f dddZdS )
_ConstantszBase class for constants.r   prefixdescr2   r.   c              	   C   s0   z| j | d W S  ttfk
r*   Y dS X dS )z!Get description of given constantr   N)r<   
IndexErrorKeyErrorclsr2   r/   r/   r0   get_desc   s    z_Constants.get_descsetidr.   c                 C   s,   | j  D ]\}}|d |kr
|  S q
dS )z$Get information about given constantr   N)r<   items)rA   rD   r2   infor/   r/   r0   get_info   s    
z_Constants.get_infor.   c              
   C   sR   g }zdd | j  D }W n0 ttfk
rL } zd| }W 5 d}~X Y nX |S )z)get full information about given constantc                 S   s"   g | ]\}}| d |d  qS )z : r   r/   ).0kvr/   r/   r0   
<listcomp>   s     z,_Constants.get_full_info.<locals>.<listcomp>z(No information found in constant class. N)r<   rE   AttributeErrorr>   )rA   reserrr/   r/   r0   get_full_info   s    z_Constants.get_full_infoN)__name__
__module____qualname____doc__r;   str__annotations__r<   r   r   intclassmethodr   rB   r	   rG   r   rP   r/   r/   r/   r0   r:   z   s   
&r:   c                   @   s(   e Zd ZdZeeee dddZdS )_Flagsz'Base class for classes describing flags)r4   r.   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<   rE   append)rA   r4   rN   r2   rF   r/   r/   r0   get_bit_info   s
    z_Flags.get_bit_infoN)	rQ   rR   rS   rT   rX   rW   r   rU   r[   r/   r/   r/   r0   rY      s   rY   c                   @   s  e Zd ZU dZdZeed< dZeed< dZ	eed< dZ
eed	< d
Zeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< d Zeed!< d"Zeed#< d$Zeed%< d&Zeed'< d(Zeed)< d*Zeed+< d,Zeed-< d.Zeed/< d0Zeed1< d2Zeed3< d4Z eed5< d6Z!eed7< d8Z"eed9< d:Z#eed;< d<d=d>d?d@dAdBdCdDdEdFdGdHdIdJdKdLdMdNdOdPdQdRdSdTdUdVdWdXZ$e%ee&eef f edY< e'e(e dZd[d\Z)e'e(e dZd]d^Z*e'e(e dZd_d`Z+e'e(e dZdadbZ,dcS )d	FieldTypezMySQL Field TypesZFIELD_TYPE_r;   r   DECIMALr   TINY   SHORT   LONG   FLOAT   DOUBLE   NULL   	TIMESTAMPr   LONGLONG	   INT24
   DATE   TIME   DATETIME   YEAR   NEWDATE   VARCHAR   BIT   JSON   
NEWDECIMAL   ENUM   SET   	TINY_BLOB   MEDIUM_BLOB   	LONG_BLOB   BLOB   
VAR_STRING   STRING   GEOMETRY)r   r]   )r   r^   )r_   r`   )ra   rb   )rc   rd   )re   rf   )rg   rh   )ri   rj   )r   rk   )rl   rm   )rn   ro   )rp   rq   )rr   rs   )rt   ru   )rv   rw   )rx   ry   )rz   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`   rb   rd   rf   rh   rj   rk   rm   ro   rq   rs   ru   rw   ry   r{   r}   r   r   r   r   r   r   r   r   r   r   r<   rH   c                 C   s   | j | j| j| jgS )z Get the list of all string types)ry   r   r   r   rA   r/   r/   r0   get_string_types   s
    zFieldType.get_string_typesc                 C   s   | j | j| j| jgS )z Get the list of all binary types)r   r   r   r   r   r/   r/   r0   get_binary_types   s
    zFieldType.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)r]   r   r^   r`   rb   rd   rf   rk   rm   r{   ru   r   r/   r/   r0   get_number_types   s    zFieldType.get_number_typesc                 C   s   | j | jgS )z#Get the list of all timestamp types)rs   rj   r   r/   r/   r0   get_timestamp_types  s    zFieldType.get_timestamp_typesN)-rQ   rR   rS   rT   r;   rU   rV   r]   rW   r^   r`   rb   rd   rf   rh   rj   rk   rm   ro   rq   rs   ru   rw   ry   r{   r}   r   r   r   r   r   r   r   r   r   r   r<   r   r   rX   r   r   r   r   r   r/   r/   r/   r0   r\      s   
		r\   c                   @   s~  e Zd ZU dZdZeed< dZeed< dZ	eed< dZ
eed	< d
Zeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< d Zeed!< d"Zeed#< d Zeed$< d%Zeed&< d'Zeed(< d)Zeed*< d+Zeed,< d-Zeed.< d/Zeed0< d1d2d3d4d5d6d7d8d9d:d;d<d=d>d?d@dAdBdCdDdEdFdGdHZe ee!eef f edI< dJS )K	FieldFlagz_MySQL Field Flags

    Field flags as found in MySQL sources mysql-src/include/mysql_com.h
    r   _prefixr   NOT_NULLr_   PRI_KEYrc   
UNIQUE_KEYr   MULTIPLE_KEYrz   r       UNSIGNED@   ZEROFILL   BINARY   r      AUTO_INCREMENT   rj      r   r   NO_DEFAULT_VALUEr   ON_UPDATE_NOW @  NUM   PART_KEYGROUP   UNIQUE   BINCMP   GET_FIXED_FIELDS   FIELD_IN_PART_FUNC   FIELD_IN_ADD_INDEX    FIELD_IS_RENAMED)r   zField can't be NULL)r_   zField is part of a primary key)rc   zField is part of a unique key)r   zField is part of a key)rz   zField is a blob)r   zField is unsigned)r   zField is zerofill)r   zField is binary  )r   zfield is an enum)r   zfield is a autoincrement field)r   zField is a timestamp)r   zfield is a set)r   z Field doesn't have default value)r   zField is set to NOW on UPDATE)r   zField is num (for clients))r   zIntern; Part of some key)r   zIntern: 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)r   r   r   r   r   r   r   r   r   r   rj   r   r   r   r   r   r   r   r   r   r   r   r   r<   N)"rQ   rR   rS   rT   r   rU   rV   r   rW   r   r   r   r   r   r   r   r   r   rj   r   r   r   r   r   r   r   r   r   r   r   r   r<   r   r   r/   r/   r/   r0   r     sb   
r   c                !   @   s  e Zd ZU dZdZeed< dZeed< dZ	eed< dZ
eed	< d
Zeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< d Zeed!< d"Zeed#< d$Zeed%< d&Zeed'< d(Zeed)< d*Zeed+< d,Zeed-< d.Zeed/< d0Zeed1< d2Zeed3< d4Z eed5< d6Z!eed7< d8Z"eed9< d:Z#eed;< d<Z$eed=< d>Z%eed?< d@Z&eedA< dBZ'eedC< dDdEdFdGdHdIdJdKdLdMdNdOdPdQdRdSdTdUdVdWdXdYdZd[d\d]d^d_d`dadbdcdd Z(e)ee*eef f ede< dfS )g	ServerCmdzMySQL Server CommandsZCOM_r   r   SLEEPr   QUITr_   INIT_DBra   QUERYrc   
FIELD_LISTre   	CREATE_DBrg   DROP_DBri   REFRESHr   SHUTDOWNrl   
STATISTICSrn   PROCESS_INFOrp   CONNECTrr   PROCESS_KILLrt   DEBUGrv   PINGrx   rq   rz   DELAYED_INSERT   CHANGE_USER   BINLOG_DUMP   
TABLE_DUMP   CONNECT_OUT   REGISTER_REPLICA   STMT_PREPARE   STMT_EXECUTE   STMT_SEND_LONG_DATA   
STMT_CLOSE   
STMT_RESET   
SET_OPTION   
STMT_FETCH   DAEMON   BINLOG_DUMP_GTID   RESET_CONNECTION)r   r   )r   r   )r_   r   )ra   r   )rc   r   )re   r   )rg   r   )ri   r   )r   r   )rl   r   )rn   r   )rp   r   )rr   r   )rt   r   )rv   r   )rx   rq   )rz   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   r   r   r   r   r   r   r   rq   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r<   N)+rQ   rR   rS   rT   r   rU   rV   r   rW   r   r   r   r   r   r   r   r   r   r   r   r   r   r   rq   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r<   r   r   r/   r/   r/   r0   r   V  s   
r   c                   @   s  e Zd ZU dZdZeed< dZeed< dZeed< dZ	eed	< d
Z
eed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< d Zeed!< d"Zeed#< d$Zeed%< d&Zeed'< d(Zeed)< d*Zeed+< d,Zeed-< d.Zeed/< d0Zeed1< d2Zeed3< d4Zeed5< d6Z eed7< d8Z!eed9< d:Z"eed;< d<d=d>d?d@dAdBdCdDdEdFdGdHdIdJdKdLdMdNdOdPdQdRdSdTdUdVdWdXZ#e$e%e&ee%f f edY< eee	eeeeeeg	Z'e(e edZ< e)ed[d\d]Z*d^S )_
ClientFlagzgMySQL Client Flags

    Client options as found in the MySQL sources mysql-src/include/mysql_com.h
    r   LONG_PASSWDr_   
FOUND_ROWSrc   	LONG_FLAGr   CONNECT_WITH_DBrz   	NO_SCHEMAr   COMPRESSr   ODBCr   LOCAL_FILESr   IGNORE_SPACEr   PROTOCOL_41r   INTERACTIVEr   SSLr   IGNORE_SIGPIPEr   TRANSACTIONSr   RESERVEDr   SECURE_CONNECTIONr   MULTI_STATEMENTSr   MULTI_RESULTSr   PS_MULTI_RESULTSr   PLUGIN_AUTHr   CONNECT_ARGSr   PLUGIN_AUTH_LENENC_CLIENT_DATA  @ CAN_HANDLE_EXPIRED_PASSWORDS   SESION_TRACK   DEPRECATE_EOF   CLIENT_QUERY_ATTRIBUTES   @SSL_VERIFY_SERVER_CERT        REMEMBER_OPTIONSi   MULTI_FACTOR_AUTHENTICATION)r   zNew more secure passwords)r_   zFound instead of affected rows)rc   zGet all column flags)r   zOne can specify db on connect)rz   z!Don't allow database.table.column)r   zCan use compression protocol)r   zODBC client)r   zCan use LOAD DATA LOCAL)r   zIgnore spaces before '')r   zNew 4.1 protocol)r   zThis is an interactive client)r   zSwitch to SSL after handshake)r   zIGNORE sigpipes)r   zClient knows about transactions)r   zOld flag for 4.1 protocol)r   zNew 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  z/Support optional extension for query parameters)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<   defaultrH   c                 C   s   d}| j D ]}||O }q
|S )zbGet the default client options set

        Returns a flag with all the default client options setr   )r  )rA   r-   optionr/   r/   r0   get_default  s    

zClientFlag.get_defaultN)+rQ   rR   rS   rT   r   rW   rV   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   rU   r   r  r   rX   r  r/   r/   r/   r0   r     s   
,r   c                   @   s   e Zd ZU dZdZeed< dZeed< dZ	eed< dZ
eed	< d
Zeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< d d!d"d#d$d%d&d'd(d)d*d+d,d-d.Zeeeeef f ed/< d0S )1
ServerFlagzeMySQL Server Flags

    Server flags as found in the MySQL sources mysql-src/include/mysql_com.h
    ZSERVER_r   r   STATUS_IN_TRANSr_   STATUS_AUTOCOMMITr   MORE_RESULTS_EXISTSrz   QUERY_NO_GOOD_INDEX_USEDr   QUERY_NO_INDEX_USEDr   STATUS_CURSOR_EXISTSr   STATUS_LAST_ROW_SENTr   STATUS_DB_DROPPEDr   STATUS_NO_BACKSLASH_ESCAPESr   SERVER_STATUS_METADATA_CHANGEDr   SERVER_QUERY_WAS_SLOWr   SERVER_PS_OUT_PARAMSr   SERVER_STATUS_IN_TRANS_READONLYr   SERVER_SESSION_STATE_CHANGED)r   zTransaction has started)r_   zServer in auto_commit mode)r   zMulti query - next query exists)rz   r   )r   r   )r   zESet when server opened a read-only non-scrollable cursor for a query.)r   z(Set when a read-only cursor is exhausted)r   zA database was dropped)r   r   )r   zSet if after a prepared statement reprepare we discovered that the new statement returns a different number of result set columns.)r   r   )r   z5To mark ResultSet containing output parameter values.)r   z>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)ZSERVER_STATUS_IN_TRANSZSERVER_STATUS_AUTOCOMMITZSERVER_MORE_RESULTS_EXISTSZSERVER_QUERY_NO_GOOD_INDEX_USEDZSERVER_QUERY_NO_INDEX_USEDZSERVER_STATUS_CURSOR_EXISTSZSERVER_STATUS_LAST_ROW_SENTZSERVER_STATUS_DB_DROPPEDZ"SERVER_STATUS_NO_BACKSLASH_ESCAPESr  r  r  r  r   r<   N)rQ   rR   rS   rT   r   rU   rV   r  rW   r  r  r  r  r  r  r  r  r  r  r  r  r   r<   r   r   r/   r/   r/   r0   r    s>   
r  c                   @   s"   e Zd ZdZeedddZdS )RefreshOptionMetazRefreshOption Metaclass.rH   c                 C   s   t ddtjS )zzReturn the deprecated alias of RefreshOption.REPLICA.

        Raises a warning about this attribute deprecation.
        zRefreshOption.SLAVEzRefreshOption.REPLICA)r9   RefreshOptionREPLICA)selfr/   r/   r0   SLAVEJ  s
    zRefreshOptionMeta.SLAVEN)rQ   rR   rS   rT   propertyrW   r%  r/   r/   r/   r0   r!  G  s   r!  c                	   @   s   e Zd ZU dZdZeed< dZeed< dZ	eed< dZ
eed	< d
Zeed< dZeed< dZeed< dZeed< dddddddddZeeeeef f ed< dS )r"  zbMySQL Refresh command options.

    Options used when sending the COM_REFRESH server command.
    ZREFRESH_r   r   GRANTr_   LOGrc   TABLESr   HOSTrz   STATUSr   THREADSr   r#  )r   zRefresh grant tables)r_   zStart on new log file)rc   zclose all tables)r   zFlush host cache)rz   zFlush status variables)r   zFlush thread cache)r   z,Reset source info and restart replica thread)r   z'Deprecated option; use REPLICA instead.)r'  r(  r)  r*  r+  r,  r#  r%  r<   N)rQ   rR   rS   rT   r   rU   rV   r'  rW   r(  r)  r*  r+  r,  r#  r<   r   r   r/   r/   r/   r0   r"  W  s$   
r"  )	metaclassc                	   @   s   e Zd ZU dZdZeed< dZeed< dZ	eed< dZ
eed	< d
Zeed< dZeed< dZeed< dZeed< dZeed< edfe	dfe
dfedfedfedfedfedfdZeeeeef f ed< dS )ShutdownTypezVMySQL Shutdown types

    Shutdown types used by the COM_SHUTDOWN server command.
    r   r   r   SHUTDOWN_DEFAULTr   SHUTDOWN_WAIT_CONNECTIONSr_   SHUTDOWN_WAIT_TRANSACTIONSr   SHUTDOWN_WAIT_UPDATESrz   SHUTDOWN_WAIT_ALL_BUFFERSr   SHUTDOWN_WAIT_CRITICAL_BUFFERSr   
KILL_QUERYr   KILL_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))r/  r0  r1  r2  r3  r4  r5  r6  r<   N)rQ   rR   rS   rT   r   rU   rV   r/  rW   r0  r1  r2  r3  r4  r5  r6  r<   r   r   r/   r/   r/   r0   r.  r  s>   
r.  c                   @   s  e Zd ZU dZeZeeee	e	e
f   ed< dZeedf ed< dZeedf ed< eeedf dd	d
dZeeee	e	f dddZeee	dddZeeee	f ee	e	ef dddZedeeee	f  ee	 eee	e	f dddZeee	df dd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   ri   .mysql_version)r   rt   r   T   W   X   slash_charsetsN)versionr.   c                 C   s"   |dd | _ | j dkrt| _dS )zSet the MySQL major version and change the charset mapping if is 5.7.

        Args:
            version (tuple): MySQL version tuple.
        Nr_   r   r   )r8  r   r<   )rA   r=  r/   r/   r0   set_mysql_version  s    
zCharacterSet.set_mysql_versionrC   c                 C   s@   z| j | dd W S  tk
r:   td| ddY nX dS )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_   Character set '' unsupportedN)r<   r>   r   rA   rD   r/   r/   r0   rG     s    zCharacterSet.get_infor=   c                 C   s   |  |\}}| 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.
        /)rG   )rA   r2   r   r   r/   r/   r0   rB     s    	zCharacterSet.get_desc)r   r.   c              	   C   s   t |trRz| j| }|d |d |fW S  ttfk
rP   td| d Y nX t| jD ]@\}}|dkrnq\|d |kr\|d dkr\|d |d |f  S q\td| ddS )	zRetrieves 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 'rA  Nr_   Tr@  )
isinstancerW   r<   r>   r?   r   	enumerate)rA   r   rF   cidr/   r/   r0   get_default_collation  s    

z"CharacterSet.get_default_collation)r   r   r.   c                 C   sl  d}t |trRz| j| }||d |d fW S  tk
rP   td| d Y nX |dkrh| jdkrhd}|dk	r|dkr| |}|d	 |d |d fS |dkr|dk	rt| jD ]4\}}|dkrq||d kr||d |d f  S qtd
| dt| jD ]J\}}|dkrq|d |kr|d |kr||d |d f  S q| |}td
| ddS )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)
        Nr   r   zCharacter set ID z unknown)utf8zutf-8r>  r   r_   zCollation 'z	' unknown)rD  rW   r<   r>   r   r8  rG  rE  )rA   r   r   rF   rF  _r/   r/   r0   get_charset_info  s4    




zCharacterSet.get_charset_inforH   c                 C   s6   g }| j D ]"}|r
|d |kr
||d  q
t|S )z^Retrieves a list with names of all supproted character sets

        Returns a tuple.
        r   )r<   rZ   tuple)rA   rN   rF   r/   r/   r0   get_supported!  s
    
zCharacterSet.get_supported)NN)rQ   rR   rS   rT   r   r<   r   r   r   rU   boolrV   r8  rW   r<  rX   r?  rG   rB   r	   rG  rJ  rL  r/   r/   r/   r0   r7    s2   

$    .r7  c                   @   s  e Zd ZU dZdZeed< dZeed< dZeed< dZ	eed< dZ
eed< dZeed< d	Zeed	< d
Zeed
< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZ eed< dZ!eed< dZ"eed< d Z#eed < d!Z$eed!< d"Z%eed"< d#Z&eed#< e'ee(e d$d%d&Z)e'e*e(e d'd(d)Z+e'e,ed*f d+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
    ZMODE_r   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_LENGTHr=   c                 C   s   t d S NNotImplementedErrorr@   r/   r/   r0   rB   Z  s    zSQLMode.get_descrC   c                 C   s   t d S rn  ro  rB  r/   r/   r0   rG   ^  s    zSQLMode.get_info.rH   c                 C   sF   g }t |  D ](}|dstt| |ds|| q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.
        rI  __call__)varskeys
startswithhasattrgetattrrZ   rK  sorted)rA   rN   keyr/   r/   r0   rP   b  s
    	zSQLMode.get_full_infoN).rQ   rR   rS   rT   r   rU   rV   rO  rP  rQ  r   rR  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  rX   r   rB   rW   rG   r   rP   r/   r/   r/   r0   rN  .  sP   
	rN  _pid	_platformZ_source_hostZ_client_nameZ_client_licenseZ_client_version_osZ_connector_nameZ_connector_licenseZ_connector_versionCONN_ATTRS_DNzNULL-MD5zNULL-SHAzRC4-MD5zRC4-SHAzIDEA-CBC-SHAzDES-CBC3-SHAzNot implemented.zDHE-DSS-DES-CBC3-SHAzDHE-RSA-DES-CBC3-SHAzADH-RC4-MD5zADH-DES-CBC3-SHAz
AES128-SHAz
AES256-SHAzDH-DSS-AES128-SHAzDH-DSS-AES256-SHAzDH-RSA-AES128-SHAzDH-RSA-AES256-SHAzDHE-DSS-AES128-SHAzDHE-DSS-AES256-SHAzDHE-RSA-AES128-SHAzDHE-RSA-AES256-SHAzADH-AES128-SHAzADH-AES256-SHAzCAMELLIA128-SHAzCAMELLIA256-SHAzDH-DSS-CAMELLIA128-SHAzDH-DSS-CAMELLIA256-SHAzDH-RSA-CAMELLIA128-SHAzDH-RSA-CAMELLIA256-SHAzDHE-DSS-CAMELLIA128-SHAzDHE-DSS-CAMELLIA256-SHAzDHE-RSA-CAMELLIA128-SHAzDHE-RSA-CAMELLIA256-SHAzADH-CAMELLIA128-SHAzADH-CAMELLIA256-SHAzSEED-SHAzDH-DSS-SEED-SHAzDH-RSA-SEED-SHAzDHE-DSS-SEED-SHAzDHE-RSA-SEED-SHAzADH-SEED-SHAzGOST94-GOST89-GOST89zGOST2001-GOST89-GOST89zGOST94-NULL-GOST94zGOST2001-NULL-GOST94).ZTLS_RSA_WITH_NULL_MD5ZTLS_RSA_WITH_NULL_SHAZTLS_RSA_WITH_RC4_128_MD5ZTLS_RSA_WITH_RC4_128_SHAZTLS_RSA_WITH_IDEA_CBC_SHAZTLS_RSA_WITH_3DES_EDE_CBC_SHAZ TLS_DH_DSS_WITH_3DES_EDE_CBC_SHAZ TLS_DH_RSA_WITH_3DES_EDE_CBC_SHAZ!TLS_DHE_DSS_WITH_3DES_EDE_CBC_SHAZ!TLS_DHE_RSA_WITH_3DES_EDE_CBC_SHAZTLS_DH_anon_WITH_RC4_128_MD5Z!TLS_DH_anon_WITH_3DES_EDE_CBC_SHAZTLS_RSA_WITH_AES_128_CBC_SHAZTLS_RSA_WITH_AES_256_CBC_SHAZTLS_DH_DSS_WITH_AES_128_CBC_SHAZTLS_DH_DSS_WITH_AES_256_CBC_SHAZTLS_DH_RSA_WITH_AES_128_CBC_SHAZTLS_DH_RSA_WITH_AES_256_CBC_SHAZ TLS_DHE_DSS_WITH_AES_128_CBC_SHAZ TLS_DHE_DSS_WITH_AES_256_CBC_SHAZ TLS_DHE_RSA_WITH_AES_128_CBC_SHAZ TLS_DHE_RSA_WITH_AES_256_CBC_SHAZ TLS_DH_anon_WITH_AES_128_CBC_SHAZ TLS_DH_anon_WITH_AES_256_CBC_SHAZ!TLS_RSA_WITH_CAMELLIA_128_CBC_SHAZ!TLS_RSA_WITH_CAMELLIA_256_CBC_SHAZ$TLS_DH_DSS_WITH_CAMELLIA_128_CBC_SHAZ$TLS_DH_DSS_WITH_CAMELLIA_256_CBC_SHAZ$TLS_DH_RSA_WITH_CAMELLIA_128_CBC_SHAZ$TLS_DH_RSA_WITH_CAMELLIA_256_CBC_SHAZ%TLS_DHE_DSS_WITH_CAMELLIA_128_CBC_SHAZ%TLS_DHE_DSS_WITH_CAMELLIA_256_CBC_SHAZ%TLS_DHE_RSA_WITH_CAMELLIA_128_CBC_SHAZ%TLS_DHE_RSA_WITH_CAMELLIA_256_CBC_SHAZ%TLS_DH_anon_WITH_CAMELLIA_128_CBC_SHAZ%TLS_DH_anon_WITH_CAMELLIA_256_CBC_SHAZTLS_RSA_WITH_SEED_CBC_SHAZTLS_DH_DSS_WITH_SEED_CBC_SHAZTLS_DH_RSA_WITH_SEED_CBC_SHAZTLS_DHE_DSS_WITH_SEED_CBC_SHAZTLS_DHE_RSA_WITH_SEED_CBC_SHAZTLS_DH_anon_WITH_SEED_CBC_SHAZ#TLS_GOSTR341094_WITH_28147_CNT_IMITZ#TLS_GOSTR341001_WITH_28147_CNT_IMITZ#TLS_GOSTR341094_WITH_NULL_GOSTR3411Z#TLS_GOSTR341001_WITH_NULL_GOSTR3411TLSV1_CIPHER_SUITESTLSV1_1_CIPHER_SUITESzNULL-SHA256zAES128-SHA256zAES256-SHA256zAES128-GCM-SHA256zAES256-GCM-SHA384zDH-RSA-AES128-SHA256zDH-RSA-AES256-SHA256zDH-RSA-AES128-GCM-SHA256zDH-RSA-AES256-GCM-SHA384zDH-DSS-AES128-SHA256zDH-DSS-AES256-SHA256zDH-DSS-AES128-GCM-SHA256zDH-DSS-AES256-GCM-SHA384zDHE-RSA-AES128-SHA256zDHE-RSA-AES256-SHA256zDHE-RSA-AES128-GCM-SHA256zDHE-RSA-AES256-GCM-SHA384zDHE-DSS-AES128-SHA256zDHE-DSS-AES256-SHA256zDHE-DSS-AES128-GCM-SHA256zDHE-DSS-AES256-GCM-SHA384zECDHE-RSA-AES128-SHA256zECDHE-RSA-AES256-SHA384zECDHE-RSA-AES128-GCM-SHA256zECDHE-RSA-AES256-GCM-SHA384zECDHE-ECDSA-AES128-SHA256zECDHE-ECDSA-AES256-SHA384zECDHE-ECDSA-AES128-GCM-SHA256zECDHE-ECDSA-AES256-GCM-SHA384zADH-AES128-SHA256zADH-AES256-SHA256zADH-AES128-GCM-SHA256zADH-AES256-GCM-SHA384z
AES128-CCMz
AES256-CCMzDHE-RSA-AES128-CCMzDHE-RSA-AES256-CCMzAES128-CCM8zAES256-CCM8zDHE-RSA-AES128-CCM8zDHE-RSA-AES256-CCM8zECDHE-ECDSA-AES128-CCMzECDHE-ECDSA-AES256-CCMzECDHE-ECDSA-AES128-CCM8zECDHE-ECDSA-AES256-CCM8zARIA128-GCM-SHA256zARIA256-GCM-SHA384zDHE-RSA-ARIA128-GCM-SHA256zDHE-RSA-ARIA256-GCM-SHA384zDHE-DSS-ARIA128-GCM-SHA256zDHE-DSS-ARIA256-GCM-SHA384zECDHE-ECDSA-ARIA128-GCM-SHA256zECDHE-ECDSA-ARIA256-GCM-SHA384zECDHE-ARIA128-GCM-SHA256zECDHE-ARIA256-GCM-SHA384zPSK-ARIA128-GCM-SHA256zPSK-ARIA256-GCM-SHA384zDHE-PSK-ARIA128-GCM-SHA256zDHE-PSK-ARIA256-GCM-SHA384zRSA-PSK-ARIA128-GCM-SHA256zRSA-PSK-ARIA256-GCM-SHA384zECDHE-ECDSA-CAMELLIA128-SHA256zECDHE-ECDSA-CAMELLIA256-SHA384zECDHE-RSA-CAMELLIA128-SHA256zECDHE-RSA-CAMELLIA256-SHA384zPSK-NULL-SHAzDHE-PSK-NULL-SHAzRSA-PSK-NULL-SHAzPSK-RC4-SHAzPSK-3DES-EDE-CBC-SHAzPSK-AES128-CBC-SHAzPSK-AES256-CBC-SHAzDHE-PSK-RC4-SHAzDHE-PSK-3DES-EDE-CBC-SHAzDHE-PSK-AES128-CBC-SHAzDHE-PSK-AES256-CBC-SHAzRSA-PSK-RC4-SHAzRSA-PSK-3DES-EDE-CBC-SHAzRSA-PSK-AES128-CBC-SHAzRSA-PSK-AES256-CBC-SHAzPSK-AES128-GCM-SHA256zPSK-AES256-GCM-SHA384zDHE-PSK-AES128-GCM-SHA256zDHE-PSK-AES256-GCM-SHA384zRSA-PSK-AES128-GCM-SHA256zRSA-PSK-AES256-GCM-SHA384zPSK-AES128-CBC-SHA256zPSK-AES256-CBC-SHA384zPSK-NULL-SHA256zPSK-NULL-SHA384zDHE-PSK-AES128-CBC-SHA256zDHE-PSK-AES256-CBC-SHA384zDHE-PSK-NULL-SHA256zDHE-PSK-NULL-SHA384zRSA-PSK-AES128-CBC-SHA256zRSA-PSK-AES256-CBC-SHA384zRSA-PSK-NULL-SHA256zRSA-PSK-NULL-SHA384zECDHE-PSK-RC4-SHAzECDHE-PSK-3DES-EDE-CBC-SHAzECDHE-PSK-AES128-CBC-SHAzECDHE-PSK-AES256-CBC-SHAzECDHE-PSK-AES128-CBC-SHA256zECDHE-PSK-AES256-CBC-SHA384zECDHE-PSK-NULL-SHAzECDHE-PSK-NULL-SHA256zECDHE-PSK-NULL-SHA384zPSK-CAMELLIA128-SHA256zPSK-CAMELLIA256-SHA384zDHE-PSK-CAMELLIA128-SHA256zDHE-PSK-CAMELLIA256-SHA384zRSA-PSK-CAMELLIA128-SHA256zRSA-PSK-CAMELLIA256-SHA384zECDHE-PSK-CAMELLIA128-SHA256zECDHE-PSK-CAMELLIA256-SHA384zPSK-AES128-CCMzPSK-AES256-CCMzDHE-PSK-AES128-CCMzDHE-PSK-AES256-CCMzPSK-AES128-CCM8zPSK-AES256-CCM8zDHE-PSK-AES128-CCM8zDHE-PSK-AES256-CCM8zECDHE-RSA-CHACHA20-POLY1305zECDHE-ECDSA-CHACHA20-POLY1305zDHE-RSA-CHACHA20-POLY1305zPSK-CHACHA20-POLY1305zECDHE-PSK-CHACHA20-POLY1305zDHE-PSK-CHACHA20-POLY1305zRSA-PSK-CHACHA20-POLY1305)ZTLS_RSA_WITH_NULL_SHA256ZTLS_RSA_WITH_AES_128_CBC_SHA256ZTLS_RSA_WITH_AES_256_CBC_SHA256ZTLS_RSA_WITH_AES_128_GCM_SHA256ZTLS_RSA_WITH_AES_256_GCM_SHA384Z"TLS_DH_RSA_WITH_AES_128_CBC_SHA256Z"TLS_DH_RSA_WITH_AES_256_CBC_SHA256Z"TLS_DH_RSA_WITH_AES_128_GCM_SHA256Z"TLS_DH_RSA_WITH_AES_256_GCM_SHA384Z"TLS_DH_DSS_WITH_AES_128_CBC_SHA256Z"TLS_DH_DSS_WITH_AES_256_CBC_SHA256Z"TLS_DH_DSS_WITH_AES_128_GCM_SHA256Z"TLS_DH_DSS_WITH_AES_256_GCM_SHA384Z#TLS_DHE_RSA_WITH_AES_128_CBC_SHA256Z#TLS_DHE_RSA_WITH_AES_256_CBC_SHA256Z#TLS_DHE_RSA_WITH_AES_128_GCM_SHA256Z#TLS_DHE_RSA_WITH_AES_256_GCM_SHA384Z#TLS_DHE_DSS_WITH_AES_128_CBC_SHA256Z#TLS_DHE_DSS_WITH_AES_256_CBC_SHA256Z#TLS_DHE_DSS_WITH_AES_128_GCM_SHA256Z#TLS_DHE_DSS_WITH_AES_256_GCM_SHA384Z%TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256Z%TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384Z%TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256Z%TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384Z'TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256Z'TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA384Z'TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256Z'TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384Z#TLS_DH_anon_WITH_AES_128_CBC_SHA256Z#TLS_DH_anon_WITH_AES_256_CBC_SHA256Z#TLS_DH_anon_WITH_AES_128_GCM_SHA256Z#TLS_DH_anon_WITH_AES_256_GCM_SHA384ZRSA_WITH_AES_128_CCMZRSA_WITH_AES_256_CCMZDHE_RSA_WITH_AES_128_CCMZDHE_RSA_WITH_AES_256_CCMZRSA_WITH_AES_128_CCM_8ZRSA_WITH_AES_256_CCM_8ZDHE_RSA_WITH_AES_128_CCM_8ZDHE_RSA_WITH_AES_256_CCM_8ZECDHE_ECDSA_WITH_AES_128_CCMZECDHE_ECDSA_WITH_AES_256_CCMZECDHE_ECDSA_WITH_AES_128_CCM_8ZECDHE_ECDSA_WITH_AES_256_CCM_8Z TLS_RSA_WITH_ARIA_128_GCM_SHA256Z TLS_RSA_WITH_ARIA_256_GCM_SHA384Z$TLS_DHE_RSA_WITH_ARIA_128_GCM_SHA256Z$TLS_DHE_RSA_WITH_ARIA_256_GCM_SHA384Z$TLS_DHE_DSS_WITH_ARIA_128_GCM_SHA256Z$TLS_DHE_DSS_WITH_ARIA_256_GCM_SHA384Z(TLS_ECDHE_ECDSA_WITH_ARIA_128_GCM_SHA256Z(TLS_ECDHE_ECDSA_WITH_ARIA_256_GCM_SHA384Z&TLS_ECDHE_RSA_WITH_ARIA_128_GCM_SHA256Z&TLS_ECDHE_RSA_WITH_ARIA_256_GCM_SHA384Z TLS_PSK_WITH_ARIA_128_GCM_SHA256Z TLS_PSK_WITH_ARIA_256_GCM_SHA384Z$TLS_DHE_PSK_WITH_ARIA_128_GCM_SHA256Z$TLS_DHE_PSK_WITH_ARIA_256_GCM_SHA384Z$TLS_RSA_PSK_WITH_ARIA_128_GCM_SHA256Z$TLS_RSA_PSK_WITH_ARIA_256_GCM_SHA384Z,TLS_ECDHE_ECDSA_WITH_CAMELLIA_128_CBC_SHA256Z,TLS_ECDHE_ECDSA_WITH_CAMELLIA_256_CBC_SHA384Z*TLS_ECDHE_RSA_WITH_CAMELLIA_128_CBC_SHA256Z*TLS_ECDHE_RSA_WITH_CAMELLIA_256_CBC_SHA384ZPSK_WITH_NULL_SHAZDHE_PSK_WITH_NULL_SHAZRSA_PSK_WITH_NULL_SHAZPSK_WITH_RC4_128_SHAZPSK_WITH_3DES_EDE_CBC_SHAZPSK_WITH_AES_128_CBC_SHAZPSK_WITH_AES_256_CBC_SHAZDHE_PSK_WITH_RC4_128_SHAZDHE_PSK_WITH_3DES_EDE_CBC_SHAZDHE_PSK_WITH_AES_128_CBC_SHAZDHE_PSK_WITH_AES_256_CBC_SHAZRSA_PSK_WITH_RC4_128_SHAZRSA_PSK_WITH_3DES_EDE_CBC_SHAZRSA_PSK_WITH_AES_128_CBC_SHAZRSA_PSK_WITH_AES_256_CBC_SHAZPSK_WITH_AES_128_GCM_SHA256ZPSK_WITH_AES_256_GCM_SHA384ZDHE_PSK_WITH_AES_128_GCM_SHA256ZDHE_PSK_WITH_AES_256_GCM_SHA384ZRSA_PSK_WITH_AES_128_GCM_SHA256ZRSA_PSK_WITH_AES_256_GCM_SHA384ZPSK_WITH_AES_128_CBC_SHA256ZPSK_WITH_AES_256_CBC_SHA384ZPSK_WITH_NULL_SHA256ZPSK_WITH_NULL_SHA384ZDHE_PSK_WITH_AES_128_CBC_SHA256ZDHE_PSK_WITH_AES_256_CBC_SHA384ZDHE_PSK_WITH_NULL_SHA256ZDHE_PSK_WITH_NULL_SHA384ZRSA_PSK_WITH_AES_128_CBC_SHA256ZRSA_PSK_WITH_AES_256_CBC_SHA384ZRSA_PSK_WITH_NULL_SHA256ZRSA_PSK_WITH_NULL_SHA384ZECDHE_PSK_WITH_RC4_128_SHAZECDHE_PSK_WITH_3DES_EDE_CBC_SHAZECDHE_PSK_WITH_AES_128_CBC_SHAZECDHE_PSK_WITH_AES_256_CBC_SHAZ!ECDHE_PSK_WITH_AES_128_CBC_SHA256Z!ECDHE_PSK_WITH_AES_256_CBC_SHA384ZECDHE_PSK_WITH_NULL_SHAZECDHE_PSK_WITH_NULL_SHA256ZECDHE_PSK_WITH_NULL_SHA384Z PSK_WITH_CAMELLIA_128_CBC_SHA256Z PSK_WITH_CAMELLIA_256_CBC_SHA384Z$DHE_PSK_WITH_CAMELLIA_128_CBC_SHA256Z$DHE_PSK_WITH_CAMELLIA_256_CBC_SHA384Z$RSA_PSK_WITH_CAMELLIA_128_CBC_SHA256Z$RSA_PSK_WITH_CAMELLIA_256_CBC_SHA384Z&ECDHE_PSK_WITH_CAMELLIA_128_CBC_SHA256Z&ECDHE_PSK_WITH_CAMELLIA_256_CBC_SHA384ZPSK_WITH_AES_128_CCMZPSK_WITH_AES_256_CCMZDHE_PSK_WITH_AES_128_CCMZDHE_PSK_WITH_AES_256_CCMZPSK_WITH_AES_128_CCM_8ZPSK_WITH_AES_256_CCM_8ZDHE_PSK_WITH_AES_128_CCM_8ZDHE_PSK_WITH_AES_256_CCM_8Z+TLS_ECDHE_RSA_WITH_CHACHA20_POLY1305_SHA256Z-TLS_ECDHE_ECDSA_WITH_CHACHA20_POLY1305_SHA256Z)TLS_DHE_RSA_WITH_CHACHA20_POLY1305_SHA256Z%TLS_PSK_WITH_CHACHA20_POLY1305_SHA256Z+TLS_ECDHE_PSK_WITH_CHACHA20_POLY1305_SHA256Z)TLS_DHE_PSK_WITH_CHACHA20_POLY1305_SHA256Z)TLS_RSA_PSK_WITH_CHACHA20_POLY1305_SHA256TLSV1_2_CIPHER_SUITESTLS_AES_128_GCM_SHA256TLS_AES_256_GCM_SHA384TLS_CHACHA20_POLY1305_SHA256TLS_AES_128_CCM_SHA256TLS_AES_128_CCM_8_SHA256)r  r  r  r  r  TLSV1_3_CIPHER_SUITES)r)   r*   r&   r'   TLS_CIPHER_SUITESOPENSSL_CS_NAMES)4rT   r6   abcr   r   typingr   r   r   r   r   r	   r
   Zcharsetsr   r   errorsr   r   rW   rV   r   r   r   r$   rU   rM  r%   r(   r+   r1   r9   r:   rY   r\   r   r   r   r  r!  r"  r.  r7  rN  r|  r}  r~  r  r  r  valuesr  r/   r/   r/   r0   <module>   s<  $$5	"n=IfB. E6  	"