ó ¿b›]c@sädZddlZddlmZddlmZddlmZddlmZddlmZd d lm Z d d lm Z d efd „ƒYZ defd„ƒYZ defd„ƒYZ defd„ƒYZeZdS(s .. dialect:: mysql+mysqldb :name: mysqlclient (maintained fork of MySQL-Python) :dbapi: mysqldb :connectstring: mysql+mysqldb://:@[:]/ :url: https://pypi.org/project/mysqlclient/ Driver Status ------------- The mysqlclient DBAPI is a maintained fork of the `MySQL-Python `_ DBAPI that is no longer maintained. `mysqlclient`_ supports Python 2 and Python 3 and is very stable. .. _mysqlclient: https://github.com/PyMySQL/mysqlclient-python .. _mysqldb_unicode: Unicode ------- Please see :ref:`mysql_unicode` for current recommendations on unicode handling. Using MySQLdb with Google Cloud SQL ----------------------------------- Google Cloud SQL now recommends use of the MySQLdb dialect. Connect using a URL like the following:: mysql+mysqldb://root@/?unix_socket=/cloudsql/: Server Side Cursors ------------------- The mysqldb dialect supports server-side cursors. See :ref:`mysql_ss_cursors`. iÿÿÿÿNi(t MySQLCompiler(t MySQLDialect(tMySQLExecutionContext(tMySQLIdentifierPreparer(tTEXTi(tsql(tutiltMySQLExecutionContext_mysqldbcBseZed„ƒZRS(cCs$t|dƒr|jS|jjSdS(Nt _rowcount(thasattrRtcursortrowcount(tself((s@lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyR >s(t__name__t __module__tpropertyR (((s@lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyR=stMySQLCompiler_mysqldbcBseZRS((R R(((s@lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyRFstMySQLIdentifierPreparer_mysqldbcBseZRS((R R(((s@lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyRJstMySQLDialect_mysqldbcBsÝeZdZeZeZeZeZdZe Z e Z e Zed„Zd„Zejjd„ƒZed„ƒZd„Zd„Zdd„Zd „Zd „Zd „Zd „Ze d ddddgƒZ!d„Z"RS(tmysqldbtformatcKsbtt|ƒj|||_|jdk rUt|jdƒrU|j|jjƒnd|_ dS(Nt __version__i(iii( tsuperRt__init__tserver_side_cursorstdbapitNoneR t_parse_dbapi_versionRt_mysql_dbapi_version(R Rtkwargs((s@lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyR[s 6cCsCtjd|ƒ}|r;td„|jdddƒDƒƒSdSdS(Ns(\d+)\.(\d+)(?:\.(\d+))?css'|]}|dk rt|ƒVqdS(N(Rtint(t.0tx((s@lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pys gsiiii(iii(tretmatchttupletgroup(R tversiontm((s@lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyRds#cCsBy#tdƒj}|j|_tSWnttfk r=tSXdS(NsMySQLdb.cursors(t __import__tcursorstSSCursort _sscursortTruet ImportErrortAttributeErrortFalse(R R(((s@lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pytsupports_server_side_cursorsks  cCs tdƒS(NtMySQLdb(R'(tcls((s@lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyRtscs(tt|ƒjƒ‰‡fd†}|S(Ncs_ˆdk rˆ|ƒn|jƒ}|dk r[|jƒ}|jd|ƒ|jƒndS(Ns SET NAMES %s(Rtcharacter_set_nameR texecutetclose(tconnt charset_nameR (tsuper_(s@lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyt on_connect{s     (RRR8(R R8((R7s@lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyR8xs cCsQy|jtƒWn5|jjk rH}|j||dƒrBtS‚nXtSdS(N(tpingR.RtErrort is_disconnectRR+(R tdbapi_connectionterr((s@lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pytdo_pingˆscCs.|j||ƒ}|dk r*||_ndS(N(t executemanyRR(R R t statementt parameterstcontextR ((s@lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pytdo_executemany“s cCs›|jd ko=|jd|jjdƒ|jjdƒfƒ}|r|tjtjtjdƒtddƒƒdƒg}ng}t t |ƒj ||ƒS( Nis:show collation where %s = 'utf8mb4' and %s = 'utf8mb4_bin'tCharsett Collations'test collated returns'tcharsettutf8mb4t utf8mb4_bin(i( tserver_version_infotscalartidentifier_preparertquoteRtcollatetcasttliteral_columnRRRt_check_unicode_returns(R t connectionthas_utf8mb4_bintadditional_tests((s@lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyRP˜s  cCsÌ|jddddddƒ}|j|jƒtj|dtƒtj|dtƒtj|d tƒtj|d tƒtj|d tƒtj|d tƒtj|d tƒtj|dtƒi}dddddg}xM|D]E}||krè||||dRRCRPRwRzR~tsett_isolation_lookupR‚(((s@lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyRNs6      -   (t__doc__R!tbaseRRRRRtRRRRRRtdialect(((s@lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyt0s  ¾