node.js - Sequelize BelongsToMany : custom column in WHERE clause

Question

我有这 3 个模型:

var User = sequelize.define('users', {
    name: {
        type: DataTypes.STRING(50),
        field: 'name' 
    }
});

var Book = sequelize.define('books', {
    name: {
        type: DataTypes.STRING(50),
        field: 'name' 
    }
});

var UserBook = sequelize.define('userbook', {
    validated: {
        type: DataTypes.INTEGER,
        field: 'validated',
        defaultValue: 0
    }
});

Book.belongsToMany(User, {through: UserBook, foreignKey: 'bookId'});
User.belongsToMany(Book, {through: UserBook, foreignKey: 'userId'});

现在我想为验证 = 1 的用户获取书籍

我试过这个:

User.findOne({
    where: { id: req.session.user.id }
})
.then(function(user){
    user.getBooks({
        through: { validated: 1 }
    })
    .then(function(books){
        return res.json({success: true, books: books});
    })
});

但它返回所有书籍而不检查validated=1

如何获取所有带有validated=1 的书籍？

谢谢

Answer 1

我试过这个:

User.findOne({
  where: { id: req.session.user.id }
})
  .then(function (user) {
    user.getBooks({
      where: { validated: 1 }
    })
      .then(function (books) {
        return res.json({ success: true, books: books });
      })
  });

?

编辑(它有效):

User.findById(req.session.user.id, {
  include: [
    {
      model: Book,
      through: {
        where: { validated: 1 }
      }
    }
  ]
}).then((user) => {
  console.log(user);
})