/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 vote159 views1 answer
Wxpython custom dialog
Python
0 vote181 views1 answer
Python align output
Python
0 vote169 views1 answer
Remove rows from a dataframe that are present in another dataframe?
Python
9 votes181 views2 answers
Discord.py unban command
Python
12 votes169 views6 answers
Pandas drop columns by index
Python
51 votes170 views6 answers
Pickle load
Python
0 vote165 views1 answer
Python garbaze collection
Python
19 votes154 views1 answer
Python cut string to length
Python
0 vote205 views1 answer
Django multi column index
Python Django
0 vote169 views1 answer
Python string replace letters with numbers
Python