summaryrefslogtreecommitdiffstats
path: root/cps-ri/src/main/resources/changelog/db/changes/05-loadData-fragment.yaml
blob: bd95a00e37222d7ed12860017176eb59c473df2b (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
#  ============LICENSE_START=======================================================
#  Copyright (C) 2021-2022 Nordix Foundation
#  Modifications Copyright (C) 2021 Pantheon.tech
#  ================================================================================
#  Licensed under the Apache License, Version 2.0 (the "License");
#  you may not use this file except in compliance with the License.
#  You may obtain a copy of the License at
#
#        http://www.apache.org/licenses/LICENSE-2.0
#
#  Unless required by applicable law or agreed to in writing, software
#  distributed under the License is distributed on an "AS IS" BASIS,
#  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
#  See the License for the specific language governing permissions and
#  limitations under the License.
#
#  SPDX-License-Identifier: Apache-2.0
#  ============LICENSE_END=========================================================

databaseChangeLog:
  - changeSet:
      author: cps
      label: xnf-data-preload
      id: 5
      loadUpdateData:
        encoding: UTF-8
        file: 'changelog/db/changes/data/fragment.csv'
        onlyUpdate: 'false'
        primaryKey: 'id'
        quotchar: '"'
        separator: '|'
        tableName: 'fragment'
        columns:
          - column:
              header:  id
              name:  id
              type:  NUMERIC
          - column:
              header:  xpath
              name:  xpath
              type:  STRING
          - column:
              header:  attributes
              name: attributes
              type: CLOB
          - column:
              header:  anchor_id
              name: anchor_id
              type: NUMERIC
          - column:
              header:  parent_id
              name: parent_id
              type: NUMERIC
          - column:
              header:  dataspace_id
              name: dataspace_id
              type: NUMERIC
          - column:
              header:  schema_node_id
              name: schema_node_id
              type: NUMERIC

  - changeSet:
      author: cps
      label: xnf-data-preload
      id: 5.1
      changes:
        - sql:
            comment: Fixes the id sequence after data insert with predefined ids
            dbms: postgresql
            sql: ALTER SEQUENCE IF EXISTS fragment_id_seq RESTART WITH 200

  - changeSet:
      author: cps
      label: dmi-registry-schema-preload
      id: 5.2
      changes:
        - sql:
            comment: Sets sequence value to current max value of the ID from the fragment table
            dbms: postgresql
            sql: SELECT setval('fragment_id_seq', (SELECT MAX(ID) FROM fragment))
      rollback:
        sql: SELECT setval('fragment_id_seq', 200)
        comment: Rollback Sequence to restart with the sequence number in the last changeset