Eg : 1
query = Session.query(Person) query = query.join(Address, Address.person_id == Person.id) query = query.filter(Address.city == "abccity") c.j2 = query.all()
Eg : 2
c.jo = Session.query(Address.city, Person.name).filter(Address.person_id==Person.id).all()
"""Person model""" from sqlalchemy import Column from sqlalchemy.types import Integer, String from pylontutor.model.meta import Base class Person(Base): __tablename__ = "person" id = Column(Integer, primary_key=True) name = Column(String(100)) email = Column(String(100)) def __init__(self, name='', email=''): self.name = name self.email = email def __repr__(self): return "<Person('%s')" % self.name