/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

3 votes284 views1 answer
Static root django
Python Django
10 votes322 views3 answers
Execute linux command in python
Python
1 vote248 views1 answer
Keyerror: 'OUTPUT_PATH'
Python
0 vote272 views1 answer
Python coding for y, you will also display a “bar” of ‘X’ characters to represent the number. For example, the prime number 2 would be represented as “X 2”.
Python
24 votes292 views2 answers
Python for loop one line
Python
0 vote306 views1 answer
Pandas calculate iqr
Python
0 vote292 views1 answer
How to usepygame.sprite.spritecollide
Python
0 vote298 views1 answer
Python import from string name
Python
16 votes285 views6 answers
Map in python
Python
2 votes294 views1 answer
How to make python3.9 active
Python