/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 vote114 views1 answer
Python mongodump
Python
3 votes139 views3 answers
Flask migrate install
Python Flask
3 votes134 views1 answer
Simple colours python
Python
0 vote113 views1 answer
Python tar a directory
Python
5 votes117 views1 answer
2set
Python
7 votes104 views6 answers
Hello world in python
Python
0 vote115 views1 answer
Python execute echo to file
Python
0 vote134 views2 answers
How to install modules to a specific version of python
Python
4 votes117 views2 answers
List to json python
Python
15 votes137 views3 answers
How to shutdown your computer using python
Python