# importingCsvFiles

State Resource

This is a State Resource as provided by the tymly-pg-plugin plugin.

# Purpose

Takes a specifically-named directory structure of CSV files and conjures bulk insert, update and delete statements and applies them to a PostgreSQL database - just a thin wrapper over Supercopy (opens new window)

# Usage

# Example

{
  "importingCsvFiles": {
    "options": {
      "headerColumnNamePkPrefix": ".",
      "topDownTableOrder": [
        "addressbase_holding"
      ]
    }
  }
}

# Options

# Optional properties

# `headerColumnNamePkPrefix`

Used to denote primary key columns when dealing with update/upsert files. Please see the options (opens new window) section in Supercopy (opens new window) for more details.

Type: string

# `topDownTableOrder`

Used to resolve foreign-key constraint issues - will be deprecated in favour of something more automatic. Please see the options (opens new window) section in Supercopy (opens new window) for more details.

Type: array

# Links

State Resource class on GitHub