Normal People, MMM!

    sequelize-auto-migrations

    1.0.3 • Public • Published

    sequelize-auto-migrations

    Migration generator && runner for sequelize

    This package provide two tools:

    • makemigration - tool for create new migrations
    • runmigration - tool for apply created by first tool migrations

    Install

    npm install sequelize-auto-migrations

    Usage

    • Init sequelize, with sequelize-cli, using sequelize init
    • Create your models
    • Create initial migration - run:

    makemigration --name <migration name>

    • Change models and run it again, model difference will be saved to the next migration

    To preview new migration, without any changes, you can run:

    makemigration --preview

    makemigration tool creates _current.json file in migrations dir, that is used to calculate difference to the next migration. Do not remove it!

    To create and then execute migration, use: makemigration --name <name> -x

    Executing migrations

    • There is simple command to perform all created migrations (from selected revision):

    runmigration

    • To select a revision, use --rev <x>
    • If migration fails, you can continue, use --pos <x>
    • To prevent execution next migrations, use --one

    For more information, use makemigration --help, runmigration --help

    TODO:

    • Migration action sorting procedure need some fixes. When many foreign keys in tables, there is a bug with action order. Now, please check it manually (--preview option)
    • Need to check (and maybe fix) field types: BLOB, RANGE, ARRAY, GEOMETRY, GEOGRAPHY
    • Downgrade is not supported, add it
    • This module tested with postgresql (I use it with my projects). Test with mysql and sqlite.

    Install

    npm i sequelize-auto-migrations

    DownloadsWeekly Downloads

    2,447

    Version

    1.0.3

    License

    MIT

    Unpacked Size

    38.6 kB

    Total Files

    8

    Last publish

    Collaborators

    • flexxnn