首页 文章

导入模型作为函数,sequelize fixtures不从json文件导入数据:未处理的拒绝错误返回?

提问于
浏览
0

在我的节点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 回答

  • 1

    我刚刚通过在sequelize-fixtures / lib / loader.js中注释这两行解决了这个问题:

    if (!Model) {
            throw new Error('Model not found: ' + fixture.model);
        // } else if (typeof Model === 'function') {
        //     throw new Error('models.' + fixture.model + ' appears to be a function. Perhaps you are importing model factory function? You should then use sequelize.import to create your model, see https://github.com/sequelize/express-example/blob/master/models/index.js#L17');
        } else if (!Model.findOne) {
            throw new Error('models.' + fixture.model + ' is not a sequelize model.');
        }
    

相关问题