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

- most of the reorg into many files with section containers

2014-12-17T02:56:47+00:00

- rework sqlite FK and unique constraint system to combine both PRAGMA

2014-12-14T00:24:56+00:00

and regexp parsing of SQL in order to form a complete picture of
constraints + their names.  fixes #3244 fixes #3261
- factor various PRAGMA work to be centralized into one call

- fix unique constraint parsing for sqlite -- may return '' for name, however

2014-12-13T23:34:50+00:00

- SQL Server 2012 now recommends VARCHAR(max), NVARCHAR(max),

2014-12-06T18:43:39+00:00

VARBINARY(max) for large text/binary types.  The MSSQL dialect will
now respect this based on version detection, as well as the new
``deprecate_large_types`` flag.
fixes #3039

- The SQLite dialect, when using the :class:`.sqlite.DATE`,

2014-12-05T19:46:43+00:00

:class:`.sqlite.TIME`,
or :class:`.sqlite.DATETIME` types, and given a ``storage_format`` that
only renders numbers, will render the types in DDL as
``DATE_CHAR``, ``TIME_CHAR``, and ``DATETIME_CHAR``, so that despite the
lack of alpha characters in the values, the column will still
deliver the "text affinity".  Normally this is not needed, as the
textual values within the default storage formats already
imply text.
fixes #3257

- New Oracle DDL features for tables, indexes: COMPRESS, BITMAP.

2014-12-05T01:08:07+00:00

Patch courtesy Gabor Gombas.
fixes #3127

- Added support for CTEs under Oracle. This includes some tweaks

2014-12-05T00:35:00+00:00

to the aliasing syntax, as well as a new CTE feature
:meth:`.CTE.suffix_with`, which is useful for adding in special
Oracle-specific directives to the CTE.
fixes #3220

- Updated the "supports_unicode_statements" flag to True for MySQLdb

2014-12-05T00:12:52+00:00

and Pymysql under Python 2.   This refers to the SQL statements
themselves, not the parameters, and affects issues such as table
and column names using non-ASCII characters.   These drivers both
appear to support Python 2 Unicode objects without issue in modern
versions.
fixes #3121

- The :meth:`.Operators.match` operator is now handled such that the

2014-12-04T23:29:56+00:00

return type is not strictly assumed to be boolean; it now
returns a :class:`.Boolean` subclass called :class:`.MatchType`.
The type will still produce boolean behavior when used in Python
expressions, however the dialect can override its behavior at
result time.  In the case of MySQL, while the MATCH operator
is typically used in a boolean context within an expression,
if one actually queries for the value of a match expression, a
floating point value is returned; this value is not compatible
with SQLAlchemy's C-based boolean processor, so MySQL's result-set
behavior now follows that of the :class:`.Float` type.
A new operator object ``notmatch_op`` is also added to better allow
dialects to define the negation of a match operation.
fixes #3263

- The :meth:`.PGDialect.has_table` method will now query against

2014-12-04T17:01:19+00:00

``pg_catalog.pg_table_is_visible(c.oid)``, rather than testing
for an exact schema match, when the schema name is None; this
so that the method will also illustrate that temporary tables
are present.  Note that this is a behavioral change, as Postgresql
allows a non-temporary table to silently overwrite an existing
temporary table of the same name, so this changes the behavior
of ``checkfirst`` in that unusual scenario.
fixes #3264