炼金术强力连接

Question

我有以下两门课。我想做的是课程名称字段总是出现在我对课程领域学习的查询中

class Curriculum(db.Model, SerializableModel):
  __tablename__ = "curriculum"
  id = db.Column(db.Integer, primary_key=True)
  name = db.Column(db.String(300), nullable=False)
  iscurrent = db.Column(db.Boolean, nullable=False)
  notes = db.Column(db.Text)
  areasoflearning = db.relationship('CurriculumAreaOfLearning', lazy='dynamic')

class CurriculumAreaOfLearning(db.Model, SerializableModel):
  __tablename__ = "curriculumareaoflearning"
  id = db.Column(db.Integer, primary_key=True)
  name = db.Column(db.String(300), nullable=False)
  curriculumid = db.Column(db.Integer, db.ForeignKey('curriculum.id'), nullable=False)
  curriculum = db.relationship('Curriculum', lazy='joined')

我尝试了以下查询。我的查询中没有我的课程属性

db.session.query(CurriculumAreaOfLearning).join(models.Curriculum, models.CurriculumAreaOfLearning.curriculumid == models.Curriculum.id)

我尝试了以下查询。我出错了

db.session.query(CurriculumAreaOfLearning).join(models.Curriculum, models.CurriculumAreaOfLearning.curriculumid == models.Curriculum.id).add_columns(model.Curriculum.name)

AttributeError:类型对象“CoursumAreaOfLearning”没有属性“Coursum”

Answer 1

试试这个：

db.session.query(CurriculumAreaOfLearning, Curriculum)
          .join(Curriculum, Curriculum.id == CurriculumAreaOfLearning.curriculumid).all()