delta/python-packages/sqlalchemy.git/lib/sqlalchemy/dialects, branch pr/53

dialects/mysql: inspect superclass for IntegerType in repr

2013-12-18T01:21:38+00:00

This was causing issues with Alembic (https://bitbucket.org/zzzeek/alembic/issue/127/auto-generate-seems-to-miss-unsigned)

Fix MSSQL dialects visit_drop_index to use the correct DDL

2013-12-05T23:37:50+00:00

- backport unique constraints reflection to 0.8.4, thereby

2013-12-03T19:59:50+00:00

assisting with alembic installations that have upgraded and are dealing with
PG index/unique constraint reflection.

Inspection API already supports reflection of table
indexes information and those also include unique
constraints (at least for PostgreSQL and MySQL).
But it could be actually useful to distinguish between
indexes and plain unique constraints (though both are
implemented in the same way internally in RDBMS).

This change adds a new method to Inspection API - get_unique_constraints()
and implements it for SQLite, PostgreSQL and MySQL dialects.

- Added ORA-02396 "maximum idle time" error code to list of

2013-12-03T18:19:05+00:00

"is disconnect" codes with cx_oracle. [ticket:2864]

Fixed bug where Oracle ``VARCHAR`` types given with no length

2013-11-22T22:56:57+00:00

(e.g. for a ``CAST`` or similar) would incorrectly render ``None CHAR``
or similar. [ticket:2870]

- Fixed bug where index reflection would mis-interpret indkey values

2013-10-27T22:16:42+00:00

when using the pypostgresql adapter, which returns these values
as lists vs. psycopg2's return type of string.
[ticket:2855]

Conflicts:
	doc/build/changelog/changelog_09.rst
	lib/sqlalchemy/__init__.py

- Fixed bug where Oracle table reflection using synonyms would fail

2013-10-25T23:12:17+00:00

if the synonym and the table were in different remote schemas.
Patch to fix courtesy Kyle Derr. [ticket:2853]

- attempt to clarify what mutable extension does for HSTORE, [ticket:2803]

2013-10-18T23:35:22+00:00

- Removed a 128-character truncation from the reflection of the

2013-10-18T23:00:29+00:00

server default for a column; this code was original from
PG system views which truncated the string for readability.
[ticket:2844]

- The change in :ticket:`2721`, which is that the ``deferrable`` keyword

2013-10-18T19:00:42+00:00

of :class:`.ForeignKeyConstraint` is silently ignored on the MySQL
backend, will be reverted as of 0.9; this keyword will now render again, raising
errors on MySQL as it is not understood - the same behavior will also
apply to the ``initially`` keyword.  In 0.8, the keywords will remain
ignored but a warning is emitted.   Additionally, the ``match`` keyword
now raises a :class:`.CompileError` on 0.9 and emits a warning on 0.8;
this keyword is not only silently ignored by MySQL but also breaks
the ON UPDATE/ON DELETE options.

To use a :class:`.ForeignKeyConstraint`
that does not render or renders differently on MySQL, use a custom
compilation option.  An example of this usage has been added to the
documentation, see :ref:`mysql_foreign_keys`.
[ticket:2721] [ticket:2839]