database-manager

This package helps with versioning the database in node.js projects. The .env.sample file has a list of all environment variables required to setup the project.

DBHOST=dbserver host
DBUSER=db user
DBPASSWORD=db password
DBNAME=db name
DBPORT=3306
DB_VERSION_SCRIPT_FOLDER=./scripts/
LOG_LEVELS=DEBUG

After you have the environment variables setup just include database-manager in your script and start versioning. The scripts folder contains a series of .sql files.

This package maintains history of executed scripts in a table inside the database and only executes scripts which have not been executed before.

require('custom-env').env(true);
require('dotenv').config();

const DatabaseManager = require('database-manager');

(async () => {
    var executor = new DatabaseManager();
    await executor.execute_scripts(true); // set false if history table already exists
})();

Project website

https://github.com/hashgit/database-manager