delta/python-packages/sqlalchemy.git/test/dialect/test_mysql.py, branch 3296

refactor test suites for postgresql, mssql, mysql into packages.

2013-06-29T02:30:11+00:00

YEAR(2) emits a warning and oursql / mysqlconnector throw an exception

2013-06-24T00:13:28+00:00

on the warning so just dump it

most of these dialect=mysql.dialect() calls are redundant

2013-06-08T18:49:56+00:00

Fix using of 'mysql_length' for composite indexes

2013-06-08T17:56:28+00:00

Currently, one can specify the prefix length for an index
column using 'mysql_length' keyword argument when creating
an Index instance. But in case of composite indexes the
prefix length value is applied only to the last column.

Extend the existing API in way so that 'mysql_length' argument
value can be either:
    - an integer specifying the same prefix length value
      for each column of an index
    - a (column_name --> integer value) mapping specifying
      the prefix length value for each column of an index
      separately

Fixes issue #2704.

The ``deferrable`` keyword argument on :class:`.ForeignKey` and

2013-06-03T22:33:20+00:00

:class:`.ForeignKeyConstraint` will not render the ``DEFERRABLE`` keyword
on the MySQL dialect.  For a long time we left this in place because
a non-deferrable foreign key would act very differently than a deferrable
one, but some environments just disable FKs on MySQL, so we'll be less
opinionated here. [ticket:2721]

mysql tests

2013-05-26T20:32:55+00:00

- the raw 2to3 run

2013-04-27T23:53:57+00:00

- went through examples/ and cleaned out excess list() calls

test for cymysql

2013-02-17T06:07:19+00:00

- [feature] Added "collation" parameter to all

2012-10-10T23:34:29+00:00

    String types.  When present, renders as
    COLLATE .  This to support the
    COLLATE keyword now supported by several
    databases including MySQL, SQLite, and Postgresql.
    [ticket:2276]

  - [change] The Text() type renders the length
    given to it, if a length was specified.

- [feature] Added TIME type to mysql dialect,

2012-10-10T18:25:21+00:00

    accepts "fst" argument which is the new
    "fractional seconds" specifier for recent
    MySQL versions.  The datatype will interpret
    a microseconds portion received from the driver,
    however note that at this time most/all MySQL
    DBAPIs do not support returning this value.
    [ticket:2534]
- attempted to modernize the types tests in test_mysql a little, though has a long
way to go