query result to csv

csv.js

const fs = require('fs-extra')

function csv (result, file) {
  const _content = []
  let _header = false
  for (const row of result) {
    const _line = []
    for (const field in row) {
      if (!_header) {
        _line.push('"' + field + '"')
      }
      _line.push(row[field])
    }
    _header = true
    _content.push('"' + _line
      .map(s => s.replace('"', '\\"'))
      .join('","') + '"')
  }
  fs.writeFile(file, _content.join('\n'), (err) => {
    if (err) {
      console.error(err)
      return
    }
    console.log('write file', file)
  })
}