I have a User model and Team model that I am looking to connect.
User.js Model
"use strict";
module.exports = sequelize => {
const User = sequelize.define(
"User",
{
id: {
type: Sequelize.UUID,
defaultValue: Sequelize.UUIDV1,
primaryKey: true,
allowNull: false
},
...more fields
}
{ tableName: "Users", timestamps: true }
);
User.associate = function(models) {
User.hasMany(models.Skill, {
foreignKey: "userId"
});
User.hasMany(models.Team, {
foreignKey: "userId"
});
};
return User;
};
Team.js Model
"use strict";
module.exports = (sequelize, DataTypes) => {
const Team = sequelize.define(
"Team",
{
id: {
allowNull: false,
autoIncrement: true,
primaryKey: true,
type: DataTypes.INTEGER
},
...more fields
},
{ tableName: "Teams", timestamps: true }
);
Team.associate = function(models) {
Team.belongsTo(models.User, {
foreignKey: "userId"
});
};
return Team;
};
The column userId in the team's table shows null despite setting the correct type (uuid).
When defining associations with no options, the userId column remains null.
User.associate = function(models) {
User.hasMany(models.Team);
}
Interestingly, the same code works for another table called "Skills".
"use strict";
module.exports = (sequelize, DataTypes) => {
const Skill = sequelize.define(
"Skill",
{
id: {
type: DataTypes.INTEGER,
allowNull: false,
autoIncrement: true,
primaryKey: true
},
},
{ tableName: "Skills", timestamps: true }
);
Skill.associate = models => {
Skill.belongsTo(models.User, {
foreignKey: "userId"
});
};
return Skill;
};
Methods used to create a team are showing an issue with the userId column.
// Create a new team
exports.createTeam = async (req, res) => {
const userId = req.session.passport.user.id;
const { title } = req.body;
const existingTeam = await models.Team.findOne({
where: { title: title, userId: userId }
});
if (existingTeam !== null) {
...
return;
}
const defaultTeamValues = {
title: title,
...
};
const team = await models.Team.create(defaultTeamValues);
res.status(200).json(team);
};
An image of the newly created team record displaying a null value in the userId column. https://i.stack.imgur.com/n9NYU.png
Although tables and constraints seem correct in pgAdmin 4, the userId issue persists.
Despite referencing documentation and searching for solutions, the userId problem remains unresolved. What steps am I missing?