cps-ri/src/main/resources/changelog/db/changes/10-loadData-dmi-registry-fragment.yaml

   1 databaseChangeLog:
   2   - changeSet:
   3       author: cps
   4       label: dmi-registry-schema-preload
   5       id: 10
   6       loadUpdateData:
   7         encoding: UTF-8
   8         file: 'changelog/db/changes/data/dmi/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: dmi-registry-schema-preload
  47       id: 10.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
  53