Parse a JSON file and output a SQL script with Node.js.

parse.js

var fs = require('fs');

var data = fs.readFileSync(process.argv[2], {
  encoding: 'ascii'
});
var json = JSON.parse(data);

for (var list in json) {
  var devices = json[list];
  for (var i = 0; i < devices.length; i++) {
    var device = devices[i];
    if (device["uid"])
      console.log("UPDATE panel.device SET hardware_id = '" + device["devid"] + "' WHERE uid = '" + device["uid"] + "' AND project = 4;");
  }
}