/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 vote415 views1 answer
Pygame disable message
Python
0 vote204 views1 answer
Convert tensorflow checkpoint to pytorch
Python
10 votes309 views1 answer
Is not none python
Python
1 vote346 views1 answer
Python sha256 of file
Python
1 vote225 views1 answer
Xpath helium
Python
0 vote195 views1 answer
Copy data with tensroflow io
Python
0 vote207 views1 answer
Tkinter bg button
Python
0 vote227 views1 answer
Compare input with list python
Python
0 vote245 views1 answer
How to get csv file first row first column value in python
Python
3 votes214 views1 answer
How to make a star in python turtle
Python