/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 vote193 views1 answer
Sort pandas dataframe by specific column
Python
1 vote127 views1 answer
Feet to meter python
Python
0 vote178 views1 answer
Pyhton dms to decimal
Python
144 votes145 views6 answers
Write in file python
Python
5 votes148 views3 answers
How to convert array value to integer in python
Python
9 votes136 views6 answers
Join pandas dataframe by column
Python
4 votes156 views4 answers
Jupyter lab autocomplete
Python
0 vote138 views1 answer
Place legend on location matplotlib
Python
0 vote163 views1 answer
Hoow to print python
Python
0 vote138 views1 answer
'jet' is not a registered namespace
Python