> > > Article has a foreign key to Video and Video has a foreign key to Tag so > these can be joined either way. >
This is a bit information I missed to be honest. I forgot that while Article has direct join to Video, Video can be joined to Article via Tag. I checked my relations so many times and I didn't notice it. > If you want joins to work with relationships alone you should consider > those using > inspect(Class).relationships to find the relationships you'd like to use > for each linkage. > Lucky for me, my code is not that mad. I only wrap some things to reduce amount of repetition, however due to wrapper work semi-autonomously not every request has exactly same join order. And because order of joins in this case fixed/caused error I was a bit confused. Thanks a lot of shedding light on the topic. Now I can sleep lightly knowing that mix fix is actually fix for my own mistake. Cheers. -- 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.
