/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 vote231 views2 answers
Pandas replace non numeric values with 0?
Python
0 vote228 views1 answer
Parallel loops in python
Python
0 vote214 views1 answer
Convert 2.9k to 2900 in python
Python
0 vote246 views1 answer
Set a random seed
Python
5 votes219 views2 answers
Python get everything between two characters
Python
25 votes259 views3 answers
Check if a value in dataframe is nan
Python
0 vote249 views1 answer
Python column = sum of list of columns
Python
0 vote235 views2 answers
How to color label in pyqt5
Python
0 vote222 views1 answer
How to add to end of linked list python
Python
0 vote205 views1 answer
Python program that gives the user a positive integer N, prints the number in the N position of the Fibonacci sequence
Python