如何使用存储在变量中的值进行原始查询

Question

我正在为Postresql 11的Nodejs上的sequelize (6.5.x)编写一个原始SQL。以下是原始查询的示例：

const { QueryTypes } = require('sequelize');
let sql = "SELECT * from messages WHERE sender_id = 1";
const msgs = await sequelize.query(sql, { type: QueryTypes.SELECT });

如果sender_id存储在变量senderID中，如何在上面的原始查询中使用变量senderID？

Answer 1

你可以像这样做

const { QueryTypes } = require("sequelize");
let sql = "SELECT * from messages WHERE sender_id = ?";
const msgs = await sequelize.query(sql, {
  replacements: [senderID],
  type: QueryTypes.SELECT,
});

或

const { QueryTypes } = require("sequelize");
let sql = "SELECT * from messages WHERE sender_id = :senderID";
const msgs = await sequelize.query(sql, {
  replacements: { senderID },
  type: QueryTypes.SELECT,
});

您可以在文档的Replacement部分找到更多详细信息