subject:"\[sqlalchemy\] Re\: Filtering a relation"

[sqlalchemy] Re: Filtering a relation

2009-03-27 Thread David Gardner

Try this: mapper(Parent, parent_table, properties = { 'boys':relation(Child, backref='parent', primaryjoin=(and_(child_table.c.pid=parent_table.c.id, child_table.c.gb=='b'), 'girls':relation(Child, backref='parent',

[sqlalchemy] Re: Filtering a relation

2009-03-27 Thread Mike Conley

Thanks, it is easy and works just as expected. Using declarative it looks like this: Parent.boys = relation(Child, viewonly=True, primaryjoin=(and_(Child.pid==Parent.id, Child.bg=='b'))) Parent.girls = relation(Child, viewonly=True, primaryjoin=(and_(Child.pid==Parent.id,