/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 vote271 views1 answer
Python index of dictionary in list
Python
0 vote249 views1 answer
How to decode recv data in python
Python
4 votes264 views5 answers
Add a new column to numpy array
Python
1 vote263 views1 answer
Selenium refresh till the element appears python
Python
0 vote261 views1 answer
Size pilimage
Python
1 vote254 views1 answer
File to lowercase python
Python
0 vote349 views1 answer
.defaultdict
Python
0 vote292 views1 answer
Tqdm for jupyter notebook
Python
0 vote258 views1 answer
Django form is onvalid
Python Django
19 votes259 views2 answers
How to add up everything in a list python
Python