ó H`¾Tc@sØdZddlmZmZmZmZddlmZmZm Z m Z ddlm Z ddl m Z deefd„ƒYZd eefd „ƒYZd e efd „ƒYZd e efd„ƒYZeZdS(sÓ .. dialect:: mysql+mysqldb :name: MySQL-Python :dbapi: mysqldb :connectstring: mysql+mysqldb://:@[:]/ :url: http://sourceforge.net/projects/mysql-python Unicode ------- MySQLdb requires a "charset" parameter to be passed in order for it to handle non-ASCII characters correctly. When this parameter is passed, MySQLdb will also implicitly set the "use_unicode" flag to true, which means that it will return Python unicode objects instead of bytestrings. However, SQLAlchemy's decode process, when C extensions are enabled, is orders of magnitude faster than that of MySQLdb as it does not call into Python functions to do so. Therefore, the **recommended URL to use for unicode** will include both charset and use_unicode=0:: create_engine("mysql+mysqldb://user:pass@host/dbname?charset=utf8&use_unicode=0") As of this writing, MySQLdb only runs on Python 2. It is not known how MySQLdb behaves on Python 3 as far as unicode decoding. Known Issues ------------- MySQL-python version 1.2.2 has a serious memory leak related to unicode conversion, a feature which is disabled via ``use_unicode=0``. It is strongly advised to use the latest version of MySQL-Python. i(t MySQLDialecttMySQLExecutionContextt MySQLCompilertMySQLIdentifierPrepareri(tMySQLDBExecutionContexttMySQLDBCompilertMySQLDBIdentifierPreparertMySQLDBConnector(tTEXT(tsqltMySQLExecutionContext_mysqldbcBseZRS((t__name__t __module__(((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyR 8stMySQLCompiler_mysqldbcBseZRS((R R (((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyR >stMySQLIdentifierPreparer_mysqldbcBseZRS((R R (((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyRBstMySQLDialect_mysqldbcBs#eZeZeZeZd„ZRS(cCsŒ|jd|jjdƒ|jjdƒfƒ}|rmtjtjtjdƒtddƒƒdƒg}ng}tt |ƒj ||ƒS(Ns4show collation where %s = 'utf8' and %s = 'utf8_bin'tCharsett Collations'test collated returns'tcharsettutf8tutf8_bin( tscalartidentifier_preparertquoteR tcollatetcasttliteral_columnRtsuperRt_check_unicode_returns(tselft connectiont has_utf8_bintadditional_tests((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyRMs ( R R R texecution_ctx_clsR tstatement_compilerRtpreparerR(((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyRHsN(t__doc__tbaseRRRRtconnectors.mysqldbRRRRRtR R R RRtdialect(((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/mysqldb.pyt*s""