pg-helper.js

module.exports = {
  generateMultipleInsertValues(data) {
    return data.reduce((result, nextData, index) => {
      result = result + Object.keys(nextData).reduce((values, key, keyIndex, allKeys) => {
        if (keyIndex === 0) {
          if (typeof nextData[key] === 'string') {
            return values + `('${nextData[key]}', `
          } else {
            return values + `(${nextData[key]}, `
          }
        }
        if (typeof nextData[key] === 'string') {
          values = values + `'${nextData[key]}'`
        } else {
          values = values + `${nextData[key]}`
        }
        if (keyIndex !== allKeys.length - 1) {
          values = values + `, `
        }
        return values
      }, '')
      if (index === data.length - 1) {
        return `${result})`
      } else {
        return `${result}), `
      }
    }, '')
  }
}