/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 vote324 views1 answer
Recursive python program to print numbers from n to 1
Python
19 votes344 views3 answers
Map python 3
Python
3 votes372 views2 answers
Python how to split a number
Python
3 votes328 views2 answers
Date object into date format python
Python
0 vote259 views1 answer
Python tableau 2d
Python
1 vote303 views1 answer
Python display text in label on new line
Python
9 votes336 views2 answers
How to read video in opencv python
Python
6 votes338 views2 answers
Google search api python
Python
0 vote353 views1 answer
Python subprocess.run output
Python
0 vote307 views2 answers
Read image from a folder python
Python