/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 vote287 views1 answer
Split dict into chunks python
Python
4 votes357 views2 answers
Python strptime format codes
Python
2 votes286 views1 answer
Display flask across network
Python
0 vote352 views1 answer
Get version of cuda in pytorch
Python
0 vote315 views1 answer
Create a dict from variables and give name
Python
0 vote371 views1 answer
Php datatables serverside
Python
0 vote365 views1 answer
Opkg install python-lxml_2.2.8-r1_mips32el.ipk
Python
-1 vote316 views1 answer
Django template filter
Python
78 votes306 views4 answers
Read json
Python
7 votes336 views2 answers
Ban all discord python script
Python