/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 vote195 views1 answer
Reshape wide to long in pandas
Python
0 vote180 views1 answer
How to import matplotlib.pyplo in python
Python
0 vote175 views1 answer
Tkinter titre fenetre
Python
0 vote241 views1 answer
Manage.py startapp not working in django
Python Django
0 vote231 views1 answer
Import mongodatetime flask
Python
0 vote142 views1 answer
How to extract keys from dictreader python
Python
0 vote233 views1 answer
Django-mathfilters
Python Django
3 votes186 views1 answer
Print decimal formatting in python
Python
2 votes182 views2 answers
Python find second occurrence in string
Python
0 vote182 views1 answer
Decimal places django template
Python