mysql - 在mysql中连接两个表时遇到SequelizeEagerLoadingError

Question

当我在 mysql 中加入两个表时，出现以下错误消息。

老师

module.exports = function(sequelize, Sequelize) {
    const Teachers = sequelize.define('Teachers', {
        id: {
            type: Sequelize.INTEGER, 
            autoIncrement: true, 
            primaryKey: true 
        },
        email: {
            type: Sequelize.STRING, 
            validate: {
                isEmail: true
            }
        }
    }, {
        classMethods: {
            associate: function (models) {
                Teachers.hasMany(models.Students);
            }
        }
    });
    return Teachers;
}

学生

module.exports = function(sequelize, Sequelize) {
    const Students = sequelize.define('Students', {
        id: {
            type: Sequelize.INTEGER, 
            autoIncrement: true, 
            primaryKey: true 
        },
        email: {
            type: Sequelize.STRING, 
            validate: {
                isEmail: true
            }
        }
    }, {
        classMethods: {
            associate: function (models) {
                Students.belongsTo(models.Students);
            }
        }
    });
    return Students;
}

和

exports.allRegisteredStudents = function (teacherId) {
    return models.Teachers.findAll({
        where: {
            id: teacherId
        },
        include: [models.Students]
    });
};

请告诉我我错过添加的内容，谢谢。

Answer 1

学生不应该属于学生模型，学生应该属于教师模型应该是这样的:

module.exports = function(sequelize, Sequelize) {
const Students = sequelize.define('Students', {
    id: {
        type: Sequelize.INTEGER, 
        autoIncrement: true, 
        primaryKey: true 
    },
    email: {
        type: Sequelize.STRING, 
        validate: {
            isEmail: true
        }
    }
}, {
    classMethods: {
        associate: function (models) {
            Students.belongsTo(models.Teachers);
        }
    }
});
return Students;

}

和

exports.allRegisteredStudents = async function (teacherId) {
return await models.Teachers.findAll({
    where: {
        id: teacherId
    },
    include: [{ model: models.Students }]
});

};