/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

3 votes200 views10 answers
Rick roll
Python
0 vote259 views1 answer
How to compare values in dictionary with same key python
Python
2 votes177 views2 answers
Fibonacci using function in python
Python
2 votes225 views1 answer
Hyperlinks in jupyter notebook
Python
2 votes190 views1 answer
How to uinstall a package in python
Python
0 vote187 views1 answer
Python, variables, Print() advanced, Input(), Variables ,INT, STR, FLOAT, BOOL, Casting
Python
1 vote171 views1 answer
Array as an input in python
Python
0 vote177 views1 answer
File = Root() path = file.fileDialog() print("PATH = ", path)
Python
1 vote273 views2 answers
No module named 'rest_framework_simplejwt'
Python
1 vote173 views1 answer
How to make nmap port scanner in python
Python