/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 vote154 views1 answer
Python generator for reading and writing file
Python
-1 vote116 views1 answer
Python command not found
Python
2 votes120 views2 answers
Python convert hex to binary
Python
0 vote90 views1 answer
Calculate time python
Python
1 vote125 views3 answers
Pandas add column from list
Python
3 votes110 views1 answer
Width and height of pil image
Python
4 votes105 views1 answer
Pandas dataframe replace inf
Python
0 vote104 views4 answers
Food
Python
3 votes115 views3 answers
Run a shell script from python
Python
2 votes109 views2 answers
What is a print statement
Python