I would need mappings / MCVE to work with this problem.
On Aug 20, 2017 9:01 AM, "Stephen Early" <[email protected]> wrote:
> I'm having trouble with undefer_group(), which I'm sure used to work for
> me but now doesn't!
>
> I've read the documentation regarding the changes to undefer_group() in
> 0.9; I'm now using 1.0.14
>
> I have a model, StockItem, with three column properties ('used', 'sold',
> 'remaining') that are all deferred and in group 'qtys'. Let's say I do a
> query like this (Delivery.items is a backref to StockItem):
>
> d = session.query(Delivery).\
> filter_by(id=int(deliveryid)).\
> options(joinedload_all('items.stocktype.unit'),
> joinedload_all('items.stockline'),
> defaultload("items").undefer_group('qtys')).\
> one()
>
> I would expect StockItem.used, StockItem.sold and StockItem.remaining to
> be undeferred, but they are not. If I do this:
>
> d = session.query(Delivery).\
> filter_by(id=int(deliveryid)).\
> options(joinedload_all('items.stocktype.unit'),
> joinedload_all('items.stockline'),
> defaultload("items")\
> .undefer('used')\
> .undefer('sold')\
> .undefer('remaining')).\
> one()
>
> ...then it works as expected.
>
> The 'used', 'sold' and 'remaining' columns are added to the StockItem
> class after it's defined, as follows:
>
> StockItem.used = column_property(
> select([func.coalesce(func.sum(StockOut.qty), text("0.0"))]).\
> correlate(StockItem.__table__).\
> where(StockOut.stockid == StockItem.id).\
> label('used'),
> deferred=True,
> group="qtys",
> doc="Amount of this item that has been used for any reason")
>
> Any ideas?
>
> Stephen Early
>
> --
> SQLAlchemy -
> The Python SQL Toolkit and Object Relational Mapper
>
> http://www.sqlalchemy.org/
>
> To post example code, please provide an MCVE: Minimal, Complete, and
> Verifiable Example. See http://stackoverflow.com/help/mcve for a full
> description.
> ---
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/d/optout.
>
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
