/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 vote99 views1 answer
Key down python
Python
0 vote155 views1 answer
How to stop all pygame mixer sound
Python
23 votes130 views2 answers
Smp meaning
Python
0 vote144 views3 answers
Dataframe row print
Python
1 vote128 views1 answer
FutureWarning: Input image dtype is bool. Interpolation is not defined with bool data type. Please set order to 0 or explicitly cast input image to another data type. Starting from version 0.19 a ValueError will be raised instead of this warning.
Python
0 vote168 views1 answer
Django nested inlines
Python Django
0 vote125 views1 answer
Using csv module how to read perticular lines in csv
Python
0 vote130 views1 answer
How to open camre aopencv
Python
0 vote193 views1 answer
Python codes for counting the occurrence of a letters in dictionary excluding digits
Python
1 vote167 views2 answers
Rsplit string from last
Python