Simple sequelize migration retry script

migrate.js

#!/usr/bin/env node

'use strict';


const program = require('commander');
const exec = require('child_process').exec;


program
  .version('0.0.1')
  .arguments('<direction>')
  .action(function (direction) {

    if (direction === 'up') {
      execAndLog('sequelize db:migrate', 0, 5);
    }

    if (direction === 'down') {
      execAndLog('sequelize db:migrate:undo', 0, 5);
    }

  });

program.parse(process.argv);


function execAndLog(cmd, index, retries) {

  let buffer_size = 1024 * 1024 * 1; //1MB

  exec(cmd, {maxBuffer: buffer_size}, function (error, stdout, stderr) {

    if (error) {

      if (retries === 0) {
        throw error;
      }

      setTimeout(() => execAndLog(cmd, index, retries - 1), 3000);

    }

  });
}