@wmfs/pg-delta-file
Advanced tools
Outputs change-only-update CSV files (or “delta” files) that contain all the necessary actions required to re-synchronize rows in a cloned table.
Outputs change-only-update CSV files (or “delta” files) that contain all the necessary actions required to re-synchronize rows in a cloned table.
const generateDeltaFile = require('pg-delta-file')
const deltaInfo = await generateDeltaFiles(
since: '2017-07-16T20:37:26.847Z',
outputFilepath: '/some/temp/dir/people-delta.csv',
actionAliases: {
insert: 'u',
update: 'u',
delete: 'd'
},
createdColumnName: '_created',
modifiedColumnName: '_modified',
transformFunction: (row, callback) => { ... } // optional data transformation
filterFunction: (row) => { ... } // option filter predicate
dryrun: true // optional flag, set true to return info without generating output file
csvExtracts: {
'[schema.]people': [
'PERSON', // Just output a literal
'$ACTION', // Will output 'u' or 'd'
'$ROW_NUM', // Row counter
'@social_security_id', /// Column data
'@first_name',
'@last_name',
'@age'
'$DATESTAMP',
'$TIMESTAMP',
'$DATETIMESTAMP',
],
'[schema2.]address': [
...
]
}
)
/*
{
"totalCount": 5,
"people": {
"totalCount": 5
},
"address": {
"totalCount": 3
"filteredCount": 2
}
}
*/
$ npm install pg-delta-file --save
1.56.0 (2020-07-13)
FAQs
Outputs change-only-update CSV files (or “delta” files) that contain all the necessary actions required to re-synchronize rows in a cloned table.
The npm package @wmfs/pg-delta-file receives a total of 240 weekly downloads. As such, @wmfs/pg-delta-file popularity was classified as not popular.
We found that @wmfs/pg-delta-file demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 0 open source maintainers 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
Critics call the Node.js EOL CVE a misuse of the system, sparking debate over CVE standards and the growing noise in vulnerability databases.
Security News
cURL and Go security teams are publicly rejecting CVSS as flawed for assessing vulnerabilities and are calling for more accurate, context-aware approaches.
Security News
Bun 1.2 enhances its JavaScript runtime with 90% Node.js compatibility, built-in S3 and Postgres support, HTML Imports, and faster, cloud-first performance.