/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

5 votes156 views2 answers
Insert function in list
Python
0 vote160 views2 answers
Python script in excel
Python
6 votes150 views3 answers
Print text on turtle screen
Python
1 vote158 views1 answer
Python combine side by side dataframes
Python
0 vote149 views1 answer
Proper function pandas
Python
0 vote165 views1 answer
Python script that turns bluetooth on
Python
28 votes247 views3 answers
Django abstractuser
Python Django
0 vote180 views3 answers
Flask socketio with gevent
Python
0 vote159 views1 answer
How to pre populate field flask wtforms
Python
0 vote196 views1 answer
Remove cog in discord.py
Python