Knex Postgress ON CONFLICT (ON DUPLICATE KEY) insert

insertOrUpdate.js

// Inspired by https://github.com/knex/knex/issues/701#issuecomment-314818463
// Will converts also CamelCase fields to SnakeCase
const knex = require('./pgAdaptor');

const camelToSnakeCase = str => str.replace(/[A-Z]/g, letter => `_${letter.toLowerCase()}`);

function insertOrUpdate(tableName, data, conflictKey) {
  const updateTxt = Object.getOwnPropertyNames(data)
    .filter(f => f !== conflictKey)
    .map(field => `${camelToSnakeCase(field)}=:${field}`).join(', ');
  return knex.raw(`
    ${knex(tableName).insert(data).toQuery()}
    ON CONFLICT (${conflictKey}) DO UPDATE
    SET
      ${updateTxt}
  `, data);
}

module.exports = insertOrUpdate;