Sequelize True Migration

I am able to form your "Sql-Based Database" connected to "Sequelize" to look like "Sequelize Models" in your "Sequelize Model Schemes"

What is Migration ?

Migration is the process of moving from one to another Form of Database Since Migration is version-based process and is reversible, our auto-migration system doesn't generate a single version file and do the changing and adding automatically. so you can't call it a migration it self but auto-migration.

Using

Caution : It's still in Beta phase so don't expect a very clean output although it won't delete or overwrite on your data Yet. But in the next updates we will add some features that includes doing this. Although it will come with granting your permission by Options parameter.

Getting Started

Suppose you have a object of "Sequelize" :

1
2const options = {
3    host   : host,
4    port   : port,
5    dialect: 'mysql',
6    define : {
7        charset: 'utf8',
8        collate: 'utf8_general_ci',
9    }
10};
11
12const  sequelize = new  Sequelize(tableName, userName, password, options);
13

Add "INFORMATION_SCHEMA" Database as a "Sequelize" Object Beside it ( in current runned "SQL-Based Database System" instance ) like below:

1
2const options = {
3    host   : host,
4    port   : port,
5    dialect: 'mysql',
6    define : {
7        charset: 'utf8',
8        collate: 'utf8_general_ci',
9    }
10};
11
12const  sequelize = new  Sequelize(tableName, userName, password, options);
13const sequelizeInfo = new Sequelize('INFORMATION_SCHEMA', userName, password, options);
14

And then add "sequelize-true-migration" package and Create new Object with "new" and call "synchronize" method for Syncing model with database:

1const SequelizeTrueMigration = require('sequelize-true-migration');
2const stmObj = new SequelizeTrueMigration(name,sequelize,sequelizeInfo,database,{
3    forceTruncate:false
4})
5
6stmObj.synchronize();

Caution : For getting affected restart your project. probably like this :

In Runner Systems :

• Nodemon : On saving files
• PM2 :

1  pm2 restart %Name-Of-Your-Project%

• Pure Node :

1  Ctrl+c ( On running project )
2  node %Main-Project-File%.js

And Done. No need to Do Anything.

Development Progress

• Main Development
• Checing Tables and Create a NOT EXIST Table
• Checing Columns and Create a NOT EXIST Column in Tables
• Matching Columns and Model Definition and Fix Conflicts ( or Error On Something that needed Developer Attention)
• Deleting Undefined Columns that corresponds in Models
• Versioning Migrations and Rollback System
• Writing Tests