/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

9 votes247 views2 answers
Remove all rows without a value pandas
Python
0 vote265 views1 answer
NaN stand for python
Python
0 vote280 views1 answer
Numpy add
Python
4 votes245 views1 answer
Record the amount of time ittales for code to run python
Python
1 vote244 views1 answer
Returns a new DataFrame omitting rows with null values
Python
3 votes258 views1 answer
Delete element from list value
Python
1 vote293 views2 answers
Python read parquet
Python
0 vote270 views1 answer
How to hash out a big paragraph in vs code python
Python
3 votes316 views1 answer
Access the value in settings django
Python Django
8 votes282 views6 answers
Python string formatting
Python