/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 vote297 views1 answer
Get href link selenium python
Python
2 votes291 views1 answer
Death stranding
Python
105 votes357 views6 answers
Python json to dict
Python
0 vote290 views1 answer
Checking if a string is in alphabetical order in python
Python
0 vote274 views1 answer
Place legend on location matplotlib
Python
0 vote286 views1 answer
AttributeError: This QueryDict instance is immutable django
Python
79 votes267 views7 answers
Pip
Python
4 votes285 views1 answer
Cannot import name 'flask' from partially initialized module 'flask' (most likely due to a circular import)
Python Flask
3 votes277 views2 answers
Pyaudio install error ubuntu
Python
0 vote289 views1 answer
Open chrome in pyhton
Python