On Fri, Jul 14, 2017 at 10:40 AM, Shane Carey <shanecare...@gmail.com> wrote: > Okay, I understand that. My example isnt actually the best for the question > I am asking. > > Say I have three subclasses ChildOne, ChildTwo, ChildThree > > is there a way to query for ChildOne and ChildTwo in one query, or do I need > to filter on the discriminator? > > something like session.query(ChildOne, ChildTwo).all()
you could actually say query(ChildOne, ChildTwo) but that means you're selecting from the table twice in one SELECT, you'd need to use aliases. if you wanted to do it purely relationally (which I don't recommend here), you'd need to say session.query(ChildOne).union(session.query(ChildTwo)), since that's really what you're doing from a relational perspective. However, filter on the discriminator is from a SQL perspective a lot more direct, which would be my recommendation. > > -- > 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. -- 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.