Export test to CSV files.

export2csv.js

#!/usr/bin/env node 

const fs = require('fs');
const csvLine = require('csv-line');

const readFile = function(file) {
  return new Promise(function(resolve, reject) {
    fs.readFile(file, 'utf8', function(err, data) {
      err ? reject(err) : resolve(JSON.parse(data));
    });
  });
};

const concat = function(items, attachments = {}) {
  const output = items.map(function(item) {
    switch (item.type) {
      case 'text':
        return item.data;

      case 'textList':
        return item.data.join(' '); 

      case 'attachment':
        return concat([attachments[item.data]], attachments);
    }
  });

  return output.join(' ');
};

const getQuestions = function(test) {
  const attachments = test.attachments;

  return test.questions.map(function(question, id) {
    return {
      id: id,
      question: concat(question.question, attachments), 
      explanation: concat(question.explanation, attachments),
      answer: question.answers.reduce(function(output, answer) {
        return answer.correct ? answer.value : output; 
      }, '')
    };
  });
};

const printQuestions = function(questions) {
  const header = Object.keys(questions[0]);
  const items = [];

  console.log(csvLine.encode(header));

  for (question of questions) {
    let item = header.map(function(key) {
      return question[key];
    });

    console.log(csvLine.encode(item));
  }
};

readFile(process.argv[2]).then(function(test) {
  const questions = getQuestions(test);

  printQuestions(questions);
});