/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

12 votes208 views3 answers
Removing punctuation in Python
Python
3 votes240 views1 answer
Pandas plotly
Python
2 votes216 views2 answers
Python split string capital letters
Python
87 votes213 views6 answers
How to convert string to datetime
Python
1 vote201 views1 answer
How to change the values of a column in numpy array
Python
2 votes194 views2 answers
Python tkinter programming project ideas
Python
0 vote200 views1 answer
Tensorfow list devices
Python
0 vote191 views1 answer
Add authorization header in python requests
Python
17 votes209 views2 answers
Python list subdirectories
Python
5 votes218 views2 answers
Python calc days between dates
Python