/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

5 votes120 views6 answers
Best python ide
Python
3 votes113 views1 answer
Install re package python
Python
0 vote118 views1 answer
Python Script to check how many images are broken
Python
15 votes110 views5 answers
List of dataframe to dataframe
Python
0 vote121 views1 answer
Corona data with python flask get pdf
Python
0 vote123 views1 answer
(for in) printing in python
Python
0 vote130 views1 answer
Python string with si suffix to number
Python
7 votes128 views3 answers
Sum of a numpy array
Python
0 vote121 views1 answer
Default python structure
Python
3 votes129 views3 answers
Use model from checkpoint tensorflow
Python