Re: [sqlalchemy] Re: Trying to query a relationship of a relationship

2011-06-16 Thread Jules Stevenson
] >> On Behalf Of Jules Stevenson >> Sent: 09 June 2011 08:53 >> To: sqlalchemy@googlegroups.com >> Subject: [sqlalchemy] Re: Trying to query a relationship of a >> relationship >> >> Sorry, for the spamming, code typo (was trying to simplify i

RE: [sqlalchemy] Re: Trying to query a relationship of a relationship

2011-06-09 Thread King Simon-NFHD78
> -Original Message- > From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] > On Behalf Of Jules Stevenson > Sent: 09 June 2011 08:53 > To: sqlalchemy@googlegroups.com > Subject: [sqlalchemy] Re: Trying to query a relationship of a > relationshi

[sqlalchemy] Re: Trying to query a relationship of a relationship

2011-06-09 Thread Jules Stevenson
Sorry, for the spamming, code typo (was trying to simplify it), should read: invoices = query(ArkInvoice).\ join(ArkInvoice.project).\ join(ArkProject.client).\ options(sa.orm.contains_eager(ArkInvoice.project.client)).\ filter(

[sqlalchemy] Re: Trying to query a relationship of a relationship

2011-06-09 Thread Jules Stevenson
I don't think the info I sent last night was particularly clear, apologies it was late. The code for the classes is below: # ArkClient - clientprojectshot module orm.mapper(ArkClient, clients_table, properties={    'contacts':orm.relation(ArkContact,            backref='client'),    'projects':orm

[sqlalchemy] Re: Trying to query a relationship of a relationship

2011-06-08 Thread Jules Stevenson
sorry, hit the send button a little too soon. Any help on the above much appreciated, Jules -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send em