o g@s4dZddlmZddlmZGdddeZeZdS)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) langhelperscsneZdZdZdZdZejddZe ddZ ejdd Z d d Z dfd d Z fddZddZZS)MySQLDialect_pymysqlpymysqlTNc Cs2z tdj}|j|_WdSttfyYdSw)Nzpymysql.cursorsTF) __import__cursorsSSCursor _sscursor ImportErrorAttributeError)selfrr]/var/www/html/flaskapp/venv/lib/python3.10/site-packages/sqlalchemy/dialects/mysql/pymysql.pysupports_server_side_cursors?s z1MySQLDialect_pymysql.supports_server_side_cursorscCstdS)Nr)r)clsrrr import_dbapiHsz!MySQLDialect_pymysql.import_dbapic Csxztdjj}Wn ttfyYdSwt|j}z|jd}Wn t y,YdSw|dko;|j p;|j dduS)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.connectionsTrF reconnect) r connections Connectionr r rget_callable_argspecpingargs IndexErrordefaults)r rinsp reconnect_argrrr_send_false_to_pingLs$   z(MySQLDialect_pymysql._send_false_to_pingcCs |jr |ddS|dS)NFT)rr)r dbapi_connectionrrrdo_pinghs  zMySQLDialect_pymysql.do_pingcs"|dur tdd}tj||dS)Nuser)username)_translate_args)dictsupercreate_connect_args)r urlr# __class__rrr&ps  z(MySQLDialect_pymysql.create_connect_argscsBt|||r dSt||jjrt|}d|vpd|vSdS)NTzalready closedzconnection was killedF)r% is_disconnect isinstancedbapiErrorstrlower)r e connectioncursorstr_er(rrr*ws z"MySQLDialect_pymysql.is_disconnectcCs$t|jdtr |jd}|jdS)Nr)r+r Exception)r exceptionrrr_extract_error_codes  z(MySQLDialect_pymysql._extract_error_code)N)__name__ __module__ __qualname__driversupports_statement_cachedescription_encodingrmemoized_propertyr classmethodrrr r&r*r6 __classcell__rrr(rr9s     rN)__doc__mysqldbrutilrrdialectrrrrs  + O