From 23378b5639b0563382ac98761ae4cf2d9786453b Mon Sep 17 00:00:00 2001 From: "david.mcweeney" Date: Wed, 21 Feb 2024 09:51:29 +0000 Subject: Condense Liquibase steps Change-Id: I1493f49bb93c359df3ff7d4f928f9a94fb8b2604 Signed-off-by: david.mcweeney Issue-ID: CPS-2061 --- .../09-loadData-dmi-registry-schema-set.yaml | 210 --------------------- 1 file changed, 210 deletions(-) delete mode 100644 cps-ri/src/main/resources/changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml (limited to 'cps-ri/src/main/resources/changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml') diff --git a/cps-ri/src/main/resources/changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml b/cps-ri/src/main/resources/changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml deleted file mode 100644 index 723c2b9ecb..0000000000 --- a/cps-ri/src/main/resources/changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml +++ /dev/null @@ -1,210 +0,0 @@ -# ============LICENSE_START======================================================= -# Copyright (C) 2021-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-preload - id: 9 - loadUpdateData: - encoding: UTF-8 - file: 'changelog/db/changes/data/dmi/dataspace.csv' - onlyUpdate: 'false' - primaryKey: 'id' - quotchar: '"' - separator: '|' - tableName: 'dataspace' - rollback: - - sql: - sql: delete from dataspace where name = 'NCMP-Admin' - - - changeSet: - author: cps - label: dmi-registry-schema-preload - id: 9.1 - loadUpdateData: - encoding: UTF-8 - file: 'changelog/db/changes/data/dmi/schema_set.csv' - onlyUpdate: 'false' - primaryKey: 'id' - quotchar: '"' - separator: '|' - tableName: 'schema_set' - rollback: - - sql: - sql: delete from schema_set where name = 'ncmp-dmi-registry-model' - - - changeSet: - author: cps - label: dmi-registry-schema-preload - id: 9.2 - 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 - rollback: - - sql: - sql: delete from yang_resource where name = 'dmi-registry@2021-05-20.yang' - - - changeSet: - author: cps - label: dmi-registry-schema-preload - id: 9.3 - 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 - rollback: - - sql: - 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') - - - changeSet: - author: cps - label: dmi-registry-schema-preload - id: 9.4 - loadUpdateData: - encoding: UTF-8 - file: 'changelog/db/changes/data/dmi/anchor.csv' - onlyUpdate: 'false' - primaryKey: 'id' - quotchar: '"' - separator: '|' - tableName: 'anchor' - rollback: - - sql: - sql: delete from anchor where name = 'ncmp-dmi-registry' - - - changeSet: - author: cps - label: dmi-registry-schema-preload - id: 9.5 - 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 - rollback: - - sql: - sql: delete from yang_resource where name = 'dmi-registry@2021-10-20.yang' - - - changeSet: - author: cps - label: dmi-registry-schema-preload - id: 9.6 - 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 - rollback: - - sql: - 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') - - - changeSet: - author: cps - label: dmi-registry-schema-preload - id: 9.7 - 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 - rollback: - - sql: - sql: delete from yang_resource where name = 'dmi-registry@2021-12-13.yang' - - - changeSet: - author: cps - label: dmi-registry-schema-preload - id: 9.8 - 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 - rollback: - - sql: - 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') \ No newline at end of file -- cgit 1.2.3-korg