Hi All,
This might be a noob question, but I wasn't able to to find the answer
combing through the docs and google search. Given the following
declarations
Base = declarative_base()
class A(Base):
__tablename__ = 'A'
id = Column(Integer, primary_key=True)
class B(Base):
__tablename__ = 'B'
id = Column(Integer, primary_key=True)
a_id = Column(Integer, ForeignKey('A.id'))
a = relationship('A', backref=backref('b'))
I want to query for all A where B is not null (essentially an inner
join on A) with something like this
session.query(A).options(joinedload('b')).filter(A.b != None)
but it won't work because 'A.b' is a backref field. If I try
filter('A.b' != None) it won't work either. So 2 part question:
1) is there a better way to do an inner join like this?
2) in general, how do you use backref fields inside of filter
criteria?
Thanks,
Alan
--
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.
