class A(Base):
primary_id = Column(Integer, prirmary_key=True)
some_A_marker = Column(String)
class B(Base):
primary_id = Column(Integer, primary_key=True)
referencing_A_id = Column(Integer, ForeignKey(A.primary_id))
class C(Base):
primary_id = Column(Integer, primary_key=True)
basedOn_B_id = Column(Integer, ForeignKey(B.primary_id))
symbol_from_A = column_property(
sasql.select(A.some_A_marker).select_from(A).join(B).where(B.primary_id ==
C.basedOn_B_id).correlate(C).scalar_subquery().label("symbol_from_A")
)
When I query this highlighted column_property along with the whole object,
it works fine:
>>> sess.query(C, C.symbol_from_A).all()
However, when I query this column_property alone, it doesn't work:
>>>sess.query(C.symbol_from_A).distinct().all()
I noticed that somehow the correlated subquery wasn't executed property
when query that column_property independently.
How to solve this?
--
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 view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/f7a0c360-ada2-456b-b02a-498ca50334f3n%40googlegroups.com.
