Postgresql database migration management

! pg-migrate-demo

# https://github.com/salsita/node-pg-migrate
npm install node-pg-migrate

config default.json

{
  "db": "postgres://meteor:meteor@localhost:5432/meteor"
}

migrations 1508891013718_players_table.js

exports.up = (pgm, run) => {
  pgm.createTable({name: 'players'},
    {
      id: {type: 'serial', notNull: true},
      name: {type: 'varchar(50)', unique: true},
      score: {type: 'integer', notNull: true}
    },
    {
      ifNotExists: true,
      constraints: {primaryKey: 'id'}
    });
  run();
};

exports.down = (pgm, run) => {
  pgm.dropTable('players', { ifExists: true, cascade: true });
  run();
};

migrations 1508891013719_players_data.js

exports.up = (pgm, run) => {
  pgm.sql('INSERT INTO players (name, score) VALUES (\'Kepler\', 40),(\'Leibniz\',50),(\'Maxwell\',60),(\'Planck\',70);');
  run();
};

exports.down = (pgm, run) => {
  pgm.sql('DELETE FROM players;');
  run();
};