Count lines by file extension and path and output csv ready to be sql-analyzed

line_counter.js

/* eslint-env node */
const fs = require(`fs`);
const path = require(`path`);

const filePaths = fs.readFileSync(`${__dirname}/file_list.txt`, `utf-8`).trim().split(`\n`);
console.log(`Total files`, filePaths.length);

for (let i = 0, len = filePaths.length; i < len; ++i) {
  const filePath = filePaths[i];
  let lines = null;
  try {
    lines = fs.readFileSync(filePath, `utf-8`).split(`\n`).filter(l => /\w/.test(l));
  } catch (e) {}

  if (lines) {
    console.log(`${filePath}, ${path.extname(filePath)}, ${lines.length}`);
  }
}