/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 vote208 views1 answer
Python pyhue
Python
2 votes190 views1 answer
How to check weather my model is on gpu in pytorch
Python
0 vote220 views1 answer
Remove the secound to last veriable in a list python
Python
1 vote209 views1 answer
Python discord discord.py disable remove help command
Python
0 vote214 views1 answer
Dataframe print column comma separated
Python
11 votes351 views2 answers
Regression python
Python
1 vote149 views1 answer
Reverse slice python
Python
1 vote214 views1 answer
Handler.setLevel(logging.DEBUG) not working python
Python
6 votes202 views2 answers
Django read mesage
Python
5 votes284 views1 answer
Use time now to caculate execution time python
Python