Breaking News: Grepper is joining You.com. Read the official announcement!

conditional relationship sqlalchemy

Bug Killer answered on June 14, 2021 Popularity 4/10 Helpfulness 2/10

answer conditional relationship sqlalchemy

conditional relationship sqlalchemy

Comment

class User(Base):
    __tablename__ = 'user'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    boston_addresses = relationship("Address",
                    primaryjoin="and_(User.id==Address.user_id, "
                        "Address.city=='Boston')")

class Address(Base):
    __tablename__ = 'address'
    id = Column(Integer, primary_key=True)
    user_id = Column(Integer, ForeignKey('user.id'))

    street = Column(String)
    city = Column(String)
    state = Column(String)
    zip = Column(String)

Popularity 4/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: conditional python relationship sqlalchemy

Link to this answer
Share Copy Link