delta/python-packages/sqlalchemy.git/lib/sqlalchemy/orm/query.py, branch oracle_numeric github.com: zzzeek/sqlalchemy.git Add clause adaptation for AliasedClass to with_parent() 2017-05-23T15:13:18+00:00 Mike Bayer mike_mp@zzzcomputing.com 2017-05-22T19:08:10+00:00 1c692f019b16ff4f3eb17ea8d09731837cc3be76 Fixed bug where :meth:`.Query.with_parent` would not work if the :class:`.Query` were against an :func:`.aliased` construct rather than a regular mapped class. Also adds a new parameter :paramref:`.util.with_parent.from_entity` to the standalone :func:`.util.with_parent` function as well as :meth:`.Query.with_parent`. Change-Id: Ic684dd63cc90b582c7580c9bba3c92fa3f286da7 Fixes: #3607 
Fixed bug where :meth:`.Query.with_parent` would not work if the
:class:`.Query` were against an :func:`.aliased` construct rather than
a regular mapped class.  Also adds a new parameter
:paramref:`.util.with_parent.from_entity` to the standalone
:func:`.util.with_parent` function as well as
:meth:`.Query.with_parent`.

Change-Id: Ic684dd63cc90b582c7580c9bba3c92fa3f286da7
Fixes: #3607
Demote innerjoin to outerjoin coming from with_polymorphic 2017-05-12T19:18:45+00:00 Mike Bayer mike_mp@zzzcomputing.com 2017-05-12T16:01:53+00:00 94a089bc2b425f7896659868630836c013e80dd0 a with_polymorphic, regardless of inheritance type, represents multiple classes. A subclass that wants to joinedload with innerjoin=True needs to be demoted to an outerjoin because the parent entity rows might not be of that type. Looks more intuitive with a joined inheritance load, but applies just as well to single or concrete. Change-Id: I4d3d76106ae20032269f8848aad70a8e2f9422f9 Fixes: #3988 
a with_polymorphic, regardless of inheritance type, represents
multiple classes.  A subclass that wants to joinedload with innerjoin=True
needs to be demoted to an outerjoin because the parent entity rows
might not be of that type.   Looks more intuitive with a joined
inheritance load, but applies just as well to single or concrete.

Change-Id: I4d3d76106ae20032269f8848aad70a8e2f9422f9
Fixes: #3988
Add selectin loading 2017-04-26T20:08:57+00:00 Mike Bayer mike_mp@zzzcomputing.com 2017-03-23T21:55:43+00:00 19d2424e05fadf66044d914b13a405cb212b4100 Adding a new kind of relationship loader that is a cross between the "immediateload" and the "subquery" eager loader, using an IN criteria to load related items in bulk immediately after the lead query result is loaded. Change-Id: If13713fba9b465865aef8fd50b5b6b977fe3ef7d Fixes: #3944 
Adding a new kind of relationship loader that is
a cross between the "immediateload" and the "subquery"
eager loader, using an IN criteria to load related items
in bulk immediately after the lead query result is loaded.

Change-Id: If13713fba9b465865aef8fd50b5b6b977fe3ef7d
Fixes: #3944
Use baked lazyloading by default 2017-04-13T18:22:59+00:00 Mike Bayer mike_mp@zzzcomputing.com 2017-04-07T18:18:22+00:00 b7644319e85ce38c1a576802317a9058a6aed82d The ``lazy="select"`` loader strategy now makes used of the :class:`.BakedQuery` query caching system in all cases. This removes most overhead of generating a :class:`.Query` object and running it into a :func:`.select` and then string SQL statement from the process of lazy-loading related collections and objects. The "baked" lazy loader has also been improved such that it can now cache in most cases where query load options are used. Change-Id: Ic96792fffaa045ae9aa0a4657d6d29235d3efb85 Fixes: #3954 
The ``lazy="select"`` loader strategy now makes used of the
:class:`.BakedQuery` query caching system in all cases.  This
removes most overhead of generating a :class:`.Query` object and
running it into a :func:`.select` and then string SQL statement from
the process of lazy-loading related collections and objects.  The
"baked" lazy loader has also been improved such that it can now
cache in most cases where query load options are used.

Change-Id: Ic96792fffaa045ae9aa0a4657d6d29235d3efb85
Fixes: #3954
Allow aliased() to be passed to Query.select_entity_from(). 2017-03-27T18:39:51+00:00 Mike Bayer mike_mp@zzzcomputing.com 2017-03-27T17:48:40+00:00 a4cdd0bc00a9985f0c775a644f7f004d6d4cab0a An :func:`.aliased()` construct can now be passed to the :meth:`.Query.select_entity_from` method. Entities will be pulled from the selectable represented by the :func:`.aliased` construct. This allows special options for :func:`.aliased` such as :paramref:`.aliased.adapt_on_names` to be used in conjunction with :meth:`.Query.select_entity_from`. Additionally rewrote the docstring for :meth:`.Query.select_entity_from`, including starting with explicit use of :func:`.aliased` as the usual idiomatic pattern. An example using text().columns() is added as well as the use case from :ticket:`3933` using name matching. Change-Id: If7e182965236993064a2a086e3b6d55a4f097ca8 Fixes: #3933 
An :func:`.aliased()` construct can now be passed to the
:meth:`.Query.select_entity_from` method.   Entities will be pulled
from the selectable represented by the :func:`.aliased` construct.
This allows special options for :func:`.aliased` such as
:paramref:`.aliased.adapt_on_names` to be used in conjunction with
:meth:`.Query.select_entity_from`.

Additionally rewrote the docstring for :meth:`.Query.select_entity_from`,
including starting with explicit use of :func:`.aliased` as the
usual idiomatic pattern.  An example using text().columns() is added
as well as the use case from :ticket:`3933` using name matching.

Change-Id: If7e182965236993064a2a086e3b6d55a4f097ca8
Fixes: #3933
Consult _select_from_entity in _adjust_for_single_inheritance 2017-03-14T23:41:21+00:00 Mike Bayer mike_mp@zzzcomputing.com 2017-01-16T18:06:44+00:00 b6a6ffa4c0e0911bb6c5e66b67da9789989c7699 Fixed bug in single-table inheritance where the select_from() argument would not be taken into account when limiting rows to a subclass. Previously, only expressions in the columns requested would be taken into account. Change-Id: Id353c45eade52b264d8f6685a58ba53975669eea Fixes: #3891 
Fixed bug in single-table inheritance where the select_from()
argument would not be taken into account when limiting rows
to a subclass.  Previously, only expressions in the
columns requested would be taken into account.

Change-Id: Id353c45eade52b264d8f6685a58ba53975669eea
Fixes: #3891
- document Query.with_session(), direct constructor usage 2017-02-08T22:47:29+00:00 Mike Bayer mike_mp@zzzcomputing.com 2017-02-08T22:47:29+00:00 7db699163bed203d8060f06097e1489eea7ba079 Change-Id: I47499d040623202dd9b3be0ea65f2d9ad03c11a4 
Change-Id: I47499d040623202dd9b3be0ea65f2d9ad03c11a4
- remove misleading comment, ref #3902 2017-01-27T17:08:57+00:00 Mike Bayer mike_mp@zzzcomputing.com 2017-01-27T17:08:57+00:00 3bd845f3ff2af203a79c76a5b493ccf9c58ad79e Change-Id: I481628146ff31bc9ea2f8a3687f375832b17e501 
Change-Id: I481628146ff31bc9ea2f8a3687f375832b17e501
Support python3.6 2017-01-13T15:57:41+00:00 Mike Bayer mike_mp@zzzcomputing.com 2017-01-11T15:12:12+00:00 fa6dd376bb24845724287d980a98ea50eb1cfab1 Corrects some warnings and adds tox config. Adds DeprecationWarning to the error category. Large sweep for string literals w/ backslashes as this is common in docstrings Co-authored-by: Andrii Soldatenko Fixes: #3886 Change-Id: Ia7c838dfbbe70b262622ed0803d581edc736e085 Pull-request: https://github.com/zzzeek/sqlalchemy/pull/337 
Corrects some warnings and adds tox config.  Adds DeprecationWarning
to the error category.   Large sweep for string literals w/ backslashes
as this is common in docstrings

Co-authored-by: Andrii Soldatenko
Fixes: #3886
Change-Id: Ia7c838dfbbe70b262622ed0803d581edc736e085
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/337
update for 2017 copyright 2017-01-04T17:39:24+00:00 Mike Bayer mike_mp@zzzcomputing.com 2017-01-04T17:39:24+00:00 64e72b58fd74db0c5c87407c824d08ad699e5e8e Change-Id: I4e8c2aa8fe817bb2af8707410fa0201f938781de 
Change-Id: I4e8c2aa8fe817bb2af8707410fa0201f938781de