/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 vote188 views1 answer
Text files to words generator
Python
4 votes187 views2 answers
Convert array to dataframe python
Python
0 vote180 views2 answers
For loop to while loop in python
Python
1 vote196 views1 answer
Python requests set user agent
Python
0 vote212 views1 answer
Mechanize python #3
Python
0 vote205 views1 answer
Bulk upload with dictionary or list in django moels
Python
0 vote200 views1 answer
Aiohttp specify app IP
Python
0 vote210 views1 answer
Creating fake instagram accounts with python
Python
0 vote241 views1 answer
Read tar.gz file python
Python
1 vote253 views1 answer
Use django taggit in template
Python Django