/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 vote304 views1 answer
Url settings
Python
0 vote338 views1 answer
Csv module remove header title python
Python
1 vote1.1K views1 answer
Random oversampling python
Python
0 vote298 views1 answer
Discord.py cog classes
Python
0 vote335 views1 answer
Django model meta ordering multiple ordering
Python
0 vote340 views1 answer
Nlog as a library to use in different project
Python
8 votes274 views3 answers
Linear search python
Python
0 vote290 views1 answer
How to print 's in python
Python
0 vote298 views1 answer
Can I activate a function inside the definition of the same function
Python
7 votes295 views1 answer
Numpy array with specific value
Python