node.js - findAll() 不是函数 sequelize

Question

我正在用 nodejs 制作一个应用程序，我想连接到我的模型，但我一直收到同样的错误:

TypeError: user.findAll is not a function

路线/用户.js

const express = require('express');
const router = express.Router();
const db = require('../config/database');
const user = require('../models/users');

router.get('/', (req, res) => user.findAll()
.then(users =>  {
    console.log(users)
    res.sendStatus(200);
     })
.catch(err => console.log(err)));

module.exports = router;

模型/用户.js

'use strict';

const Sequelize = require('sequelize');
const db = require('../config/database')

module.exports = (sequelize, DataTypes) => {
  const users = sequelize.define('users', {
    id: DataTypes.INTEGER,
    name: DataTypes.STRING,
    age: DataTypes.INTEGER,
    email: DataTypes.STRING,
    country: DataTypes.STRING,
    state: DataTypes.STRING,
    city: DataTypes.STRING
  }, {});
  users.associate = function(models) {
    // associations can be defined here
  };
  return users;
};

Answer 1

您应该使用 db.users.findAll() 而不是 user.findAll() 。它会工作