Sequelize migration - defining an empty JSON array

Question

In my MySQL database i have a JSON column that i created using the following sequelize-cli migration:

queryInterface.addColumn(
          'Users',
          'favorites',
          {
              type: Sequelize.JSON,
              allowNull: false,
              defaultValue: []
  }
      );

However, instead of having a default value of [], the records are getting a default value of null for that column.

What am i doing wrong?

score 1 · Answer 1 · answered Apr 27 '21 at 20:39

In MySQL - you cant have default value for JSON field in case of strict mode.

Here you can get some explanation and solution to resolve this issue: Why can't a text column have a default value in MySQL?

Then you can use your code without any modification.

Sequelize migration - defining an empty JSON array

1 Answers1