Problem
Trying to create an instance of my model results in this error:SequelizeDatabaseError: null value in column "player_id" violates not-null constraint
Information
My model is defined like this:const PlayerTournament = sequelize.define("player_tournament_data", {
rebuys: INTEGER,
position: INTEGER,
});
PlayerTournament.associate = () => {
PlayerTournament.belongsTo(Player, { foreignKey: "player_id" });
PlayerTournament.belongsTo(Tournament, { foreignKey: "tournament_id" });
};
PlayerTournament.removeAttribute("id");
And the call is done here:
await sequelize.transaction(async ta => {
try {
const tournament = await Tournament.create({}, { transaction: ta });
const promises = players.map(player => {
const playerID = getPlayerID(player);
return PlayerTournament.create(
{ player_id: playerID, tournament_id: tournament.id },
{ transaction: ta }
);
});
return await Promise.all(promises);
} catch (error) {
throw new Error(error);
}
});
But the resulting query looks like:
INSERT INTO "player_tournament_data" DEFAULT VALUES RETURNING "rebuys","position";