You'd need to turn on echo='debug' on create_engine() and look at the
rows actually being sent to see what's happening.
On 06/20/2017 01:59 PM, Ryan Weinstein wrote:
Thanks for the reply Mike. SQLAlchemy is a fantastic ORM and you've done
an amazing job with it.
You're suggestion hasn't fixed my issue though, perhaps there's
something fundamental I'm misunderstanding?
Here is the query I'm testing:
|
r_product_category_history_list =
db.Model.metadata.tables['r_product_category_history_list'] query =
db.session.query(rProduct,
r_product_category_history_list.c.time_updated)\
.join(rProductCategoryHistory)\
.order_by(desc(rProductCategoryHistory.time_updated))
|
It should be returning two rProduct's but it only returns one
On Tuesday, June 20, 2017 at 10:20:51 AM UTC-7, Mike Bayer wrote:
On 06/20/2017 01:04 PM, Ryan Weinstein wrote:
>
>
> On Tuesday, June 20, 2017 at 9:53:10 AM UTC-7, Jonathan Vanasco
wrote:
>
> you're almost there.
>
> flip a few lines around to rewrite the query to select from
> product... e.g. something like
>
> SELECT r_product_list.* FROM r_product_list
> JOIN r_product_category_history_list on
> r_product_list.r_id=r_product_category_history_list.r_id
> JOIN r_product_reviews_historical_details_list on
>
r_product_list.most_recent_historical_reviews_id=r_product_reviews_historical_details_list.id
<http://r_product_reviews_historical_details_list.id>
> <http://r_product_reviews_historical_details_list.id
<http://r_product_reviews_historical_details_list.id>>
>
> then it should be clear how to convert to the sqlalchemy syntax.
>
>
> The problem is when I do that it doesn't return the correct
number of
> instances. I need one instance of rProduct per entry into
> r_product_category_history_list.
the ORM deduplicates full entities (e.g. mapped objects) when returned
from a Query object. This is so that eager loading schemes don't
return
dupes. If you need each object associated with something distinct, add
that to the query:
session.query(Product, product_category_list.some_column)
>
> --
> 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
<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 sqlalchemy+...@googlegroups.com <javascript:>
> <mailto:sqlalchemy+unsubscr...@googlegroups.com <javascript:>>.
> To post to this group, send email to sqlal...@googlegroups.com
<javascript:>
> <mailto:sqlal...@googlegroups.com <javascript:>>.
> Visit this group at https://groups.google.com/group/sqlalchemy
<https://groups.google.com/group/sqlalchemy>.
> For more options, visit https://groups.google.com/d/optout
<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 sqlalchemy+unsubscr...@googlegroups.com
<mailto:sqlalchemy+unsubscr...@googlegroups.com>.
To post to this group, send email to sqlalchemy@googlegroups.com
<mailto:sqlalchemy@googlegroups.com>.
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 sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
