const model = require(path;join(__dirname, file))(sequelize,

Question

我是web开发的初学者，试图使用Mysql, Node.js与Express创建一个项目。在使用Sequalize时面临这个TypeError问题。有人能给我解释一下并帮我找到解决方案吗?

"sequelize"^ 6.19.0"

"sequelize-cli"^ 6.4.1"

/模型/user.js:

module.exports = (sequelize, DataTypes) => {
  const user = sequelize.define('User', {
    name: DataTypes.STRING,
    username: DataTypes.STRING,
    email: DataTypes.STRING,
    password: DataTypes.STRING,
  });
  return user;
};

/模型/index.js:

'use strict';
const fs = require('fs');
const path = require('path');
const Sequelize = require('sequelize');
const basename = path.basename(__filename);
const env = process.env.NODE_ENV || 'development';
const config = require(`${__dirname}/../../config/config.js`)[env];
const db = {};
let sequelize;
if (config.use_env_variable) {
  sequelize = new Sequelize(process.env[config.use_env_variable], config);
} 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 = require(path.join(__dirname, file))(sequelize, Sequelize.DataTypes);
    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;

错误:

[nodemon] starting `node ./src/api/server.js`
/home/back-end/src/models/index.js:25
    const model = require(path.join(__dirname, file))(sequelize, Sequelize.DataTypes);
                                                     ^
TypeError: require(...) is not a function
    at /home/back-end/src/models/index.js:25:54
    at Array.forEach (<anonymous>)
    at Object.<anonymous> (/home/back-end/src/models/index.js:24:4)
    at Module._compile (internal/modules/cjs/loader.js:1068:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1097:10)
    at Module.load (internal/modules/cjs/loader.js:933:32)
    at Function.Module._load (internal/modules/cjs/loader.js:774:14)
    at Module.require (internal/modules/cjs/loader.js:957:19)
    at require (internal/modules/cjs/helpers.js:88:18)
    at Object.<anonymous> (/home/back-end/src/services/usersService.js:1:18)
[nodemon] app crashed - waiting for file changes before starting...

Answer 1

经验之谈我在"models"目录中添加了一个不是模型的文件后遇到了这个问题。假设我们只能将模型文件添加到'models'目录中，因为index.js会检查整个目录中的每个文件。

Answer 2

我实际上已经与这个问题斗争了一段时间了。对我有用的是，我使用ES6类(在Sequelize文档中称为扩展模型)来创建我的表，而不是(Sequelize.define)。老实说，我仍然不确定为什么，但是您可以在sequelize文档中找到如何使用扩展模型在sequelize中创建表。

Answer 3

在你的index.js文件中，你应该使用这个格式，它会解决你的错误

const fs = require('fs')
const path = require('path')
const Sequelize = require('sequelize')
const config = require('../config/config')
const db = {}
const sequelize = new Sequelize(
  config.database, 
  config.username, 
  config.password, 
  config
);   
fs
 .readFileSync(__dirname)
 .filter((file) =>
  file !== 'index.js'
 )
.forEach((file) => {
   const model = require(path.join(__dirname, file))(sequelize,Sequelize.DataTypes)
    db[model.name] = model
 })
 
 db.sequelize = sequelize
 db.Sequelize = Sequelize
 module.exports = db