H`Tc@sg dZddlZddlZddlZddlmZddlmZmZm Z m Z ddl m Z ddl m Z ddlmZdd lmZdd lmZdd l mZdd lmZmZmZmZmZed ddddddddddddddddddd d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;d<d=d>d?d@dAdBdCdDdEdFdGdHdIdJdKdLdMdNdOdPdQdRdSdTdUdVdWdXdYdZd[d\d]d^d_d`dadbdcdddedfdgdhdidjdkdldmdndodpdqdrdsdtdudvdwdxdydzd{d|d}d~ddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd d|dddddddddddddddddddgZejdejejBZejdejejBZde fdYZ!de!ej"fdYZ#de!ej$fd YZ%d ej&fd YZ'd e!ej(fd YZ(de!ej)fdYZ)de#fdYZ*de#ej+fdYZ+de#ej,fdYZ,de%ej-fdYZ-de%ej.fdYZ.de%fdYZ/de%fdYZ0de%ej1fdYZ1d ej2fd!YZ3d"ej4fd#YZ4d$ej5fd%YZ5d&ej6fd'YZ6d(ej2fd)YZ7d*e'ej8fd+YZ8d,e'fd-YZ9d.e'fd/YZ:d0e'fd1YZ;d2e'ej<fd3YZ<d4e'ej=fd5YZ=d6e'ej>fd7YZ>d8e'ej?fd9YZ?d:ej@fd;YZAd<ej@fd=YZBd>ej@fd?YZCd@e'fdAYZDdBejEeDfdCYZFdDeDfdEYZGe4ZHeGZIeFZJeCZKeBZLeAZMeZNeZOeZPe?ZQe>ZRe=ZSe<ZTe;ZUe:ZVe9ZWe8ZXe7ZYe5ZZe3Z[e1Z\e0Z]e/Z^e.Z_e(Z`e)Zae*Zbe+Zce,Zde-Zeie%e%6e!e!6e#e#6e(ejf6e,ej"6e4ejg6eFejE6Zhi"e.d6ed6e3dF6ed6edG6e=d!6edH6e6dI6e)d86e*dC6eFdJ6e)dK6e,dP6e-dh6e-dn6eCd6e;d6eBd6e/d6e:d6e?dL6e>dM6e(d6eGd6e1d6e8dN6e4dO6e5dP6eAd6e0d6e9d6ed6e<d6e7dQ6ZidRejjfdSYZkdTe jlfdUYZmdVe jnfdWYZodXe jpfdYYZqdZe jrfd[YZsejtd\ejufd]YZvd^e fd_YZwejtd`e fdaYZxdbdcdddedffZydge fdhYZze{diZ|djZ}dS(ks ? .. dialect:: mysql :name: MySQL Supported Versions and Features ------------------------------- SQLAlchemy supports MySQL starting with version 4.1 through modern releases. However, no heroic measures are taken to work around major missing SQL features - if your server version does not support sub-selects, for example, they won't work in SQLAlchemy either. See the official MySQL documentation for detailed information about features supported in any given server release. .. _mysql_connection_timeouts: Connection Timeouts ------------------- MySQL features an automatic connection close behavior, for connections that have been idle for eight hours or more. To circumvent having this issue, use the ``pool_recycle`` option which controls the maximum age of any connection:: engine = create_engine('mysql+mysqldb://...', pool_recycle=3600) .. _mysql_storage_engines: CREATE TABLE arguments including Storage Engines ------------------------------------------------ MySQL's CREATE TABLE syntax includes a wide array of special options, including ``ENGINE``, ``CHARSET``, ``MAX_ROWS``, ``ROW_FORMAT``, ``INSERT_METHOD``, and many more. To accommodate the rendering of these arguments, specify the form ``mysql_argument_name="value"``. For example, to specify a table with ``ENGINE`` of ``InnoDB``, ``CHARSET`` of ``utf8``, and ``KEY_BLOCK_SIZE`` of ``1024``:: Table('mytable', metadata, Column('data', String(32)), mysql_engine='InnoDB', mysql_charset='utf8', mysql_key_block_size="1024" ) The MySQL dialect will normally transfer any keyword specified as ``mysql_keyword_name`` to be rendered as ``KEYWORD_NAME`` in the ``CREATE TABLE`` statement. A handful of these names will render with a space instead of an underscore; to support this, the MySQL dialect has awareness of these particular names, which include ``DATA DIRECTORY`` (e.g. ``mysql_data_directory``), ``CHARACTER SET`` (e.g. ``mysql_character_set``) and ``INDEX DIRECTORY`` (e.g. ``mysql_index_directory``). The most common argument is ``mysql_engine``, which refers to the storage engine for the table. Historically, MySQL server installations would default to ``MyISAM`` for this value, although newer versions may be defaulting to ``InnoDB``. The ``InnoDB`` engine is typically preferred for its support of transactions and foreign keys. A :class:`.Table` that is created in a MySQL database with a storage engine of ``MyISAM`` will be essentially non-transactional, meaning any INSERT/UPDATE/DELETE statement referring to this table will be invoked as autocommit. It also will have no support for foreign key constraints; while the ``CREATE TABLE`` statement accepts foreign key options, when using the ``MyISAM`` storage engine these arguments are discarded. Reflecting such a table will also produce no foreign key constraint information. For fully atomic transactions as well as support for foreign key constraints, all participating ``CREATE TABLE`` statements must specify a transactional engine, which in the vast majority of cases is ``InnoDB``. .. seealso:: `The InnoDB Storage Engine `_ - on the MySQL website. Case Sensitivity and Table Reflection ------------------------------------- MySQL has inconsistent support for case-sensitive identifier names, basing support on specific details of the underlying operating system. However, it has been observed that no matter what case sensitivity behavior is present, the names of tables in foreign key declarations are *always* received from the database as all-lower case, making it impossible to accurately reflect a schema where inter-related tables use mixed-case identifier names. Therefore it is strongly advised that table names be declared as all lower case both within SQLAlchemy as well as on the MySQL database itself, especially if database reflection features are to be used. .. _mysql_isolation_level: Transaction Isolation Level --------------------------- :func:`.create_engine` accepts an ``isolation_level`` parameter which results in the command ``SET SESSION TRANSACTION ISOLATION LEVEL `` being invoked for every new connection. Valid values for this parameter are ``READ COMMITTED``, ``READ UNCOMMITTED``, ``REPEATABLE READ``, and ``SERIALIZABLE``:: engine = create_engine( "mysql://scott:tiger@localhost/test", isolation_level="READ UNCOMMITTED" ) .. versionadded:: 0.7.6 AUTO_INCREMENT Behavior ----------------------- When creating tables, SQLAlchemy will automatically set ``AUTO_INCREMENT`` on the first :class:`.Integer` primary key column which is not marked as a foreign key:: >>> t = Table('mytable', metadata, ... Column('mytable_id', Integer, primary_key=True) ... ) >>> t.create() CREATE TABLE mytable ( id INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) ) You can disable this behavior by passing ``False`` to the :paramref:`~.Column.autoincrement` argument of :class:`.Column`. This flag can also be used to enable auto-increment on a secondary column in a multi-column key for some storage engines:: Table('mytable', metadata, Column('gid', Integer, primary_key=True, autoincrement=False), Column('id', Integer, primary_key=True) ) Ansi Quoting Style ------------------ MySQL features two varieties of identifier "quoting style", one using backticks and the other using quotes, e.g. ```some_identifier``` vs. ``"some_identifier"``. All MySQL dialects detect which version is in use by checking the value of ``sql_mode`` when a connection is first established with a particular :class:`.Engine`. This quoting style comes into play when rendering table and column names as well as when reflecting existing database structures. The detection is entirely automatic and no special configuration is needed to use either quoting style. .. versionchanged:: 0.6 detection of ANSI quoting style is entirely automatic, there's no longer any end-user ``create_engine()`` options in this regard. MySQL SQL Extensions -------------------- Many of the MySQL SQL extensions are handled through SQLAlchemy's generic function and operator support:: table.select(table.c.password==func.md5('plaintext')) table.select(table.c.username.op('regexp')('^[a-d]')) And of course any valid MySQL statement can be executed as a string as well. Some limited direct support for MySQL extensions to SQL is currently available. * SELECT pragma:: select(..., prefixes=['HIGH_PRIORITY', 'SQL_SMALL_RESULT']) * UPDATE with LIMIT:: update(..., mysql_limit=10) rowcount Support ---------------- SQLAlchemy standardizes the DBAPI ``cursor.rowcount`` attribute to be the usual definition of "number of rows matched by an UPDATE or DELETE" statement. This is in contradiction to the default setting on most MySQL DBAPI drivers, which is "number of rows actually modified/deleted". For this reason, the SQLAlchemy MySQL dialects always add the ``constants.CLIENT.FOUND_ROWS`` flag, or whatever is equivalent for the target dialect, upon connection. This setting is currently hardcoded. .. seealso:: :attr:`.ResultProxy.rowcount` CAST Support ------------ MySQL documents the CAST operator as available in version 4.0.2. When using the SQLAlchemy :func:`.cast` function, SQLAlchemy will not render the CAST token on MySQL before this version, based on server version detection, instead rendering the internal expression directly. CAST may still not be desirable on an early MySQL version post-4.0.2, as it didn't add all datatype support until 4.1.1. If your application falls into this narrow area, the behavior of CAST can be controlled using the :ref:`sqlalchemy.ext.compiler_toplevel` system, as per the recipe below:: from sqlalchemy.sql.expression import Cast from sqlalchemy.ext.compiler import compiles @compiles(Cast, 'mysql') def _check_mysql_version(element, compiler, **kw): if compiler.dialect.server_version_info < (4, 1, 0): return compiler.process(element.clause, **kw) else: return compiler.visit_cast(element, **kw) The above function, which only needs to be declared once within an application, overrides the compilation of the :func:`.cast` construct to check for version 4.1.0 before fully rendering CAST; else the internal element of the construct is rendered directly. .. _mysql_indexes: MySQL Specific Index Options ---------------------------- MySQL-specific extensions to the :class:`.Index` construct are available. Index Length ~~~~~~~~~~~~~ MySQL provides an option to create index entries with a certain length, where "length" refers to the number of characters or bytes in each value which will become part of the index. SQLAlchemy provides this feature via the ``mysql_length`` parameter:: Index('my_index', my_table.c.data, mysql_length=10) Index('a_b_idx', my_table.c.a, my_table.c.b, mysql_length={'a': 4, 'b': 9}) Prefix lengths are given in characters for nonbinary string types and in bytes for binary string types. The value passed to the keyword argument *must* be either an integer (and, thus, specify the same prefix length value for all columns of the index) or a dict in which keys are column names and values are prefix length values for corresponding columns. MySQL only allows a length for a column of an index if it is for a CHAR, VARCHAR, TEXT, BINARY, VARBINARY and BLOB. .. versionadded:: 0.8.2 ``mysql_length`` may now be specified as a dictionary for use with composite indexes. Index Types ~~~~~~~~~~~~~ Some MySQL storage engines permit you to specify an index type when creating an index or primary key constraint. SQLAlchemy provides this feature via the ``mysql_using`` parameter on :class:`.Index`:: Index('my_index', my_table.c.data, mysql_using='hash') As well as the ``mysql_using`` parameter on :class:`.PrimaryKeyConstraint`:: PrimaryKeyConstraint("data", mysql_using='hash') The value passed to the keyword argument will be simply passed through to the underlying CREATE INDEX or PRIMARY KEY clause, so it *must* be a valid index type for your MySQL storage engine. More information can be found at: http://dev.mysql.com/doc/refman/5.0/en/create-index.html http://dev.mysql.com/doc/refman/5.0/en/create-table.html .. _mysql_foreign_keys: MySQL Foreign Keys ------------------ MySQL's behavior regarding foreign keys has some important caveats. Foreign Key Arguments to Avoid ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ MySQL does not support the foreign key arguments "DEFERRABLE", "INITIALLY", or "MATCH". Using the ``deferrable`` or ``initially`` keyword argument with :class:`.ForeignKeyConstraint` or :class:`.ForeignKey` will have the effect of these keywords being rendered in a DDL expression, which will then raise an error on MySQL. In order to use these keywords on a foreign key while having them ignored on a MySQL backend, use a custom compile rule:: from sqlalchemy.ext.compiler import compiles from sqlalchemy.schema import ForeignKeyConstraint @compiles(ForeignKeyConstraint, "mysql") def process(element, compiler, **kw): element.deferrable = element.initially = None return compiler.visit_foreign_key_constraint(element, **kw) .. versionchanged:: 0.9.0 - the MySQL backend no longer silently ignores the ``deferrable`` or ``initially`` keyword arguments of :class:`.ForeignKeyConstraint` and :class:`.ForeignKey`. The "MATCH" keyword is in fact more insidious, and is explicitly disallowed by SQLAlchemy in conjunction with the MySQL backend. This argument is silently ignored by MySQL, but in addition has the effect of ON UPDATE and ON DELETE options also being ignored by the backend. Therefore MATCH should never be used with the MySQL backend; as is the case with DEFERRABLE and INITIALLY, custom compilation rules can be used to correct a MySQL ForeignKeyConstraint at DDL definition time. .. versionadded:: 0.9.0 - the MySQL backend will raise a :class:`.CompileError` when the ``match`` keyword is used with :class:`.ForeignKeyConstraint` or :class:`.ForeignKey`. Reflection of Foreign Key Constraints ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Not all MySQL storage engines support foreign keys. When using the very common ``MyISAM`` MySQL storage engine, the information loaded by table reflection will not include foreign keys. For these tables, you may supply a :class:`~sqlalchemy.ForeignKeyConstraint` at reflection time:: Table('mytable', metadata, ForeignKeyConstraint(['other_id'], ['othertable.other_id']), autoload=True ) .. seealso:: :ref:`mysql_storage_engines` .. _mysql_timestamp_null: TIMESTAMP Columns and NULL -------------------------- MySQL enforces that a column which specifies the TIMESTAMP datatype implicitly includes a default value of CURRENT_TIMESTAMP, even though this is not stated, and additionally sets the column as NOT NULL, the opposite behavior vs. that of all other datatypes:: mysql> CREATE TABLE ts_test ( -> a INTEGER, -> b INTEGER NOT NULL, -> c TIMESTAMP, -> d TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -> e TIMESTAMP NULL); Query OK, 0 rows affected (0.03 sec) mysql> SHOW CREATE TABLE ts_test; +---------+----------------------------------------------------- | Table | Create Table +---------+----------------------------------------------------- | ts_test | CREATE TABLE `ts_test` ( `a` int(11) DEFAULT NULL, `b` int(11) NOT NULL, `c` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `d` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `e` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Above, we see that an INTEGER column defaults to NULL, unless it is specified with NOT NULL. But when the column is of type TIMESTAMP, an implicit default of CURRENT_TIMESTAMP is generated which also coerces the column to be a NOT NULL, even though we did not specify it as such. Therefore, the usual "NOT NULL" clause *does not apply* to a TIMESTAMP column; MySQL selects this implicitly. SQLAlchemy therefore does not render NOT NULL for a TIMESTAMP column on MySQL. However, it *does* render NULL when we specify nullable=True, or if we leave nullable absent, as it also defaults to True. This is to accommodate the essentially reverse behavior of the NULL flag for TIMESTAMP:: from sqlalchemy import MetaData, TIMESTAMP, Integer, Table, Column, text m = MetaData() t = Table('ts_test', m, Column('a', Integer), Column('b', Integer, nullable=False), Column('c', TIMESTAMP), Column('d', TIMESTAMP, nullable=False), Column('e', TIMESTAMP, nullable=True) ) from sqlalchemy import create_engine e = create_engine("mysql://scott:tiger@localhost/test", echo=True) m.create_all(e) In the output, we can see that the TIMESTAMP column receives a different treatment for NULL / NOT NULL vs. that of the INTEGER:: CREATE TABLE ts_test ( a INTEGER, b INTEGER NOT NULL, c TIMESTAMP NULL, d TIMESTAMP, e TIMESTAMP NULL ) MySQL above receives the NULL/NOT NULL constraint as is stated in our original :class:`.Table`:: mysql> SHOW CREATE TABLE ts_test; +---------+--------------------------- | Table | Create Table +---------+--------------------------- | ts_test | CREATE TABLE `ts_test` ( `a` int(11) DEFAULT NULL, `b` int(11) NOT NULL, `c` timestamp NULL DEFAULT NULL, `d` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `e` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Be sure to always favor the ``SHOW CREATE TABLE`` output over the SQLAlchemy-emitted DDL when checking table definitions, as MySQL's rules can be hard to predict. iNi(tschema(texctlogtsqltutil(tcompiler(tarray(t reflection(tdefault(ttypes(t topological(tDATEtBOOLEANtBLOBtBINARYt VARBINARYt accessibletaddtalltaltertanalyzetandtastasct asensitivetbeforetbetweentbiginttbinarytblobtbothtbytcalltcascadetcasetchangetchart charactertchecktcollatetcolumnt conditiont constrainttcontinuetconverttcreatetcrosst current_datet current_timetcurrent_timestampt current_usertcursortdatabaset databasestday_hourtday_microsecondt day_minutet day_secondtdectdecimaltdeclareRtdelayedtdeletetdesctdescribet deterministictdistinctt distinctrowtdivtdoubletdroptdualteachtelsetelseiftenclosedtescapedtexiststexittexplaintfalsetfetchtfloattfloat4tfloat8tfortforcetforeigntfromtfulltexttgranttgroupthavingt high_prioritythour_microsecondt hour_minutet hour_secondtiftignoretintindextinfiletinnertinoutt insensitivetinserttinttint1tint2tint3tint4tint8tintegertintervaltintotistiteratetjointkeytkeystkilltleadingtleavetlefttliketlimittlineartlinestloadt localtimetlocaltimestamptlocktlongtlongblobtlongtexttloopt low_prioritytmaster_ssl_verify_server_certtmatcht mediumblobt mediumintt mediumtextt middleinttminute_microsecondt minute_secondtmodtmodifiestnaturaltnottno_write_to_binlogtnulltnumerictontoptimizetoptiont optionallytortordertouttoutertoutfilet precisiontprimaryt proceduretpurgetrangetreadtreadst read_onlyt read_writetrealt referencestregexptreleasetrenametrepeattreplacetrequiretrestricttreturntrevoketrighttrlikeRtschemastsecond_microsecondtselectt sensitivet separatortsettshowtsmallinttspatialtspecificRt sqlexceptiontsqlstatet sqlwarningtsql_big_resulttsql_calc_found_rowstsql_small_resulttssltstartingt straight_jointtablet terminatedtthenttinyblobttinyintttinytextttottrailingttriggerttruetundotuniontuniquetunlocktunsignedtupdatetusagetusetusingtutc_datetutc_timet utc_timestamptvaluest varbinarytvarchart varcharactertvaryingtwhentwheretwhiletwithtwritetx509txort year_monthtzerofilltcolumnstfieldst privilegestsonamettablestgeneraltignore_server_idstmaster_heartbeat_periodtmaxvaluetresignaltsignaltslowtgettio_after_gtidstio_before_gtidst master_bindtone_shott partitiontsql_after_gtidstsql_before_gtidss@\s*(?:UPDATE|INSERT|CREATE|DELETE|DROP|ALTER|LOAD +DATA|REPLACE)s%\s*SET\s+(?:(?:GLOBAL|SESSION)\s+)?\wt _NumericTypecBs&eZdZeedZdZRS(svBase for MySQL numeric types. This is the base both for NUMERIC as well as INTEGER, hence it's a mixin. cKs,||_||_tt|j|dS(N(RRtsuperRt__init__(tselfRRtkw((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRs  cCstj|dttjgS(Nt to_inspect(Rt generic_reprRtsqltypestNumeric(R((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt__repr__ s (t__name__t __module__t__doc__tFalseRR (((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRst _FloatTypecBs#eZddedZdZRS(c Kst|ttfrW|dkr-|dk sE|dk rW|dkrWtjdntt|jd|d||||_ dS(NsBYou must specify both precision and scale or omit both altogether.Rt asdecimal( t isinstancetREALtDOUBLEtNoneRt ArgumentErrorRRRtscale(RRRRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRs cCstj|dtttjgS(NR(RRRRR tFloat(R((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR !sN(R R RtTrueRR (((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRs t _IntegerTypecBseZddZdZRS(cKs#||_tt|j|dS(N(t display_widthRRR(RRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR)s cCstj|dtttjgS(NR(RRRRR tInteger(R((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR -sN(R R RRR (((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR's t _StringTypecBs2eZdZddeeeedZdZRS(sBase for MySQL string types.cKsc||_|jd|jd|||_||_||_||_tt|j |dS(Nt collationR'( tcharsett setdefaulttpoptasciitunicodeRtnationalRRR(RRRR"RR#R$R((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR7s     cCstj|dttjgS(NR(RRRR tString(R((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR Es N(R R RRRRR (((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR3s   tNUMERICcBs&eZdZdZddedZRS(sMySQL NUMERIC type.R&cKs,tt|jd|d|d||dS(s#Construct a NUMERIC. :param precision: Total digits in this number. If scale and precision are both None, values are stored to limits allowed by the server. :param scale: The number of digits after the decimal point. :param unsigned: a boolean, optional. :param zerofill: Optional. If true, values will be stored as strings left-padded with zeros. Note that this does not effect the values returned by the underlying database API, which continue to be numeric. RRRN(RR&R(RRRRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRPsN(R R Rt__visit_name__RRR(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR&JstDECIMALcBs&eZdZdZddedZRS(sMySQL DECIMAL type.R(cKs,tt|jd|d|d||dS(s#Construct a DECIMAL. :param precision: Total digits in this number. If scale and precision are both None, values are stored to limits allowed by the server. :param scale: The number of digits after the decimal point. :param unsigned: a boolean, optional. :param zerofill: Optional. If true, values will be stored as strings left-padded with zeros. Note that this does not effect the values returned by the underlying database API, which continue to be numeric. RRRN(RR(R(RRRRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRjsN(R R RR'RRR(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR(dsRcBs&eZdZdZddedZRS(sMySQL DOUBLE type.RcKs,tt|jd|d|d||dS(sConstruct a DOUBLE. .. note:: The :class:`.DOUBLE` type by default converts from float to Decimal, using a truncation that defaults to 10 digits. Specify either ``scale=n`` or ``decimal_return_scale=n`` in order to change this scale, or ``asdecimal=False`` to return values directly as Python floating points. :param precision: Total digits in this number. If scale and precision are both None, values are stored to limits allowed by the server. :param scale: The number of digits after the decimal point. :param unsigned: a boolean, optional. :param zerofill: Optional. If true, values will be stored as strings left-padded with zeros. Note that this does not effect the values returned by the underlying database API, which continue to be numeric. RRRN(RRR(RRRRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRsN(R R RR'RRR(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR~sRcBs&eZdZdZddedZRS(sMySQL REAL type.RcKs,tt|jd|d|d||dS(sConstruct a REAL. .. note:: The :class:`.REAL` type by default converts from float to Decimal, using a truncation that defaults to 10 digits. Specify either ``scale=n`` or ``decimal_return_scale=n`` in order to change this scale, or ``asdecimal=False`` to return values directly as Python floating points. :param precision: Total digits in this number. If scale and precision are both None, values are stored to limits allowed by the server. :param scale: The number of digits after the decimal point. :param unsigned: a boolean, optional. :param zerofill: Optional. If true, values will be stored as strings left-padded with zeros. Note that this does not effect the values returned by the underlying database API, which continue to be numeric. RRRN(RRR(RRRRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRsN(R R RR'RRR(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRstFLOATcBs/eZdZdZddedZdZRS(sMySQL FLOAT type.R)cKs,tt|jd|d|d||dS(s!Construct a FLOAT. :param precision: Total digits in this number. If scale and precision are both None, values are stored to limits allowed by the server. :param scale: The number of digits after the decimal point. :param unsigned: a boolean, optional. :param zerofill: Optional. If true, values will be stored as strings left-padded with zeros. Note that this does not effect the values returned by the underlying database API, which continue to be numeric. RRRN(RR)R(RRRRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRscCsdS(N(R(Rtdialect((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytbind_processorsN(R R RR'RRRR+(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR)stINTEGERcBs eZdZdZddZRS(sMySQL INTEGER type.R,cKs tt|jd||dS(sConstruct an INTEGER. :param display_width: Optional, maximum display width for this number. :param unsigned: a boolean, optional. :param zerofill: Optional. If true, values will be stored as strings left-padded with zeros. Note that this does not effect the values returned by the underlying database API, which continue to be numeric. RN(RR,R(RRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRs N(R R RR'RR(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR,stBIGINTcBs eZdZdZddZRS(sMySQL BIGINTEGER type.R-cKs tt|jd||dS(sConstruct a BIGINTEGER. :param display_width: Optional, maximum display width for this number. :param unsigned: a boolean, optional. :param zerofill: Optional. If true, values will be stored as strings left-padded with zeros. Note that this does not effect the values returned by the underlying database API, which continue to be numeric. RN(RR-R(RRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRs N(R R RR'RR(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR-st MEDIUMINTcBs eZdZdZddZRS(sMySQL MEDIUMINTEGER type.R.cKs tt|jd||dS(sConstruct a MEDIUMINTEGER :param display_width: Optional, maximum display width for this number. :param unsigned: a boolean, optional. :param zerofill: Optional. If true, values will be stored as strings left-padded with zeros. Note that this does not effect the values returned by the underlying database API, which continue to be numeric. RN(RR.R(RRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRs N(R R RR'RR(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR. stTINYINTcBs eZdZdZddZRS(sMySQL TINYINT type.R/cKs tt|jd||dS(sConstruct a TINYINT. :param display_width: Optional, maximum display width for this number. :param unsigned: a boolean, optional. :param zerofill: Optional. If true, values will be stored as strings left-padded with zeros. Note that this does not effect the values returned by the underlying database API, which continue to be numeric. RN(RR/R(RRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR's N(R R RR'RR(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR/!stSMALLINTcBs eZdZdZddZRS(sMySQL SMALLINTEGER type.R0cKs tt|jd||dS(sConstruct a SMALLINTEGER. :param display_width: Optional, maximum display width for this number. :param unsigned: a boolean, optional. :param zerofill: Optional. If true, values will be stored as strings left-padded with zeros. Note that this does not effect the values returned by the underlying database API, which continue to be numeric. RN(RR0R(RRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR=s N(R R RR'RR(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR07stBITcBs)eZdZdZddZdZRS(sMySQL BIT type. This type is for MySQL 5.0.3 or greater for MyISAM, and 5.0.5 or greater for MyISAM, MEMORY, InnoDB and BDB. For older versions, use a MSTinyInteger() type. R1cCs ||_dS(sLConstruct a BIT. :param length: Optional, number of bits. N(tlength(RR2((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRYscCs d}|S(sConvert a MySQL's 64 bit, variable length binary string to a long. TODO: this is MySQL-db, pyodbc specific. OurSQL and mysqlconnector already do this, so this logic should be moved to those dialects. cSsB|dk r>d}x%tt|D]}|d>|B}q"W|S|S(Nii(Rtmaptord(tvaluetvti((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytprocessis  ((RR*tcoltypeR8((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytresult_processoras N(R R RR'RRR:(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR1Ms tTIMEcBs,eZdZdZeddZdZRS(sMySQL TIME type. R;cCs&tt|jd|||_dS(s9Construct a MySQL TIME type. :param timezone: not used by the MySQL dialect. :param fsp: fractional seconds precision value. MySQL 5.6 supports storage of fractional seconds; this parameter will be used when emitting DDL for the TIME type. .. note:: DBAPI driver support for fractional seconds may be limited; current support includes MySQL Connector/Python. .. versionadded:: 0.8 The MySQL-specific TIME type as well as fractional seconds support. ttimezoneN(RR;Rtfsp(RR<R=((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRyscstjfd}|S(NcsV|dk rN|j}|j}|d}|d|d||dd|SdSdS(Ni<t microsecond(Rt microsecondstseconds(R5R?R@tminutes(ttime(sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR8s     (tdatetimeRB(RR*R9R8((RBsd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR:s  N(R R RR'RRRR:(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR;sst TIMESTAMPcBs#eZdZdZeddZRS(sMySQL TIMESTAMP type. RDcCs&tt|jd|||_dS(sSConstruct a MySQL TIMESTAMP type. :param timezone: not used by the MySQL dialect. :param fsp: fractional seconds precision value. MySQL 5.6.4 supports storage of fractional seconds; this parameter will be used when emitting DDL for the TIMESTAMP type. .. note:: DBAPI driver support for fractional seconds may be limited; current support includes MySQL Connector/Python. .. versionadded:: 0.8.5 Added MySQL-specific :class:`.mysql.TIMESTAMP` with fractional seconds support. R<N(RRDRR=(RR<R=((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRsN(R R RR'RRR(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRDstDATETIMEcBs#eZdZdZeddZRS(sMySQL DATETIME type. REcCs&tt|jd|||_dS(sPConstruct a MySQL DATETIME type. :param timezone: not used by the MySQL dialect. :param fsp: fractional seconds precision value. MySQL 5.6.4 supports storage of fractional seconds; this parameter will be used when emitting DDL for the DATETIME type. .. note:: DBAPI driver support for fractional seconds may be limited; current support includes MySQL Connector/Python. .. versionadded:: 0.8.5 Added MySQL-specific :class:`.mysql.DATETIME` with fractional seconds support. R<N(RRERR=(RR<R=((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRsN(R R RR'RRR(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyREstYEARcBs eZdZdZddZRS(s<MySQL YEAR type, for single byte storage of years 1901-2155.RFcCs ||_dS(N(R(RR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRsN(R R RR'RR(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRFstTEXTcBs eZdZdZddZRS(s0MySQL TEXT type, for text up to 2^16 characters.RGcKs tt|jd||dS(scConstruct a TEXT. :param length: Optional, if provided the server may optimize storage by substituting the smallest TEXT type sufficient to store ``length`` characters. :param charset: Optional, a column-level character set for this string value. Takes precedence to 'ascii' or 'unicode' short-hand. :param collation: Optional, a column-level collation for this string value. Takes precedence to 'binary' short-hand. :param ascii: Defaults to False: short-hand for the ``latin1`` character set, generates ASCII in schema. :param unicode: Defaults to False: short-hand for the ``ucs2`` character set, generates UNICODE in schema. :param national: Optional. If true, use the server's configured national character set. :param binary: Defaults to False: short-hand, pick the binary collation type that matches the column's character set. Generates BINARY in schema. This does not affect the type of data stored, only the collation of character data. R2N(RRGR(RR2R((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRsN(R R RR'RR(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRGstTINYTEXTcBseZdZdZdZRS(s3MySQL TINYTEXT type, for text up to 2^8 characters.RHcKstt|j|dS(sConstruct a TINYTEXT. :param charset: Optional, a column-level character set for this string value. Takes precedence to 'ascii' or 'unicode' short-hand. :param collation: Optional, a column-level collation for this string value. Takes precedence to 'binary' short-hand. :param ascii: Defaults to False: short-hand for the ``latin1`` character set, generates ASCII in schema. :param unicode: Defaults to False: short-hand for the ``ucs2`` character set, generates UNICODE in schema. :param national: Optional. If true, use the server's configured national character set. :param binary: Defaults to False: short-hand, pick the binary collation type that matches the column's character set. Generates BINARY in schema. This does not affect the type of data stored, only the collation of character data. N(RRHR(Rtkwargs((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRs(R R RR'R(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRHst MEDIUMTEXTcBseZdZdZdZRS(s6MySQL MEDIUMTEXT type, for text up to 2^24 characters.RJcKstt|j|dS(sConstruct a MEDIUMTEXT. :param charset: Optional, a column-level character set for this string value. Takes precedence to 'ascii' or 'unicode' short-hand. :param collation: Optional, a column-level collation for this string value. Takes precedence to 'binary' short-hand. :param ascii: Defaults to False: short-hand for the ``latin1`` character set, generates ASCII in schema. :param unicode: Defaults to False: short-hand for the ``ucs2`` character set, generates UNICODE in schema. :param national: Optional. If true, use the server's configured national character set. :param binary: Defaults to False: short-hand, pick the binary collation type that matches the column's character set. Generates BINARY in schema. This does not affect the type of data stored, only the collation of character data. N(RRJR(RRI((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR5s(R R RR'R(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRJ/stLONGTEXTcBseZdZdZdZRS(s4MySQL LONGTEXT type, for text up to 2^32 characters.RKcKstt|j|dS(sConstruct a LONGTEXT. :param charset: Optional, a column-level character set for this string value. Takes precedence to 'ascii' or 'unicode' short-hand. :param collation: Optional, a column-level collation for this string value. Takes precedence to 'binary' short-hand. :param ascii: Defaults to False: short-hand for the ``latin1`` character set, generates ASCII in schema. :param unicode: Defaults to False: short-hand for the ``ucs2`` character set, generates UNICODE in schema. :param national: Optional. If true, use the server's configured national character set. :param binary: Defaults to False: short-hand, pick the binary collation type that matches the column's character set. Generates BINARY in schema. This does not affect the type of data stored, only the collation of character data. N(RRKR(RRI((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRVs(R R RR'R(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRKPstVARCHARcBs eZdZdZddZRS(s7MySQL VARCHAR type, for variable-length character data.RLcKs tt|jd||dS(sConstruct a VARCHAR. :param charset: Optional, a column-level character set for this string value. Takes precedence to 'ascii' or 'unicode' short-hand. :param collation: Optional, a column-level collation for this string value. Takes precedence to 'binary' short-hand. :param ascii: Defaults to False: short-hand for the ``latin1`` character set, generates ASCII in schema. :param unicode: Defaults to False: short-hand for the ``ucs2`` character set, generates UNICODE in schema. :param national: Optional. If true, use the server's configured national character set. :param binary: Defaults to False: short-hand, pick the binary collation type that matches the column's character set. Generates BINARY in schema. This does not affect the type of data stored, only the collation of character data. R2N(RRLR(RR2RI((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRwsN(R R RR'RR(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRLqstCHARcBs/eZdZdZddZedZRS(s1MySQL CHAR type, for fixed-length character data.RMcKs tt|jd||dS(sConstruct a CHAR. :param length: Maximum data length, in characters. :param binary: Optional, use the default binary collation for the national character set. This does not affect the type of data stored, use a BINARY type for binary data. :param collation: Optional, request a particular collation. Must be compatible with the national character set. R2N(RRMR(RR2RI((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRs cCstj|}t|tjr%|St|trwtd|jd|jd|jd|jd|j d|j dt Std|jSdS(NR2RRR"RR#R$( R t to_instanceRRMRR2RRR"RR#R(Rttype_((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt_adapt_string_for_casts      N(R R RR'RRt classmethodRP(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRMs tNVARCHARcBs eZdZdZddZRS(sxMySQL NVARCHAR type. For variable-length character data in the server's configured national character set. RRcKs*t|dst MySQLCompilercBseZeZejjjZejidd6dZ dZ dZ dZ dZ dZdZd Zd Zd Zed Zd ZdZdZdZdZRS(t millisecondt millisecondscKsd|j|S(Nsrand%s(tfunction_argspec(RtfnR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_random_funcLscKsdS(Nt UTC_TIMESTAMP((RRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_utc_timestamp_funcOscKsdS(Ns SYSDATE()((RRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_sysdate_funcRscKs&d|j|j|j|jfS(Nsconcat(%s, %s)(R8R{R(RRtoperatorR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_concat_op_binaryUscKs&d|j|j|j|jfS(Ns'MATCH (%s) AGAINST (%s IN BOOLEAN MODE)(R8R{R(RRRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_match_op_binaryYscCs|S(N((RRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytget_from_hint_text]scCs-|jj|j}t|tjrDt|dtr=dSdSnt|tjrZdSt|tj tj tj tj fr|jj j|St|tjrt|ttf rtj|}|jj j|St|tjrdSt|tjr%|jj j|jddSdSdS(NRsUNSIGNED INTEGERsSIGNED INTEGERRERR&R((ttypet dialect_implR*RR RtgetattrRRDR(tDateTimetDatetTimet type_compilerR8R%RkRxRMRPt_BinaryR&RR(Rt typeclauseROtadapted((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_typeclause`s( cKsp|jjs"|j|jjS|j|j}|dkrV|j|jjSd|j|j|fS(NsCAST(%s AS %s)(R*t_supports_castR8tclauset self_groupRR(RtcastRIRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_castxs   cCs@tt|j||}|jjr<|jdd}n|S(Ns\s\\(RRtrender_literal_valueR*t_backslash_escapesR(RR5RO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRs cCs;t|jtjr&|jjdS|jr3dSdSdS(sAdd special MySQL keywords in place of DISTINCT. .. note:: this usage is deprecated. :meth:`.Select.prefix_with` should be used for special keywords at the start of a SELECT. t s DISTINCT RzN(Rt _distinctRR~tupper(RR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytget_select_precolumnss  c Ksddj|j|jdt||jr-dp0d|j|jdt|d|j|j|fS(NRztasfroms LEFT OUTER JOIN s INNER JOIN s ON (RuR8R{RtisouterRtonclause(RRuRRI((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_joins cCs|jjrdSdSdS(Ns LOCK IN SHARE MODEs FOR UPDATE(t_for_update_argR(RR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytfor_update_clauses cCs|j|j}}||fdkr)dS|dk r|dkrad|jtj|dfSd|jtj||jtj|fSnd|jtj|fSdS(NRzs LIMIT %s, %st18446744073709551615s LIMIT %s(NN(t_limitt_offsetRR8Rtliteral(RRR}toffset((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt limit_clauses   cCs5|jjd|jjd}|r-d|SdSdS(Ns%s_limitsLIMIT %s(RIRR*RnR(Rt update_stmtR}((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytupdate_limit_clausesc s-djfd|gt|DS(Ns, c3s'|]}|jdtVqdS(RN(t_compiler_dispatchR(t.0tt(RR(sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pys s(Rutlist(RRt from_tablet extra_fromsR((RRsd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytupdate_tables_clausescKsdS(N(R(RRRRt from_hintsR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytupdate_from_clauses(R R Rt'render_table_with_column_in_update_fromRt SQLCompilert extract_maptcopyRRRRRRRRRRRRRRRRRR(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRDs&            #  tMySQLDDLCompilercBsPeZdZdZdZdZdZdZdZdZ RS(cCstt|j|}d|j|jjkoQ|j|jjdjdk}|j}|r|dk r|t |j dk r|r|d7}n|d|j j d|j|j j |f7}n|S(sGet table constraints.tenginetinnodbis, s KEY %s (%s)sidx_autoinc_%sN(RRtcreate_table_constraintstdialect_optionsR*Rntlowert_autoincrement_columnRRt primary_keytpreparerRot format_column(RRtconstraint_stringt is_innodbtauto_inc_column((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRs      cKs|jj||jjj|jg}|j|}|dk rY|jd|nt |jt j }|j r| r|jdn+|j r|r|dkr|jdn||j jkr|jdkr|jdndj|S(sBuilds column DDL.sDEFAULT sNOT NULLtNULLtAUTO_INCREMENTRN(RRR*RR8Rtget_column_default_stringRRgRR RDtnullableRRtserver_defaultRu(RR(RtcolspecRt is_timestamp((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytget_column_specifications c sg}tfd|jjD}xtjdddg|D]}||}|tkrd|jdd jd d }n|dkr|jdd}nd}|dkrd}n|j|j||fqGWdj|S(s9Build table-level CREATE options like ENGINE and COLLATE.c3sT|]J\}}|jdjjr|tjjdj|fVqdS(s%s_iN(t startswithR*RnR\R(RtkR6(R(sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pys s tDEFAULT_CHARSETtCOLLATEtDEFAULT_CHARACTER_SETt PARTITION_BYt PARTITIONSs'%s's\s\\Rfs''tDATA_DIRECTORYtINDEX_DIRECTORYt CHARACTER_SETtDEFAULT_COLLATEt_Rt=t TABLESPACEsDEFAULT CHARACTER SETs CHARACTER SETs PARTITION BY(RR(RR(RR(RRRRRRR(RsDEFAULT CHARACTER SETs CHARACTER SETRs PARTITION BYR( tdictRItitemsR tsortt_options_of_type_stringRRgRu(RRt table_optstoptstopttargtjoiner((Rsd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytpost_create_tables0     %    c sx|j}|j||j}|j|j}g|jD]$}|jj|dtdt ^q;}|j |}d}|j r|d7}n|d||f7}|j dddk r ttrdjfd t|j|D}q/djfd |D}ndj|}|d |7}|j dd } | dk rt|d |j| 7}n|S(Nt include_tablet literal_bindssCREATE sUNIQUE sINDEX %s ON %s tmysqlR2s, c3se|][\}}|jkr5d||jfn'|krUd||fnd|VqdS(s%s(%d)s%sN(Rn(Rtcoltexpr(R2(sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pys Usc3s|]}d|fVqdS(s%s(%d)N((RR(R2(sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pys ass(%s)Rs USING %s(telementt_verify_index_tableRt format_tableRt expressionst sql_compilerR8RRt_prepared_index_nameRRRRRRutzipRo( RR-RdRRRRRnRR((R2sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_create_index=s4   1      cCsPtt|j|}|jdd}|rL|d|jj|7}n|S(NRRs USING %s(RRtvisit_primary_key_constraintRRRo(RR*RR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRns  cCs5|j}d|j|dt|jj|jfS(Ns DROP INDEX %s ON %stinclude_schema(RRRRRR(RRFRd((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_drop_indexvs   cCs|j}t|tjr6d}|jj|}nft|tjrWd}d}nEt|tjrd}|jj|}nd}|jj|}d|jj|j ||fS(Ns FOREIGN KEY s PRIMARY KEY RzsINDEX sALTER TABLE %s DROP %s%s( RRt sa_schematForeignKeyConstraintRtformat_constrainttPrimaryKeyConstrainttUniqueConstraintRR(RRFR*tqualtconst((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_drop_constraint~s  cCs%|jdk r!tjdndS(NsjMySQL ignores the 'MATCH' keyword while at the same time causes ON UPDATE/ON DELETE clauses to be ignored.Rz(RRRt CompileError(RR*((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytdefine_constraint_matchs ( R R RRRRRRRR(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRs   & 1   tMySQLTypeCompilercBs^eZdZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZ dZ!d Z"d!Z#d"Z$d#Z%d$Z&d%Z'RS(&cCsC|j|s|S|jr)|d7}n|jr?|d7}n|S(sAExtend a numeric-type declaration with MySQL specific extensions.s UNSIGNEDs ZEROFILL(t _mysql_typeRR(RROtspec((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt_extend_numerics    csfd}|dr1d|d}n0|drFd}n|dr[d}nd}|dr}d j}n|d rd }nd}|d rd jgd||fD]}|dk r|^qSd jg|||fD]}|dk r|^qS(sExtend a string-type declaration with standard SQL CHARACTER SET / COLLATE annotations and MySQL specific extensions. cst|j|S(N(RR(Rn(ROtdefaults(sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytattrsRsCHARACTER SET %sR"tASCIIR#tUNICODERs COLLATE %sRRR$RtNATIONALN(RRRu(RRORRRRRtc((RORsd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt_extend_strings$         cCst|ttfS(N(RRR(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRscCsx|jdkr|j|dS|jdkrL|j|di|jd6S|j|di|jd6|jd6SdS(NR&sNUMERIC(%(precision)s)Rs!NUMERIC(%(precision)s, %(scale)s)R(RRRR(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_NUMERICs   cCsx|jdkr|j|dS|jdkrL|j|di|jd6S|j|di|jd6|jd6SdS(NR(sDECIMAL(%(precision)s)Rs!DECIMAL(%(precision)s, %(scale)s)R(RRRR(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_DECIMALs   cCsZ|jdk rF|jdk rF|j|di|jd6|jd6S|j|dSdS(Ns DOUBLE(%(precision)s, %(scale)s)RRR(RRRR(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_DOUBLEs   cCsZ|jdk rF|jdk rF|j|di|jd6|jd6S|j|dSdS(NsREAL(%(precision)s, %(scale)s)RRR(RRRR(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_REALs   cCs|j|rM|jdk rM|jdk rM|j|d|j|jfS|jdk rv|j|d|jfS|j|dSdS(Ns FLOAT(%s, %s)s FLOAT(%s)R)(RRRRR(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_FLOATs cCsP|j|r<|jdk r<|j|di|jd6S|j|dSdS(NsINTEGER(%(display_width)s)RR,(RRRR(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_INTEGERs cCsP|j|r<|jdk r<|j|di|jd6S|j|dSdS(NsBIGINT(%(display_width)s)RR-(RRRR(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_BIGINT s cCsP|j|r<|jdk r<|j|di|jd6S|j|dSdS(NsMEDIUMINT(%(display_width)s)RR.(RRRR(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_MEDIUMINTs cCsI|j|r5|jdk r5|j|d|jS|j|dSdS(Ns TINYINT(%s)R/(RRRR(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_TINYINTs cCsP|j|r<|jdk r<|j|di|jd6S|j|dSdS(NsSMALLINT(%(display_width)s)RR0(RRRR(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_SMALLINT s  cCs"|jdk rd|jSdSdS(NsBIT(%s)R1(R2R(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_BIT)s cCs%t|ddrd|jSdSdS(NR=s DATETIME(%d)RE(RRR=(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_DATETIME/s cCsdS(NR ((RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_DATE5scCs%t|ddrd|jSdSdS(NR=sTIME(%d)R;(RRR=(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_TIME8s cCs%t|ddrd|jSdSdS(NR=s TIMESTAMP(%d)RD(RRR=(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_TIMESTAMP>s cCs"|jdkrdSd|jSdS(NRFsYEAR(%s)(RR(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_YEARDscCs:|jr#|j|id|jS|j|idSdS(NsTEXT(%d)RG(R2R(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_TEXTJs cCs|j|idS(NRH(R(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_TINYTEXTPscCs|j|idS(NRJ(R(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_MEDIUMTEXTSscCs|j|idS(NRK(R(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_LONGTEXTVscCs@|jr#|j|id|jStjd|jjdS(Ns VARCHAR(%d)s'VARCHAR requires a length on dialect %s(R2RRRR*Rn(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_VARCHARYs  cCsA|jr*|j|idi|jd6S|j|idSdS(NsCHAR(%(length)s)R2RM(R2R(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_CHARbs cCsN|jr1|j|itd6di|jd6Stjd|jjdS(NR$sVARCHAR(%(length)s)R2s(NVARCHAR requires a length on dialect %s(R2RRRRR*Rn(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_NVARCHARis  cCsO|jr1|j|itd6di|jd6S|j|itd6dSdS(NR$sCHAR(%(length)s)R2RM(R2RR(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_NCHARus   cCs d|jS(Ns VARBINARY(%d)(R2(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_VARBINARYscCs |j|S(N(t visit_BLOB(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_large_binaryscCs9|jstt|j|S|jd||jSdS(NRk(RpRRt visit_enumt_visit_enumerated_valuesRs(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR9s cCs|jrd|jSdSdS(NsBLOB(%d)R (R2(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR7s  cCsdS(NRT((RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_TINYBLOBscCsdS(NRU((RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_MEDIUMBLOBscCsdS(NRV((RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytvisit_LONGBLOBscCsZg}x+|D]#}|jd|jddq W|j|id|dj|fS(Ns'%s'Rfs''s%s(%s)R{(RgRRRu(RRnROtenumerated_valuest quoted_enumsRc((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR:s  !cCs|jd||jS(NRk(R:R`(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_ENUMs cCs|jd||jS(NRx(R:R`(RRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_SETs cCsdS(NtBOOL((RR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt visit_BOOLEANs((R R RRRRRR R!R"R#R$R%R&R'R(R)R*R+R,R-R.R/R0R1R2R3R4R5R6R8R9R7R;R<R=R:R@RARC(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRsL                          tMySQLIdentifierPreparercBs#eZeZedZdZRS(cKs;|sd}nd}tt|j|d|d|dS(Nt`Ret initial_quotet escape_quote(RRDR(RR*tserver_ansiquotesRRo((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRs cGs2tg|D]!}|dk r |j|^q S(s4Unilaterally identifier-quote any number of strings.N(RyRtquote_identifier(RtidsR7((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt_quote_free_identifierss(R R tRESERVED_WORDStreserved_wordsRRRK(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRDs t MySQLDialectcBseZdZdZeZdZdZeZeZ e Z eZ dZ eZeZeZeZeZeZeZe Zejid4d6fejid4d6fejid4d6fej id4d6d4d6fgZ!d4d Z"d Z#e$d d d dgZ%dZ&dZ'dZ(dZ)dZ*dZ+ee dZ,ee dZ-dZ.dZ/d4dZ0d4dZ1d4dZ2dZ3dZ4d4dZ5dZ6e7d Z8e9j:d!Z;e9j:d4d"Z<e9j:d4d#Z=e9j:d4d$Z>e9j:d4d%Z?e9j:d4d&Z@e9j:d4d'ZAe9j:d4d(ZBe9j:d4d)ZCe9j:d4d*ZDd4d+ZEeFjGd,ZHe9j:d4d-ZId.ZJd/ZKd0ZLd1ZMd4d4d2ZNd4d4d3ZORS(5sMDetails of the MySQL dialect. Not used directly in application code. Rii@tformatt*R}RR2cKs0|jddtjj||||_dS(Ntuse_ansiquotes(R!RRtDefaultDialectRtisolation_level(RRSRI((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRscs*jdk r"fd}|SdSdS(Ncsj|jdS(N(tset_isolation_levelRS(tconn(R(sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytconnects(RSR(RRV((Rsd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt on_connectst SERIALIZABLEsREAD UNCOMMITTEDsREAD COMMITTEDsREPEATABLE READcCs|jdd}||jkrOtjd||jdj|jfn|j}|jd||jd|jdS(NRRsLInvalid value '%s' for isolation_level. Valid isolation levels for %s are %ss, s*SET SESSION TRANSACTION ISOLATION LEVEL %stCOMMIT( Rt_isolation_lookupRRRnRuR3texecutetclose(Rt connectiontlevelR3((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRT s%  cCsp|j}|jd|jd}|jtjrZt|trZ|j}n|j j ddS(NsSELECT @@tx_isolationit-R( R3R[tfetchoneR\Rtpy3kRtbytestdecodeRR(RR]R3tval((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytget_isolation_level s   cCs^y|jWnI|jdkrStjdj}|rS|ddkrSdSnnXdS( sExecute a COMMIT.iiiiii(N(iii(tcommittserver_version_infotsystexc_infotargs(Rtdbapi_connectionRj((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt do_commit s cCs^y|jWnI|jdkrStjdj}|rS|ddkrSdSnnXdS( sExecute a ROLLBACK.iiiiii(N(iii(trollbackRgRhRiRj(RRkRj((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt do_rollback. scCs |jtjdd|dS(Ns XA BEGIN :xidtxid(R[RR(RR]Ro((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytdo_begin_twophase: scCs<|jtjdd||jtjdd|dS(Ns XA END :xidRosXA PREPARE :xid(R[RR(RR]Ro((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytdo_prepare_twophase= scCsE|s%|jtjdd|n|jtjdd|dS(Ns XA END :xidRosXA ROLLBACK :xid(R[RR(RR]Rot is_preparedtrecover((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytdo_rollback_twophaseA scCs9|s|j||n|jtjdd|dS(NsXA COMMIT :xidRo(RqR[RR(RR]RoRrRs((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytdo_commit_twophaseG scCs5|jd}g|D]}|dd|d!^qS(Ns XA RECOVERtdatait gtrid_length(R[(RR]t resultsettrow((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytdo_recover_twophaseM scCsat||jj|jjfr4|j|dkSt||jjrYdt|kStSdS(Niiiiis(0, '')(iiiii(RtdbapitOperationalErrortProgrammingErrort_extract_error_codetInterfaceErrortstrR(RRcR]R3((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt is_disconnectQ s cCs&g|jD]}t||^q S(sMProxy result rows to smooth over MySQL-Python driver inconsistencies.(tfetchallt_DecodingRowProxy(RtrpRRy((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt_compat_fetchall] scCst|j|S(sNProxy a result row to smooth over MySQL-Python driver inconsistencies.(RR`(RRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt_compat_fetchonec scCst|j|S(sNProxy a result row to smooth over MySQL-Python driver inconsistencies.(Rtfirst(RRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt _compat_firsti scCs tdS(N(tNotImplementedError(Rt exception((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR~o scCs|jdjS(NsSELECT DATABASE()(R[tscalar(RR]((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt_get_default_schema_namer sc Csdj|jj||}d|}d}zoy3|j|}|jdk }|j|SWn5tjk r}|j |j dkrt SnXWd|r|jnXdS(Nt.s DESCRIBE %siz( Rutidentifier_preparerRKRR[R`R\Rt DBAPIErrorR~torigR( RR]t table_nameRt full_nametsttrsthaveRc((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt has_tableu s    cCs]|j||_|j||jrF|j|d|j|_ntjj||dS(NRH( t_detect_charsett_connection_charsett_detect_ansiquotest_server_ansiquotesRRRRRt initialize(RR]((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR s   cCs|jdkp|jdkS(Niii(iii(RgR(R((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR scKs*|jd}g|D]}|d^qS(Ns SHOW schemasi(R[(RR]RRtr((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytget_schema_names scKs|d k r|}n |j}|j}|jd kr|jd|jj|}g|j|d|D]}|d^qkS|jd|jj|}g|j|d|D] }|ddkr|d^qSd S( s1Return a Unicode SHOW TABLES from a given schema.iiisSHOW TABLES FROM %sRsSHOW FULL TABLES FROM %sis BASE TABLEN(iii(Rtdefault_schema_nameRRgR[RRIR(RR]RRtcurrent_schemaRRRy((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytget_table_names s     'cKs|jd krtn|dkr0|j}n|jd krO|j||S|j}|jd|jj|}g|j |d|D] }|dd kr|d^qS( NiiisSHOW FULL TABLES FROM %sRitVIEWs SYSTEM VIEW(iii(iii(Rs SYSTEM VIEW( RgRRRRRR[RRIR(RR]RRRRRy((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytget_view_names s    cKs|j||||}|jS(N(t_parsed_state_or_createt table_options(RR]RRRt parsed_state((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytget_table_options scKs|j||||}|jS(N(RR(RR]RRRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt get_columns sc Ks|j||||}xT|jD]I}|ddkr"g|dD]}|d^qC}i|d6dd6Sq"Wigd6dd6S(NRtPRIMARYRitconstrained_columnsRn(RRwR( RR]RRRRRvtstcols((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytget_pk_constraint s!cKs<|j||||}d}g}x|jD]}|dd} t|ddkrf|ddpi|} | s|dkr|jj}n||kr|} qn|d} |d} i} x1dD])}|j|tr||| |(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +\($sF(?:(?:%(iq)s((?:%(esc_fq)s|[^%(fq)s])+)%(fq)s)(?:\((\d+)\))?(?=\,|$))+s\x27(?:\x27\x27|[^\x27])*\x27s\d+s6 %(iq)s(?P(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +(?P\w+)(?:\((?P(?:\d+|\d+,\d+|(?:\x27(?:\x27\x27|[^\x27])*\x27,?)+))\))?(?: +(?PUNSIGNED))?(?: +(?PZEROFILL))?(?: +CHARACTER SET +(?P[\w_]+))?(?: +COLLATE +(?P[\w_]+))?(?: +(?PNOT NULL))?(?: +DEFAULT +(?P(?:NULL|\x27(?:\x27\x27|[^\x27])*\x27|\w+(?: +ON UPDATE \w+)?)))?(?: +(?PAUTO_INCREMENT))?(?: +COMMENT +(P(?:\x27\x27|[^\x27])+))?(?: +COLUMN_FORMAT +(?P\w+))?(?: +STORAGE +(?P\w+))?(?: +(?P.*))?,?$s %(iq)s(?P(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +(?P\w+)(?:\((?P(?:\d+|\d+,\d+|\x27(?:\x27\x27|[^\x27])+\x27))\))?.*?(?PNOT NULL)?s (?:(?P\S+) )?KEY(?: +%(iq)s(?P(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s)?(?: +USING +(?P\S+))? +\((?P.+?)\)(?: +USING +(?P\S+))?(?: +KEY_BLOCK_SIZE *[ =]? *(?P\S+))?(?: +WITH PARSER +(?P\S+))?,?$s"RESTRICT|CASCADE|SET NULL|NOACTIONRs, CONSTRAINT +%(iq)s(?P(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +FOREIGN KEY +\((?P[^\)]+?)\) REFERENCES +(?P%(iq)s[^%(fq)s]+%(fq)s(?:\.%(iq)s[^%(fq)s]+%(fq)s)?) +\((?P[^\)]+?)\)(?: +(?PMATCH \w+))?(?: +ON DELETE (?P%(on)s))?(?: +ON UPDATE (?P%(on)s))?s(?:.*)(?:SUB)?PARTITION(?:.*)tENGINEtTYPERtAVG_ROW_LENGTHs CHARACTER SETsDEFAULT CHARSETtCHECKSUMRtDELAY_KEY_WRITEt INSERT_METHODtMAX_ROWStMIN_ROWSt PACK_KEYSt ROW_FORMATtKEY_BLOCK_SIZEtUNIONs \([^\)]+\)Rs.*? STORAGE DISKt RAID_TYPEs4\w+\s+RAID_CHUNKS\s*\=\s*\w+RAID_CHUNKSIZE\s*=\s*\w+N(R*R+R,(R-R.sAUTO_INCREMENTR/s CHARACTER SETsDEFAULT CHARSETR0sCOLLATER1R2R3R4R5R6R7(t _re_columnsR Rt final_quoteRRRFt_escape_identifierRtescapet _pr_compilet_unescape_identifierRt _re_compileR(RRRRRRRRRt_add_option_stringt_add_option_wordt_add_option_regex(Rt_finalRtquotesRR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR s\     4        s(?:\s*(?:=\s*)|\s+)cCs<dtj||jf}|jjt|ddS(Ns0(?P%s)%s'(?P(?:[^']|'')*?)'(?!')cSs|jddjddS(Ns\\s\s''Rf(R(R6((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyto s(RR=t_optional_equalsR RgR>(RR R ((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRAj s cCs6dtj||jf}|jjt|dS(Ns(?P%s)%s(?P\w+)(RR=RGR RgR>(RR R ((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRBr scCs9dtj||j|f}|jjt|dS(Ns(?P%s)%s(?P%s)(RR=RGR RgR>(RR R ((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyRCx s(R R RRRRRRRRRRRGRARBRC(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR s   #  P -    tCOMMENTsDATA DIRECTORYsINDEX DIRECTORYtPASSWORDt CONNECTIONRcBs)eZdZdZdZdZRS(sReturn unicode-decoded values based on type inspection. Smooth over data type issues (esp. with alpha driver versions) and normalize strings as Unicode regardless of user-configured driver encoding settings. cCs||_||_dS(N(trowproxyR(RRKR((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR s cCs^|j|}t|tr+|j}n|jrVt|tjrV|j|jS|SdS(N(RKRt_arrayttostringRRt binary_typeRc(RRdtitem((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt __getitem__ s  cCsct|j|}t|tr0|j}n|jr[t|tjr[|j|jS|SdS(N( RRKRRLRMRRRNRc(RRRO((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyt __getattr__ s (R R RRRPRQ(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR s  cCst||fS(s1Prepare a 2-tuple of compiled regex and callable.(R@(R R ((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR> scCstj|tjtjBS(s)Compile a string to regex, I and UNICODE.(RtcompiletIR(R ((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pyR@ s(~RRCRRhRzRR RRRRRRRLRRRR R R R R R RRRRLRRRSRRtSET_REtobjectRRRRRR%RR&R(RRR)R,R-R.R/R0t TypeEngineR1R;RDRERFRGRHRJRKRLRMRRRSRRTRURVRWRrRkRxtMSTimetMSSettMSEnumt MSLongBlobt MSMediumBlobt MSTinyBlobtMSBlobtMSBinaryt MSVarBinarytMSNChart MSNVarChartMSChartMSStringt MSLongTextt MSMediumTextt MSTinyTexttMSTexttMSYeart MSTimeStamptMSBittMSSmallIntegert MSTinyIntegertMSMediumIntegert MSBigIntegert MSNumerict MSDecimaltMSDoubletMSRealtMSFloatt MSIntegerR RRRtDefaultExecutionContextRRRt DDLCompilerRtGenericTypeCompilerRtIdentifierPreparerRDt class_loggerRRRNRRRRRR>R@(((sd/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/dialects/mysql/base.pytsv   "(       ""&. %!!!!*,Yb         &