Hi List,
I'm inexperienced with DBs so please bear with me.
I would like to return a list of all invoices that are assigned to a
specific client. However the relationships are built so that an
invoice has a foreign key to a project, which in turn has a foreign
key to a client:
Invoice.project > project.client > client
or in reverse
client.projects > project.invoices > invoice[s]
I've really been struggling as how to implement this, from what I've
been reading I want to join these relationships so that I can actually
filter the results, but Im having no luck at implementing this, my
nasty code is below:
invoices = query(ArkInvoice).\
join(ArkInvoice.project).\
join(ArkProject.client).\
options(sa.orm.contains_eager(model.ArkInvoice.project.client)).\
filter(model.ArkInvoice.project.client.id == id)
Which fails on the instrumented list of 'client' on the contains_eager.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
