/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 vote142 views1 answer
Input must be string python
Python
0 vote173 views1 answer
Extends template django
Python Django
0 vote149 views1 answer
Reorder list python
Python
1 vote137 views1 answer
Pip is not a batch command but python is installed
Python
17 votes148 views1 answer
Sudo apt-get install python3-tk not working
Python
0 vote138 views1 answer
How to get minimum value in list python
Python
0 vote142 views1 answer
Pytorch dataloader to numpy array
Python
0 vote136 views1 answer
Download python 3.8
Python
0 vote165 views1 answer
Parallel loops in python
Python
1 vote142 views1 answer
How to print whole year calendar in python
Python