cps-ri/src/main/resources/changelog/db/changes/12-delete-all-previous-dmi-registry-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: 12
  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@2021-05-20.yang')
  27       rollback:
  28         loadUpdateData:
  29           encoding: UTF-8
  30           file: 'changelog/db/changes/data/dmi/schema_set_yang_resources.csv'
  31           quotchar: '"'
  32           primaryKey: 'schema_set_id,yang_resource_id'
  33           separator: '|'
  34           tableName: 'schema_set_yang_resources'
  35           usePreparedStatements: true
  36
  37   - changeSet:
  38       author: cps
  39       label: dmi-registry-schema-delete
  40       id: 12.1
  41       sql: delete from yang_resource where name = 'dmi-registry@2021-05-20.yang'
  42       rollback:
  43         loadUpdateData:
  44           encoding: UTF-8
  45           file: 'changelog/db/changes/data/dmi/yang_resource.csv'
  46           onlyUpdate: 'false'
  47           primaryKey: 'id'
  48           quotchar: '"'
  49           separator: '|'
  50           tableName: 'yang_resource'
  51           columns:
  52             - column:
  53                 header: name
  54                 name: name
  55                 type: STRING
  56             - column:
  57                 header: content
  58                 name: content
  59                 type: STRING
  60             - column:
  61                 header: checksum
  62                 name: checksum
  63                 type: STRING
  64         sql: update yang_resource set module_name = 'dummy_module_name', revision = '2021-08-04' where module_name is null and revision is null
  65
  66   - changeSet:
  67       author: cps
  68       label: dmi-registry-schema-delete
  69       id: 12.2
  70       sql: delete from schema_set_yang_resources
  71         where schema_set_id = (select id from schema_set where name = 'ncmp-dmi-registry-model')
  72         and yang_resource_id = (select id from yang_resource where name = 'dmi-registry@2021-10-20.yang')
  73       rollback:
  74         loadUpdateData:
  75           encoding: UTF-8
  76           file: 'changelog/db/changes/data/dmi/schema_set_yang_resources@2021-10-20.csv'
  77           quotchar: '"'
  78           primaryKey: 'schema_set_id,yang_resource_id'
  79           separator: '|'
  80           tableName: 'schema_set_yang_resources'
  81           usePreparedStatements: true
  82
  83   - changeSet:
  84       author: cps
  85       label: dmi-registry-schema-delete
  86       id: 12.3
  87       sql: delete from yang_resource where name = 'dmi-registry@2021-10-20.yang'
  88       rollback:
  89         loadUpdateData:
  90           encoding: UTF-8
  91           file: 'changelog/db/changes/data/dmi/yang_resource@2021-10-20.csv'
  92           onlyUpdate: 'false'
  93           primaryKey: 'id'
  94           quotchar: '"'
  95           separator: '|'
  96           tableName: 'yang_resource'
  97           columns:
  98             - column:
  99                 header: name
 100                 name: name
 101                 type: STRING
 102             - column:
 103                 header: content
 104                 name: content
 105                 type: STRING
 106             - column:
 107                 header: checksum
 108                 name: checksum
 109                 type: STRING
 110         sql: update yang_resource set module_name = 'dummy_module_name', revision = '2021-08-04' where module_name is null and revision is null
 111
 112   - changeSet:
 113       author: cps
 114       label: dmi-registry-schema-delete
 115       id: 12.4
 116       sql: delete from schema_set_yang_resources
 117         where schema_set_id = (select id from schema_set where name = 'ncmp-dmi-registry-model')
 118         and yang_resource_id = (select id from yang_resource where name = 'dmi-registry@2021-12-13.yang')
 119       rollback:
 120         loadUpdateData:
 121           encoding: UTF-8
 122           file: 'changelog/db/changes/data/dmi/schema_set_yang_resources@2021-12-13.csv'
 123           quotchar: '"'
 124           primaryKey: 'schema_set_id,yang_resource_id'
 125           separator: '|'
 126           tableName: 'schema_set_yang_resources'
 127           usePreparedStatements: true
 128
 129   - changeSet:
 130       author: cps
 131       label: dmi-registry-schema-delete
 132       id: 12.5
 133       sql: delete from yang_resource where name = 'dmi-registry@2021-12-13.yang'
 134       rollback:
 135         loadUpdateData:
 136           encoding: UTF-8
 137           file: 'changelog/db/changes/data/dmi//generated-csv/generated_yang_resource_dmi-registry@2021-12-13.csv'
 138           onlyUpdate: 'false'
 139           primaryKey: 'id'
 140           quotchar: '"'
 141           separator: '|'
 142           tableName: 'yang_resource'
 143           columns:
 144             - column:
 145                 header: name
 146                 name: name
 147                 type: STRING
 148             - column:
 149                 header: content
 150                 name: content
 151                 type: STRING
 152             - column:
 153                 header: checksum
 154                 name: checksum
 155                 type: STRING
 156         sql: update yang_resource set module_name = 'dummy_module_name', revision = '2021-08-04' where module_name is null and revision is null
 157