/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 vote117 views2 answers
How to kill python process started by excel
Python
1 vote118 views1 answer
Xarray add coordinate
Python
0 vote109 views2 answers
Cannot create group in read-only mode. keras
Python
0 vote113 views1 answer
Fabbinacci series program in python
Python
14 votes107 views2 answers
Two groupby pandas
Python
0 vote104 views1 answer
Make screen shot of specific part of screen python
Python
92 votes108 views6 answers
String to datetime
Python
8 votes118 views3 answers
Python print version
Python
0 vote111 views1 answer
Python dictionary get ket
Python
1 vote67 views2 answers
Functions in python 3
Python