Nested Parenthetical Madness

    sequelize-replace-enum-postgres

    1.6.0 • Public • Published

    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

    Install

    npm i sequelize-replace-enum-postgres

    DownloadsWeekly Downloads

    9,943

    Version

    1.6.0

    License

    ISC

    Unpacked Size

    35 kB

    Total Files

    14

    Last publish

    Collaborators

    • aosorio