cps-ri/src/main/resources/changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml

   1 # ============LICENSE_START=======================================================
   2 # Copyright (C) 2021-2022 Nordix Foundation.
   3 # ================================================================================
   4 # Licensed under the Apache License, Version 2.0 (the "License");
   5 # you may not use this file except in compliance with the License.
   6 # You may obtain a copy of the License at
   7 #
   8 #       http://www.apache.org/licenses/LICENSE-2.0
   9 #
  10 # Unless required by applicable law or agreed to in writing, software
  11 # distributed under the License is distributed on an "AS IS" BASIS,
  12 # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  13 # See the License for the specific language governing permissions and
  14 # limitations under the License.
  15 #
  16 # SPDX-License-Identifier: Apache-2.0
  17 # ============LICENSE_END=========================================================
  18
  19 databaseChangeLog:
  20   - changeSet:
  21       author: cps
  22       label: dmi-registry-schema-preload
  23       id: 9
  24       loadUpdateData:
  25         encoding: UTF-8
  26         file: 'changelog/db/changes/data/dmi/dataspace.csv'
  27         onlyUpdate: 'false'
  28         primaryKey: 'id'
  29         quotchar: '"'
  30         separator: '|'
  31         tableName: 'dataspace'
  32       rollback:
  33         - sql:
  34             sql: delete from dataspace where name = 'NCMP-Admin'
  35
  36   - changeSet:
  37       author: cps
  38       label: dmi-registry-schema-preload
  39       id: 9.1
  40       loadUpdateData:
  41         encoding: UTF-8
  42         file: 'changelog/db/changes/data/dmi/schema_set.csv'
  43         onlyUpdate: 'false'
  44         primaryKey: 'id'
  45         quotchar: '"'
  46         separator: '|'
  47         tableName: 'schema_set'
  48       rollback:
  49         - sql:
  50             sql: delete from schema_set where name = 'ncmp-dmi-registry-model'
  51
  52   - changeSet:
  53       author: cps
  54       label: dmi-registry-schema-preload
  55       id: 9.2
  56       loadUpdateData:
  57         encoding: UTF-8
  58         file: 'changelog/db/changes/data/dmi/yang_resource.csv'
  59         onlyUpdate: 'false'
  60         primaryKey: 'id'
  61         quotchar: '"'
  62         separator: '|'
  63         tableName: 'yang_resource'
  64         columns:
  65           - column:
  66               header:  name
  67               name:  name
  68               type:  STRING
  69           - column:
  70               header:  content
  71               name: content
  72               type: STRING
  73           - column:
  74               header:  checksum
  75               name: checksum
  76               type: STRING
  77       rollback:
  78         - sql:
  79             sql: delete from yang_resource where name = 'dmi-registry@2021-05-20.yang'
  80
  81   - changeSet:
  82       author: cps
  83       label: dmi-registry-schema-preload
  84       id: 9.3
  85       loadUpdateData:
  86         encoding: UTF-8
  87         file: 'changelog/db/changes/data/dmi/schema_set_yang_resources.csv'
  88         quotchar: '"'
  89         primaryKey: 'schema_set_id,yang_resource_id'
  90         separator: '|'
  91         tableName: 'schema_set_yang_resources'
  92         usePreparedStatements:  true
  93       rollback:
  94         - sql:
  95             sql: >
  96               delete from schema_set_yang_resources
  97               where schema_set_id = (select id from schema_set where name = 'ncmp-dmi-registry-model')
  98               and yang_resource_id = (select id from yang_resource where name = 'dmi-registry@2021-05-20.yang')
  99
 100   - changeSet:
 101       author: cps
 102       label: dmi-registry-schema-preload
 103       id: 9.4
 104       loadUpdateData:
 105         encoding: UTF-8
 106         file: 'changelog/db/changes/data/dmi/anchor.csv'
 107         onlyUpdate: 'false'
 108         primaryKey: 'id'
 109         quotchar: '"'
 110         separator: '|'
 111         tableName: 'anchor'
 112       rollback:
 113         - sql:
 114             sql: delete from anchor where name = 'ncmp-dmi-registry'
 115
 116   - changeSet:
 117       author: cps
 118       label: dmi-registry-schema-preload
 119       id: 9.5
 120       loadUpdateData:
 121         encoding: UTF-8
 122         file: 'changelog/db/changes/data/dmi/yang_resource@2021-10-20.csv'
 123         onlyUpdate: 'false'
 124         primaryKey: 'id'
 125         quotchar: '"'
 126         separator: '|'
 127         tableName: 'yang_resource'
 128         columns:
 129           - column:
 130               header:  name
 131               name:  name
 132               type:  STRING
 133           - column:
 134               header:  content
 135               name: content
 136               type: STRING
 137           - column:
 138               header:  checksum
 139               name: checksum
 140               type: STRING
 141       rollback:
 142         - sql:
 143             sql: delete from yang_resource where name = 'dmi-registry@2021-10-20.yang'
 144
 145   - changeSet:
 146       author: cps
 147       label: dmi-registry-schema-preload
 148       id: 9.6
 149       loadUpdateData:
 150         encoding: UTF-8
 151         file: 'changelog/db/changes/data/dmi/schema_set_yang_resources@2021-10-20.csv'
 152         quotchar: '"'
 153         primaryKey: 'schema_set_id,yang_resource_id'
 154         separator: '|'
 155         tableName: 'schema_set_yang_resources'
 156         usePreparedStatements:  true
 157       rollback:
 158         - sql:
 159             sql: >
 160               delete from schema_set_yang_resources
 161               where schema_set_id = (select id from schema_set where name = 'ncmp-dmi-registry-model')
 162               and yang_resource_id = (select id from yang_resource where name = 'dmi-registry@2021-10-20.yang')
 163
 164   - changeSet:
 165       author: cps
 166       label: dmi-registry-schema-preload
 167       id: 9.7
 168       loadUpdateData:
 169         encoding: UTF-8
 170         file: 'changelog/db/changes/data/dmi//generated-csv/generated_yang_resource_dmi-registry@2021-12-13.csv'
 171         onlyUpdate: 'false'
 172         primaryKey: 'id'
 173         quotchar: '"'
 174         separator: '|'
 175         tableName: 'yang_resource'
 176         columns:
 177           - column:
 178               header:  name
 179               name:  name
 180               type:  STRING
 181           - column:
 182               header:  content
 183               name: content
 184               type: STRING
 185           - column:
 186               header:  checksum
 187               name: checksum
 188               type: STRING
 189       rollback:
 190         - sql:
 191             sql: delete from yang_resource where name = 'dmi-registry@2021-12-13.yang'
 192
 193   - changeSet:
 194       author: cps
 195       label: dmi-registry-schema-preload
 196       id: 9.8
 197       loadUpdateData:
 198         encoding: UTF-8
 199         file: 'changelog/db/changes/data/dmi/schema_set_yang_resources@2021-12-13.csv'
 200         quotchar: '"'
 201         primaryKey: 'schema_set_id,yang_resource_id'
 202         separator: '|'
 203         tableName: 'schema_set_yang_resources'
 204         usePreparedStatements:  true
 205       rollback:
 206         - sql:
 207             sql: >
 208               delete from schema_set_yang_resources
 209               where schema_set_id = (select id from schema_set where name = 'ncmp-dmi-registry-model')
 210               and yang_resource_id = (select id from yang_resource where name = 'dmi-registry@2021-12-13.yang')