Sequelize constraint on delete

Question

I would like to add a constraint inside my migration file, for example when I try and delete a row and there's another row inside another table that's referencing the row i'm deleting it needs to throw an error. There will also be multiple tables that will associate with the table.

return queryInterface.createTable('status', {
  id: {
    allowNull: false,
    autoIncrement: true,
    primaryKey: true,
    type: Sequelize.INTEGER
  },
  name: {
    type: Sequelize.STRING,
    unique: true
  },
  slug: {
    type: Sequelize.STRING,
    unique: true
  },
  createdAt: {
    allowNull: false,
    type: Sequelize.DATE
  },
  updatedAt: {
    allowNull: false,
    type: Sequelize.DATE
  },
});

table status: ... id

table locales: ... id_status

table users ... id_status

@tadman any examples? I see there's hasMany, belongs to relations do I need to use those or something else? — user990717, Mar 26 '19 at 00:44
Worth a quick trip to [the documentation](http://docs.sequelizejs.com/manual/associations.html). — tadman, Mar 26 '19 at 01:08

score 0 · Answer 1 · answered Mar 26 '19 at 01:20

0

  id_status: {
    type: Sequelize.INTEGER,
    references: {
      model: 'status',
      key: 'id',
      onDelete: 'restrict'    
    }
  },

answered Mar 26 '19 at 01:20

user990717

470
9
18

score 0 · Answer 2 · answered Mar 26 '19 at 02:44

0

 id_status: {
    type: Sequelize.INTEGER,
    references: {
      model: 'status',
      key: 'id',
    },
onDelete: 'restrict'    
  },

answered Mar 26 '19 at 02:44

margherita pizza

6,623
23
84
152

Sequelize constraint on delete

2 Answers2