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

Clarify order_by(False)

2016-07-29T22:57:04+00:00

It wasn't clear how this differs from order_by(None);
add more tests and document that this has to do with whether or
not mapper.order_by will be re-enabled as well.

Change-Id: I332e8ac60c999b38c5a243f1cb72de3cf77891b6

Allow None to cancel Query.group_by()

2016-07-29T22:44:34+00:00

This replicates the same behavior as order_by().

order_by() will also be updated to deprecate passing
of False as this is no longer functionally different
than passing None.

Change-Id: I2fc05d0317d28b6c83373769a48f7eea32d56290
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/297

Add 'FOR NO KEY UPDATE' / 'FOR KEY SHARE' support for Postgresql

2016-06-08T15:24:57+00:00

Adds ``key_share=True`` for with_for_update().

Co-authored-by: Mike Bayer 
Change-Id: I74e0c3fcbc023e1dc98a1fa0c7db67b4c3693a31
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/279

Add SKIP LOCKED support for Postgresql, Oracle

2016-06-02T21:46:16+00:00

This adds `SELECT ... FOR UPDATE SKIP LOCKED`/
`SELECT ... FOR SHARE SKIP LOCKED` rendering.

Change-Id: Id1dc4f1cafc1de23f397a6f73d54ab2c58d5910d
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/86

Rename Query._mapper_zero() to Query._entity_zero()

2016-04-19T19:53:50+00:00

To be more descriptive of the use of _mapper_zero(), rename
it to _entity_zero(), but also supply a new _mapper_zero() function
that more strictly returns a mapper.  The existing
_entity_zero() function is renamed to _query_entity_zero.
_only_mapper_zero() is removed as it isn't used.  Divide up the
existing calling functions to refer to the appropriate new method.

Change-Id: I8780c3235e87b4936c6daf64d9d299b22b6e1260
Fixes: #3608

- Added support for rendering "FULL OUTER JOIN" to both Core and ORM.

2016-03-28T15:50:09+00:00

Pull request courtesy Stefan Urbanek.  fixes #1957

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