/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

1 vote179 views1 answer
How to identify GPU with pytorch script
Python
0 vote228 views1 answer
How to get the time zones in python
Python
0 vote289 views1 answer
Flask_uploads.exceptions.UploadNotAllowed
Python
0 vote291 views1 answer
How to print correlation to a feature in pyhton
Python
0 vote196 views1 answer
Model o weight
Python
0 vote212 views1 answer
Flask google analytics
Python
1 vote183 views1 answer
Flatten image python numpy
Python
0 vote183 views1 answer
Python format decimal list
Python
0 vote183 views1 answer
Python random select no replace
Python
0 vote189 views1 answer
Parquet folder single df dataframe
Python