Skip to content

How to get content from 2 many to many #793

Answered by OmniCed
OmniCed asked this question in Q&A
Discussion options

You must be logged in to vote

If someone need the answer :

        query = (
            Parent.outerjoin(ParentXChildOne)
            .outerjoin(ParentXChildTwo)
            .outerjoin(ChildTwo)
            .outerjoin(ChildOne)
            .select()
            .where(Parent.id == model_id)
        )
        loader = Parent.distinct(Parent.id).load(
            add_child_1=ChildOne.distinct(ChildOne.id),
            add_child_2=ChildTwo.distinct(ChildTwo.id)
        )
        db_response = await query.gino.load(loader).all()

Replies: 1 comment

Comment options

You must be logged in to vote
0 replies
Answer selected by OmniCed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet
1 participant