sequelize.js - 如何导入 sequelize js 以执行原始查询

Question

我想在 Sequelize js 中运行 raw 查询。

这是我在banner.js controller 文件中的查询

const sequelize = require("sequelize");

const data = await sequelize.query("SELECT * FROM banners", {
      type: sequelize.QueryTypes.SELECT
      });

但我收到一条错误消息:

TypeError: sequelize.query is not a function

为什么会发生这种情况？

Answer 1

您可以在 here 找到答案

var Sequelize = require('sequelize');
var sequelize = new Sequelize('database', 'username', 'password');

sequelize.query("SELECT * FROM 'property'", { type:Sequelize.QueryTypes.SELECT})
   .then(function(properties) {
      res.json(properties)
  })