node.js - Sequelizejs 与

我做了一些同事，但没有用，可能是我觉得有问题，寻求帮助。
有两种型号

module.exports = function (sequelize, DataTypes) {
var pages_lang = require('./pages_lang')(sequelize, DataTypes);
return sequelize.define('pages', {
    id: {
        type: DataTypes.INTEGER(10),
        allowNull: false,
        primaryKey: true,
        autoIncrement: true,
        references :  { model: "pages_lang", key: "page_id" }
    },
    name: {
        type: DataTypes.STRING,
        allowNull: false
    },
    published: {
        type: DataTypes.BOOLEAN,
        allowNull: false,
        defaultValue: '0'
    },
    createdAt: {
        type: DataTypes.DATE,
        allowNull: false,
        defaultValue: '0000-00-00 00:00:00'
    },
    updatedAt: {
        type: DataTypes.DATE,
        allowNull: false,
        defaultValue: '0000-00-00 00:00:00'
    }
}, {
    classMethods: {
        associate: function (models) {
            this.hasMany(models.pages_lang, {onDelete: 'SET NULL', onUpdate: 'CASCADE', foreignKey: 'page_id', as: 'pages', through: models.pages_lang});
        },
        getAll() {
            return this.findAll({include: [{model: pages_lang, as: 'pages_lang'}]}).then(function (result) {
                return result;
            });
        }
    }
});

};

module.exports = function (sequelize, DataTypes) {
return sequelize.define('pages_lang', {
    id: {
        type: DataTypes.INTEGER(10),
        allowNull: false,
        primaryKey: true,
        autoIncrement: true
    },
    page_id: {
        type: DataTypes.INTEGER(10),
        allowNull: false,
        references :  { model: "pages", key: "id" }
    },
    content: {
        type: DataTypes.TEXT,
        allowNull: false
    }
}, {
    classMethods: {
        associate: function (models) {
            this.belongsTo(models.pages, {foreignKey: 'id', foreignKeyConstraint:true, as: 'pages', through: models.pages});
        }
    }
});

};

但是当你调用导致错误时



提前非常感谢帮助

最佳答案

您的关联别名 ( as ) 应与您传递给 findAll 的内容匹配

this.hasMany(models.pages_lang, {onDelete: 'SET NULL', onUpdate: 'CASCADE', foreignKey: 'page_id', as: 'pages_lang' });

return this.findAll({include: [{model: pages_lang, as: 'pages_lang'}]});

由于模型已经被称为 pages_lang ，你也可以完全跳过别名:

this.hasMany(models.pages_lang, {onDelete: 'SET NULL', onUpdate: 'CASCADE', foreignKey: 'page_id'});

return this.findAll({include: [pages_lang]});

请注意，我删除了 through 参数 - 它应该仅用于 belongsToMany(多对多)

关于node.js - Sequelizejs 与，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/36268134/