Sequelize查询给出TypeError:undefined不是一个函数 [英] Sequelize query is giving TypeError: undefined is not a function

问题描述

我正在为我的节点应用程序使用express和sequelize.在控制器文件上，我具有以下内容:

I'm using express and sequelize for my node application. On the controller file, I have the following:

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不是一个函数.您能指出我在这段代码中做错了什么吗?

I can use model.findAll fine but when I try to use raw query, I'm getting the TypeError: undefined is not a function. Can you point what I'm doing wrong in this code?

推荐答案

您需要在 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)
  })

这篇关于Sequelize查询给出TypeError:undefined不是一个函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！