/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 vote182 views1 answer
Get method to create a set of counters in python
Python
11 votes232 views3 answers
Django q filter
Python
0 vote211 views1 answer
Read image python
Python
0 vote229 views1 answer
Datetime column only extract date pandas
Python
28 votes233 views3 answers
Np.zero
Python
2 votes237 views1 answer
Sess.run tensorflow
Python
3 votes270 views1 answer
Pandas plotly
Python
0 vote294 views2 answers
Pandas read parquet from s3
Python
0 vote230 views1 answer
Check if string equals string in list python
Python
0 vote250 views2 answers
Python check if dir exists else create
Python