delta/python-packages/sqlalchemy.git/lib/sqlalchemy/orm/query.py, branch pr/249

Adds documentation to Query.slice().

2016-03-13T20:37:55+00:00

- An improvement to the workings of :meth:`.Query.correlate` such

2016-02-26T04:27:49+00:00

that when a "polymorphic" entity is used which represents a straight
join of several tables, the statement will ensure that all the
tables within the join are part of what's correlating.
fixes #3662

- CTE functionality has been expanded to support all DML, allowing

2016-02-11T17:27:28+00:00

INSERT, UPDATE, and DELETE statements to both specify their own
WITH clause, as well as for these statements themselves to be
CTE expressions when they include a RETURNING clause.
fixes #2551

- A refinement to the logic which adds columns to the resulting SQL when

2016-02-09T22:49:38+00:00

:meth:`.Query.distinct` is combined with :meth:`.Query.order_by` such
that columns which are already present will not be added
a second time, even if they are labeled with a different name.
Regardless of this change, the extra columns added to the SQL have
never been returned in the final result, so this change only impacts
the string form of the statement as well as its behavior when used in
a Core execution context.   Additionally, columns are no longer added
when the DISTINCT ON format is used, provided the query is not
wrapped inside a subquery due to joined eager loading.
fixes #3641

- happy new year

2016-01-29T16:20:22+00:00

- The ``str()`` call for :class:`.Query` will now take into account

2016-01-19T17:44:42+00:00

the :class:`.Engine` to which the :class:`.Session` is bound, when
generating the string form of the SQL, so that the actual SQL
that would be emitted to the database is shown, if possible.  Previously,
only the engine associated with the :class:`.MetaData` to which the
mappings are associated would be used, if present.  If
no bind can be located either on the :class:`.Session` or on
the :class:`.MetaData` to which the mappings are associated, then
the "default" dialect is used to render the SQL, as was the case
previously.  fixes #3081

- Fixed bug where use of the :meth:`.Query.select_from` method would

2015-12-13T02:08:56+00:00

cause a subsequent call to the :meth:`.Query.with_parent` method to
fail. fixes #3606
- add mark-as-fail test for #3607

- write a real inline documentation section for from_self(),

2015-12-07T17:36:36+00:00

building on the example of query.join().  Ideally all the methods
in Query would have this kind of thing.  fixes #3544

- Added support for parameter-ordered SET clauses in an UPDATE

2015-11-28T19:30:05+00:00

statement.  This feature is available by passing the
:paramref:`~.sqlalchemy.sql.expression.update.preserve_parameter_order`
flag either to the core :class:`.Update` construct or alternatively
adding it to the :paramref:`.Query.update.update_args` dictionary at
the ORM-level, also passing the parameters themselves as a list of 2-tuples.
Thanks to Gorka Eguileor for implementation and tests.
adapted from pullreq github:200

- Fixed bug where the "single table inheritance" criteria would be

2015-11-11T17:57:32+00:00

added onto the end of a query in some inappropriate situations, such
as when querying from an exists() of a single-inheritance subclass.

fixes #3582