sqlalchemy 一对多 relationship ForeignKey back_populates

from sqlalchemy import Table, Column, Integer, ForeignKey, create_engine, String
from sqlalchemy.orm import relationship, sessionmaker
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()
# 初始化数据库连接:
engine = create_engine('sqlite:///./sql_app.db', connect_args={'check_same_thread':False})

DBSession = sessionmaker(autoflush=False, autocommit=False,bind=engine)

# 初始化数据表
Base.metadata.create_all(bind=engine)

class Parent(Base):
    __tablename__ = 'parent'
    id = Column(Integer, primary_key=True)
    name = Column(String)

    # 因为 Child 中有 Parent 的 ForeignKey，这边的声明不需要再额外指定什么。
    children = relationship("Child", back_populates = "parent")  # children 的集合，相当于一个视图。

class Child(Base):
    __tablename__ = 'child'
    id = Column(Integer, primary_key=True)
    book = Column(String)
    parent_id = Column(Integer, ForeignKey('parent.id'))

    parent = relationship("Parent", back_populates = "children")


Base.metadata.create_all(bind=engine)
session = DBSession()

# user = Child(book='time is friend', parent_id=22)
#
# session.add(user)
# # 提交即保存到数据库:
# session.commit()
# # 关闭session:
# session.close()

user = session.query(Child).filter(Child.id==4).first()

print('user', user.parent.name)

参考
https://www.liaoxuefeng.com/wiki/897692888725344/955081460091040

https://www.cnblogs.com/kirito-c/p/10900024.html