在我的节点js项目中,我使用express和sequelize . 我想创建一些灯具以填充我的数据表 .
使用Sequelize-fixtures npm,这是我的 fixtures.js
文件:
'use strict';
const sequelize_fixtures = require('sequelize-fixtures');
// define all the model
const models = {
Mission: require(__dirname+'/../models/mission.js')
};
var fixtures =[
{
"model": "Mission",
"data": {
"description": "mission test 1",
"state": "pending",
"slug" : "mission-test-1"
}
},
{
"model": "Mission",
"data": {
"description": "mission test 2",
"state": "finished",
"slug" : "mission-test-2"
}
}
];
// export and load fixtures
module.exports = {
loadFixtures: () => {
// can use glob syntax to select multiple files
sequelize_fixtures.loadFixtures(fixtures, models).then(function(){
console.log("Fixtures have been loaded, check your database tables ;) !!!");
});
}
};
在我的项目的根目录中,我在 server.js
中将此模块称为:
// ...
// Importing sequelize
let database = require(__dirname + '/database/database');
let fixturesLoader = require(__dirname+'/database/fixtures/fixtures.js');
但是当我重新启动节点服务器时,我现在在控制台中出现此错误:
未处理的拒绝错误:models.Mission似乎是一个功能 . 也许您正在导入模型工厂功能?然后你应该使用sequelize.import来创建你的模型,参见https://github.com/sequelize/express-example/blob/master/models/index.js#L17
当然我检查链接,这就是我在名为database.js的文件中使用sequelize和配置的方法:
'use strict';
const fs = require('fs');
const path = require('path');
const Sequelize = require('sequelize');
const config = require(__dirname+'/database.json');
const db = {};
let sequelize = new Sequelize(config.db.dbname, config.db.user, config.db.password, {
host: config.db.host,
port: config.db.port,
define: {
// And deletedAt to be called destroyTime (remember to enable paranoid for this to work)
deletedAt: 'deleted_at',
paranoid: true,
// don't use camelcase for automatically added attributes but underscore style
underscored: true,
// disable the modification of table names; By default, sequelize will automatically
// transform all passed model names (first parameter of define) into plural.
freezeTableName: true,
charset: 'utf8',
collate: 'utf8_general_ci',
timestamps: true,
language: 'fr'
}
});
fs.readdirSync(__dirname + '/models').filter(function (file) {
return (file.indexOf('.') !== 0);
}).forEach(function (file) {
let model = sequelize.import(path.join(__dirname + '/models', file));
db[model.name] = model;
});
Object.keys(db).forEach(function (modelName) {
if ('associate' in db[modelName]) {
db[modelName].associate(db);
}
});
db.sequelize = sequelize;
db.Sequelize = Sequelize;
module.exports = db;
我知道我正在将我的模型导入为函数,但是按照文档,我不明白如何在没有这种方式的情况下导入它们 .
1 回答
我刚刚通过在sequelize-fixtures / lib / loader.js中注释这两行解决了这个问题: