javascript - Sequelize : join tables beyond first degree relationship

Question

我有以下关系:

User 有 Subscription

Subscription 有 Subject

Subject 有 Lesson

如果这是一个多维数组，它看起来像这样:

`User` =>
      (`Subscription` => 
                 `Subject` => 
                     (`Lesson`, `Lesson`),
       `Subscription` => 
                 `Subject` =>
                     (`Lesson`, `Lesson`)
       ,  ...)

如何使用 Sequelize 查询保留此结构的完整数据集？ 如果我必须用“Sequelize 伪代码”来编写它，我会有类似的东西:

seq.User.findAll({
include[seq.Subscription.findAll({
include[seq.Subject.findAll({include: [seq.Lesson]}) ...

Answer 1

这应该是关于你需要的。你几乎在你的伪代码中就有了这个想法/流程。他们可能是写这个/做这个的更有效的方式？但这应该有效

seq.User.findAll({
  where: {},
  include: [{
    model: seq.Subscription,
    include: [{
      model: seq.Subject,
      include: [{
        seq.Lesson
      }]
    }]
  }]
}).then(function(responseFromDB) {
  handle callback
});