# exportingCsvDeltaFile
State Resource
This is a State Resource as provided by the tymly-pg-plugin plugin.
# Purpose
Outputs change-only-update CSV files (or “delta” files) that contain all the necessary actions required to re-synchronize rows in a cloned table - just a thin wrapper over pg-delta-file (opens new window)
# Usage
# Example
{
"exportingCsvDeltaFile": {
"options": {
"since": "2000-07-16T20:37:26.847Z",
"createdColumnName": "_created",
"modifiedColumnName": "_modified",
"actionAliases": {
"insert": "u",
"update": "u",
"delete": "d"
},
"tables": [
{
"tableName": "people",
"csvColumns": [
"PERSON",
"$ACTION",
"$ROW_NUM",
"@social_security_id",
"@first_name",
"@last_name",
"@age"
]
}
]
}
}
}
# Options
# Optional properties
# since
The moment-in-time (e.g. an epoch) that the exported CSV file should contain changes since.
- Type:
string - Format:
date-time(opens new window)
# actionAliases
Maps the necessary action (insert, update or delete) to a value to include in the outgoing CSV line (see the dynamic $ACTION column).
- Type:
object
# tables
An array of objects that contain a table object... which in turn define how to assemble each CSV line. Please see pg-delta-file (opens new window) for more information.
- Type:
array