knex-postgres-transactional-upsert
Advanced tools
Transactionally upsert data into a postgres db using knex
Make it into an electrolyte component like so:
var getUpserters = require('knex-postgres-transactional-upsert');
module.exports = (knex) => getUpserters(knex, {batchSize: 500});
module.exports['@singleton'] = true;
module.exports['@require'] = ['knex'];
Then use it like so:
// Upsert a single row without a transaction
upsert.upsert('tablename', id, data);
// Upsert many rows transactionally
upsert.transactionalUpsert('tablename', rows, fieldToTypeMap, primaryKey);
FAQs
Transactionally upsert data into a postgres db using knex
The npm package knex-postgres-transactional-upsert receives a total of 58 weekly downloads. As such, knex-postgres-transactional-upsert popularity was classified as not popular.
We found that knex-postgres-transactional-upsert demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Research
A malicious npm package disguised as a WhatsApp client is exploiting authentication flows with a remote kill switch to exfiltrate data and destroy files.
Security News
PyPI now supports digital attestations, enhancing security and trust by allowing package maintainers to verify the authenticity of Python packages.
Security News
GitHub removed 27 malicious pull requests attempting to inject harmful code across multiple open source repositories, in another round of low-effort attacks.