/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

1 vote169 views1 answer
Python tkinter disable dropdown
Python
0 vote185 views1 answer
Expionenttiation python
Python
1 vote270 views1 answer
Count words python
Python
11 votes160 views2 answers
Append 1 colimn in pandas df
Python
0 vote181 views1 answer
Pandas dataframe to excel hyperlink length limit
Python
0 vote163 views1 answer
Kroki - hello.dot
Python
0 vote228 views1 answer
How to maximize the screen in selenium
Python
14 votes249 views1 answer
Create data dir in python
Python
1 vote171 views2 answers
Python any in string
Python
1 vote228 views1 answer
Howt to make caluclator in python
Python