Whoops, yes, you're right. You should be able to simplify the relationship definition to a simple "primaryjoin" clause, no need for any of the "secondary" stuff.
Simon On Thu, Nov 10, 2016 at 1:41 PM, Dorian Hoxha <dorian.ho...@gmail.com> wrote: > Note that you're joining with User, which I don't want. Only the "like" is > needed. I'll try to change it to only query/join the like. > > > > On Thursday, November 10, 2016 at 10:32:45 AM UTC+1, Dorian Hoxha wrote: >> >> So I have: >> >> class Thing(): >> current_user_like = relationship(Like) >> >> class User(): >> pass >> >> class Like(): >> user_id = Column(primary_key=True) >> thing_id = Column(primary_key=True) >> >> >> Now I want, to do "session.query(Thing).all()" and also join the >> "current_user_like" for each Thing, but only get 1 row instead of the whole >> collection of `likes` for each Thing. >> I know this can be done with db.session.query(Thing,Like) and doing an >> outerjoin, but can it be done so I get Like embedded inside >> Thing.current_user_like ? >> >> Thank You > > -- > 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.