Ë
|
Wñúhô¦ ã ó U d Z ddlZddlmZmZ ddlmZmZmZmZ ddl m
|
Z
|
ddlm Z ddl m Z mZmZmZmZmZmZmZ dd lmZmZ dd
|
lmZ dd lmZm Z d Z e e d < dZ e e d< dZ!e e d< dZ" dZ#dZ$i ddddddddddddd d d d d dd!d"d#d$d%dd&dd'd(d)d(d*dd+di d,d(d-d(d.dd/dd0dd1dd2d(d3d(d4d(d5dd6dd7dd8d(d9d(d:dd;dd<d(¥i d=dd>dd?dd@ddAddBd(dCddDd(dEddFd(dGddHd(dId(dJddKddLddMd¥ddddN¥Z%ee&eee&e'e f f e dO< dPZ(ee&e&e&f e dQ< dRZ)ee&dSf e dT< dUZ*e&e dV< ee z Z+ee& e dW< i dXdYdZd[d\d]d^d_d`dadbdcdddedfdgdhdidjdkdldmdndodpdqdrdsdtdudvdwdxdyi dzd{d|d}d~ddddddd
dddddddddddddddddddddd¥i ddddd d¡d¢d£d¤d¥d¦d§d¨d©dªd«d¬dd®d¯d°d±d²d³d´dµd¶d·d¸d¹dºd»d¼d½¥i 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ߥi 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¥i dddddddd d
|
d d d ddddddddddddddd d d d d d!d"d#¥i d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;d<d=d>d?d@dAdBdCdDdE¥dFdGdHdIdJdKdLdMdNdOdPdQ ¥Z,ee&e&f e dR< dSdTdUdVdWdXZ-ee&e&f e dY< e,e-dZZ.ee&ee&e&f f e d[< e,j_ « e-j_ « dZZ0ee&ee& f e d\< e d]e1d^e&d_e2d`e3dae'db e4d« dceddedeedfe dgedhe
|
dii Z5 dje dke dle'fdmZ6dne&doe&dpe dle fdqZ7 G dr dse« Z8 G dt due8« Z9 G dv dwe8« Z: G dx dye9« Z; G dz d{e« Z< G d| d}e8e<¬~« Z= G d de9« Z> G d de9« Z? G d de« Z@ G d
de8e@¬~« ZA G d de8« ZB G d d« ZC G d de8« ZDy( z+Various MySQL constants and character sets.é N)ÚABCÚABCMeta)ÚdateÚdatetimeÚtimeÚ timedelta)ÚDecimal)Ú struct_time)ÚAnyÚDictÚListÚOptionalÚSequenceÚTupleÚUnionÚ
|
ValuesViewé )ÚMYSQL_CHARACTER_SETSÚMYSQL_CHARACTER_SETS_57)ÚProgrammingError)ÚAPPROVED_TLS_VERSIONSÚDEPRECATED_TLS_VERSIONSé ÚNET_BUFFER_LENGTHé ÚMAX_MYSQL_TABLE_COLUMNSé ÚPARAMETER_COUNT_AVAILABLEÚfé- éÿ ÚdatabaseÚuserÚ ÚpasswordÚ password1Ú password2Ú password3Úhostz 127.0.0.1Úportiê Ú unix_socketÚ use_unicodeTÚcharsetÚutf8mb4Ú collationÚconverter_classÚconverter_str_fallbackFÚ
|
autocommitÚ time_zoneÚsql_modeÚ get_warningsÚraise_on_warningsÚconnection_timeoutÚ read_timeoutÚ write_timeoutÚ client_flagsÚcompressÚbufferedÚrawÚssl_caÚssl_certÚssl_keyÚssl_verify_certÚssl_verify_identityÚ
|
ssl_cipherÚtls_ciphersuitesÚ ssl_disabledÚ tls_versionsÚpasswdÚdbÚconnect_timeoutÚdsnÚ
|
force_ipv6Ú auth_pluginÚallow_local_infileÚallow_local_infile_in_pathÚconsume_resultsÚ
|
conn_attrsÚdns_srvÚuse_pureÚkrb_service_principalÚoci_config_fileÚoci_config_profileÚwebauthn_callback)Úkerberos_auth_modeÚ init_commandÚopenid_token_fileÚDEFAULT_CONFIGURATION)Ú pool_nameÚ pool_sizeÚpool_reset_sessionÚ CNX_POOL_ARGS)
|
Ú_pidÚ _platformÚ _source_hostÚ _client_nameÚ_client_licenseÚ_client_versionÚ_osÚ_connector_nameÚ_connector_licenseÚ_connector_version.Ú CONN_ATTRS_DNzH
|
The property counterpart '{property_name}' should be used instead.
|
ÚDEPRECATED_METHOD_WARNINGÚ TLS_VERSIONSÚTLS_RSA_WITH_NULL_SHA256z NULL-SHA256Ú TLS_RSA_WITH_AES_128_CBC_SHA256z AES128-SHA256Ú TLS_RSA_WITH_AES_256_CBC_SHA256z AES256-SHA256Ú TLS_RSA_WITH_AES_128_GCM_SHA256zAES128-GCM-SHA256Ú TLS_RSA_WITH_AES_256_GCM_SHA384zAES256-GCM-SHA384Ú"TLS_DH_RSA_WITH_AES_128_CBC_SHA256zDH-RSA-AES128-SHA256Ú"TLS_DH_RSA_WITH_AES_256_CBC_SHA256zDH-RSA-AES256-SHA256Ú"TLS_DH_RSA_WITH_AES_128_GCM_SHA256zDH-RSA-AES128-GCM-SHA256Ú"TLS_DH_RSA_WITH_AES_256_GCM_SHA384zDH-RSA-AES256-GCM-SHA384Ú"TLS_DH_DSS_WITH_AES_128_CBC_SHA256zDH-DSS-AES128-SHA256Ú"TLS_DH_DSS_WITH_AES_256_CBC_SHA256zDH-DSS-AES256-SHA256Ú"TLS_DH_DSS_WITH_AES_128_GCM_SHA256zDH-DSS-AES128-GCM-SHA256Ú"TLS_DH_DSS_WITH_AES_256_GCM_SHA384zDH-DSS-AES256-GCM-SHA384Ú#TLS_DHE_RSA_WITH_AES_128_CBC_SHA256zDHE-RSA-AES128-SHA256Ú#TLS_DHE_RSA_WITH_AES_256_CBC_SHA256zDHE-RSA-AES256-SHA256Ú#TLS_DHE_RSA_WITH_AES_128_GCM_SHA256zDHE-RSA-AES128-GCM-SHA256Ú#TLS_DHE_RSA_WITH_AES_256_GCM_SHA384zDHE-RSA-AES256-GCM-SHA384Ú#TLS_DHE_DSS_WITH_AES_128_CBC_SHA256zDHE-DSS-AES128-SHA256Ú#TLS_DHE_DSS_WITH_AES_256_CBC_SHA256zDHE-DSS-AES256-SHA256Ú#TLS_DHE_DSS_WITH_AES_128_GCM_SHA256zDHE-DSS-AES128-GCM-SHA256Ú#TLS_DHE_DSS_WITH_AES_256_GCM_SHA384zDHE-DSS-AES256-GCM-SHA384Ú%TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256zECDHE-RSA-AES128-SHA256Ú%TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384zECDHE-RSA-AES256-SHA384Ú%TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256zECDHE-RSA-AES128-GCM-SHA256Ú%TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384zECDHE-RSA-AES256-GCM-SHA384Ú'TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256zECDHE-ECDSA-AES128-SHA256Ú'TLS_ECDHE_ECDSA_WITH_AES_256_CBC_SHA384zECDHE-ECDSA-AES256-SHA384Ú'TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256z ECDHE-ECDSA-AES128-GCM-SHA256Ú'TLS_ECDHE_ECDSA_WITH_AES_256_GCM_SHA384z ECDHE-ECDSA-AES256-GCM-SHA384Ú#TLS_DH_anon_WITH_AES_128_CBC_SHA256zADH-AES128-SHA256Ú#TLS_DH_anon_WITH_AES_256_CBC_SHA256zADH-AES256-SHA256Ú#TLS_DH_anon_WITH_AES_128_GCM_SHA256zADH-AES128-GCM-SHA256Ú#TLS_DH_anon_WITH_AES_256_GCM_SHA384zADH-AES256-GCM-SHA384ÚRSA_WITH_AES_128_CCMz
|
AES128-CCMÚRSA_WITH_AES_256_CCMz
|
AES256-CCMÚDHE_RSA_WITH_AES_128_CCMzDHE-RSA-AES128-CCMÚDHE_RSA_WITH_AES_256_CCMzDHE-RSA-AES256-CCMÚRSA_WITH_AES_128_CCM_8z AES128-CCM8ÚRSA_WITH_AES_256_CCM_8z AES256-CCM8ÚDHE_RSA_WITH_AES_128_CCM_8zDHE-RSA-AES128-CCM8ÚDHE_RSA_WITH_AES_256_CCM_8zDHE-RSA-AES256-CCM8Ú ECDHE_ECDSA_WITH_AES_128_CCMzECDHE-ECDSA-AES128-CCMÚ ECDHE_ECDSA_WITH_AES_256_CCMzECDHE-ECDSA-AES256-CCMÚ ECDHE_ECDSA_WITH_AES_128_CCM_8zECDHE-ECDSA-AES128-CCM8Ú ECDHE_ECDSA_WITH_AES_256_CCM_8zECDHE-ECDSA-AES256-CCM8Ú TLS_RSA_WITH_ARIA_128_GCM_SHA256zARIA128-GCM-SHA256Ú TLS_RSA_WITH_ARIA_256_GCM_SHA384zARIA256-GCM-SHA384Ú$TLS_DHE_RSA_WITH_ARIA_128_GCM_SHA256zDHE-RSA-ARIA128-GCM-SHA256Ú$TLS_DHE_RSA_WITH_ARIA_256_GCM_SHA384zDHE-RSA-ARIA256-GCM-SHA384Ú$TLS_DHE_DSS_WITH_ARIA_128_GCM_SHA256zDHE-DSS-ARIA128-GCM-SHA256Ú$TLS_DHE_DSS_WITH_ARIA_256_GCM_SHA384zDHE-DSS-ARIA256-GCM-SHA384Ú(TLS_ECDHE_ECDSA_WITH_ARIA_128_GCM_SHA256z ECDHE-ECDSA-ARIA128-GCM-SHA256Ú(TLS_ECDHE_ECDSA_WITH_ARIA_256_GCM_SHA384z ECDHE-ECDSA-ARIA256-GCM-SHA384Ú&TLS_ECDHE_RSA_WITH_ARIA_128_GCM_SHA256zECDHE-ARIA128-GCM-SHA256Ú&TLS_ECDHE_RSA_WITH_ARIA_256_GCM_SHA384zECDHE-ARIA256-GCM-SHA384Ú TLS_PSK_WITH_ARIA_128_GCM_SHA256zPSK-ARIA128-GCM-SHA256Ú TLS_PSK_WITH_ARIA_256_GCM_SHA384zPSK-ARIA256-GCM-SHA384Ú$TLS_DHE_PSK_WITH_ARIA_128_GCM_SHA256zDHE-PSK-ARIA128-GCM-SHA256Ú$TLS_DHE_PSK_WITH_ARIA_256_GCM_SHA384zDHE-PSK-ARIA256-GCM-SHA384Ú$TLS_RSA_PSK_WITH_ARIA_128_GCM_SHA256zRSA-PSK-ARIA128-GCM-SHA256Ú$TLS_RSA_PSK_WITH_ARIA_256_GCM_SHA384zRSA-PSK-ARIA256-GCM-SHA384Ú,TLS_ECDHE_ECDSA_WITH_CAMELLIA_128_CBC_SHA256z ECDHE-ECDSA-CAMELLIA128-SHA256Ú,TLS_ECDHE_ECDSA_WITH_CAMELLIA_256_CBC_SHA384z ECDHE-ECDSA-CAMELLIA256-SHA384Ú*TLS_ECDHE_RSA_WITH_CAMELLIA_128_CBC_SHA256z ECDHE-RSA-CAMELLIA128-SHA256Ú*TLS_ECDHE_RSA_WITH_CAMELLIA_256_CBC_SHA384z ECDHE-RSA-CAMELLIA256-SHA384ÚPSK_WITH_NULL_SHAz PSK-NULL-SHAÚDHE_PSK_WITH_NULL_SHAzDHE-PSK-NULL-SHAÚRSA_PSK_WITH_NULL_SHAzRSA-PSK-NULL-SHAÚPSK_WITH_RC4_128_SHAz PSK-RC4-SHAÚPSK_WITH_3DES_EDE_CBC_SHAzPSK-3DES-EDE-CBC-SHAÚPSK_WITH_AES_128_CBC_SHAzPSK-AES128-CBC-SHAÚPSK_WITH_AES_256_CBC_SHAzPSK-AES256-CBC-SHAÚDHE_PSK_WITH_RC4_128_SHAzDHE-PSK-RC4-SHAÚ DHE_PSK_WITH_3DES_EDE_CBC_SHAzDHE-PSK-3DES-EDE-CBC-SHAÚ DHE_PSK_WITH_AES_128_CBC_SHAzDHE-PSK-AES128-CBC-SHAÚ DHE_PSK_WITH_AES_256_CBC_SHAzDHE-PSK-AES256-CBC-SHAÚRSA_PSK_WITH_RC4_128_SHAzRSA-PSK-RC4-SHAÚ RSA_PSK_WITH_3DES_EDE_CBC_SHAzRSA-PSK-3DES-EDE-CBC-SHAÚ RSA_PSK_WITH_AES_128_CBC_SHAzRSA-PSK-AES128-CBC-SHAÚ RSA_PSK_WITH_AES_256_CBC_SHAzRSA-PSK-AES256-CBC-SHAÚPSK_WITH_AES_128_GCM_SHA256zPSK-AES128-GCM-SHA256ÚPSK_WITH_AES_256_GCM_SHA384zPSK-AES256-GCM-SHA384Ú DHE_PSK_WITH_AES_128_GCM_SHA256zDHE-PSK-AES128-GCM-SHA256Ú DHE_PSK_WITH_AES_256_GCM_SHA384zDHE-PSK-AES256-GCM-SHA384Ú RSA_PSK_WITH_AES_128_GCM_SHA256zRSA-PSK-AES128-GCM-SHA256Ú RSA_PSK_WITH_AES_256_GCM_SHA384zRSA-PSK-AES256-GCM-SHA384ÚPSK_WITH_AES_128_CBC_SHA256zPSK-AES128-CBC-SHA256ÚPSK_WITH_AES_256_CBC_SHA384zPSK-AES256-CBC-SHA384ÚPSK_WITH_NULL_SHA256zPSK-NULL-SHA256ÚPSK_WITH_NULL_SHA384zPSK-NULL-SHA384Ú DHE_PSK_WITH_AES_128_CBC_SHA256zDHE-PSK-AES128-CBC-SHA256Ú DHE_PSK_WITH_AES_256_CBC_SHA384zDHE-PSK-AES256-CBC-SHA384ÚDHE_PSK_WITH_NULL_SHA256zDHE-PSK-NULL-SHA256ÚDHE_PSK_WITH_NULL_SHA384zDHE-PSK-NULL-SHA384Ú RSA_PSK_WITH_AES_128_CBC_SHA256zRSA-PSK-AES128-CBC-SHA256Ú RSA_PSK_WITH_AES_256_CBC_SHA384zRSA-PSK-AES256-CBC-SHA384ÚRSA_PSK_WITH_NULL_SHA256zRSA-PSK-NULL-SHA256ÚRSA_PSK_WITH_NULL_SHA384zRSA-PSK-NULL-SHA384ÚECDHE_PSK_WITH_RC4_128_SHAzECDHE-PSK-RC4-SHAÚ ECDHE_PSK_WITH_3DES_EDE_CBC_SHAzECDHE-PSK-3DES-EDE-CBC-SHAÚ ECDHE_PSK_WITH_AES_128_CBC_SHAzECDHE-PSK-AES128-CBC-SHAÚ ECDHE_PSK_WITH_AES_256_CBC_SHAzECDHE-PSK-AES256-CBC-SHAÚ!ECDHE_PSK_WITH_AES_128_CBC_SHA256zECDHE-PSK-AES128-CBC-SHA256Ú!ECDHE_PSK_WITH_AES_256_CBC_SHA384zECDHE-PSK-AES256-CBC-SHA384ÚECDHE_PSK_WITH_NULL_SHAzECDHE-PSK-NULL-SHAÚECDHE_PSK_WITH_NULL_SHA256zECDHE-PSK-NULL-SHA256ÚECDHE_PSK_WITH_NULL_SHA384zECDHE-PSK-NULL-SHA384Ú PSK_WITH_CAMELLIA_128_CBC_SHA256zPSK-CAMELLIA128-SHA256Ú PSK_WITH_CAMELLIA_256_CBC_SHA384zPSK-CAMELLIA256-SHA384Ú$DHE_PSK_WITH_CAMELLIA_128_CBC_SHA256zDHE-PSK-CAMELLIA128-SHA256Ú$DHE_PSK_WITH_CAMELLIA_256_CBC_SHA384zDHE-PSK-CAMELLIA256-SHA384Ú$RSA_PSK_WITH_CAMELLIA_128_CBC_SHA256zRSA-PSK-CAMELLIA128-SHA256Ú$RSA_PSK_WITH_CAMELLIA_256_CBC_SHA384zRSA-PSK-CAMELLIA256-SHA384Ú&ECDHE_PSK_WITH_CAMELLIA_128_CBC_SHA256z ECDHE-PSK-CAMELLIA128-SHA256Ú&ECDHE_PSK_WITH_CAMELLIA_256_CBC_SHA384z ECDHE-PSK-CAMELLIA256-SHA384ÚPSK_WITH_AES_128_CCMzPSK-AES128-CCMÚPSK_WITH_AES_256_CCMzPSK-AES256-CCMÚDHE_PSK_WITH_AES_128_CCMzDHE-PSK-AES128-CCMÚDHE_PSK_WITH_AES_256_CCMzDHE-PSK-AES256-CCMzPSK-AES128-CCM8zPSK-AES256-CCM8zDHE-PSK-AES128-CCM8zDHE-PSK-AES256-CCM8zECDHE-RSA-CHACHA20-POLY1305z ECDHE-ECDSA-CHACHA20-POLY1305zDHE-RSA-CHACHA20-POLY1305zPSK-CHACHA20-POLY1305zECDHE-PSK-CHACHA20-POLY1305zDHE-PSK-CHACHA20-POLY1305zRSA-PSK-CHACHA20-POLY1305) ÚPSK_WITH_AES_128_CCM_8ÚPSK_WITH_AES_256_CCM_8ÚDHE_PSK_WITH_AES_128_CCM_8ÚDHE_PSK_WITH_AES_256_CCM_8Ú+TLS_ECDHE_RSA_WITH_CHACHA20_POLY1305_SHA256Ú-TLS_ECDHE_ECDSA_WITH_CHACHA20_POLY1305_SHA256Ú)TLS_DHE_RSA_WITH_CHACHA20_POLY1305_SHA256Ú%TLS_PSK_WITH_CHACHA20_POLY1305_SHA256Ú+TLS_ECDHE_PSK_WITH_CHACHA20_POLY1305_SHA256Ú)TLS_DHE_PSK_WITH_CHACHA20_POLY1305_SHA256Ú)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)zTLSv1.2zTLSv1.3ÚTLS_CIPHER_SUITESÚOPENSSL_CS_NAMESÚintÚfloatÚstrÚbytesÚ bytearrayÚboolÚnonetyper r r r
|
r ÚdecimalÚflagÚflagsÚreturnc ó || z dkD ryy)z.Checks if the flag is set
|
|
Returns booleanr TF© )rÿ r s úLH:\Change_password\venv_build\Lib\site-packages\mysql/connector/constants.pyÚ flag_is_setr 7 s ð ÒØØ ó ÚnameÚnew_nameÚvaluec óJ t j d| d| dt ¬« |S )a Raise 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)ÚwarningsÚwarnÚDeprecationWarning)r r r s r Ú_obsolete_optionr @ s- ô MMØ
|
tfÐ 8¸¸
|
À*ÐMÜ#õð Lr c ó¼ e Zd ZU dZdZeed< i Zeee e
|
ef f ed< e dede e fd« Z e de
|
dee e e eef f fd « Ze deeee f fd
|
« Zy ) Ú
|
_ConstantszBase class for constants.r$ ÚprefixÚdescr r c óR | j | d S # t t f$ r Y yw xY w)z!Get description of given constantr N)r Ú
|
IndexErrorÚKeyError©Úclsr s r Úget_descz_Constants.get_descX s1 ð Ø88D> !Ñ$Ð $øÜHÐ%ò Ùð ús &¥&Úsetidc ó` | j j « D ] \ }}|d |k( s|c S y)z$Get information about given constantr N)r Úitems)r r r Úinfos r Úget_infoz_Constants.get_info` s8 ð ((..Ó*ò JD$ØAw%Ó Ø ð ð r c óÄ g } | j j « D cg c] \ }}| d|d }}}|S c c}}w # t t f$ r}d| }Y d}~|S d}~ww xY w)z)get full information about given constantz : r z(No information found in constant class. N)r r ÚAttributeErrorr )r ÚresÚkÚvÚerrs r Ú get_full_infoz_Constants.get_full_infoh st ð &(ð CØ/2¯x©x¯~©~Ó/?×@¡t q¨!aSAaD6?Ð@CÑ@ð
|
ùó AøÜ ¤
|
Ð+ò CØ<¸S¸EÐBCà
|
ûð Cús% A ¡:µA ºA Á A ÁAÁA N)Ú__name__Ú
|
__module__Ú __qualname__Ú__doc__r rù Ú__annotations__r r r r÷ Ú classmethodr r r r r r& r r r r r R s°
Ù#àFCÓØ')D$sE#s(OÐ#Ñ
|
$Ó)àðCð H¨S¡Mò ó ðð ðSð U¨8°C©=¸%ÀÀSÀ¹/Ð+IÑ%Jò ó ðð ðe C¨°#© Ð$6Ñ 7ò ó ñr r c ó0 e Zd ZdZededee fd« Zy)Ú_Flagsz'Base class for classes describing flagsr r c ó g }| j j « D ] \ }}||d z s|j |« ! |S )z@Get the name of all bits set
|
|
Returns a list of strings.r )r r Úappend)r r r" r r s r Ú get_bit_infoz_Flags.get_bit_infow sE ð
|
Ø ((..Ó*ò !JD$ØtAwØ
|
|
4Õ ð !ð
|
r N) r' r( r) r* r, r÷ r rù r1 r r r r. r. t s) Ù1àð 𠨨c©ò ó ñr r. c ó@ e Zd ZU dZdZeed< dZeed< dZ eed< dZ
|
eed < d
|
Z eed < d Z eed < dZ eed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< d Zeed < d Zeed < d Zeed!< d"Zeed#< d$Zeed%< d&Zeed'< d(Zeed)< d*Zeed+< d,Z eed-< d.Z eed/< d0Z eed1< d2Z eed3< d4Z eed5< d6Z!eed7< d8Z"eed9< d:Z#eed;< d<Z$eed=< i dedfde dfd e
|
d fd e d fd e d fde dfdedfdedfdedfdedfdedfdedfd ed fd ed fd!ed!fd#ed#fd%ed%fed'fed)fed+fe d-fe d/fe d1fe d3fe d5fe!d7fe"d9fe#d;fe$d=fd> ¥Z%e&ee'eef f ed?< e(d@e)e fdA« Z*e(d@e)e fdB« Z+e(d@e)e fdC« Z,e(d@e)e fdD« Z-yE)FÚ FieldTypeaY MySQL Field Types.
|
|
This class provides all supported MySQL field or data types. They can be useful
|
when dealing with raw data or defining your own converters. The field type is
|
stored with every cursor in the description for each column.
|
|
The `FieldType` class shouldn't be instantiated.
|
|
Examples:
|
The following example shows how to print the name of the data type for
|
each column in a result set.
|
|
```
|
from __future__ import print_function
|
import mysql.connector
|
from mysql.connector import FieldType
|
|
cnx = mysql.connector.connect(user='scott', database='test')
|
cursor = cnx.cursor()
|
|
cursor.execute(
|
"SELECT DATE(NOW()) AS `c1`, TIME(NOW()) AS `c2`, "
|
"NOW() AS `c3`, 'a string' AS `c4`, 42 AS `c5`")
|
rows = cursor.fetchall()
|
|
for desc in cursor.description:
|
colname = desc[0]
|
coltype = desc[1]
|
print("Column {} has type {}".format(
|
colname, FieldType.get_info(coltype)))
|
|
cursor.close()
|
cnx.close()
|
```
|
Ú FIELD_TYPE_r r ÚDECIMALr ÚTINYé ÚSHORTé ÚLONGé ÚFLOATé ÚDOUBLEé ÚNULLé Ú TIMESTAMPr ÚLONGLONGé ÚINT24é
|
ÚDATEé ÚTIMEé ÚDATETIMEé ÚYEARé ÚNEWDATEé ÚVARCHARé ÚBITéò ÚVECTORéõ ÚJSONéö Ú
|
NEWDECIMALé÷ ÚENUMéø ÚSETéù Ú TINY_BLOBéú Ú MEDIUM_BLOBéû Ú LONG_BLOBéü ÚBLOBéý Ú
|
VAR_STRINGéþ ÚSTRINGr! ÚGEOMETRY) rU rW rY r[ r] r_ ra rc re rg ri rj r r c ó^ | j | j | j | j gS )z Get the list of all string types)rQ r[ rg ri ©r s r Úget_string_typeszFieldType.get_string_typesç s* ð KKØ HHØ NNØ JJð
|
ð
|
r c ó^ | j | j | j | j gS )z Get the list of all binary types)r_ ra rc re rl s r Úget_binary_typeszFieldType.get_binary_typesñ s* ð MMØ OOØ MMØ HHð
|
ð
|
r c óø | j | j | j | j | j | j
|
| j | j | j | j | j g S )z Get the list of all number types) r5 rY r6 r8 r: r< r> rC rE rS rM rl s r Úget_number_typeszFieldType.get_number_typesû s[ ð KKØ NNØ HHØ IIØ HHØ IIØ JJØ LLØ IIØ GGØ HHð
|
ð
|
r c ó2 | j | j gS )z#Get the list of all timestamp types)rK rB rl s r Úget_timestamp_typesz FieldType.get_timestamp_types s ð LLØ MMð
|
ð
|
r N).r' r( r) r* r rù r+ r5 r÷ r6 r8 r: r< r> r@ rB rC rE rG rI rK rM rO rQ rS rU rW rY r[ r] r_ ra rc re rg ri rj r r r r, r rm ro rq rs r r r r3 r3 sJ
ñ"ðH FCÓ ØGSÓØD#ÓØE3ÓØD#ÓØE3ÓØFCÓØD#ÓØIsÓØHcÓØE3ÓØD#ÓØD#ÓØHcÓØD#ÓØGSÓØGSÓØCOØFCÓØD#ÓØJÓØD#ÓØCOØIsÓØKÓØIsÓØD#ÓØJÓØFCÓØHcÓð (ØGYÐ'ð (àvð (ð %Ð!ð (ð vð (ð
|
%Ð!ð (ð 68Ð$ð (ð vð (ð i Ð-ð (ð XzÐ*ð (ð %Ð!ð (ð vð (ð vð (ð XzÐ*ð (ð vð (ð GYÐ'ð (ð GYÐ'ð! (ð" U|ð# (ð$ 8Ð$ØvØ! <Ð0ØvØU|Ø Ð-Ø# ]Ð3Ø Ð-ØvØ! <Ð0Ø8Ð$Ø zÐ*ò; (D$sE#s(OÐ#Ñ
|
$ó ð@ ð
|
c¡ò
|
ó ð
|
ð ð
|
c¡ò
|
ó ð
|
ð ð
|
c¡ò
|
ó ð
|
ð ð
|
D¨¡Iò
|
ó ñ
|
r r3 c óü e Zd ZU dZdZeed< dZeed< dZ eed< dZ
|
eed < d
|
Z eed < d Z eed < dZ eed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< d Zeed < d Zeed < d Zeed!< d"Zeed#< d Zeed$< d%Zeed&< d'Zeed(< d)Zeed*< d+Z eed,< d-Z eed.< d/Z eed0< i dd1dd2d d3d d4d d5dd6dd7dd8dd9dd:dd;dd<d d=d d>d!d?d#d@d$dAdBdCdDdEdFdGdH¥Z e ee!eef f edI< yJ)KÚ FieldFlagz_MySQL Field Flags
|
|
Field flags as found in MySQL sources mysql-src/include/mysql_com.h
|
r$ Ú_prefixr ÚNOT_NULLr7 ÚPRI_KEYr; Ú
|
UNIQUE_KEYr Ú MULTIPLE_KEYrR re é ÚUNSIGNEDé@ ÚZEROFILLé ÚBINARYé r[ é ÚAUTO_INCREMENTé rB é 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 zField can't be NULL)r7 z Field is part of a primary key)r; z Field is part of a unique key)r zField is part of a key)rR zField is a blob)r{ zField is unsigned)r} zField is zerofill)r zField is binary )r zfield is an enum)r z field is a autoincrement field)r zField is a timestamp)r
zfield is a set)r z Field doesn't have default value)r z Field is set to NOW on UPDATE)r zField is num (for clients))r zIntern; Part of some key)r 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)r r r r r r r N)"r' r( r) r* rv rù r+ rw r÷ rx ry rz re r| r~ r r[ r rB r] r r r r r r r r r r r r r r r r r ru ru s
ñð
|
GSÓØHcÓØGSÓØ JÓ Ø L#Ó ØD#ÓØHcÓØHcÓØFCÓàD#ÓØ NCÓ Ø IsÓ ØCÓà #ÐcÓ#Ø M3Ó ØCÓØHcÓØE3ÓØFCÓØFCÓà #ÐcÓ#Ø %ÐÓ%Ø %ÐÓ%Ø #ÐcÓ#ð(ØÐ3ð(àÐ=ð(ð Ð?ð(ð Ð:ð (ð
|
Ð+ð (ð Ð1ð (ð Ð1ð(ð Ð/ð(ð Ð,ð(ð ÐDð(ð Ð6ð(ð Ð*ð(ð Ð Ið(ð ÐCð (ð Ð6ð (ð Ð9ð!(ð" Ð1ð#(ð$ 8Ø7Ø HØ GØ JØ Gò/(D$sE#s(OÐ#Ñ
|
$ô r ru c ó, e Zd ZdZdedef fd Z xZS )Ú ServerCmdMetazClientFlag Metaclass.r r c ól d}||v r t j d| dt ¬« t | |« S )N)Ú
|
FIELD_LISTÚREFRESHÚSHUTDOWNÚ PROCESS_INFOÚ PROCESS_KILLzThe option 'ServerCmd.z8' is deprecated and will be removed in a future release.r )r r r ÚsuperÚ__getattribute__)r r Údeprecated_optionsÚ __class__s r r£ z ServerCmdMeta.__getattribute__U sH ø ð
|
Ðð Ð%Ñ %Ü MMØ(¨¨ð /$ð $ä+õ ô
|
wÑ'¨Ó-Ð-r )r' r( r) r* rù r r£ Ú __classcell__)r¥ s @r r r R s ø Ù ð. Cð .¨C÷ .ñ .r r c ó e Zd ZU dZdZeed< dZeed< dZ eed< dZ
|
eed < d
|
Z eed < d Z eed < dZ eed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< d Zeed < d Zeed < d Zeed!< d"Zeed#< d$Zeed%< d&Zeed'< d(Zeed)< d*Zeed+< d,Z eed-< d.Z eed/< d0Z eed1< d2Z eed3< d4Z eed5< d6Z!eed7< d8Z"eed9< d:Z#eed;< d<Z$eed=< d>Z%eed?< d@Z&eedA< dBZ'eedC< i ddDddEd dFd dGd dHddIddJddKddLddMddNddOd dPd dQd!dRd#dSd%dTdUdVdWdXdYdZd[d\d]d^d_d`dadbdcdd¥Z(e)ee*eef f ede< yf)gÚ ServerCmdzMySQL Server CommandsÚCOM_rv r ÚSLEEPr ÚQUITr7 ÚINIT_DBr9 ÚQUERYr; r r= Ú CREATE_DBr? ÚDROP_DBrA r r r rD Ú
|
STATISTICSrF r rH ÚCONNECTrJ r¡ rL ÚDEBUGrN ÚPINGrP rI rR Ú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« )r7 r¬ )r9 r )r; r )r= r® )r? r¯ )rA r )r r )rD r° )rF r )rH r± )rJ r¡ )rL r² )rN r³ )rP rI )rR 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Ò r N)+r' r( r) r* rv rù r+ rª r÷ r« r¬ r r r® r¯ r r r° r r± r¡ r² r³ rI r´ r¶ r¸ rº r¼ r¾ rÀ r rÄ rÆ rÈ rÊ rÌ rÎ rÐ rÒ r r r r r r r¨ r¨ f sp
Ù àGSÓØE3NØD#MØGSÓØE3NØJÓØIsÓØGSÓØGSÓØHcÓØJÓØL#ÓØGSÓØL#ÓØE3OØD#NØD#NØ NCÓ ØKÓØKÓØJÓØKÓØ ÐcÓ ØL#ÓØL#ÓØ !ÐÓ!ØJÓØJÓØJÓØJÓØFCÓØ ÐcÓ Ø ÐcÓ ð!(Ø ð!(à ð!(ð >ð!(ð ð !(ð
|
Ð'ð !(ð Ð%ð !(ð >ð!(ð >ð!(ð Oð!(ð Ð'ð!(ð Ð,ð!(ð ?ð!(ð Ð,ð!(ð ð !(ð ð !(ð ð!!(ð" Ð0ð#!(ð$ +Ø*Ø(Ø*Ø 4Ø,Ø,Ø :Ø(Ø(Ø(Ø(Ø Ø 4Ø 4òA!(D$sE#s(OÐ#Ñ
|
$ô !r r¨ )Ú metaclassc ó e Zd ZU dZdZeed< dZeed< dZeed< dZ eed < d
|
Z
|
eed < d Z eed < dZ eed< dZ eed< dZeed< dZeed< dZeed< dZeed< dZeed< d Zeed < d Zeed < d Zeed!< d"Zeed#< d$Zeed%< d&Zeed'< d(Zeed)< d*Zeed+< d,Zeed-< d.Z eed/< d0Z eed1< d0Z eed2< d3Z eed4< d5Z eed6< d7Z!eed8< d9Z"eed:< d;Z#eed<< i dd=dd>dd?d d@d dAd dBddCddDddEddFddGddHddId dJd dKd!dLd#dMdNdOdPdQdRdSdTdTdUdVdWdXdY ¥Z$e%e&e'ee&f f edZ< eee eeeeeeeg
|
Z(e)e ed[< e*d\efd]« Z+y^)_Ú
|
ClientFlagaÿ MySQL Client Flags.
|
|
Client options as found in the MySQL sources mysql-src/include/mysql_com.h.
|
|
This class provides constants defining MySQL client flags that can be used
|
when the connection is established to configure the session. The `ClientFlag`
|
class is available when importing mysql.connector.
|
|
The `ClientFlag` class shouldn't be instantiated.
|
|
Examples:
|
```
|
>>> import mysql.connector
|
>>> mysql.connector.ClientFlag.FOUND_ROWS
|
2
|
```
|
r Ú LONG_PASSWDr7 Ú
|
FOUND_ROWSr; Ú LONG_FLAGr ÚCONNECT_WITH_DBrR Ú 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Ú SESSION_TRACKé Ú DEPRECATE_EOFé ÚCLIENT_QUERY_ATTRIBUTESé @ÚSSL_VERIFY_SERVER_CERTì ÚREMEMBER_OPTIONSi ÚMULTI_FACTOR_AUTHENTICATION)r zNew more secure passwords)r7 z Found instead of affected rows)r; zGet all column flags)r z One can specify db on connect)rR z!Don't allow database.table.column)r{ z Can use compression protocol)r} z ODBC client)r zCan use LOAD DATA LOCAL)r zIgnore spaces before '')r zNew 4.1 protocol)r z This is an interactive client)r
z Switch to SSL after handshake)r zIGNORE sigpipes)r z Client knows about transactions)r 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ó z/Support optional extension for query parameters)rõ r$ )r÷ r$ ) rç rè ré rê rë rí rï rð rò rô rö rø r Údefaultr c ó6 d}| j D ] }||z } |S )zbGet the default client options set
|
|
Returns a flag with all the default client options setr )rú )r r Úoptions r Ú get_defaultzClientFlag.get_default s* ð
|
Økkò FØ VOEð à r N),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 r rÕ rÕ ¯ sÁ
ñð$ KÓ Ø JÓ ØIsÓØ!OSÓ!ØIsÓØHcÓØD#ÓØ KÓ Ø L#Ó Ø KÓ Ø KÓ ØCÓØ!NCÓ!Ø L#Ó ØHcÓØ $ÐsÓ$Ø #ÐcÓ#Ø M3Ó Ø #ÐcÓ#Ø KÓ Ø L#Ó Ø*1Ð" CÓ1Ø(/Ð #Ó/Ø L#Ó Ø M3Ó Ø M3Ó Ø#*ÐSÓ*Ø")ÐCÓ)Ø #ÐcÓ#Ø'.Ð Ó.ð-(ØÐ<ð-(àÐ@ð-(ð Ð5ð-(ð ÐDð -(ð
|
ÐBð -(ð Ð<ð -(ð Ð'ð-(ð Ð:ð-(ð Ð;ð-(ð Ð3ð-(ð ÐAð-(ð Ð9ð-(ð Ð6ð-(ð ÐDð -(ð Ð:ð -(ð Ð @ð!-(ð" Ð Jð#-(ð$ CØ EØIØJð+
|
ð)
|
ð
|
ð
|
ð Hð$
|
ð #0Ø )òY-(D$sE#s(OÐ#Ñ
|
$ó -ð` ØØØØØØØØØ&ð GT#Yó ð ðCò ó ñr rÕ c ó$ e Zd ZU dZdZeed< dZeed< dZ eed< dZ
|
eed < d
|
Z eed < d Z eed < dZ eed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< d Zeed < d Zeed < d d!d"d#d$d%d&d'd(d)d*d+d,d-d.Zeeeeef f ed/< y0)1Ú
|
ServerFlagzeMySQL Server Flags
|
|
Server flags as found in the MySQL sources mysql-src/include/mysql_com.h
|
ÚSERVER_rv r ÚSTATUS_IN_TRANSr7 ÚSTATUS_AUTOCOMMITr ÚMORE_RESULTS_EXISTSrR Ú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 zTransaction has started)r7 zServer in auto_commit mode)r z Multi query - next query exists)rR 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 zA 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)ÚSERVER_STATUS_IN_TRANSÚSERVER_STATUS_AUTOCOMMITÚSERVER_MORE_RESULTS_EXISTSÚ SERVER_QUERY_NO_GOOD_INDEX_USEDÚSERVER_QUERY_NO_INDEX_USEDÚSERVER_STATUS_CURSOR_EXISTSÚSERVER_STATUS_LAST_ROW_SENTÚSERVER_STATUS_DB_DROPPEDÚ"SERVER_STATUS_NO_BACKSLASH_ESCAPESr
|
r r r r r N)r' r( r) r* 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ÿ ( s
ñð
|
GSÓ Ø!OSÓ!Ø #ÐsÓ#Ø %ÐÓ%Ø$*Ð cÓ*Ø %ÐÓ%Ø &Ð#Ó&Ø &Ð#Ó&Ø #ÐsÓ#Ø'-Ð Ó-Ø*1Ð" CÓ1Ø!(Ð3Ó(Ø 'Ð#Ó'Ø+2Ð# SÓ2Ø(/Ð #Ó/ð #FØ$Jð'
|
ð ,8Ø&2ð(
|
ð(
|
ð %GØ.:ð+
|
ð ",ð!
|
ð,
|
ð)
|
ñG)(D$sE#s(OÐ#Ñ
|
$ô )r rÿ c ó& e Zd ZdZedefd« Zy)ÚRefreshOptionMetazRefreshOption Metaclass.r c ó8 t ddt j « S )zzReturn the deprecated alias of RefreshOption.REPLICA.
|
|
Raises a warning about this attribute deprecation.
|
zRefreshOption.SLAVEzRefreshOption.REPLICA)r Ú RefreshOptionÚREPLICA©Úselfs r ÚSLAVEzRefreshOptionMeta.SLAVEm s ô Ø !Ø #Ü × !Ñ !ó
|
ð
|
r N)r' r( r) r* Úpropertyr÷ r r r r r r j s Ù"à ð
|
sò
|
ó ñ
|
r r c ó¦ e Zd ZU dZdZeed< dZeed< dZ eed< dZ
|
eed < d
|
Z eed < d Z eed < dZ eed< ddddddddZeeeeef f ed< y)r zbMySQL Refresh command options.
|
|
Options used when sending the COM_REFRESH server command.
|
ÚREFRESH_rv r ÚGRANTr7 ÚLOGr; ÚTABLESr ÚHOSTrR ÚSTATUSr} r )r zRefresh grant tables)r7 zStart on new log file)r; zclose all tables)r zFlush host cache)rR zFlush status variables)r} z,Reset source info and restart replica thread)r} z'Deprecated option; use REPLICA instead.)r# r$ r% r& r' r r r N)r' r( r) r* rv rù r+ r# r÷ r$ r% r& r' r r r r r r r r r z s
ñð
|
GSÓ ØE3ÓØCÓØFCÓØD#ÓØFCÓØGSÓð 2Ø0Ø.Ø,Ø4ØKØDñ(D$sE#s(OÐ#Ñ
|
$ô r r c óä e Zd ZU dZdZeed< dZeed< dZ eed< dZ
|
eed < d
|
Z eed < d Z eed < dZ eed< dZeed< dZeed< edfe dfe
|
dfe dfe dfe dfedfedfdZeeeeef f ed < y ) Ú ShutdownTypezVMySQL Shutdown types
|
|
Shutdown types used by the COM_SHUTDOWN server command.
|
r$ rv r ÚSHUTDOWN_DEFAULTr ÚSHUTDOWN_WAIT_CONNECTIONSr7 ÚSHUTDOWN_WAIT_TRANSACTIONSr ÚSHUTDOWN_WAIT_UPDATESrR ÚSHUTDOWN_WAIT_ALL_BUFFERSrµ Ú SHUTDOWN_WAIT_CRITICAL_BUFFERSrh Ú
|
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* r+ r, r- r. r/ r0 r1 r N)r' r( r) r* rv rù r+ r* r÷ r+ r, r- r. r/ r0 r1 r r r r r r r) r) së
ñð
|
GSÓØ ÐcÓ Ø%&Ð sÓ&Ø&'Ð Ó'Ø!"Ð3Ó"Ø%'Ð sÓ'Ø*,Ð" CÓ,ØJÓØ OSÓ ð Ø 3ð
|
ð
|
&Ø 5ð&
|
ð
|
'Ø /ð'
|
ð
|
"Ø 1ð"
|
ð
|
&Ø ;ð&
|
ð
|
+Ø Nð+
|
ð "Ð#5Ð6Ø +Ð-?Ð@ñ5(D$sE#s(OÐ#Ñ
|
$ô r r) c
|
óì e Zd ZU dZdZeedf ed< ddZdeedf ddfd Z d
|
edee
|
e
|
f fd Z d ede
|
fd Z de ee
|
f dee
|
e
|
ef fdZ ddee ee
|
f dee
|
deee
|
e
|
f fdZdee
|
df fdZy)Ú 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 rL rË éT éW éX .Úslash_charsetsr Nc ó( t | _ d| _ y )N)r= rA )r Ú_descÚ_mysql_versionr s r Ú__init__zCharacterSet.__init__Ï s ä<S
|
Ø/5Õr Úversionc óN |dd | _ | j dk\ r t | _ yy)zSet the MySQL major version and change the charset mapping if is 5.7.
|
|
Args:
|
version (tuple): MySQL version tuple.
|
Nr7 ©r r )r: r r9 )r r< s r Úset_mysql_versionz CharacterSet.set_mysql_versionÔ s, ð & b qkÔØ × Ñ &Ò (Ü-DJð )r r c ób | j | dd S # t $ r t d| d« dw xY w)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 r7 úCharacter set 'ú ' unsupportedN)r9 r r )r r s r r zCharacterSet.get_infoÞ sF ð UØ::eÑ$ Q qÐ)Ð )øÜò UÜ" _°U°G¸=Ð#IÓJÐPTÐ Tð Uús .r c ó8 | j |« \ }}| d| S )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.
|
ú/)r )r r r- r/ s r r zCharacterSet.get_descí s( ð "]]¨4Ó 0ÑØ!I;Ð'Ð'r r- c ó> t |t « r | j | }|d |d |fS t | j « D ]% \ }}| |d |k( s|d du s|d |d |fc S t d| d« # t t f$ r}t d| d« |d}~ww xY w) z¸Retrieves the default collation for given character set
|
|
Raises ProgrammingError when character set is not supported.
|
|
Returns list (collation, charset, index)
|
r r zCharacter set ID 'rB Nr7 TrA )Ú
|
isinstancer÷ r9 r r r Ú enumerate)r r- r r% Úcids r Úget_default_collationz"CharacterSet.get_default_collationø sÐ ô gsÔ #ð Øzz 'Ñ*ØAw Q¡¨Ð0Ð0ô # 4§:¡:Ó.ò -ICØ|ØØAw'Ó! d¨1¡g°¢oØAw Q¡¨Ð,Ò,ð -ô °° ¸ Ð GÓHÐHøô ¤Ð)ò Ü&Ø(¨¨ ° Ð?óàðûð ús A8 Á8B ÂBÂB r/ c óZ d}t |t « r | j | }||d |d fS |dv r| j
|
dk\ rd}|!| | j |« }|d |d |d fS |F|Dt | j « D ] \ }}| ||d k( s||d |d fc S t d
|
| d « t | j « D ]& \ }}| |d |k( s|d |k( s||d |d fc S | j |« }t d
|
| d « # t $ r}t d| d« |d}~ww xY w) 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 zCharacter set ID z unknown)Úutf8zutf-8r> r. r7 z Collation 'z ' unknown)rF r÷ r9 r r r: rI rG )r r- r/ r r% rH Ú_s r Úget_charset_infoz CharacterSet.get_charset_info s ð$ NRÜ gsÔ #ð WØzz 'Ñ*Ø a¡¨$¨q©'Ð2Ð2ð Ð'Ñ '¨D×,?Ñ,?À6Ò,IØ GØ Ð 9Ð#4Ø×-Ñ-¨gÓ6DØGT !W d¨1¡gÐ.Ð .Ø ?yÐ 4Ü & t§z¡zÓ 2ò 3 TØ<Ø Ø Q¡Ó'Ø a¡¨$¨q©'Ð2Ò2ð 3ô
|
# [°° ¸9Ð#EÓFÐ FÜ" 4§:¡:Ó.ò /ICØ|ØØAw'Ó! d¨1¡g°Ó&:ØT !W d¨1¡gÐ.Ò.ð /ð
|
× &Ñ & wÓ /Ü ¨Y¨K°yÐ AÓBÐBøô+ ò WÜ&Ð):¸7¸)À8Ð'LÓMÐSVÐVûð Wús D Ä D*ÄD%Ä%D*c ó| g }| j D ]! }|s|d |vs|j |d « # t |« S )z^Retrieves a list with names of all supproted character sets
|
|
Returns a tuple.
|
r )r9 r0 Útuple)r r" r s r Ú get_supportedzCharacterSet.get_supported> sF ð
|
ØJJò $DÚQ sÒ*Ø
|
|
4 7Õ#ð $ô SzÐr )r N)NN)r' r( r) r* r7 r r÷ r+ r; r? rù r r r rI r rM rP r r r r3 r3 Á sï
ñð '>NE#s(OÓ=ó6ð
|
.¨¨s°C¨x© ð .¸Tó .ð Ucð U e¨C°¨H¡oó Uð (Sð ( Só (ðI¨U°3¸°8©_ð IÀÀsÈCÐQTÀ}ÑAUó Ið2 UYñ,CØ c¨3 h¡Ñ0ð,CØDLÈSÁMð,Cà sC}Ñ ó,Cð\ u S¨# Xô r r3 c ó@ e Zd ZU dZdZeed< dZeed< dZeed< dZ eed< dZ
|
eed< dZ eed< d Z eed < d
|
Z eed
|
< d Zeed < d Zeed < d Zeed < dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZeed< dZ eed< dZ eed< dZ eed< d Z eed < d Z eed < d Z!eed < d Z"eed < d Z#eed < d!Z$eed!< d"Z%eed"< d#Z&eed#< e'd$ed%e(e fd&« Z)e'd'e*d%e(e fd(« Z+e'd%e,ed)f fd*« Z-y+),ÚSQLModea. 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.
|
|
The `SQLMode` class shouldn't be instantiated.
|
|
See http://dev.mysql.com/doc/refman/5.6/en/server-sql-mode.html
|
ÚMODE_rv Ú 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 r c ó t ©N©ÚNotImplementedErrorr s r r zSQLMode.get_descx ó ä!Ð!r r c ó t rt ru )r r s r r zSQLMode.get_info| rw r .c óÞ g }t | « j « D ]< }|j d« rt t | |« d« r,|j |« > t t |« « 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.
|
rL Ú__call__)ÚvarsÚkeysÚ
|
startswithÚhasattrÚgetattrr0 rO Úsorted)r r" Úkeys r r& zSQLMode.get_full_info s[ ð Ü9>>Ó#ò CØ>> #Õ&¬w´w¸sÀCÓ7HÈ*Õ/UØ
|
|
3ð ô VC[Ó!Ð!r N).r' r( r) r* rv rù r+ rT rU rV rÞ rW rX rY rZ r[ r\ r] r^ r_ r` ra rb rc rd re rf rg rh ri rj rk rl rm rn ro rp rq rr r, r r r÷ r r r& r r r rR rR J sÎ
ñ ð GSÓØ(M3Ó(Ø,OSÓ,Ø$KÓ$Ø&L#Ó&Ø HcÓ Ø 2ÐÓ2Ø#<ÐSÓ<Ø .ÐcÓ.Ø"JÓ"ØFCÓØE3ÓØCÓØE3ÓØ*NCÓ*Ø .ÐcÓ.Ø .ÐcÓ.Ø HcÓ Ø GSÓ ØD#ÓØ!8Ð3Ó8Ø 6Ð#Ó6Ø 4ÐÓ4Ø 0ÐsÓ0Ø,OSÓ,Ø&L#Ó&Ø(M3Ó(Ø&BÐ ÓBØ$KÓ$Ø 4ÐÓ4Ø 4ÐÓ4Ø":ÐCÓ:Ø#<ÐSÓ<àð"Cð " H¨S¡Mò "ó ð"ð ð"Sð " X¨c¡]ò "ó ð"ð ð "e C¨ Hoò "ó ñ "r rR )Er* r Úabcr r r r r r rþ r r
|
Útypingr r r r r r r r Úcharsetsr r Úerrorsr Ú tls_ciphersr r r r÷ r+ r r ÚMYSQL_VECTOR_TYPE_CODEÚMYSQL_DEFAULT_CHARSET_ID_57ÚMYSQL_DEFAULT_CHARSET_ID_80rZ rù rü r^ ri rj rk rî rô rõ Úvaluesrö rø rú rû ÚtypeÚ!NATIVE_SUPPORTED_CONVERSION_TYPESr r r r. r3 ru r r¨ rÕ rÿ r r r) r3 rR r r r ú<module>r sì ðò: 2ã ç ß 4Ó 4Ý Ý ß P× PÓ Pç CÝ $ß Gà Ð 3Ó Ø #Ð Ó #Ø!"Ð 3Ó "Ø IØ Ð ðð !Ð Ø !Ð ð7EØð7Eà
|
Bð7Eð ð7Eð ð 7Eð
|
ð 7Eð ð 7Eð Kð7Eð Dð7Eð 4ð7Eð 4ð7Eð yð7Eð ð7Eð tð7Eð eð 7Eð %ð 7Eð ð!7Eð" ñ#7Eð$ Eð%7Eð& ð'7Eð( $ð)7Eð* Dð+7Eð, Tð-7Eð. Að/7Eð0 ð17Eð2 ð37Eð4
|
5ð57Eð6 dð77Eð8 ð97Eð: tð;7Eð< uð=7Eð> 5ð?7Eð@ $ðA7EðB ðC7EðD EòE7EðF DðG7EðH dðI7EðJ $ðK7EðL tðM7EðN
|
4ðO7EðP %ðQ7EðR 4ðS7EðT %ðU7EðV ! $ðW7EðX uðY7EðZ $ð[7Eð\ uð]7Eð^ ð_7Eð` Tða7Eðb tðc7Eðd $ðe7Eðf ñg7Eðh ØØ òm7EÐ tC ¨%°°T¸3°Ñ*?Ñ!@Ð @ÑAó 7ðr 'W uS#s]Ñ#Ó Vð " uS#Xó ð"Ð 3ó ð 0Ð2IÑI d3iÓ IØ QðG)Ø ðG)à% ðG)ð & ðG)ð &Ð':ð G)ð
|
&Ð':ð G)ð )Ð*@ð G)ð )Ð*@ðG)ð )Ð*DðG)ð )Ð*DðG)ð )Ð*@ðG)ð )Ð*@ðG)ð )Ð*DðG)ð )Ð*DðG)ð *Ð+Bð G)ð *Ð+Bð G)ð *Ð+Fð!G)ð" *Ð+Fñ#G)ð$ *Ð+Bð%G)ð& *Ð+Bð'G)ð( *Ð+Fð)G)ð* *Ð+Fð+G)ð, ,Ð-Fð-G)ð. ,Ð-Fð/G)ð0 ,Ð-Jð1G)ð2 ,Ð-Jð3G)ð4 .Ð/Jð5G)ð6 .Ð/Jð7G)ð8 .Ð/Nð9G)ð: .Ð/Nð;G)ð< *Ð+>ð=G)ð> *Ð+>ð?G)ð@ *Ð+BðAG)ðB *Ð+BðCG)ðD LòEG)ðF LðGG)ðH Ð 4ðIG)ðJ Ð 4ðKG)ðL mðMG)ðN mðOG)ðP !Ð"7ðQG)ðR !Ð"7ðSG)ðT #Ð$<ðUG)ðV #Ð$<ðWG)ðX %Ð&?ðYG)ðZ %Ð&?ð[G)ð^ 'Ð(<ð_G)ð` 'Ð(<ðaG)ðb +Ð,HðcG)ðd +Ð,HðeG)ðf +Ð,HðgG)ðh +Ð,HòiG)ðj /Ð0PðkG)ðl /Ð0PðmG)ðn -Ð.HðoG)ðp -Ð.HðqG)ðr 'Ð(@ðsG)ðt 'Ð(@ðuG)ðv +Ð,HðwG)ðx +Ð,HðyG)ðz +Ð,Hð{G)ð| +Ð,Hð}G)ð@ 3Ð4TðAG)ðB 3Ð4TðCG)ðD 1Ð2PðEG)ðF 1Ð2PðGG)ðJ ðKG)ðL Ð /ðMG)ðN Ð /òOG)ðP MðQG)ðR Ð!7ðSG)ðT Ð 4ðUG)ðV Ð 4ðWG)ðX Ð 1ðYG)ðZ $Ð%?ð[G)ð\ #Ð$<ð]G)ð^ #Ð$<ð_G)ð` Ð 1ðaG)ðb $Ð%?ðcG)ðd #Ð$<ðeG)ðf #Ð$<ðgG)ðh "Ð#:ðiG)ðj "Ð#:ðkG)ðl &Ð'BðmG)ðn &Ð'BðoG)ñp &Ñ'BòqG)ñr &Ñ'BðsG)ñt "Ñ#:ðuG)ñv "Ñ#:ðwG)ñx Ñ -ðyG)ñz Ñ -ð{G)ñ| &Ñ'Bð}G)ñ~ &Ñ'BðG)ñ@ Ñ 5ðAG)ñB Ñ 5ðCG)ñD &Ñ'BðEG)ñF &Ñ'BðGG)ñH Ñ 5ðIG)ñJ Ñ 5ðKG)ñL !Ñ"5ðMG)ñN &Ñ'CðOG)ñP %Ñ&@ðQG)ñR %Ñ&@òSG)ñT (Ñ)FðUG)ñV (Ñ)FðWG)ñX Ñ 3ðYG)ñZ !Ñ"9ð[G)ñ\ !Ñ"9ð]G)ñ^ 'Ñ(@ð_G)ñ` 'Ñ(@ðaG)ñb +Ñ,HðcG)ñd +Ñ,HðeG)ñf +Ñ,HðgG)ñh +Ñ,HðiG)ñj -Ñ.LðkG)ñl -Ñ.LðmG)ñn Ñ ,ðoG)ñp Ñ ,ðqG)ñr Ñ 4ðsG)ñt Ñ 4ñuG)ñv 0Ù /Ù"7Ù"7á3PÙ5TÙ1LÙ-DÙ3PÙ1LÙ1LóMG)Ð tC H~ô GñV 7Ù 6Ù$BÙ 6Ù :ò )Ð tC H~ô ð %Ø$ò0Ð 4T # s (^Ð+Ñ,ô ð %×+Ñ+Ó-Ø$×+Ñ+Ó-ò0Ð $sJ sOÐ+Ñ,ô ð Ø 7ØØ 7Ø {Ø&ÙJ
|
Ø jØ&Ø&Ø Ø {Ø Yð%Ð !ð 5ñ cñ #ñ ¨$ô ñ3ñ ¨#ñ °cñ ¸cô ö$ ô öD Zô ö O
|
|
ô O
|
öd:ô :öz.Gô .ö(F
|
mö FöRvô vör?ô ?öD
|
ô
|
ö JÐ*;ö ö2+:ô +÷\Fó FöRC"jõ C"r
|
