/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

15 votes185 views3 answers
Max int python
Python
0 vote241 views1 answer
Find the closest smaller value in an array python
Python
0 vote189 views1 answer
What is tf.repeat()
Python
0 vote182 views1 answer
Random string generate python of 2.7
Python
0 vote196 views2 answers
Cannot create group in read-only mode. keras
Python
1 vote192 views1 answer
Are tuples in python mutable
Python
0 vote203 views1 answer
Chat bot in python
Python
0 vote189 views1 answer
Nn.softmax for pure sconvoultional classifier
Python
0 vote182 views1 answer
What is best app for Python
Python
-1 vote189 views1 answer
Python launch prompt
Python