/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

57 votes219 views11 answers
Python print color
Python
0 vote221 views1 answer
Deep copy a dataframe
Python
11 votes227 views6 answers
Enumerate in python
Python
0 vote234 views1 answer
Computecost pyspark
Python
3 votes241 views2 answers
Pandas normalize columns
Python
0 vote255 views1 answer
Whitelist the ip address django
Python Django
-1 vote222 views1 answer
Numpy split array into chunks of equal size
Python
42 votes219 views4 answers
Replace column values pandas
Python
0 vote221 views1 answer
Prints out the schema in the tree format
Python
1 vote221 views1 answer
Use chrome console in selenium
Python