Migration to add apiKey field

20210108030637-add_apiKey_to_providers.js

"use strict";

module.exports = {
  up: async (queryInterface, Sequelize) => {
    /**
     * Add altering commands here.
     *
     * Example:
     * await queryInterface.createTable('users', { id: Sequelize.INTEGER });
     */
    return queryInterface.sequelize.transaction((t) => {
      return Promise.all([
        queryInterface.addColumn("providers", "apiKey", {
          allowNull: true,
          type: Sequelize.STRING(50),
        }),
      ]);
    });
  },

  down: async (queryInterface, Sequelize) => {
    /**
     * Add reverting commands here.
     *
     * Example:
     * await queryInterface.dropTable('users');
     */
    return queryInterface.sequelize.transaction((t) => {
      return Promise.all([
        queryInterface.removeColumn("providers", "apiKey", { transaction: t }),
      ]);
    });
  },
};

Explanation.md

Ran npx sequelize-cli db:migrate to migrate.

provider.js

"use strict";

const { Model } = require("sequelize");

module.exports = (sequelize, DataTypes) => {
  class provider extends Model {
    /**
     * Helper method for defining associations.
     * This method is not a part of Sequelize lifecycle.
     * The `models/index` file will call this method automatically.
     */
    static associate(models) {
      // define association here
    }
  }
  provider.init(
    {
      name: {
        allowNull: false,
        type: DataTypes.STRING(50),
      },
      url: {
        allowNull: true,
        type: DataTypes.STRING,
      },
      image: {
        allowNull: true,
        type: DataTypes.STRING,
      },
      isVerified: {
        type: DataTypes.BOOLEAN,
        defaultValue: true,
        allowNull: false,
      },
      apiKey: {
        type: DataTypes.STRING(50),
        allowNull: true,
      },
    },
    {
      sequelize,
      modelName: "provider",
    }
  );

  return provider;
};