Condense Liquibase steps

[cps.git] / cps-ri / src / main / resources / changelog / db / changes / 12-delete-all-previous-dmi-registry-schema-set.yaml

diff --git a/cps-ri/src/main/resources/changelog/db/changes/12-delete-all-previous-dmi-registry-schema-set.yaml b/cps-ri/src/main/resources/changelog/db/changes/12-delete-all-previous-dmi-registry-schema-set.yaml
deleted file mode 100644 (file)
index 9eda029..0000000
--- a/cps-ri/src/main/resources/changelog/db/changes/12-delete-all-previous-dmi-registry-schema-set.yaml
+++ /dev/null
@@ -1,157 +0,0 @@
-# ============LICENSE_START=======================================================
-# Copyright (C) 2022 Nordix Foundation.
-# ================================================================================
-# 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: dmi-registry-schema-delete
-      id: 12
-      sql: delete from schema_set_yang_resources
-        where schema_set_id = (select id from schema_set where name = 'ncmp-dmi-registry-model')
-        and yang_resource_id = (select id from yang_resource where name = 'dmi-registry@2021-05-20.yang')
-      rollback:
-        loadUpdateData:
-          encoding: UTF-8
-          file: 'changelog/db/changes/data/dmi/schema_set_yang_resources.csv'
-          quotchar: '"'
-          primaryKey: 'schema_set_id,yang_resource_id'
-          separator: '|'
-          tableName: 'schema_set_yang_resources'
-          usePreparedStatements: true
-
-  - changeSet:
-      author: cps
-      label: dmi-registry-schema-delete
-      id: 12.1
-      sql: delete from yang_resource where name = 'dmi-registry@2021-05-20.yang'
-      rollback:
-        loadUpdateData:
-          encoding: UTF-8
-          file: 'changelog/db/changes/data/dmi/yang_resource.csv'
-          onlyUpdate: 'false'
-          primaryKey: 'id'
-          quotchar: '"'
-          separator: '|'
-          tableName: 'yang_resource'
-          columns:
-            - column:
-                header: name
-                name: name
-                type: STRING
-            - column:
-                header: content
-                name: content
-                type: STRING
-            - column:
-                header: checksum
-                name: checksum
-                type: STRING
-        sql: update yang_resource set module_name = 'dummy_module_name', revision = '2021-08-04' where module_name is null and revision is null
-
-  - changeSet:
-      author: cps
-      label: dmi-registry-schema-delete
-      id: 12.2
-      sql: delete from schema_set_yang_resources
-        where schema_set_id = (select id from schema_set where name = 'ncmp-dmi-registry-model')
-        and yang_resource_id = (select id from yang_resource where name = 'dmi-registry@2021-10-20.yang')
-      rollback:
-        loadUpdateData:
-          encoding: UTF-8
-          file: 'changelog/db/changes/data/dmi/schema_set_yang_resources@2021-10-20.csv'
-          quotchar: '"'
-          primaryKey: 'schema_set_id,yang_resource_id'
-          separator: '|'
-          tableName: 'schema_set_yang_resources'
-          usePreparedStatements: true
-
-  - changeSet:
-      author: cps
-      label: dmi-registry-schema-delete
-      id: 12.3
-      sql: delete from yang_resource where name = 'dmi-registry@2021-10-20.yang'
-      rollback:
-        loadUpdateData:
-          encoding: UTF-8
-          file: 'changelog/db/changes/data/dmi/yang_resource@2021-10-20.csv'
-          onlyUpdate: 'false'
-          primaryKey: 'id'
-          quotchar: '"'
-          separator: '|'
-          tableName: 'yang_resource'
-          columns:
-            - column:
-                header: name
-                name: name
-                type: STRING
-            - column:
-                header: content
-                name: content
-                type: STRING
-            - column:
-                header: checksum
-                name: checksum
-                type: STRING
-        sql: update yang_resource set module_name = 'dummy_module_name', revision = '2021-08-04' where module_name is null and revision is null
-
-  - changeSet:
-      author: cps
-      label: dmi-registry-schema-delete
-      id: 12.4
-      sql: delete from schema_set_yang_resources
-        where schema_set_id = (select id from schema_set where name = 'ncmp-dmi-registry-model')
-        and yang_resource_id = (select id from yang_resource where name = 'dmi-registry@2021-12-13.yang')
-      rollback:
-        loadUpdateData:
-          encoding: UTF-8
-          file: 'changelog/db/changes/data/dmi/schema_set_yang_resources@2021-12-13.csv'
-          quotchar: '"'
-          primaryKey: 'schema_set_id,yang_resource_id'
-          separator: '|'
-          tableName: 'schema_set_yang_resources'
-          usePreparedStatements: true
-
-  - changeSet:
-      author: cps
-      label: dmi-registry-schema-delete
-      id: 12.5
-      sql: delete from yang_resource where name = 'dmi-registry@2021-12-13.yang'
-      rollback:
-        loadUpdateData:
-          encoding: UTF-8
-          file: 'changelog/db/changes/data/dmi//generated-csv/generated_yang_resource_dmi-registry@2021-12-13.csv'
-          onlyUpdate: 'false'
-          primaryKey: 'id'
-          quotchar: '"'
-          separator: '|'
-          tableName: 'yang_resource'
-          columns:
-            - column:
-                header: name
-                name: name
-                type: STRING
-            - column:
-                header: content
-                name: content
-                type: STRING
-            - column:
-                header: checksum
-                name: checksum
-                type: STRING
-        sql: update yang_resource set module_name = 'dummy_module_name', revision = '2021-08-04' where module_name is null and revision is null
-