/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 vote143 views1 answer
Least square fit straight line python
Python
2 votes163 views2 answers
Django exclude queryset
Python
2 votes160 views2 answers
Generate random integer matrix python
Python
0 vote146 views1 answer
Os.startfile on raspberry
Python
80 votes172 views21 answers
Python syntax cheat sheet
Python
0 vote146 views1 answer
Python tf.maximum
Python
3 votes198 views2 answers
Python replace space with underscore
Python
0 vote163 views1 answer
How to read backslash slash python
Python
0 vote143 views1 answer
Pytest suppress errors
Python
2 votes151 views1 answer
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xb0 in position 1968: invalid start byte
Python