Hi there, I'm exploring the bidirectional adjacency list pattern described in the documentation (the scalar relationship is intentional):
Person.child = relationship( Person, uselist=False, backref=backref('parent', remote_side=Person.id) ) However, I'd like to add an additional primaryjoin condition, something to the effect of: child = aliased(Person) Person.child_bob = relationship( child, uselist=False, primaryjoin=and_( child.parent_id == Person.id, child.name == 'Bob' ), backref=backref('parent', remote_side=Person.id) ) But of course I can't use an AliasedClass in the first argument to relationship(). Similarly I can't add the relationship property onto an aliased parent class. What's the proper way of defining such a relationship? -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@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.