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.