is there a stack trace (just the beginning and then a bit of the
repeating part, not the whole thing), there's no recursion inherent in
the SQLAlchemy part of this so something must be up with your model.
an MCVE (see the link below) is always the best way to show what's
happening.
On Thu, Aug 23, 2018 at 4:57 PM, Alireza Ayin Mehr
<alireza.dark...@gmail.com> wrote:
> Well, I tried "or_()" before
> primaryjoin="or_(User.id == Conversation.user1, User.id ==
> Conversation.user2)"
> It returns RecursionError :(
>
> On Thursday, August 23, 2018 at 9:00:58 PM UTC+4:30, Jonathan Vanasco wrote:
>>
>> I believe something like this should work.
>>
>>
>> conversations = sqlalchemy.orm.relationship("Conversation",
>>
>> primaryjoin="""or_(User.id==Conversation.user_id_1,
>>
>> User.id==Conversation.user_id_2,
>> )""",
>>
>> order_by="Conversation.id.desc()",
>> )
>>
>>
>> i also think you'll need to make an explicit relationship for a user1 and
>> user2 relationship instead of using back_populates. i could be wrong.
>> personally i would make separate relationships though, because having an
>> undordered list for them makes little sense.
>>
> --
> 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.
