delta/python-packages/sqlalchemy.git/lib/sqlalchemy/engine, branch pr/230

- calling str() on a core sql construct has been made more "friendly",

2016-01-19T21:47:16+00:00

when the construct contains non-standard sql elements such as
returning, array index operations, or dialect-specific or custom
datatypes.  a string is now returned in these cases rendering an
approximation of the construct (typically the postgresql-style
version of it) rather than raising an error. fixes #3631
- add within_group to top-level imports
- add eq_ignore_whitespace to sqlalchemy.testing imports

- A deep improvement to the recently added :meth:`.TextClause.columns`

2016-01-14T23:06:26+00:00

method, and its interaction with result-row processing, now allows
the columns passed to the method to be positionally matched with the
result columns in the statement, rather than matching on name alone.
The advantage to this includes that when linking a textual SQL statement
to an ORM or Core table model, no system of labeling or de-duping of
common column names needs to occur, which also means there's no need
to worry about how label names match to ORM columns and so-forth.  In
addition, the :class:`.ResultProxy` has been further enhanced to
map column and string keys to a row with greater precision in some
cases.  fixes #3501
- reorganize the initialization of ResultMetaData for readability
and complexity; use the name "cursor_description", define the
task of "merging" cursor_description with compiled column information
as its own function, and also define "name extraction" as a separate task.
- fully change the name we use in the "ambiguous column" error to be the
actual name that was ambiguous, modify the C ext also

- reorganize schema_translate_map to be succinct and gain the performance

2016-01-11T21:44:28+00:00

back by using an attrgetter for the default case

- ensure we use a Connection for effective schema here since Engine doesn't

2016-01-10T03:25:56+00:00

have it; keep it simple

- Multi-tenancy schema translation for :class:`.Table` objects is added.

2016-01-09T03:12:25+00:00

This supports the use case of an application that uses the same set of
:class:`.Table` objects in many schemas, such as schema-per-user.
A new execution option
:paramref:`.Connection.execution_options.schema_translate_map` is
added. fixes #2685
- latest tox doesn't like the {posargs} in the profile rerunner

- Added a new entrypoint system to the engine to allow "plugins" to

2016-01-06T22:20:57+00:00

be stated in the query string for a URL.   Custom plugins can
be written which will be given the chance up front to alter and/or
consume the engine's URL and keyword arguments, and then at engine
create time will be given the engine itself to allow additional
modifications or event registration.  Plugins are written as a
subclass of :class:`.CreateEnginePlugin`; see that class for
details.
fixes #3536

- Fixed 1.0 regression where the eager fetch of cursor.rowcount was

2016-01-05T15:25:36+00:00

no longer called for an UPDATE or DELETE statement emitted via plain
text or via the :func:`.text` construct, affecting those drivers
that erase cursor.rowcount once the cursor is closed such as SQL
Server ODBC and Firebird drivers.
fixes #3622

Change generator termination from StopIteration to return.

2015-10-30T20:20:58+00:00

From [PEP 479](https://www.python.org/dev/peps/pep-0479/) the correct way to
terminate a generator is to return (which implicitly raises StopIteration)
rather than raise StopIteration.

Without this change using sqlalchemy in python 3.5 or greater results in
these warnings
    PendingDeprecationWarning: generator '__iter__' raised StopIteration
which this commit should remove.

Add a lot more detail

2015-09-23T21:05:20+00:00

(cherry picked from commit 5db5e18d3babdb3ee857c075c774a585505b78ce)

Add some markup

2015-09-23T21:05:14+00:00

(cherry picked from commit 81eefe038ea44a5314002483dde9cf00580df1bd)