/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

19 votes99 views3 answers
Debugger online for python
Python
0 vote97 views4 answers
Newspaper pypi
Python
1 vote103 views1 answer
Seaborn plot set ylabel
Python
5 votes93 views1 answer
How to rezize image in python tkinter
Python
10 votes138 views1 answer
Https://docs.djangoproject.com/en/2.0/howto/static-files/
Python Django
0 vote96 views1 answer
Return maximum of three values in python
Python
2 votes94 views1 answer
Python tkinter underline text
Python
0 vote105 views1 answer
Python start process in background and get pid
Python
-1 vote60 views1 answer
Python fiboncci
Python
0 vote114 views1 answer
Issue TypeError: ‘numpy.float64’ object cannot be interpreted as an integer
Python