node.js - Sequelize 查询给出 TypeError : undefined is not a function

Question

我正在为我的 Node 应用程序使用express和sequelize。在 Controller 文件上，我有以下内容:

var models          = require('../models'),
    Property        = models.property,
    Sequelize       = require('sequelize');

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

我可以很好地使用 model.findAll 但当我尝试使用原始查询时，我收到 TypeError: undefined is not a function。你能指出我在这段代码中做错了什么吗？

Answer 1

您需要在 Sequelize 实例上调用 query()::

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