How to create a Sequelize cli db migration after changes to the model

Question

I am starting with sequelize and was following their video tutorial online. After running

node_modules/.bin/sequelize model:create --name User --attributes username:string

node_modules/.bin/sequelize model:create --name Task --attributes title:string

which created the migration files for create user and create task. Then I had to add the associations to each model as follow:

// user.js
classMethods: {
  associate: function(models) {
    User.hasMany(models.Task);
  }
}

// task.js
classMethods: {
  associate: function(models) {
    Task.belongsTo(models.User);
  }
}

However, the migration files for creating the tables for user and task are already created. Do i have to manually update them to add the relationships? "migration:create" command creates the migration skeleton file. Do I manually fill out the skeleton files or is there a way to automatically create the complete migration file besides model creation?

P.S i have seen the following stackoverflow question: How to auto generate migrations with Sequelize CLI from Sequelize models?

Johnston · Accepted Answer · 2016-10-22 13:57:54Z

12

You can create a separate migration from an empty migration file. I did that when I needed to add a few extra columns to a table.

sequelize migration:create --name users

Then in my new migration file.

module.exports = {
  up: function (queryInterface, Sequelize) {
    queryInterface.addColumn(
      'Users',
      'url',
      Sequelize.STRING
    );
  },

  down: function (queryInterface, Sequelize) {
    queryInterface.removeColumn(
      'Users',
      'url',
      Sequelize.STRING
    );
  }
};

Then just run the migrations.

sequelize db:migrate

answered Oct 22, 2016 at 13:57

Johnston

21.1k22 gold badges77 silver badges124 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

MRVMV · Accepted Answer · 2020-09-22 17:17:01Z

0

Try this new npm package

Sequelize-mig

Install:

npm install sequelize-mig -g / yarn global add sequelize-mig

then use it like this

sequelize-mig migration:make -n <migration name>

and it will auto generate the migration file for you with all updates

answered Sep 22, 2020 at 17:17

MRVMV

1921 silver badge8 bronze badges

Collectives™ on Stack Overflow

How to create a Sequelize cli db migration after changes to the model

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related