On Friday 31 July 2009 08:30:52 am Kirk Strauser wrote:
> On Thursday 30 July 2009 04:26:20 pm Michael Bayer wrote:
> > you have to get the select() syntax right:
> >
> >
> > BillingInfo = relation('BillingInfo',
> >
> > primaryjoin="and_(Invoice.pay2addrid==BillingInfo.pay2addrid,Invoice.cust
> >om er==
> > select([Customer.customer]).where(Customer.xrscustid==BillingInfo.xrscust
> >id ))")
>
> Michael, a million thanks. Seriously. That did exactly what I needed, and
> should handle a bunch of similar issues with other legacy tables. I
> appreciate it!
Can you stand one more question on this? I tried to enable eager loading on
this table:
invoices = invoices.options(eagerload('BillingInfo'))
but ended up with an error:
sqlalchemy.exc.InvalidRequestError: Select statement 'SELECT fro.xrscust.xrscust
FROM fro.xrscust, fro.bllginfo AS bllginfo_1
WHERE bllginfo_1.xrscustid = fro.xrscust.xrscustid' returned no FROM clauses
due to auto-correlation; specify
correlate(<tables>) to control correlation manually.
I don't really understand what it's asking for, and the docs for correlate()
only seem to explain how to configure it and not what I should want it
to be set to.
--
Kirk Strauser
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
