/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

10 votes152 views3 answers
Django make migrations
Python
19 votes159 views1 answer
Python cut string to length
Python
0 vote151 views1 answer
Pivot table with lambda
Python
2 votes156 views1 answer
Pandas reset row indices
Python
1 vote165 views3 answers
Pandas add column from list
Python
0 vote167 views1 answer
Image from wikipedia module in python
Python
0 vote152 views1 answer
Discord.py how get user input
Python
0 vote202 views1 answer
Migrate using other database django
Python Django
0 vote157 views1 answer
Collecting candies codevita solution in python
Python
64 votes155 views6 answers
How to define a class in python
Python