Sequelizer db.define不是函数？

Question

我有个后遗症。我阅读了文档并做了和他们一样的事情，但是总是被以下错误所困扰。请帮我解决这个错误。

以下是错误

TypeError:Db.Define不是对象上的函数。(/home/robin/public/server/models/users.js:6:17)

在module._compile(internal/modules/cjs/loader.js:1151:30)

位于object.module._extensions..js(internal/modules/cjs/loader.js:1171:10)

在module.load处(internal/modules/cjs/loader.js:1000:32)

在function.module._load(internal/modules/cjs/loader.js:899:14)

在module.require处(internal/modules/cjs/loader.js:1040:19)

要求(internal/modules/cjs/helpers.js:72:18)

在物体上。(/home/robin/public/server/routes/user.js:4:14)

在module._compile(internal/modules/cjs/loader.js:1151:30)

位于object.module._extensions..js(internal/modules/cjs/loader.js:1171:10)

在module.load处(internal/modules/cjs/loader.js:1000:32)

在function.module._load(internal/modules/cjs/loader.js:899:14)

在module.require处(internal/modules/cjs/loader.js:1040:19)

null

在物体上。(/home/robin/public/server/app.js:10:19)

在module._compile(internal/modules/cjs/loader.js:1151:30)

[nodemon]应用程序崩溃-在启动前等待文件更改。。。

这是代码

模型

const Sequelize = require("sequelizer");
const db = require("../config/database");

const users = db.define("user", {
  email: {
    type: Sequelize.STRING
  } 
});

module.exports = users;

null

var fs = require("fs");
var path = require("path");
var Sequelize = require("sequelize");
var basename = path.basename(module.filename);
var env = process.env.NODE_ENV || "development";
var config = require(__dirname + "/../config/config.json")[env];
var db = {};

if (config.use_env_variable) {
  var sequelize = new Sequelize(process.env[config.use_env_variable]);
} else {
  var sequelize = new Sequelize(
    config.database,
    config.username,
    config.password,
    config
  );
}

fs.readdirSync(__dirname)
  .filter(function(file) {
    return (
      file.indexOf(".") !== 0 && file !== basename && file.slice(-3) === ".js"
    );
  })
  .forEach(function(file) {
    var model = sequelize["import"](path.join(__dirname, file));
    db[model.name] = model;
  });

Object.keys(db).forEach(function(modelName) {
  if (db[modelName].associate) {
    db[modelName].associate(db);
  }
});

sequelize
  .authenticate()
  .then(() => {
    console.log("Connection has been established successfully.");
  })
  .catch(err => {
    console.error("Unable to connect to the database:", err);
  });

db.sequelize = sequelize;
db.Sequelize = Sequelize;

module.exports = db;

Answer 1

您的模型

const Sequelize = require("sequelizer");
const db = require("../config/database");

module.exports = (sequelize, Sequelize) => {
const users = db.define("user", {
  email: {
    type: Sequelize.STRING
  } 
})
    return Users
}

Answer 2

我想，应该是

db.sequelize.define(user)，

不是

db.define(user)“，

const Sequelize = require("sequelizer");
const db = require("../config/database");

const users = db.sequelize.define("user", {
  email: {
    type: Sequelize.STRING
  } 
});

module.exports = users;

（或）（已更新）

module.exports = (sequelize, Sequelize) => {
const users = sequelize.define("user", {
      email: {
        type: Sequelize.STRING
      } 
    });
 }

不要忘记在Dasebase文件中导入用户模型，例如:

db.sequelize = sequelize;
db.Sequelize = Sequelize;

    db.users = require('./path/to/usermodel.js')(sequelize, Sequelize);   

module.exports = db;

Answer 3

我也遇到了同样的问题，在做了一些研究之后，发现在使用 时，生成的 文件并不与所有nodejs版本兼容。

null

const fs = require('fs');
const path = require('path');
const Sequelize = require('sequelize');
const basename = path.basename(module.filename);
const env = process.env.NODE_ENV || 'development';
const config = require('../config/config.json')[env];
const db = {};

let sequelize;
if (config.use_env_variable) {
  sequelize = new Sequelize(process.env[config.use_env_variable]);
} else {
  sequelize = new Sequelize(
    config.database, config.username, config.password, config
  );
}

fs
  .readdirSync(__dirname)
  .filter(file =>
    (file.indexOf('.') !== 0) &&
    (file !== basename) &&
    (file.slice(-3) === '.js'))
  .forEach(file => {
    const model = sequelize.import(path.join(__dirname, file));
    db[model.name] = model;
  });

Object.keys(db).forEach(modelName => {
  if (db[modelName].associate) {
    db[modelName].associate(db);
  }
});

db.sequelize = sequelize;
db.Sequelize = Sequelize;

module.exports = db;

希望这有用！