i have an idea where this issue is, since it will become a unit test
you can save me some trouble by sending along some tables defs too.
its that the columns in the primaryjoin are not explicitly part of
the mapped tables and i have to add a conditional somewhere.
On Mar 18, 2007, at 7:56 AM, Steve Zatz wrote:
>
> I hadn't updated in several weeks so I am not sure when this issue
> first arose but with the following setup:
>
> ----------------------------
> mapper(Section, section_table, properties = {'items': relation(Item,
> backref='section'), 'keywords':relation(Keyword,
> primaryjoin=and_
> (keyword_table.c.uuid==itemkeyword_table.c.keyword_uuid,
> item_table.c.uuid==itemkeyword_table.c.item_uuid,
> section_table.c.id==item_table.c.section_id),
> viewonly=True, foreignkey=keyword_table.c.uuid)})
>
> mapper(Item, item_table, properties = dict(itemkeywords =
> relation(ItemKeyword, lazy=False, backref='item'),
> reminder = relation(Reminder, backref='item'),
> children = relation(Item, remote_side=[item_table.c.parent_uuid],
> backref=backref('parent', remote_side=[item_table.c.uuid])),
> note = deferred(item_table.c.note),
> ))
>
> mapper(Keyword, keyword_table)
>
> mapper(ItemKeyword, itemkeyword_table, properties={'keyword':
> relation(Keyword, lazy=False, backref='itemkeywords')})
> ----------------------------------
>
> when I ask for:
>
> some_section.keywords
>
> I get the following exception:
>
> sqlalchemy.exceptions.InvalidRequestError: No column
> item_keyword.keyword_uuid is configured on mapper
> Mapper|Section|section...
>
> Prior to updating today, this worked fine and produced the expected
> results. Let me know if it would help to see the tables and classes.
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
