/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

3 votes353 views1 answer
Python list of random float numbers
Python
0 vote358 views1 answer
Python loop list from last to first
Python
92 votes377 views6 answers
Python choose random element from list
Python
0 vote343 views1 answer
Stemming words python
Python
0 vote352 views1 answer
Robinhood python api
Python
1 vote326 views1 answer
How to import multiple modules in one line python
Python
30 votes405 views6 answers
Df drop column
Python
13 votes371 views6 answers
Django orm
Python
1 vote297 views1 answer
Cannot import name 'joblib' from 'sklearn.externals' (/shared-libs/python3.7/py/lib/python3.7/site-packages/sklearn/externals/__init__.py)
Python
1 vote338 views1 answer
Django template tags capitalize
Python