cps-ri/src/main/resources/changelog/db/changes/14-loadData-dmi-registry-2022-05-10-schema-set.yaml

   1 # ============LICENSE_START=======================================================
   2 # Copyright (C) 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-delete
  23       id: 14
  24       sql: DELETE FROM schema_set_yang_resources
  25         where schema_set_id = (select id from schema_set where name = 'ncmp-dmi-registry-model')
  26         and yang_resource_id = (select id from yang_resource where name = 'dmi-registry@2022-02-10.yang')
  27       rollback:
  28         sql: INSERT INTO schema_set_yang_resources (schema_set_id, yang_resource_id)
  29           VALUES ((select id from schema_set where name = 'ncmp-dmi-registry-model'), (select id from yang_resource where name = 'dmi-registry@2022-02-10.yang'));
  30
  31   - changeSet:
  32       author: cps
  33       label: dmi-registry-schema-delete
  34       id: 14.1
  35       sql: DELETE FROM yang_resource where name = 'dmi-registry@2022-02-10.yang'
  36       rollback:
  37         loadUpdateData:
  38           encoding: UTF-8
  39           file: 'changelog/db/changes/data/dmi//generated-csv/generated_yang_resource_dmi-registry@2022-02-10.csv'
  40           onlyUpdate: 'false'
  41           primaryKey: 'id'
  42           quotchar: '"'
  43           separator: '|'
  44           tableName: 'yang_resource'
  45           columns:
  46             - column:
  47                 header: name
  48                 name: name
  49                 type: STRING
  50             - column:
  51                 header: content
  52                 name: content
  53                 type: STRING
  54             - column:
  55                 header: checksum
  56                 name: checksum
  57                 type: STRING
  58             - column:
  59                 header: module_name
  60                 name: module_name
  61                 type: STRING
  62             - column:
  63                 header: revision
  64                 name: revision
  65                 type: STRING
  66
  67   - changeSet:
  68       author: cps
  69       label: dmi-registry-schema-load-revision-2022-05-10
  70       id: 14.2
  71       loadUpdateData:
  72         encoding: UTF-8
  73         file: 'changelog/db/changes/data/dmi/generated-csv/generated_yang_resource_dmi-registry@2022-05-10.csv'
  74         onlyUpdate: 'false'
  75         primaryKey: 'id'
  76         quotchar: '"'
  77         separator: '|'
  78         tableName: 'yang_resource'
  79         columns:
  80           - column:
  81               header: name
  82               name: name
  83               type: STRING
  84           - column:
  85               header: content
  86               name: content
  87               type: STRING
  88           - column:
  89               header: checksum
  90               name: checksum
  91               type: STRING
  92           - column:
  93               header: module_name
  94               name: module_name
  95               type: STRING
  96           - column:
  97               header: revision
  98               name: revision
  99               type: STRING
 100       rollback:
 101         - sql:
 102             sql: DELETE FROM yang_resource where name = 'dmi-registry@2022-05-10.yang'
 103
 104   - changeSet:
 105       author: cps
 106       label: dmi-registry-schema-load-revision-2022-05-10
 107       id: 14.3
 108       sql: INSERT INTO schema_set_yang_resources (schema_set_id, yang_resource_id)
 109         VALUES ((select id from schema_set where name = 'ncmp-dmi-registry-model'), (select id from yang_resource where name = 'dmi-registry@2022-05-10.yang'));
 110       rollback:
 111         sql: DELETE FROM schema_set_yang_resources
 112           where schema_set_id = (select id from schema_set where name = 'ncmp-dmi-registry-model')
 113           and yang_resource_id = (select id from yang_resource where name = 'dmi-registry@2022-05-10.yang')