sqlalchemy many to many select

Viewed 26

I have 3 tables: customers, products, customers_products.
What I want to select all products and all customers which have this product.
The result may look like:

[  
{  
    id: "1",  
    name: "Apple"  
    customers: [
        {
            id: 1,
            name: "Customer 1"
        },
        {
            id: 2,
            name: "Customer 2"
        }
    ]  
},  
{  
    id: "2",  
    name: "Onions"  
    customers: [
        {
            id: 1,
            name: "Customer 1"
        },
        {
            id: 2,
            name: "Customer 2"
        }
    ]  
}  
]

I've tried something like:

query_select = select([products]).where(customers_products.c.product_id == products.c.id)
return await self.database.fetch_all(query=query_select)

But this query select only products(((

0 Answers
Related