How to generate migrations automatically from Sequelize models

Question

I just started to program with node.js. I needed an ORM so I used Sequelize library. I wrote my User model as follows and I need to create a migration for it. Is there any way to create migrations automatically from the Sequelize models instead of writing them on my own? I tried package sequelize-auto-migrations and run npx makemigration --name create_users but it returns error:

Unexpected token {

I'm using node v10.19.3

This is my Sequelize model:

const Model = require('sequelize');

module.exports = (sequelize, DataTypes) => {
  class User extends Model {
    getFullname() {
      return [ this.firstname, this.lastname ].join(' ');
    }
  }
  User.init({
    firstName: { type: DataTypes.STRING, allowNull: false },
    lastName: { type: DataTypes.STRING, allowNull: false },
    email: { type: DataTypes.STRING, allowNull: false, unique: true },
    national_number: { type: DataTypes.STRING, unique: true },
    phone_number: { type: DataTypes.STRING, allowNull: false, unique: true },
    username: { type: DataTypes.STRING, allowNull: false, unique: true },
    join_date: { type: DataTypes.DATEONLY, defaultValue: sequelize.NOW },
    last_login: { type: DataTypes.DATE },
    password: { type: DataTypes.STRING, allowNull: false },
    active: { type: DataTypes.BOOLEAN, allowNull: false, defaultValue: true }
  }, {
    sequelize,
    modelName: 'User',
  });
  return User;
};

billobeng · Accepted Answer · 2020-12-06 07:23:01Z

0

You might want to try sequelize-cli instead. To run migrations you have to run this command npx sequelize-cli model:generate This link on sequelize.com should help https://sequelize.org/master/manual/migrations.html

edited Dec 6, 2020 at 7:23

answered Dec 6, 2020 at 4:21

billobeng

1666 bronze badges

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

4 Comments

mohammad hosein moti Over a year ago

I have seen that URL but that is for running migrations not creating. I need to create them automatically. Now I have to create them manually every time I make changes to my models

billobeng Over a year ago

in the link it says you can create migrations using this sequelize-cli model:generate --name

Aum Trivedi Over a year ago

stackoverflow.com/questions/27835801/… this link will help you.

MadaShindeInai Over a year ago

there is no way to automatically generate initial migrations from existing models in sequelize-cli. Looks like author of the answer not even checked info he suggests to use

Collectives™ on Stack Overflow

How to generate migrations automatically from Sequelize models

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related