node.js - 自定义查询的不一致的 Sequelize 查询构造

Question

我目前正在尝试在我的 Node 应用程序中构建一个 Sequelize 查询，如下所示；

import sequelize from 'sequelize';

function getReadMsg(){
  const where = [sequelize.where(
    sequelize.literal('"Message"."status" = \'read\'') 
  )];

  const attributes = { exclude: ['updated_at'] };

  const order = [['created_at', 'ASC']];

  return model.findAll({ where, attributes, order }); // model is a sequelize model object
}

但是，Sequelize 构造的原始查询正在比较
其中 块为空，因此违背了查询的目的。
下面是原始的 Sequelize 构造查询；

SELECT "id", "title", "body", "to", "from", "status", "created_at" FROM "Messages" AS "Message" WHERE ("Message"."status" = 'read' IS NULL) ORDER BY "Message"."created_at" ASC;

代替;

SELECT "id", "title", "body", "to", "from", "status", "created_at" FROM "Messages" AS "Message" WHERE ("Message"."status" = 'read') ORDER BY "Message"."created_at" ASC;

压缩版本:5.21.4。
squelize-cli 版本:5.5.1。
Node 版本:12.16.1

Answer 1

sequelize.where 使用 3 个参数，如果省略最后两个参数，它们将分别为 '=' 和 'null'。
你应该做这样的事情:

sequelize.where(sequelize.literal('"Message"."status"'), '=', 'read')