WiBdZddlmZddlmZGddeZeZdS)a .. dialect:: mysql+pymysql :name: PyMySQL :dbapi: pymysql :connectstring: mysql+pymysql://:@/[?] :url: https://pymysql.readthedocs.io/ Unicode ------- Please see :ref:`mysql_unicode` for current recommendations on unicode handling. .. _pymysql_ssl: SSL Connections ------------------ The PyMySQL DBAPI accepts the same SSL arguments as that of MySQLdb, described at :ref:`mysqldb_ssl`. See that section for additional examples. If the server uses an automatically-generated certificate that is self-signed or does not match the host name (as seen from the client), it may also be necessary to indicate ``ssl_check_hostname=false`` in PyMySQL:: connection_uri = ( "mysql+pymysql://scott:tiger@192.168.0.134/test" "?ssl_ca=/home/gord/client-ssl/ca.pem" "&ssl_cert=/home/gord/client-ssl/client-cert.pem" "&ssl_key=/home/gord/client-ssl/client-key.pem" "&ssl_check_hostname=false" ) MySQL-Python Compatibility -------------------------- The pymysql DBAPI is a pure Python port of the MySQL-python (MySQLdb) driver, and targets 100% compatibility. Most behavioral notes for MySQL-python apply to the pymysql driver as well. )MySQLDialect_mysqldb) langhelpersceZdZdZdZdZejdZe dZ ejdZ dZ d fd Z fd Zd ZxZS) MySQLDialect_pymysqlpymysqlTNcx tdj}|j|_dS#tt f$rYdSwxYw)Nzpymysql.cursorsTF) __import__cursorsSSCursor _sscursor ImportErrorAttributeError)selfr s k/var/www/html/jarvis.com/web/backend/venv/lib/python3.11/site-packages/sqlalchemy/dialects/mysql/pymysql.pysupports_server_side_cursorsz1MySQLDialect_pymysql.supports_server_side_cursors@sN  !233;G$-DN4^,   55 s $99c tdS)Nr)r )clss r import_dbapiz!MySQLDialect_pymysql.import_dbapiIs)$$$c tdjj}tj|j} |jd}|dko|j p|jdduS#t$rYdSwxYw#ttf$rYdSwxYw)adetermine if pymysql has deprecated, changed the default of, or removed the 'reconnect' argument of connection.ping(). See #10492 and https://github.com/PyMySQL/mysqlclient/discussions/651#discussioncomment-7308971 for background. zpymysql.connectionsr reconnectFT) r connections Connectionrget_callable_argspecpingargsdefaults IndexErrorrr)rrinsp reconnect_args r_send_false_to_pingz(MySQLDialect_pymysql._send_false_to_pingMs #%*  3JODDD  $ ! % 3 %Fq)9)F   uu  ^,   44 s"A0 A A-,A-0BBch|jr|dn|dS)NFT)r#r)rdbapi_connections rdo_pingzMySQLDialect_pymysql.do_pingis;  # $  ! !% ( ( ( (  ! ! # # #trcn|td}t||S)Nuser)username)_translate_args)dictsupercreate_connect_args)rurlr* __class__s rr-z(MySQLDialect_pymysql.create_connect_argsqs?  ""F333Oww** +   rct|||rdSt||jjr)t |}d|vpd|vSdS)NTzalready closedzconnection was killedF)r, is_disconnect isinstancedbapiErrorstrlower)re connectioncursorstr_er/s rr1z"MySQLDialect_pymysql.is_disconnectxso 77 J 7 7 4 4:+ , , FFLLNNE E)M-D-M 5rcvt|jdtr |jd}|jdS)Nr)r2r Exception)r exceptions r_extract_error_codez(MySQLDialect_pymysql._extract_error_codes4 inQ' 3 3 *!q)I~a  r)N)__name__ __module__ __qualname__driversupports_statement_cachedescription_encodingrmemoized_propertyr classmethodrr#r&r-r1r> __classcell__)r/s@rrr:s F#"#"%%[%"#"6           !!!!!!!rrN)__doc__mysqldbrutilrrdialectrrrMsu**X*)))))L!L!L!L!L!/L!L!L!^ r