/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 vote153 views1 answer
Find substring in string python
Python
3 votes195 views2 answers
Dict_values to list python
Python
0 vote162 views4 answers
Regex find all french phone number python
Python
60 votes193 views6 answers
Python Class Example
Python
26 votes171 views1 answer
Python gmail
Python
0 vote171 views1 answer
Ubuntu install pip for python 3.8
Python
0 vote184 views1 answer
List square python
Python
1 vote126 views2 answers
Alpaca api python wrapper
Python
36 votes181 views5 answers
Colored text python
Python
0 vote180 views1 answer
Removing new line character in python from dataframe
Python