,hdZdgZddlZddlZddlZddlZddlZddlZddlZddl Z ddl m Z ddl m Z ddlmZmZmZmZmZmZmZmZmZmZmZddlmZdd lmZdd lmZm Z m!Z!m"Z"m#Z#m$Z$dd l%m&Z&m'Z'm(Z(m)Z)m*Z*m+Z+m,Z,m-Z-m.Z.m/Z/m0Z0dd l1m2Z2m3Z3m4Z4m5Z5dd l6m7Z7m8Z8m9Z9m:Z:m;Z;mZ>ddl?m@Z@mAZAmBZBmCZCmDZDmEZEddlFmGZGmHZHddlImJZJmKZKmLZLddlMmMZMddlNmOZOmPZPmQZQmRZRmSZSmTZTmUZUmVZVddlWmWZWddlXmYZYmZZZGddeJZ[y)zDImplemention of the communication with MySQL servers in pure Python.MySQLConnectionN)Decimal)IOBase) AnyAsyncGeneratorBinaryIODictListMappingOptionalSequenceTupleTypeUnion)version)get_local_infile_filenames) ClientFlag FieldType RefreshOption ServerCmd ServerFlag flag_is_set) ConnectionTimeoutError DatabaseErrorErrorInterfaceError InternalErrorNotSupportedErrorOperationalErrorProgrammingErrorReadTimeoutErrorWriteTimeoutError get_exception) EOF_STATUS ERR_STATUSLOCAL_INFILE_STATUS OK_STATUS)BinaryProtocolTypeDescriptionType EofPacketType OkPacketType ResultTypeRowTypeStatsPacketType StrOrBytes) get_platform int1store int4storelc_intwarn_ciphersuites_deprecatedwarn_tls_version_deprecated)cmd_refresh_verify_optionshandle_read_write_timeout)MySQLConnectionAbstractMySQLCursorAbstract ServerInfo)charsets) MySQLCursorMySQLCursorBufferedMySQLCursorBufferedDictMySQLCursorBufferedRawMySQLCursorDictMySQLCursorPreparedMySQLCursorPreparedDictMySQLCursorRaw)logger)MySQLTcpSocketMySQLUnixSocketceZdZUdZdZeed<edeefdZ d`dZ d`dZ d e de fd Zd`d Zd`d Zd edefdZdeddfdZd edefdZe dade deedeedefdZe dad edeedeede fdZd edee effdZed edeeeeeeefffdZ e dbdedeeded eede!dedeedeedee"fdZ#e dcde$d e!deedeede"f d!Z%de!fd"Z&de!fd#Z' ddd$e!d%ed&eddfd'Z(d`d(Z)d`d)Z*e*Z+ ded*ee!d+ee!d,ee!d-ee,e-d.ee!deedeede.fd/Z/e dcd0e!d1eeed+ee!d2e0deee1eeff d3Z2e dfd4eed0e!d1eeed+ee!d5e0d2e0deee1eeffd6Z3d`d7Z4d`d8Z5de!fd9Z6d:e defd;Z7 dgd e8d+e!d*e!de8d2e0de:e dffd?Z; dhd@edAed2e0ddfdBZ<edCed2e0de=e eeeefffdDZ> did@edEe?e@dFe?e0ded2e0deeeeeeefff dGZAd@ed2e0ddfdHZBd@ed2e0ddfdIZCeDdJedefdKZEd@edLedEe$d2e0def dMZFdefdNZGdjdOeeddfdPZHdeIfdQZJdRedefdSZKdefdTZLdefdUZM dkdVe dWe d:e dXeedYe dZe d[e d\e d]e d^e deefd_ZNy)lrz3Implementation of the pure Python MySQL connection.r7 _mfa_nfactorreturncR|jr|jjdSy)zMySQL connection ID.server_threadidN) _handshakegetselfs `/var/www/html/Resume-Scraper/venv/lib/python3.12/site-packages/mysql/connector/aio/connection.py connection_idzMySQLConnection.connection_id|s$ ????&&'89 9Nc K |jr/tjdk(rt|j|_n&t |j |j|_tj|jj|jd{|jd{|jd{|j(t*j,zr|jj/ |j0|_|j9d{|j:st=|jj>d rktA|jj>jBrA|jj>jCd \}}}tE|tG||yyyy7/77#t$r|}|jjd{7t!|tj"tj$fr)t'dd|j d|jd|d}~wwxYw#t4$r}t7d |d}~wwxYw7Lw) Nposix) unix_socket)hostportiz!Can't connect to MySQL server on :z (timed out))errnomsgzFConverter classA should be a subclass of conversion.MySQLConverterBaseget_extra_infocipher)$ _unix_socketosnamerH_socketrG_host_portasynciowait_foropen_connection_connection_timeout _do_handshake_do_auth Exceptionclose_connection isinstanceCancelledError TimeoutErrorr _client_flagsrCOMPRESSswitch_to_compressed_mode_converter_classconverter_class TypeErrorAttributeError_post_connection _ssl_disabledhasattr_writercallabler]r6r5)rQerrr^ tls_version_s rRconnectzMySQLConnection.connects   RWW%7.4;L;LM -4::DJJO "" ,,.0H0H  $$& & &--/ ! !    3 3 3 LL 2 2 4 #'#8#8D ##%%%"" ,,.>?--<<=&*\\%9%9%H%H%R "FK ' 4 ( =>@#A  ' ! ,,//1 1 1# 6 68L8LMN,;DJJH?AIIJ I:) I55I::Jc t}tjjd}|ddk(rd}nd}t t j |dtjd|djtjdd Dcgc] }t |c}|d d }|jj|y cc}w) z&Add the default connection attributes. rGPLv2zGPL-2.0 Commercialarchzmysql-connector-python.r)_pid _platform _source_host _client_name_client_license_client_version_osN) r1rLICENSEsplitstrr`getpidsocket gethostnamejoinVERSION_connection_attrsupdate)rQplatformlicense_chunksclient_licensexdefault_conn_attrss rR_add_default_conn_attrsz'MySQLConnection._add_default_conn_attrss> ..s3 !  '&N)N $!&)"..04-"xx19M(NAQ(NOI&  %%'9; )Os CqueryctK|jd{|j|d{S77w)zExecute a query. This method simply calls cmd_query() after checking for unread result. If there are still unread result, an InterfaceError is raised. Otherwise whatever cmd_query() returns is returned. N)handle_unread_result cmd_query)rQrs rR_execute_queryzMySQLConnection._execute_querys5'')))^^E*** **s848688c K|jjd{}tjd||dtk(r t ||j j||_t|jd|jd|jd|jd|jd|jd |jd |jd  |_ tj|jjd tjd|jj|jr<|j r0tj"|j|j |_na|jr%tj&|j|_n0|j r$tj(|j |_|jd t*j,zs~|j.s4|j0dk(r t3d|j0dk(r t3d|j4r t3dd|xj6t*j,zc_n/|j8s#|xj6t*j,zc_|jd t*j:zrt*j:g|_|jd t*j>zr'd|j_ t*j>g|_|jd t*jBzrt*jBg|_yy7Sw)z(Get the handshake from the MySQL server.NzProtocol::Handshake packet: %sprotocolserver_version_originalrMcharset server_status auth_plugin auth_data capabilities)rr thread_idr status_flagsrrrrzProtocol::Handshake charset: %smysql_clear_passwordzEClear password authentication is not supported over insecure channels$authentication_openid_connect_clientzEOpenID Connect authentication is not supported over insecure channelsz1SSL is required but the server doesn't support iti)r[T)"rbreadrFdebugr&r$ _protocolparse_handshakerNr< _server_infor=set_mysql_major_version version_tupler _charset_name_charset_collationget_by_name_and_collation_charset get_by_nameget_by_collationrSSL is_secure _auth_pluginr_ssl_verify_certrprx PLUGIN_AUTH client_flagsCLIENT_QUERY_ATTRIBUTESquery_attrs_is_supportedMULTI_FACTOR_AUTHENTICATIONrQpackets rRrizMySQLConnection._do_handshakes||((** 5v> !9 "' '..88@&__Z0OO$=>oo&78OOI.9 6ook28   (():):)H)H)KL 68I8I8Q8QR   $"9"9$>>""D$;$;DM  $001C1CDDM  $ $$55d6M6MNDM~.?>>$$(>>(,$$(NN(,$$$G   :>>/ 1 ##   *.. 0  ??> *Z-C-C C!+!7!7 8D  ??> *Z-O-O O9=D   6!+!C!C DD  ??> *Z-S-S S!+!G!G HD  Ty+sM6M3MM6cK|jr|jjds:|jr~|jjdrctjdk(rP|jsDt j |_tjd|j|j|jr%|j|jk7r |jn |j}d|_ |js |jtjzr|j j#|j$|j&|j(|j*|j,|j.|j0}|j2j5|j6j8|j}|j j;|d{|j j=|d{d |_ |j>jA|jB|jD|jF|jH|jJd  |j>jM|j |jN|j||jP|jR|jT|j6j8|j|j|j|jV|jX d{}|j[||jtj\zs1|jTr$|j_|jTd{yyy77u7j7w) afAuthenticate with the MySQL server. Authentication happens in two parts. We first send a response to the handshake. The MySQL server will then send either an AuthSwitchRequest or an error packet. Raises NotSupportedError when we get the old, insecure password reply back. Raises any error coming from MySQL. authentication_ociauthentication_kerberosntz4MySQL user is empty, OS user: %s will be used for %sF)ssl_cassl_certssl_keyssl_verify_certssl_verify_identity tls_versionstls_cipher_suites)rrNT)krb_service_principaloci_config_fileoci_config_profilewebauthn_callbackopenid_token_fileconfig) sock handshakeusername password1 password2 password3databaserr ssl_enabledrauth_plugin_class conn_attrs)0r startswithr`ra_usergetpassgetuserrFr _password1 _password _ssl_activerxrprrrbbuild_ssl_context_ssl_ca _ssl_cert_ssl_keyr_ssl_verify_identity _tls_versions_tls_ciphersuitesr make_auth_sslr charset_idwrite switch_to_ssl_authenticatorupdate_plugin_config_krb_service_principal_oci_config_file_oci_config_profile_webauthn_callback_openid_token_file authenticaterN _password2 _password3 _database_auth_plugin_classr _handle_okCONNECT_WITH_DB cmd_init_db)rQpassword ssl_contextrok_pkts rRrjzMySQLConnection._do_auths   !!,,-AB!!%%001JKGGtO** *DJ LLF !! 4>>T__#D OO  !!!t'9'9JNN'J,,88|| $ 5 5$($=$=!//"&"8"89K!NN88 00t?Q?Q9F,,$$V, , ,,,,,[9 9 9#D  00)-)D)D#'#8#8&*&>&>%)%<%<%)%<%<  1 **77ooZZoooo^^MM,,++(())"55--8   ""Z%?%??T^^""4>>2 2 2FT?A - 9 $ 3sJG!N#M8$"NM;D NM>AN0N1N;N>NNrc|dtk(r1|jj|}|j|d|S|dtk(r t |t d)zHandle a MySQL OK packet. This method handles a MySQL OK packet. When the packet is found to be an Error packet, an error will be raised. If the packet is neither an OK or an Error packet, InterfaceError will be raised. r status_flagzExpected OK packet)r(rparse_ok_handle_server_statusr&r$r)rQrrs rRrzMySQLConnection._handle_okgs_ !9 !^^,,V4F  & &vm'< =M !9 "' '122rTflagscttj||_ttj||_y)aHandle the server flags found in MySQL packets. This method handles the server flags send by MySQL OK and EOF packets. It, for example, checks whether there exists more result sets or whether there is an ongoing transaction. N)rrMORE_RESULTS_EXISTS_have_next_resultSTATUS_IN_TRANS_in_transaction)rQr s rRr z%MySQLConnection._handle_server_statusvs."-Z-K-KU!S*:+E+EuMrTc|dtk(r1|jj|}|j|d|S|dtk(r t |t d)aHandle a MySQL EOF packet. This method handles a MySQL EOF packet. When the packet is found to be an Error packet, an error will be raised. If the packet is neither and OK or an Error packet, InterfaceError will be raised. rr zExpected EOF packet)r%r parse_eofr r&r$r)rQreofs rR _handle_eofzMySQLConnection._handle_eofs_ !9 "..**62C  & &s='9 :J !9 "' '233rTfilename read_timeout write_timeoutcK|j1t|j|_|js"td|js tdtj j |}tj j |jj}tj j|std|dtj j|std|d tj j||std|d|d  tj j|r td |js|js td |js{|jrotj j |j}d} tj j!||g}||k7rd } t| j%|| t)|d} |j+|j-| d||d{ | j/S#t$r }t|d}~wwxYw#t"$r-}d } t| j%t'||||d}~wwxYw7j#t0t2f$rYSwxYw#t0$rd |j4j7d|xs |j8d{7n#t:$r}td|d}~wwxYwtd|ddwxYw#  j/w#t0t2f$rYwwxYwxYww)z(Handle a LOAD DATA INFILE LOCAL request.NzxNo `LOCAL INFILE` statements found in the client's request. Check your request includes valid `LOCAL INFILE` statements.zGot more `LOCAL INFILE` responses than number of `LOCAL INFILE` statements specified in the client's request. Please, report this issue to the development team.zLocation specified by filename z& from client's request does not exist.z' from server's response does not exist.z Filename z8 from the server's response is not the same as filename z from the client's request.z#Use of symbolic link is not allowedKLOAD DATA LOCAL INFILE file request rejected due to restrictions on access.zL{} while loading file `{}` and path `{}` given in allow_local_infile_in_pathzEThe file `{}` is not found in the given allow_local_infile_in_path {}rbTrTrMySQL Connection not availablezFile 'z' could not be read)_local_infile_filenamesr_queryrr`pathabspathpopleftexistssamefileOSErrorislinkr _allow_local_infile_allow_local_infile_in_pathr commonpath ValueErrorformatropenr _send_datacloseIOError NameErrorrbr_write_timeoutrv) rQrrr file_namefile_name_from_requestr| infile_pathc_patherr_msg data_files rR_handle_load_data_infilez(MySQLConnection._handle_load_data_infiles_  ' ' /+Edkk+RD (//$S-- 1  GGOOH- !#1M1M1U1U1W!Xww~~45 12H1IJ88  ww~~i( 1)=++  *77##I/EF$ {+##9":;((G 77>>) $"#HI I''0P0P* ''D,L,L''//$*J*JKKF ++[),DE$4$GNN9k$JKK Y-I??ooi|]SS !a * c ) *  5%NN3s8Y D  &TY'   T Rll((}'K8K8K)" R&'GHcQ R 6)4G!HIt S T !Y'  sDM 2IJ??M L/ .L:K=;LL/ L LLL//L22M4MMMMMMMc|K|rt|dkr td|dtk(r|j|S|dtk(r.|ddj }|j |||d{S|dtk(r|j|S|dtk(r t||jj|}|rt|ts tddg|z|_t!d|D]d}|jj#|j$j'|xs |j(d{|j*|j|<f|j|j$j'|xs |j(d{}d|_|j|dS7E7{7#w) auHandle a MySQL Result. This method handles a MySQL result, for example, after sending the query command. OK and EOF packets will be handled and returned. If the packet is an Error packet, an Error-exception will be raised. The dictionary returned of: - columns: column information - eof: the EOF-packet information rEmpty responseNzIllegal result setrT)columnsr)lenrr(rr'decoder8r%rr&r$rparse_column_countrmint _columns_descrange parse_columnrbr _read_timeoutpython_charset unread_result)rQrrrr column_countirs rR_handle_resultzMySQLConnection._handle_results"Vq !12 2 !9 !??6* * !9+ +abz((*H66,   !9 "##F+ + !9 "' '~~88@ :lC#@ !56 6  q,' A$(NN$?$?ll'' (J8J8JKK##%D  q !  ,,##L$FD4F4FG G "--c::5$L Hs8A.F<0F51C F<<F8 =AF<F:F<8F<:F<c|dtk(r|jj|S|dtk(r t |t d)a>Handle a MySQL Binary Protocol OK packet This method handles a MySQL Binary Protocol OK packet. When the packet is found to be an Error packet, an error will be raised. If the packet is neither an OK or an Error packet, InterfaceError will be raised. Returns a dict() rzExpected Binary OK packet)r(rparse_binary_prepare_okr&r$rrs rR_handle_binary_okz!MySQLConnection._handle_binary_ok&sH !9 !>>99&A A !9 "' '899rTcK|rt|dkr td|dtk(r|j|S|dtk(r|j |S|dt k(r t||jj|}|rt|ts tddg|z}td|D]V}|jj|jj|j d{|j"||<X|j |jj|j d{}|||fS7Y7w)aHandle a MySQL Result This method handles a MySQL result, for example, after sending the query command. OK and EOF packets will be handled and returned. If the packet is an Error packet, an Error exception will be raised. The tuple returned by this method consist of: - the number of columns in the result, - a list of tuples with information about the columns, - the EOF packet information as a dictionary. Returns tuple() or dict() rr:zIllegal result set.Nr)r=rr(rr%rr&r$rr?rmr@rBrCrbrrDrE)rQrrGr<rHrs rR_handle_binary_resultz%MySQLConnection._handle_binary_result6s>"Vq !12 2 !9 !??6* * !9 "##F+ + !9 "' '~~88@ :lC#@ !67 7*.,)>q,' A44ll''(:(:;;T=P=PGAJ  T\\%6%6t7I7I%JJKgs++ < Ks%C7E9E :A EEEEcommandargument packet_numberexpect_responsecompressed_packet_numberc K|jd{ |jj|jj ||xs||||xs |j d{|sy|jj|xs |jd{S77:#t $r} td| d} ~ wwxYw7%w)aSend a command to the MySQL server. This method sends a command with an optional argument. If packet is not None, it will be sent and the argument will be ignored. The packet_number is optional and should usually not be used. Some commands might not result in the MySQL server returning a response. If a command does not return anything, you should set expect_response to False. The _send_cmd method will then return None instead of a MySQL packet. Nr) rrbrr make_commandr1rvr rrD) rQrOrPrQrrRrSrrr|s rR _send_cmdzMySQLConnection._send_cmd^s.''))) N,,$$++GV5GxH(4!4!4   \\&&|'It7I7IJJJ *   N"#CD# M N KsQCB"CA B&)B$*B&./CCC$B&& C/ B;;CCr7send_empty_packetcK|jd{t|ds tdd} |j|dz }|rJ|jj ||xs |j d{|j|dz }|rJ|r3 |jj d|xs |j d{|jj|xs |jd{}|S77#t$r}td|d}~wwxYw7X#t$r}td|d}~wwxYw7Fw) a4Send data to the MySQL server This method accepts a file-like object and sends its data as is to the MySQL server. If the send_empty_packet is True, it will send an extra empty package (for example when using LOAD LOCAL DATA INFILE). Returns a MySQL packet. Nrzexpecting a file-like objectrrrT) rryr*rrbrr1rvr rD) rQr7rWrr chunk_sizebufr|ress rRr-zMySQLConnection._send_datasL"'')))y&);< <  N..b1Cll((}'K8K8K) nnZ"_5   Rll((m.Rt?R?RSSSLL%%l&Hd6H6HII / * N"#CD# M N T! R&'GHcQ RJsD?C=D?AD9C?:DD?-D DD ,D?6D=7D??D D DDD?D D:) D55D::D?cdt|jxr|jjS)zReports whether the socket is connected. Instead of ping the server like ``is_connected()``, it only checks if the socket connection flag is set. )boolrb is_connectedrPs rRis_socket_connectedz#MySQLConnection.is_socket_connecteds% DLL@T\\%>%>%@AArTc`K |jd{y7#t$rYywxYww)aReports whether the connection to MySQL Server is available. This method checks whether the connection to MySQL is available. It is similar to ``ping()``, but unlike the ``ping()`` method, either `True` or `False` is returned and no exception is raised. NFT)cmd_pingrrPs rRr`zMySQLConnection.is_connecteds5 --/ ! ! "  s(.. +.+. reconnectattemptsdelaycK |jd{y7#t$r5}|r|j||d{7n td|Yd}~yd}~wwxYww)a Check availability of the MySQL server. When reconnect is set to `True`, one or more attempts are made to try to reconnect to the MySQL server using the ``reconnect()`` method. ``delay`` is the number of seconds to wait between each retry. When the connection is not available, an InterfaceError is raised. Use the ``is_connected()`` method if you just want to check the connection without raising an error. Raises: InterfaceError: On errors. N)rerfz$Connection to MySQL is not available)rcrrdr)rQrdrerfr|s rRpingzMySQLConnection.pingsZ" V--/ ! ! VnnhenDDD$%KLRUUE VsBA A  AAAAA AA cK|jsy |jjd{y7#t$rYywxYww)ahShut down connection to MySQL Server. This method closes the socket. It raises no exceptions. Unlike `disconnect()`, `shutdown()` closes the client connection without attempting to send a QUIT command to the server first. Thus, it will not block if the connection is disrupted for some reason such as network failure. N)rbrlrkrPs rRshutdownzMySQLConnection.shutdowns>||  ,,//1 1 1   s0A646A6 AAAAcKtjt5t|jD]}|j d{|jj |jr2|jjr|jd{ddd|jr"|jjd{d|_y77D#1swYCxYw7wN) contextlibsuppressrtuple_cursorsr.clearrbr`cmd_quitrl)rQcursors rRr.zMySQLConnection.closes   ' & . %lln$$ % MM   !|| 9 9 ;mmo%%  & <<,,//1 1 1 %&  & & 2sMC7,C)C% AC)"C'#C)'1C7C5 C7%C)'C))C2.C7bufferedrawprepared cursor_class dictionaryc *K|jr|jjs td| t|tr|dkr t d| t|tr|dkr t d|j d{|%t|ts td||||S||n |j}||n |j}d}|dur|dz}|dur|d z}|dur|d z}|dur|d z}tttttt t"t$d } | ||||S7#t&$rOd } dj)t+d D cgc]} |d| zzdk7s| | ncc} wc} } t-d| dwxYww)aInstantiate and return a cursor. By default, MySQLCursor is returned. Depending on the options while connecting, a buffered and/or raw cursor is instantiated instead. Also depending upon the cursor options, rows can be returned as a dictionary or a tuple. It is possible to also give a custom cursor through the cursor_class parameter, but it needs to be a subclass of mysql.connector.aio.abstracts.MySQLCursorAbstract. Raises: ProgrammingError: When cursor_class is not a subclass of MySQLCursor. ValueError: When cursor is not available. InterfaceError: When read or write timeout is not a positive integer. rNrz.Option read_timeout must be a positive integerz/Option write_timeout must be a positive integerz8Cursor class needs be to subclass of MySQLCursorAbstractTr7rrrZ)rr7rrrr;rZ)rtrurxrvz, z*Cursor not available with given criteria: )rbr`r rmr@rr issubclassr>r! _buffered_rawr?rErArBr@rCrDKeyErrorrrBr*) rQrtrurvrwrxrr cursor_typetypesargsrHcriterias rRrszMySQLConnection.cursors6||4<<#<#<#>"#CD D  #<-1A !QR R  $=#.-!2C !RS S'')))  #lK8&N!$ mD D'38_c$)) t  1 K $; 1 K   1 K t  2 K"%&#'   &E+&lMJ JC *D @Dyy"'(JQkQ!V.D.IaJJH !c{ s 424r prep_stmtcK| |j}|js tdgdf} |jdd}|rS|j} | dk(rd} |j j |j||| |xs |jd{}nR|j j|j|jj||xs |jd{}|\}} |sR|sP|jD|rBt|dr6|jj } |D cgc]} | | |j}} | $|j#d| vr| dn| d d|_|| fS77#t$r} d|_| d} ~ wwxYwcc} ww) zGet all rows returned by the MySQL server. This method gets all rows returned by the MySQL server after sending, for example, the query command. The result is a tuple consisting of a list of rows and the EOF packet. NzNo result set availablerutf8mb4utf8F converterr r)r}rFrrOrrread_binary_resultrbrDread_text_resultrrrrAryr row_to_pythonr )rQrrr<rurrrrrr|eof_prrows rRrzMySQLConnection.get_rowshs ;))C!! 9: :GI4j !::nd;L,,i'$G!^^>>LL 6D$6$6 "^^<<LL%%-- 6D$6$6  e3"".k* NN88MFJKsM#t'9'9:KDK    & & E)m$?+  "'D U{I  !&D I LsZ*F A!E-E)AE-!E+"E-&=F #F=,F )E-+E-- F6 E??FF cBK|jdd{y7w)zCommit current transaction.COMMITN)rrPs rRcommitzMySQLConnection.commits!!(+++ cK|jr|jd{|jdd{y77w)zRollback current transaction.NROLLBACK)rFrrrPs rRrollbackzMySQLConnection.rollbacks;   --/ ! !!!*--- "-s AAAAAAcK |j|jtjd{|j d{y7!7#t t f$rYywxYww)zResets the session state without re-authenticating. Reset command only works on MySQL server 5.7.3 or later. The result is True for a successful reset otherwise False. NTF)rrVrRESET_CONNECTIONrwrr rPs rRcmd_reset_connectionz$MySQLConnection.cmd_reset_connections_   OO$..1K1K"LL M'') ) )M )!#34  sJA,-AAA AAA,AAA)&A,(A))A,rcK|j|jtj|j dd{S7w)zChange the current database. This method changes the current (default) database by sending the INIT_DB command. The result is a dictionary containing the OK packet infawaitormation. zutf-8N)rrVrINIT_DBencode)rQrs rRrzMySQLConnection.cmd_init_dbs< ..!2!2HOOG4LM M  Ms>A A  A  raw_as_stringc Kt|ts+t|tr|j}t|}||_d|_|j jdk7r|j jnd}t}|jjs'|jrtjdt|jtj zrUg}g} g} dgt#|jdzdzz} t%|jD]2\} } | d}d}|K| | dzxxd| dzzzcc<| j't)t*j,t)|z[t|t.r2|j0j3|\}}}| j'|n6t|trI|j|}| j't5t#||zt*j6}nt|t8r8| j't5t#||zt*j:}nt|t<rh| j't5t#t|j|t|j|zt*j>}nt|t@r6| j'tCjDd |t*jF}nt|tHjHtHjJfr0|j0jM|\}}| j'|n}t|tHjNtHjPfr0|j0jS|\}}| j'|n#tUd |jVjXd | j't)|t)|z| dj|}|j't5t#||z5|j[t5t#|j|j[t5d| r|j[d j]| Dcgc]}tCjDd |c}t)dzt_| |D]'\}}|j[||j[|)| D]}|j[||j[|t9|} |jadd}|jadd}|jc|jetfjh|||d{||d{}|Scc}w77 #tT$r1}|jjdk(rd|jlvrd}to||d}~wwxYww)NrrO>O MMN      B B BEE"$F##d&7&7"81"<!BCK#,T->->#?. 7Z"1 =+qS1W~=+LL9>>!:Yu=M!MNeS) ==eD "MM&)s+!LL1EMM&U"4u"<=!*!2!2Ju-MM&U"4u"<=!*Jw/MMs3u:#4#4W#=>?e*++G45"+!2!2Ju-MM&++dE":;!*!1!1J(9(98=='IJ??F"MM&)(:(:HMM'JK+/>>+M+Me+T(VZMM&)*!OO445Y@ Yz2Yu5EEF!!}++G4 VCI.56]. 7b MM&T%6%6!78 9 MM&) $ HH{Kfkk#s3KLl#$'ue#4(KE4MM%(MM$'($)EMM%()  ef  !::nd;L"JJ=M..nnOO!-"/ %   F$ CL    yyD %E%P1$G,#5  s\R3X5V> BXAW)W* W7W8W<XWW X,W<<XX statementsc K |jdd}|jdd}t}t|ts,t|tr|j d}t|}|j t jzr4|jtd|jtd|j|t|}|j|jtj|||d{||d{|jrs|j!d{|j|j"j%|xs |j&d{||d{|jrryy777d7*7#t(t*f$r}|d}~wwxYww)acSend one or more statements to the MySQL server. Similar to the cmd_query method, but instead returns a generator object to iterate through results. It sends the statements to the MySQL server and through the iterator you can get the results. statement = 'SELECT 1; INSERT INTO t1 VALUES (); SELECT 2' for result in await cnx.cmd_query(statement, iterate=True): if 'columns' in result: columns = result['columns'] rows = await cnx.get_rows() else: # do something useful with INSERT result rNrrrr7r)rOrrmrrrprrrr4rrIrVrrrrrbrrDr"r#)rQrrrrrrr|s rRcmd_query_iterzMySQLConnection.cmd_query_iterDs&' !::nd;L"JJ=M[Fj)4j#.!+!2!26!:J&z2 !!J$F$FF fQi( fQi( MM* %&ME++nnOO!-"/ %    ((//111 //,,++L,ND F, F* F, G"F,$F,&F,(F,*F,,G;F==GG statement_idrcK|jdd}|jdd}|jj||}d|_|j t j |d||d{d|_y7 w)zFetch a MySQL statement Result Set. This method will send the FETCH command to MySQL together with the given statement id and the number of rows to fetch. rNrFrRrrT)rOrmake_stmt_fetchrFrVr STMT_FETCH)rQrrrrrrs rRcmd_stmt_fetchzMySQLConnection.cmd_stmt_fetchszz.$7  ?D9 // dC"nn  !%'    " sA/B1A>2 B statementc K|jdd}|jdd}|jtj|||d{}|j |}g|d<g|d<|ddkDrt d|dD]i}|dj |jj|jj|xs |jd{|jk|j|jj|xs |jd{|d dkDrt d|d D]i}|dj |jj|jj|xs |jd{|jk|j|jj|xs |jd{|S77"77c7w) zPrepare a MySQL statement. This method will send the PREPARE command to MySQL together with the given statement. rNrrr< parameters num_paramsr num_columns)rOrVr STMT_PREPARErLrBrrrCrbrrDrEr)rQrrrrrrr~s rRcmd_stmt_preparez MySQLConnection.cmd_stmt_prepareszz.$7  ?D9 ~~  " " %' &   ''/y!| , ! #1f\23 |$++NN//"ll// 0R@R@RSS++    ll'' (J8J8JKK  - 1 $1f]34 y!((NN//"ll// 0R@R@RSS++    ll'' (J8J8JKK  C T L T Ls^A H G5BHG8AH'G;(A1HG=AH*G?+ H8H;H=H?Hdatarc Kt|}i}|jdd}|jdd}|rbt|D]T\} } t|| tsd} d|| j v} |j|| || ||d{| f|| <V|js'|jrtjdt|jtjzrJ|j j#||t%||||j&|j|j(} n?|j j#||t%||||j&|j( } |j+t,j.| || d{} |j1| d{}|S#t $rYTwxYw7<727w) z#Execute a prepared MySQL statement.rNrTbrrr)converter_str_fallback)rrr)listrOrrmrmodervcmd_stmt_send_long_data_query_attrs_supportedrrrrrprrrmake_stmt_executeror_converter_str_fallbackrVr STMT_EXECUTErN)rQrrrr rlong_data_usedrrparam_idr~rexecute_packetrrs rRcmd_stmt_executez MySQLConnection.cmd_stmt_executes*% zz.$7  ?D9 (4 9 !d8nf5!F!$DN,?,?!?66$ X%1&3 717yN8, 9**t/@/@ MMN      B B B!^^==j! !!,, N"^^==j! '+'C'C>N~~  " "!%' &   11&99 W*D :saAGGF7/G G D GG G0G 1G7 GGGG G Gc K|j|jtjt ||j dd|j ddd{y7 w)z}Reset data for prepared statement sent as long data. The result is a dictionary with OK packet information. rNrr)rrVr STMT_RESETr3rOrQrrs rRcmd_stmt_resetzMySQLConnection.cmd_stmt_resets\ ..$$,'#ZZ=$jj$? !   sAA)A' A)c K|jtjt|d|j dd|j ddd{y7w)zDeallocate a prepared MySQL statement. This method deallocates the prepared statement using the statement_id. Note that the MySQL server does not return anything. FrNrr)rVr STMT_CLOSEr3rOrs rRcmd_stmt_closezMySQLConnection.cmd_stmt_closesS nn  l #!ND9 **_d;    sAAAAoptionscVK|tjtjztjztjztj ztj zzs tdd}|tjzr|jdd{}|tjzr|jdd{}|tjzr|jdd{}|tjzr|jdd{}|tj zr|jdd{}|tj zr4|j|jjdkrdnd d{}|S77777U7w) NzInvalid command REFRESH optionzFLUSH PRIVILEGESz FLUSH LOGSz FLUSH TABLESz,TRUNCATE TABLE performance_schema.host_cachez FLUSH STATUS)rrz RESET SLAVEz RESET REPLICA) rGRANTLOGTABLESHOSTSTATUSREPLICAr*rrr)rQrr]s rR cmd_refreshzMySQLConnection.cmd_refresh"sr    "" #   !""  # ##  $ => > ](( ('9::C ]&& &|44C ])) )~66C ]'' ''UVVC ])) )~66C ]** *$$22Z?$C  !;46V6smBF)F +F) F +F)7F!8+F)#F#$+F)F%AF)F'F)F)!F)#F)%F)'F)rc Kd}d} |j|}|r|jj|||}|jtj |d|j dd|j ddd{|t|z }|j|}|r|S7(#t$r} td| d} ~ wwxYww) aSend data for a column. This methods send data for a column (for example BLOB) for statement identified by statement_id. The param_id indicate which parameter the data belongs too. The data argument should be a file-like object. Since MySQL does not send anything back, no error is raised. When the MySQL server is not reachable, an OperationalError is raised. cmd_stmt_send_long_data should be called before cmd_stmt_execute. The total bytes send is returned. rYrFrNr)rrRrrr) rrprepare_stmt_send_long_datarVrSTMT_SEND_LONG_DATArOr=rvr ) rQrrrrr[ total_sentr\rr|s rRrz'MySQLConnection.cmd_stmt_send_long_dataBs(   N))J'CCC (Cnn11!$)!'ND!A"(**_d"C %c#h& ii +  N"#CD# M Ns;CA7B*?B(%B*&C(B** C3 B??CCc&K|jd{|jjtj} |j j ||jd{|S7_7#t$r }Yd}~|Sd}~wwxYww)zClose the current connection with the server. Send the QUIT command to the MySQL server, closing the current connection. Nr) rrrUrQUITrbrr1r#)rQrr~s rRrrzMySQLConnection.cmd_quitls ''))),,Y^^< ,,$$V4;N;N$O O O * P     sEBA6-B*A:/A80A:4B8A:: BB BB shutdown_typecBK|jdd{y7w)zShut down the MySQL Server. This method sends the SHUTDOWN command to the MySQL server. The `shutdown_type` is not used, and it's kept for backward compatibility. SHUTDOWNN)r)rQrs rR cmd_shutdownzMySQLConnection.cmd_shutdownys nnZ(((rcK|jd{|jjtj}|j j |dd|jd{|jj|j j|jd{S77L7 w)zSend the statistics command to the MySQL Server. This method sends the STATISTICS command to the MySQL server. The result is a dictionary with various statistical information. Nr) rrrUr STATISTICSrbrr1parse_statisticsrrDrs rRcmd_statisticszMySQLConnection.cmd_statisticss ''))),,Y-A-ABll  At/B/BCCC~~..,,##D$6$67 7  * D 7s5CB:AC/B<0AC1B>2 C<C>C mysql_pidc|Kt|ts td|jd|d{S7w)zKill a MySQL process. This method send the PROCESS_KILL command to the server along with the process ID. The result is a dictionary with the OK packet information. zMySQL PID must be intzKILL N)rmr@r*r)rQrs rRcmd_process_killz MySQLConnection.cmd_process_kills: )S)45 5^^eI;$78888s 3<:<czK|j|jtjd{S7w)a-Send the DEBUG command. This method sends the DEBUG command to the MySQL server, which requires the MySQL user to have SUPER privilege. The output will go to the MySQL server error log and the result of this method is a dictionary with EOF packet information. N)rrVrDEBUGrPs rR cmd_debugzMySQLConnection.cmd_debugs,dnnY__&E EFF E .;9 ;czK|j|jtjd{S7w)zSend the PING command. This method sends the PING command to the MySQL server. It is used to check if the the connection is still valid. The result of this method is dictionary with OK packet information. N)rrVrPINGrPs rRrczMySQLConnection.cmd_pings*T^^INN%CCDDCrrrrrrrrrrc K|Et|ts td|dkr tdtj||_d|_||_||_||_ ||_ ||_ |jr ||jk7r|j|_|jd{|jr td|r||_| r| |_| |_|j$j'|j|j"|j d|j$j)|j*|j,|j|j|j|j|j.|j j0|j2|j4|j6|j8d |j:|j< d{} |j2t>j@zs|r|jC|d{|jE| S77P7w) zChange the current logged in user. This method allows to change the current logged in user information. The result is a dictionary with OK packet information. Nzcharset must be an integerrz2charset should be either zero or a postive integerr7z-Change user is not supported with compression)rrrrT)rrrrrrrrrrrris_change_user_requestrr)#rmr@r*r= get_by_idrrJrrrrrr _compressrrrrrrrrbrNrrrprrrrDr1rrrr) rQrrrrrrrrrr ok_packets rRcmd_change_userzMySQLConnection.cmd_change_users(  gs+ !=>>{ !UVV$..w7DM !### ??x4??:!__DN''))) >>#$ST T $3D ! &7D ##5  00#'#8#8&*&>&>%)%<%< 1 "&!4!4!A!AooZZnnoooo^^MM,,++(())--#'++--"B"  $""Z%?%??X""8, , ,y))U *( & -s7B1H>3H74D5H>)H:*7H>!H<"H>:H><H>)rKN)NN)NrNTrNN)FNN)Fr7r)NNNNNNN)NFNNN)FFF)r7)rrrrl) rrNrrrrrr)Or __module__ __qualname____doc__rJr@__annotations__propertyr rSrrrr-rrirjrr,rr r+rr9r8rIr rLrrr r*rNr_rrVrr-rar`rhrjr. disconnectrr;r>rsrr.rrrrrrr0rrrrr rr r)rrrr8rrrrr r/rrrrcrrrTrRrrws=L# x} 2>h<(+#+*+?IBO3b 3 3< 3N3N4N 4% 4M 4 '+'+ aasma } a  a!aF '+'+ 0;0;sm0; } 0;  0;!0;d::$sCx.:  %,%, |U3_(=}#LMM N%,!%,N %)"& $()&*'+$K$K5/$K $K  $K  $K#&$Ksm$K }$K ) $K!$KL #(&*'+ '' 'sm '  } '  '!'RBTB D HIVV14VADV V2" J$("#'<@%)&*'+P4.Pd^P4. P t$789 P TN PsmP }P Pd 37" $/0d^    x (="99 : !0  $37" @}@@$/0 @ d^ @  @@ tG}h}55 6@!@D,. D  # , # vvv v  v  v vp:::  D( ) :z./""'*":=" "* --- eCo!6677 8 -!-d.0$& ??)*?SM ?  ?  ? |U3_(=}#LMM N?B                 !">((( (  ( (T  ) ))  o  99 9GGE E!%!"$!#O*O*O* O* # O*  O*O*O*O* O*O* , O*rT)\r"__all__rermrrr`rrrdecimalriortypingrrrr r r r r rrrrr _scriptingr constantsrrrrrrerrorsrrrrrrr r!r"r#r$rr%r&r'r(rr)r*r+r,r-r.r/r0utilsr1r2r3r4r5r6 _decoratingr8r9 abstractsr:r;r<r=rsr>r?r@rArBrCrDrErFnetworkrGrHrrrTrRr1s>K       3    NM   OOO   4D*-D*rT