sql-temp-gen-hack.js

/**
 * Quick hack to generate migration template into a file
 * @author David
 * @param {*} files
 * @returns {string} SQL template
 */
const SqlTempGenerator = files => {
  if (!Array.isArray(files)) throw "Must be an array of SQL files";
  let sqlStr = "INSERT INTO migrations (filename) VALUES";
  return sqlStr.concat(" ", files.map(file => `('${file}')`).join(","), ";");
};

// from fs.readdir()
const upFiles = [
  "/20200610015707-tbl1",
  "/20200618082927-tbl2",
];

const INSERT_TEMPLATE = SqlTempGenerator(upFiles);

fs.writeFile('migrations.sql', INSERT_TEMPLATE, err => ...)