/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 vote336 views1 answer
Python assers
Python
4 votes311 views2 answers
How to get the system time in python
Python
0 vote323 views2 answers
Python create gif
Python
0 vote351 views1 answer
Find a string hackereank
Python
0 vote338 views1 answer
Python byte like to string
Python
0 vote302 views1 answer
End without space in python
Python
0 vote392 views1 answer
Super().__init__(pos, model) in python
Python
0 vote346 views1 answer
Module 'cv2.cv2' has no attribute 'imWrite'
Python
3 votes333 views2 answers
Python get line of exception
Python
9 votes384 views2 answers
Default flask app
Python Flask