Проблема заключается в findAll
продукте, выбранном со столбцом, которого не существует "PermissionId"
Я не понимаю, почему sequelize создает этот столбец.
Ошибка:
Необработанное отклонение SequelizeDatabaseError: столбец «PermissionId» не существует в Query.formatError (/home/baptiste/IUT2/ProjetS3/code/M3301/node_modules/sequelize/lib/dialects/postgres/query.js:366:16) at home /baptiste/IUT2/ProjetS3/code/M3301/node_modules/sequelize/lib/dialects/postgres/query.js:72:18 в tryCatcher (/ home / baptiste / IUT2 / ProjetS3 / code / M3301 / node_modules / bluebird release / util.js: 16:23) в Promise._settlePromiseFromHandler (/home/baptiste/IUT2/ProjetS3/code/M3301/node_modules/bluebird/js/release/promise.js:547:31) в Promise._settlePromise (/ home / baptiste / IUT2 / ProjetS3 / code / M3301 / node_modules / bluebird / js / release / promise.js: 604: 18) в Promise._settlePromise0 (/ home / baptiste / IUT2 / ProjetS3 / code / M3301 / node_modules / bluebird / js / release / promise.js: 649: 10) в Promise._settlePromises (/home/baptiste/IUT2/ProjetS3/code/M3301/node_modules/bluebird/js/release/promise.js:725:18) в _drainQueueStep ( /home/baptiste/IUT2/ProjetS3/code/M3301/node_modules/bluebird/js/release/async.js:93:12) в _drainQueue (/ home / baptiste / IUT2 / ProjetS3 / code / M3301 / node_modules / bluebird /release/async.js:86:9) в Async._drainQueues (/home/baptiste/IUT2/ProjetS3/code/M3301/node_modules/bluebird/js/release/async.js:102:5) в Immediate.Async. DrainQueues [как _onImmediate] (/home/baptiste/IUT2/ProjetS3/code/M3301/node_modules/bluebird/js/release/async.js:15:14) в processImmediate (internal / timers.js: 439: 21)
код миграции:
Таблицы 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;
};