/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 vote105 views1 answer
Python count lines in string
Python
0 vote124 views1 answer
Store user input in list
Python
6 votes133 views3 answers
Message: 'chromedriver' executable needs to be in PATH. Please see https://sites.google.com/a/chromium.org/chromedriver/home
Python
0 vote105 views1 answer
Soup.find_all attr
Python
0 vote103 views1 answer
How to resume request downloads
Python
0 vote100 views1 answer
Forgot password miguel grinberg
Python
71 votes95 views6 answers
Clear console in python
Python
1 vote104 views1 answer
How to change the color of command prompt in python
Python
15 votes101 views3 answers
Discord.py send image
Python
0 vote97 views2 answers
Flask api abort
Python