cps-ri/src/main/resources/changelog/db/changes/05-loadData-fragment.yaml

   1 databaseChangeLog:
   2   - changeSet:
   3       author: cps
   4       label: xnf-data-preload
   5       id: 5
   6       loadUpdateData:
   7         encoding: UTF-8
   8         file: 'changelog/db/changes/data/fragment.csv'
   9         onlyUpdate: 'false'
  10         primaryKey: 'id'
  11         quotchar: '"'
  12         separator: '|'
  13         tableName: 'fragment'
  14         columns:
  15           - column:
  16               header:  id
  17               name:  id
  18               type:  NUMERIC
  19           - column:
  20               header:  xpath
  21               name:  xpath
  22               type:  STRING
  23           - column:
  24               header:  attributes
  25               name: attributes
  26               type: CLOB
  27           - column:
  28               header:  anchor_id
  29               name: anchor_id
  30               type: NUMERIC
  31           - column:
  32               header:  parent_id
  33               name: parent_id
  34               type: NUMERIC
  35           - column:
  36               header:  dataspace_id
  37               name: dataspace_id
  38               type: NUMERIC
  39           - column:
  40               header:  schema_node_id
  41               name: schema_node_id
  42               type: NUMERIC
  43
  44   - changeSet:
  45       author: cps
  46       label: xnf-data-preload
  47       id: 5.1
  48       changes:
  49         - sql:
  50             comment: Fixes the id sequence after data insert with predefined ids
  51             dbms: postgresql
  52             sql: ALTER SEQUENCE IF EXISTS fragment_id_seq RESTART WITH 200