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

Question

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

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

const sequelize = require("sequelize");

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

但我收到一条错误消息：

TypeError: sequelize.query is not a function

为什么会发生这种情况？

标签： sequelize.js

Answer 1

你可以在这里找到答案

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)
  })