Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Sequelize model references vs associations

Just starting to use Sequelize and I've setup a bunch of models and seeds, but I can't figure out references vs associations. I don't see the use case for references if they even do what I think they do, but I couldn't find a good explanation in the docs.

Is this redundant having references and associations?

module.exports = (sequelize, DataTypes) => {
  const UserTask = sequelize.define('UserTask',
    {
      id: {
        primaryKey: true,
        type: DataTypes.UUID,
        defaultValue: DataTypes.UUIDV4
      },
      userId: {
        type: DataTypes.UUID,
        references: { // <--- is this redundant to associate
          model: 'User',
          key: 'id'
        }
      }
      // ... removed for brevity
    },
    {
      classMethods: {
        associate: models => { <--- makes references redundant?
          UserTask.belongsTo(models.User, {
            onDelete: 'CASCADE',
            foreignKey: {
              fieldName: 'userId',
              allowNull: true,
              require: true
            },
            targetKey: 'id'
          });
        }
      }
    }
  );
  return UserTask;
};
like image 976
mtpultz Avatar asked Sep 19 '17 16:09

mtpultz


People also ask

How do you define association in Sequelize model?

Creating associations in sequelize is done by calling one of the belongsTo / hasOne / hasMany / belongsToMany functions on a model (the source), and providing another model as the first argument to the function (the target). hasOne - adds a foreign key to the target and singular association mixins to the source.


1 Answers

Using references you create a reference to another table, without adding any constraints, or associations. Which means that is just a way of signaling the database that this table has a reference to another.

Creating an association will add a foreign key constraint to the attributes. And the you can perform all the magic behind it the association functions. i.e User.getTasks();

More info about references here: https://sequelize.readthedocs.io/en/latest/docs/associations/#foreign-keys_1

About association here: http://docs.sequelizejs.com/manual/tutorial/associations.html

like image 177
Dmytro Mysak Avatar answered Oct 23 '22 10:10

Dmytro Mysak