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(((