U !Jj@sdZddlmZddlmZddlmZddlmZddlmZddlmZddlm Z d d l m Z d d l m Z d d lmZerd dlmZd dlmZd dlmZd dlmZd dlmZd dlmZdddddZGddde ZeZdS)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. ) annotations)Any)Dict)Optional)Type) TYPE_CHECKING)Union)MySQLDialect_mysqldb) langhelpers)Literal)ConnectArgsType)DBAPIConnection) DBAPICursor) DBAPIModule)PoolProxiedConnection)URLz Type[Any]bool)connection_clsreturncCsTt|j}z|jd}Wntk r0YdSX|dkoN|j pN|jddk SdS)axGiven a Connection class like pymysql.Connection, aiomysql.Connection, asyncmy.Connection, inspect the ping() method and determine if it has a "reconnect" parameter that either defaults to True, or is positional. a return value of True here means that when we call ``connection.ping()``, we **must** pass `reconnect=False`. a return value of False means that we should call ``connection.ping()`` with **no arguments**. This routine originates from issue #10492 for pymysql, however arg signature mismatches in aiomysql/asyncmy tracked by issue #13306 necessitated a more open ended function. r FZ reconnectrN)r Zget_callable_argspecpingargs IndexErrordefaults)rZinspZ reconnect_argr/var/www/api.dyntland.com/public_html/python_social_comments/venv/lib/python3.8/site-packages/sqlalchemy/dialects/mysql/pymysql.py _connection_ping_reconnects_trueJs rcseZdZdZdZdZejddddZe ddd d Z ejddd d Z d ddddZ d#ddddfdd Z dddddfdd Zddd d!d"ZZS)$MySQLDialect_pymysqlpymysqlTNr)rc Cs8ztdj}|j|_WdSttfk r2YdSXdS)Nzpymysql.cursorsTF) __import__cursorsZSSCursorZ _sscursor ImportErrorAttributeError)selfr!rrrsupports_server_side_cursorsis  z1MySQLDialect_pymysql.supports_server_side_cursorsrcCstdS)Nr)r )clsrrr import_dbapirsz!MySQLDialect_pymysql.import_dbapic Cs8ztdjj}Wnttfk r*YdSXt|SdS)a4determine 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. Revised as part of #13306 zpymysql.connectionsTN)r connections Connectionr"r#r)r$r)rrr_send_false_to_pingvs  z(MySQLDialect_pymysql._send_false_to_pingrz Literal[True])dbapi_connectionrcCs|jr|dn|dS)NFT)r*r)r$r+rrrdo_pings zMySQLDialect_pymysql.do_pingrzOptional[Dict[str, Any]]r)url_translate_argsrcs"|dkrtdd}tj||dS)Nuser)username)r.)dictsupercreate_connect_args)r$r-r. __class__rrr3s  z(MySQLDialect_pymysql.create_connect_argszDBAPIModule.Errorz7Optional[Union[PoolProxiedConnection, DBAPIConnection]]zOptional[DBAPICursor])e connectioncursorrcsFt|||rdSt||jjr>t|}d|kps(+                P