/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 vote233 views1 answer
Assert vs validate in python
Python
12 votes256 views2 answers
Write number of lines in file python
Python
0 vote241 views1 answer
Start a webservice quickly using python2.7
Python
5 votes236 views3 answers
Learn python the hard way
Python
0 vote233 views1 answer
Pandas nat to null?
Python
0 vote246 views2 answers
Is not and != difference in python
Python
5 votes278 views1 answer
Py2exe
Python
0 vote241 views1 answer
Reactstrap example
Python
5 votes244 views2 answers
Matplotlib add space between subplots
Python
2 votes242 views1 answer
Python ftplib get list of directories
Python