Hi all,
I'm having an issue where I'm doing a query that I want to be loaded
all in one select to the database. I have a table "ContentLeaf" which
inherits from "Content", I can get the ContentLeaf fields to eagerload
by using select_table in the mapper:
myjoin = content_table.outerjoin(content_leaf)
cm = mapper(Content, content_table,
select_table = myjoin,
properties = {
'account' : relation(Account, cascade='all',
lazy=False),
Here I also define the account property to eagerload by specifying
lazy=False. In this case, only the ContentLeaf eagerloads and I see
this in the debug logs:
DEBUG:sqlalchemy.orm.strategies.EagerLoader:Could not locate aliased
clauses for key: (<sqlalchemy.orm.mapper.Mapper object at 0x2d95850>,
'account')
DEBUG:sqlalchemy.orm.strategies.EagerLoader:eager loader Mapper|
Content|content.account degrading to lazy loader
If I remove the select_table, the account property will then
eagerload, but I really want both to eagerload in the same query. Any
ideas on how to make this happen?
thx
Matt
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
