index.js

const config = require("../config.json"),
      request = require('request'),
      async = require('async'),
      fs = require('fs'),
      utils = require('../lib/utils'),
      activespecs = require('../lib/active-specs'),
      w3c = require('node-w3capi');

const selectedgroups = process.argv[2] ? process.argv[2].split(",").map(n => parseInt(n,10)) : false;
const restrictGroups = g => !selectedgroups || selectedgroups.includes(g.id);
let existingdata;
if (selectedgroups) {
    var data = fs.readFileSync("./groups.json");
    existingdata = JSON.parse(data);
}

const jsonify = o => JSON.stringify(o, null, 2);

w3c.groups().fetch({embed:true}, (err, groups) => {
    if (err) return console.error(err);
    const workinggroups = groups.filter(g => g.type === 'working group') ;
    async.map(workinggroups, (wg,cb) => {
        activespecs(wg.id, (err, unfinishedSpecs) => {
            if (!unfinishedSpecs) return console.error("undefined result for " + wg.name);
            if (err) console.error(err);
            createOrUpdateSpreadSheet(wg, unfinishedSpecs.map(s=> s.shortlink), cb, restrictGroups(wg));
        });
    }, (err, results) => {
        if (err) return console.error(err);
        const groups = results.filter(g => g).reduce((a,b) => { a[b.id] = b; return a;}, {});
        fs.writeFileSync("./groups.json", jsonify(groups, null, 2));
    });
});


function createOrUpdateSpreadSheet(wg, specs, cb, create) {
    if (create) {
        const body = "TR shortlink,FPWD,Wide Review start, CR, Test Suite status, PR, Rec, Comments & notes\n" + specs.join("\n");
        request({
            method: 'POST',
            url: config.ethercalc + '/_',
            headers: {
                'Content-Type': 'text/csv'
            },
            body: body
        }, function (error, response, body) {
            cb(null, {id: wg.id, name: wg.name, start: wg["start-date"], end: wg["end-date"], url: config.ethercalc + body});
        });
    } else {
        if (!existingdata[wg.id]) throw new Error("Working Group " + wg.name + "(" + wg.id + ") is missing in the list");
        cb(null, {id: wg.id, name: wg.name, start: wg["start-date"], end: wg["end-date"], url: existingdata[wg.id].url});
    }
}