Simple-Mysql-Migrate

Dead simple database migration for SQL only

The principle is similar to Flyway and all similar tools, except it's VERY basic and runs in a few lines of code for NodeJS. MySQL only.

Javascript:
``javascript
const DbMigrate = require('simple-mysql-migrate').default;

const migration = new DbMigrate({
host: "127.0.0.1",
port: 3306,
username: "my_user",
password: "my_password",
database: "my_database_name"
});

migration.setMigrationPath("/path/to/my/migration/files/");
migration.migrate();
`

Typescript:
`javascript
import DbMigrate from 'simple-mysql-migrate';

// These are the default settings if none are used
const migration = new DbMigrate ({
"host": "127.0.0.1",
"port": 3306,
"username": "my_user",
"password": "my_password",
"database": "my_database_name"
});

migration.setMigrationPath("/path/to/my/migration/files/");
await migration.migrate();
`

It is dead simple: it will scan through the .sql files and run them in order.

A schema_version table will be created to keep track of what has already been ran.

The filenames should be called v[any version]__[any string].sql, for example: v1.2.5__new_user_table.sql`