/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 vote138 views2 answers
How to find 1 st digit in python
Python
0 vote120 views1 answer
Fill na with average pandas
Python
-1 vote128 views1 answer
Python schleife
Python
0 vote136 views3 answers
How to create a login page in python
Python
0 vote141 views1 answer
Recorrer lista desde el final python
Python
0 vote113 views1 answer
S3 pre signed url python
Python
0 vote159 views1 answer
Indent python code
Python
0 vote154 views1 answer
Del no of elements in lis
Python
11 votes151 views5 answers
Python discord mention user
Python
4 votes135 views1 answer
Df select first n rows
Python