后遗症数据库错误列名称不存在

Question

我不明白为什么sequelize会生成这个专栏。

错误有：

未处理的拒绝SequelizeDatabaseError：列“PermissionID”不存在于Query.FormatError(/Home/Baptiste/IUT2/Projets3/Code/M3301/Node_Modules/Sequelize/lib/Dialects/Postgres/Query.js:366:16)的/Home/Baptite/IUT2/Projets3/Code/M3301/Node_Modules/Sequelize/lib/Dialects/Postgres/Query.js:72:18的tryCatcherS:93:12)在_DrainQueue(/Home/Baptiste/IUT2/Projets3/Code/M3301/Node_Modules/BlueBird/JS/Release/Async.js:86:9)在Async._DrainQuees(/Home/Baptiste/IUT2/Projets3/Code/M3301/Node_Modules/BlueBird/JS/Release/Async.js:102:5)在Inmediate.Async.DrainQuees[As_onInmediate]

迁移代码：

Utilisateurs表

    'use strict';
    module.exports = {
        up: (queryInterface, Sequelize) => {
            return queryInterface.createTable('Utilisateurs', {
                id: {
                    allowNull: false,
                    autoIncrement: true,
                    primaryKey: true,
                    type: Sequelize.INTEGER
                },
                adresseMail: {
                    type: Sequelize.STRING
                },
                nomUtilisateur: {
                    type: Sequelize.STRING
                },
                dateDeNaissance: {
                    type: Sequelize.STRING
                },
                motDePasse: {
                    type: Sequelize.STRING
                },
                createdAt: {
                    allowNull: false,
                    type: Sequelize.DATE
                },
                updatedAt: {
                    allowNull: false,
                    type: Sequelize.DATE
                },
                idPermission: {
                    type: Sequelize.INTEGER,
                    references: {
                        model: {
                            tableName: 'Permissions',
                            schema: 'public'
                        },
                        key: 'id'
                    }
                }
            });
        },
        down: (queryInterface, Sequelize) => {
            return queryInterface.dropTable('Utilisateurs');
        }
    };

权限表

'use strict';
    module.exports = {
        up: (queryInterface, Sequelize) => {
            return queryInterface.createTable('Permissions', {
                id: {
                    allowNull: false,
                    autoIncrement: true,
                    primaryKey: true,
                    type: Sequelize.INTEGER
                },
                estRegatier: {
                    type: Sequelize.BOOLEAN
                },
                estJury: {
                    type: Sequelize.BOOLEAN
                },
                estOrganisateur: {
                    type: Sequelize.BOOLEAN
                },
                createdAt: {
                    allowNull: false,
                    type: Sequelize.DATE
                },
                updatedAt: {
                    allowNull: false,
                    type: Sequelize.DATE
                }
            });
        },
        down: (queryInterface, Sequelize) => {
            return queryInterface.dropTable('Permissions');
        }
    };
    ```
    'use strict';
    module.exports = {
        up: (queryInterface, Sequelize) => {
            return queryInterface.createTable('Permissions', {
                id: {
                    allowNull: false,
                    autoIncrement: true,
                    primaryKey: true,
                    type: Sequelize.INTEGER
                },
                estRegatier: {
                    type: Sequelize.BOOLEAN
                },
                estJury: {
                    type: Sequelize.BOOLEAN
                },
                estOrganisateur: {
                    type: Sequelize.BOOLEAN
                },
                createdAt: {
                    allowNull: false,
                    type: Sequelize.DATE
                },
                updatedAt: {
                    allowNull: false,
                    type: Sequelize.DATE
                }
            });
        },
        down: (queryInterface, Sequelize) => {
            return queryInterface.dropTable('Permissions');
        }
    };
    ```
    models code :
    **Utilisateur**
    ```'use strict';
    module.exports = (sequelize, DataTypes) => {
        const Utilisateurs = sequelize.define('Utilisateur', {
            adresseMail: DataTypes.STRING,
            nomUtilisateur: DataTypes.STRING,
            dateDeNaissance: DataTypes.STRING,
            motDePasse: DataTypes.STRING,
            idPermission: DataTypes.INTEGER
        }, {});
        Utilisateurs.associate = function (models) {
            Utilisateurs.belongsTo(models.Permission);
            Utilisateurs.hasMany(models.Licencie);
        };
        return Utilisateurs;
    };

'use strict';

    module.exports = (sequelize, DataTypes) => {
        const Permission = sequelize.define('Permission', {
            estRegatier: DataTypes.BOOLEAN,
            estJury: DataTypes.BOOLEAN,
            estOrganisateur: DataTypes.BOOLEAN
        }, {});
        Permission.associate = function (models) {
            Permission.hasMany(models.Utilisateur);
        };
        return Permission;
    };

Answer 1

您可以尝试以下方法：

module.exports = (sequelize, DataTypes) => {
    const Utilisateurs = sequelize.define('Utilisateur', {
        adresseMail: DataTypes.STRING,
        nomUtilisateur: DataTypes.STRING,
        dateDeNaissance: DataTypes.STRING,
        motDePasse: DataTypes.STRING,
        // idPermission: DataTypes.INTEGER **I belive you must remove this line!
    }, {});
    Utilisateurs.associate = function (models) {
        Utilisateurs.belongsTo(models.Permission, { foreignKey: 'idPermission'});
        Utilisateurs.hasMany(models.Licencie);
    };
    return Utilisateurs;
};

我尝试为该表指定foreign_PK，默认情况下，sequelize将尝试PermissionId，但您的键是IDPermission。

请为我糟糕的英语道歉！