Sqlalchemy one to many

class Parent(Base):
    __tablename__ = 'parent'
    id = Column(Integer, primary_key=True)
    children = relationship("Child", back_populates="parent")

class Child(Base):
    __tablename__ = 'child'
    id = Column(Integer, primary_key=True)
    parent_id = Column(Integer, ForeignKey('parent.id'))
    parent = relationship("Parent", back_populates="children")

Source: docs.sqlalchemy.org

Similar codes

3 votes192 views1 answer
Python for data analysis
Python
11 votes195 views3 answers
Reorder columns in python
Python
1 vote193 views1 answer
Update xls file using python
Python
0 vote216 views1 answer
For loop to create a set of counters in python
Python
0 vote206 views1 answer
Kivy on press call python function
Python
35 votes202 views6 answers
Install matplotlib
Python
5 votes213 views3 answers
Jupyter dark theme vampire
Python
0 vote188 views1 answer
AttributeError: type object 'User' has no attribute 'query'
Python
0 vote196 views1 answer
Hide window in selenium Webdriver python
Python
2 votes179 views1 answer
How to autosave in python
Python