sequelize-replace-enum-postgres

This package provides the methods needed to replace a PostgreSQL ENUM in Sequelize migrations.

Usage no npm install needed!

<script type="module">
  import sequelizeReplaceEnumPostgres from 'https://cdn.skypack.dev/sequelize-replace-enum-postgres';
</script>

README

Replace ENUM PostgreSQL

Build Status NPM version

This package provides the methods needed to replace a PostgreSQL ENUM in Sequelize migrations.

Install

npm install --save sequelize-replace-enum-postgres

How to use

In this migration we are adding the on-demand value to the recurrenceType field of eventRecurrence:

'use strict';

const replaceEnum = require('sequelize-replace-enum-postgres').default;

module.exports = {
  up: (queryInterface, Sequelize) => {
    return replaceEnum({
      queryInterface,
      tableName: 'eventRecurrence',
      columnName: 'recurrenceType',
      defaultValue: 'weekly',
      newValues: ['weekly', 'monthly', 'yearly', 'on-demand'],
      enumName: 'enum_event_recurrence_recurrence_type'
    });
  },

  down: (queryInterface, Sequelize) => {
    return replaceEnum({
      queryInterface,
      tableName: 'eventRecurrence',
      columnName: 'recurrenceType',
      defaultValue: 'weekly',
      newValues: ['weekly', 'monthly', 'yearly'],
      enumName: 'enum_event_recurrence_recurrence_type'
    });
  }
};

Mantainers

Issues