Tukukkk

I have a many to many relationship between: Step and Control Through ControlsConfig.
When creating a Control object and call addStep function and specify the additional attributes (which exist in the relation table), Sequelize creates the records in the relational table ControlsConfig but the additional attributes are NULLs.

PS: The tables are creating correctly in the database.

Table 1: Step

Table 2: Control

Relation table: ControlsConfig

Step

 var Step = sequelize.define('Step', {

    title: { type: DataTypes.STRING, allowNull: false },

    description: DataTypes.STRING,

    type: { type: DataTypes.ENUM('task', 'approval'), allowNull: false, defaultValue: 'task' },

    order: DataTypes.INTEGER

  });



  Step.associate = function(models) {

    models.Step.belongsTo(models.User);

    models.Step.belongsTo(models.Template);

    models.Step.hasMany(models.Action);

  };

Control

var Control = sequelize.define('Control', {

    label: { type: DataTypes.STRING, allowNull: false },

    order: { type: DataTypes.INTEGER },

    type: { type: DataTypes.ENUM('text', 'yes/no') },

    config: { type: DataTypes.TEXT },

    controlUiId: { type: DataTypes.STRING }

  });



  Control.associate = function(models) {

    models.Control.belongsTo(models.Section);

  };

ControlsConfigs

  module.exports = (sequelize, DataTypes) => {

  var ControlsConfig = sequelize.define('ControlsConfig', {

    visibility: { type: DataTypes.ENUM('hidden', 'readonly', 'editable', 'required') },

    config: { type: DataTypes.TEXT }

  });



  ControlsConfig.associate = function(models) {

    models.Control.belongsToMany(models.Step, { through: models.ControlsConfig });

    models.Step.belongsToMany(models.Control, { through: models.ControlsConfig });

    models.ControlsConfig.belongsTo(models.Template);

  };



  return ControlsConfig;

};

Insertion:

try {

    var step1 = await Step.create({ /*bla bla*/ });        

    var control1 = await Control.create({ /*bla bla*/ });    

    var OK = await control1.addStep(step1, {through: { config: 'THIS FIELD ALWAYS APPEARS NULL' }});

  } catch (error) { /* No errors*/ }

I am following the same strategy stated at the documentation

//If you want additional attributes in your join table, you can define a model for the join table in sequelize, before you define the association, and then tell sequelize that it should use that model for joining, instead of creating a new one:



const User = sequelize.define('user', {})

const Project = sequelize.define('project', {})

const UserProjects = sequelize.define('userProjects', {

    status: DataTypes.STRING

})



User.belongsToMany(Project, { through: UserProjects })

Project.belongsToMany(User, { through: UserProjects })



//To add a new project to a user and set its status, you pass extra options.through to the setter, which contains the attributes for the join table



user.addProject(project, { through: { status: 'started' }})

You have to pass edit: true to the addProject and addStep method.

See this answer it has a similar issue

Sequelize belongsToMany additional attributes in join table