npm package discovery and stats viewer.

Discover Tips

  • General search

    [free text search, go nuts!]

  • Package details

    pkg:[package-name]

  • User packages

    @[username]

Sponsor

Optimize Toolset

I’ve always been into building performant and accessible sites, but lately I’ve been taking it extremely seriously. So much so that I’ve been building a tool to help me optimize and monitor the sites that I build to make sure that I’m making an attempt to offer the best experience to those who visit them. If you’re into performant, accessible and SEO friendly sites, you might like it too! You can check it out at Optimize Toolset.

About

Hi, 👋, I’m Ryan Hefner  and I built this site for me, and you! The goal of this site was to provide an easy way for me to check the stats on my npm packages, both for prioritizing issues and updates, and to give me a little kick in the pants to keep up on stuff.

As I was building it, I realized that I was actually using the tool to build the tool, and figured I might as well put this out there and hopefully others will find it to be a fast and useful way to search and browse npm packages as I have.

If you’re interested in other things I’m working on, follow me on Twitter or check out the open source projects I’ve been publishing on GitHub.

I am also working on a Twitter bot for this site to tweet the most popular, newest, random packages from npm. Please follow that account now and it will start sending out packages soon–ish.

Open Software & Tools

This site wouldn’t be possible without the immense generosity and tireless efforts from the people who make contributions to the world and share their work via open source initiatives. Thank you 🙏

© 2024 – Pkg Stats / Ryan Hefner

migy

v0.1.5

Published

Easy migration tool for databases

Downloads

2

Readme

Why migy?

There are many options to handle migrations of your MySQL, Postgres or SQLite databases, but migy offers cool features to make this process easier:

  • May work as a part of your application or standalone.
  • Works with popular databases modules and can be extended to work with any module you want.
  • Migrations stored in *.sql files. You will have full IDE features like syntax highlighting when edit migrations.
  • Rollback migrations stored in same file with up migration.
  • Supports any count of separate queries in one migration.
  • Stores migrations info in migration table, so you can restore migration files from database if needed. Also the hash of every applied migration will be checked, so when you have a different set of migrations files, database migration will be aborted.

Getting started

Standalone

Create a file named like migrator.js where you want.

const migy = require('migy');

// Import one of supported modules
const mysql = require('mysql2'); 

// Create a connection as described in module's docs
const conn = mysql.createConnection({
            host: 'localhost',  
            user: 'user', 
            password: 'example', 
            database: 'things'
});

migy.cli({
    db: conn, //Connection to db
    adapter: 'mysql2', //Specify what module to use
    dir: 'migrations' //Directory where stored migration files
});

Now run this file with Node as a common CLI application.

node migrator.js --help

As a part of your application

Add migy initialization somewhere in your app. Usually in its startup routine. Be sure that you already have existing database connection handeled by one of supported modules.

const migy = require('migy');

...

const migrator = await migy.init({
    db: conn, //Existing connection to db
    adapter: 'postgres', //Specify what module to use
    dir: 'db/migrations' //Directory where stored migration files
});

await migrator.migrate(); // Update database to the latest version

Migrations syntax

Migrations stored in *.sql files in specified directory. Every file's name must starts with digits, which will be treated as migration version. For example:

migrations
  ├─ 1.sql
  ...
  └─ 42.sql

Also you can add some additional text or leading zeros:

migrations
  ├─ 01-create_table.sql
  ...
  └─ 42_add_seed.sql

Each file must content at least one SQL-query which will be run on migration to this version.

CREATE TABLE things (id INT,thing TEXT);

When you need run several queries in one migration separate them with ### on blank line:

CREATE TABLE things (id INT,thing TEXT);
###
INSERT INTO things (id,thing) VALUES (1,'apple');

Also you can add rollback queries using ### ROLLBACK or ### DOWN separator on blank line. These queries will be ran in case of lowering database version.

CREATE TABLE things (id INT,thing TEXT);
###
INSERT INTO things (id,thing) VALUES (1,'apple');

### DOWN

DROP TABLE things;

Finally, you may use comments in your files.

/* Create a table for things */
CREATE TABLE things (id INT,thing TEXT);

### DOWN

/* Delete table of things */
DROP TABLE things;

API

migy.init({db,adapter,dir,store})

Initializing the migy instance

  • db: database established connection
  • adapter: name of adapter of supported module, or custom adapter function.
  • dir: directory with migrations files. Default: migrations
  • store: string specified migration store in DB(table name in most cases). Default: _migrations

migy.cli({db,adapter,dir,store})

Run migy as standalone CLI application. Parameters are same as for migi.init function.


The migy.init asynchronus function returns an object with methods:

migrate() Run migration process. Checks already applied migration. Validate them with current migrations files. Run queries one by one to reach latest database version.

rollback(version) Run rollback process. Checks already applied migration. Validate them with current migrations files. Run rollback queries from migration files to reach specified version of database. In case when some files between versions haven't rollback queries, process will be aborted(without any changes).

  • version: integer specifing version to rollback. If you ommit it, all rollback queries will be ran to reach database state before any migrations.

restore({dir}) Extract all applied migrations from database and save them in specified directory.

  • dir: the directory where migrations files will be saved. Default: restored_migrations

Custom adapter

There are a couple of builtin adapters for most popular modules like sqlite3,mysql,mysql2 and pg. But you can create your own adapter for any database module you want.

Adapter is a function which returns object of methods - up,down,init,list and get. Every method is required and will be used by migy during migrations processes.

module.exports = async function(options){
    
    /* 
       - options.db - DB connection object or similar
       - options.store - string specifing store of migrations(like table name)
    */

    return {
        up: async ({version,queries,md5,data}) => {
            /* 
                version - migration version
                queries - array of SQL queries
                md5 - hash of migration 
                data - packed migration file (may be long)
            */

           // Run all queries here to migrate DB up
           // Also save version,md5 and data in your store (table)
        },

        
        down: async ({version,queries}) => {
            /* 
                version - migration version
                queries - array of SQL queries
            */

           // Run all queries here to migrate DB down
           // Also delete entry with version=version from your store (table)
        },

      
        init: async ()=>{
           // Any preparation before migration
           // Create your store(table) here 
        },


        list: async ()=>{
            // return an array of all migration here
            // Note: don't return data field here
            // [{version,md5},...]
        },


        get: async (version) => {
            /* 
                version - needed migration version
            */
            // return an object of needed migration here
            // {version,md5,data}
        }
    }
}

Then you can use it with migy:

const migy = require('migy');
const myAdapter = require('./my_adapter.js');
const anyDB = require('anydb-module');

const conn = anyDB.createConnection(...);

const migrator = await migy.init({
    db: conn,
    adapter: myAdapter
});