NodeJs Sequelize - Update Enum column's default value

'use strict';

/** @type {import('sequelize-cli').Migration} */
module.exports = {
  async up(queryInterface, Sequelize) {
    // Create a new enum type, make sure its name isn't the same as current column's enum type
    await queryInterface.sequelize.query(`
      CREATE TYPE enum_new_size AS ENUM ('big', 'medium', 'small');
    `);

    // Add a new temp column with the enum type, setting the new default value as 'big'
    await queryInterface.addColumn('Shirts', 'sizeTemp', {
      type: 'enum_new_size',
      allowNull: false,
      defaultValue: 'big',
    });

    // Copy over the old data to new column and cast to Enum values
    await queryInterface.sequelize.query(`
      UPDATE "Shirts"
      SET "sizeTemp" = CASE
        WHEN "size" = 'small' THEN CAST('small' AS enum_new_size)
        WHEN "size" = 'medium' THEN CAST('medium' AS enum_new_size)
        WHEN "size" = 'big' THEN CAST('big' AS enum_new_size)
        ELSE CAST('big' AS enum_new_size)
      END;
    `);

    // Remove the old column
    await queryInterface.removeColumn('Shirts', 'size');

    // Rename the temporary column
    await queryInterface.renameColumn(
      'Shirts',
      'sizeTemp',
      'size',
    );
  },

  async down(queryInterface, Sequelize) {
    /**
     * Add reverting commands here.
     */
    await queryInterface.removeColumn('Shirts', 'sizeTemp');
  },
};