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