/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 vote162 views1 answer
Python pandas table save
Python
0 vote168 views1 answer
Cv2 gaussian blur
Python
1 vote156 views1 answer
Dataframe select entries that are in a list
Python
1 vote193 views1 answer
Reverse key order dict python
Python
1 vote182 views1 answer
Pytho narrondir un nombre
Python
4 votes165 views2 answers
Add y axis label matplotlib
Python
6 votes159 views2 answers
Numpy from csv
Python
0 vote176 views1 answer
First_list = [10,20,30,40] second list = first list second list[3]=400
Python
0 vote166 views1 answer
Django extend user model
Python
21 votes156 views2 answers
Convert column to datetime format python
Python