On Apr 7, 2011, at 11:07 AM, Aleksander Siewierski wrote:
>
> Hi, in part of my model I have a TaskIntro item and RedirectRule item
> connected with relation one-to-one one-sided, mapper for TaskIntro
> looks like:
>
> mapper(
>TaskIntro,
>table,
>version_id_col = table.c.version ,
>properties={
> ...
>'redirect_rule': relation( RedirectRule,
> cascade="all, delete",
> primaryjoin=table.c.redirect_rule_id ==
> redirect_rule_t.c.id
> ),
>...
>}
>
> and when I call method that get TaskIntro defined:
> def _get_all_query(self, **kwargs):
>query = self.query.options(
>contains_eager('redirect_rule'),
>eagerload_all('redirect_rule.periods'),
>eagerload('redirect_rule.channels'),
>...
>)
>return query
>
> I receive following warning:
> /usr/lib/python2.6/dist-packages/sqlalchemy/orm/mapper.py:2113:
> SAWarning: Multiple rows returned with uselist=False for eagerly-
> loaded attribute 'TaskIntro.redirect_rule'
> populator(state, dict_, row)
>
> I'm googling about this warning, but have no idea what this can mean.
> How can multiple rows be returned here?
You didn't put a full example or the query you're using so its impossible to
give a specific answer. But it means the way you're joining from TaskIntro to
RedirectRule in your query is incorrect such that multiple RedirectRule rows
are being returned corresponding to a single TaskIntro identity.
--
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 email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
