[sqlalchemy] Dynamic relationship in queries

2013-07-28 Thread askel
Hello everybody, I've been tearing my hairs out trying to figure out how to achieve the following. Base = declarative_base() class Group(Base): g_id = Column(Integer, primary_key=True) events = relationship('Event', backref='group', lazy='dynamic') class

[sqlalchemy] Re: Dynamic relationship in queries

2013-07-28 Thread askel
What I have ended up with is the following: class Group(Base): events = relationship('Event', lazy=True) session.query(Group).join(Group.events).options(contains_eager(Group.events).filter(Event.e_date=='2013-01-01') The above gives me what I want and does not look crazy. It might be using

Re: [sqlalchemy] Dynamic relationship in queries

2013-07-28 Thread Michael Bayer
On Jul 28, 2013, at 9:29 AM, askel dummy...@mail.ru wrote: What I have ended up with is the following: class Group(Base): events = relationship('Event', lazy=True) session.query(Group).join(Group.events).options(contains_eager(Group.events).filter(Event.e_date=='2013-01-01') The

Re: [sqlalchemy] Dynamic relationship in queries

2013-07-28 Thread askel
Thanks for the reply. I'll stick with *contains_eager* solution as per your advice. That *bindparam* trick would work in this particular case too but I like flexibility of using former solution. - alex On Sunday, July 28, 2013 11:50:29 AM UTC-4, Michael Bayer wrote: On Jul 28, 2013, at 9:29