Sequelize migrations generator && runner
npm install @crystaldelta/sequelize-auto-migrationsFork of https://github.com/Scimonster/sequelize-auto-migrations
This package provide two tools:
* makemigration - tool for create new migrations
* runmigration - tool for apply created by first tool migrations
npm install @crystaldelta/sequelize-auto-migrationssequelize initmakemigration --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
runmigration
* To select a revision, use --rev
* To prevent execution of next migrations, use --one
* To rollback/downgrade to the selected revision, use --rollback
Each migration runs in a transaction, so it will be rolled back if part of it fails. To disable, use --no-transaction. Then, if it fails, you can continue by using --pos .
For more information, use makemigration --help, runmigration --help
--preview option)BLOB, RANGE, ARRAY, GEOMETRY, GEOGRAPHY