-hHFSrSSKJr SSKJr SSKJr "SS\5r\rg) 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) langhelpers)py3kc^\rSrSrSrSrSrSrSr\ RS5r \ S5r \ RS5rSrS U4S jjrU4S jr\(a S rS rU=r$S rU=r$)MySQLDialect_pymysql9pymysqlTNc~[S5RnURUlg![[ 4a gf=f)Nzpymysql.cursorsTF) __import__cursorsSSCursor _sscursor ImportErrorAttributeError)selfr s vC:\Users\ROHAN GUPTA\OneDrive\Desktop\mathbuddy-assessment\venv\Lib\site-packages\sqlalchemy/dialects/mysql/pymysql.pysupports_server_side_cursors1MySQLDialect_pymysql.supports_server_side_cursorsEs?  !23;;G$--DN^,  s &)<<c[S5$)Nr )r )clss rdbapiMySQLDialect_pymysql.dbapiNs )$$cX[S5RRn[R"UR 5nUR SnUS:H=(a) UR(+=(d URSSL$![a gf=f![[4a gf=f)zdetermine 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_ping(MySQLDialect_pymysql._send_false_to_pingRs #%k**  33JOODD  $ ! % 3 %Fq)9)F   ^,  s#BB BBB)(B)cjUR(aURS5 gUR5 g)NFT)r'r!)rdbapi_connections r _ping_implMySQLDialect_pymysql._ping_implns/  # #  ! !% (  ! ! #rc>>Uc [SS9n[[U]XS9$)Nuser)username)_translate_args)dictsuperrcreate_connect_args)rurlr0 __class__s rr3(MySQLDialect_pymysql.create_connect_argsvs1  ""F3O)4D E  rc>[[U] XU5(ag[XRR 5(a*[ U5R5nSU;=(d SU;$g)NTzalready closedzconnection was killedF)r2r is_disconnect isinstancerErrorstrlower)re connectioncursorstr_er5s rr8"MySQLDialect_pymysql.is_disconnect}sc %t : 6   ::++ , ,FLLNE E)M-D-M rc[URS[5(aURSnURS$)Nr)r9r" Exception)r exceptions r_extract_error_code(MySQLDialect_pymysql._extract_error_codes5)..+Y77%NN1- >>!$ $r)r)N)__name__ __module__ __qualname____firstlineno__driversupports_statement_cachedescription_encodingsupports_unicode_statementssupports_unicode_bindsrmemoized_propertyr classmethodrr'r+r3r8rrE__static_attributes__ __classcell__)r5s@rrr9s F# #'!""#%%""#6    % % rrN)__doc__mysqldbrutilrrrdialectrrrYs-*X*V%/V%r r