/Python/Conditional relationship sqlalchemy

Conditional relationship sqlalchemy

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)

Source: stackoverflow.com

Similar codes

-1 vote266 views1 answer
Python curses resize window
Python
0 vote291 views2 answers
Python int string float
Python
0 vote260 views1 answer
Python pandas table save
Python
0 vote258 views1 answer
Python square all numbers in list
Python
0 vote292 views1 answer
Python format seconds to hh mm ss
Python
46 votes318 views6 answers
Python for loop array index
Python
0 vote283 views3 answers
Add a new button in the index of the page wagtail
Python
8 votes318 views3 answers
Is alphabet python
Python
1 vote272 views1 answer
Nlargest hierarchy series pandas
Python
0 vote271 views1 answer
Matplotlib text relative to axis
Python