文章内容
2018/8/9 13:54:34,作 者: 黄兵
SQLAlchemy级联查询
最近使用SQLAlchemy做级联查询,记录如下:
SQLAlchemy级联查询:
u = db.session.query(ClassificationCatalog.classification_id).group_by( ClassificationCatalog.classification_id).subquery() for a in db.session.query(MaterialClassification).outerjoin(u,MaterialClassification.id == u.c.classification_id).order_by(MaterialClassification.id): print(a.classification_name)
评论列表