/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

0 vote345 views5 answers
Pine script to python
Python
0 vote351 views1 answer
Handle dict invalid key python
Python
0 vote389 views1 answer
No default language could be detected for django app
Python Django
0 vote351 views1 answer
ImportError: cannot import name 'clock' from 'time' (unknown location)
Python
0 vote347 views1 answer
Slayer_coins_spent
Python
1 vote341 views1 answer
Flask sending post request
Python
0 vote341 views1 answer
Converting (YYYY-MM-DD-HH:MM:SS) date time
Python
6 votes348 views2 answers
Python 2d array append
Python
6 votes388 views6 answers
Change date format python
Python
2 votes332 views4 answers
Numpy reshape (n ) to (n 1)
Python