/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 vote263 views1 answer
Calculate vif in python
Python
47 votes263 views6 answers
Python enumerate for loop
Python
2 votes254 views1 answer
Python time now other timezone
Python
3 votes258 views1 answer
Maping value to data in pandas dataframe
Python
-1 vote289 views2 answers
Python print 2d array as table
Python
4 votes223 views1 answer
Python open and read file with
Python
10 votes237 views2 answers
How to detect an even number in python
Python
0 vote260 views1 answer
Can we pickle pyspark dataframe using python
Python
7 votes251 views2 answers
Log base in python
Python
1 vote248 views2 answers
Django print query
Python