aboutsummaryrefslogtreecommitdiffstats
path: root/cps-ri/src/main/resources/changelog/db/changes/13-insert-dmi-registry-2022-02-10-schema-set.yaml
diff options
context:
space:
mode:
authordavid.mcweeney <david.mcweeney@est.tech>2024-02-21 09:51:29 +0000
committerDavid <david.mcweeney@est.tech>2024-03-26 15:22:21 +0000
commit23378b5639b0563382ac98761ae4cf2d9786453b (patch)
tree3bcb9ec503e28b7b2741dee23d3c0d5aa7f9cf19 /cps-ri/src/main/resources/changelog/db/changes/13-insert-dmi-registry-2022-02-10-schema-set.yaml
parente1277ab49cfbd8fd980336b1f2b84bca3166a449 (diff)
Condense Liquibase steps
Change-Id: I1493f49bb93c359df3ff7d4f928f9a94fb8b2604 Signed-off-by: david.mcweeney <david.mcweeney@est.tech> Issue-ID: CPS-2061
Diffstat (limited to 'cps-ri/src/main/resources/changelog/db/changes/13-insert-dmi-registry-2022-02-10-schema-set.yaml')
-rw-r--r--cps-ri/src/main/resources/changelog/db/changes/13-insert-dmi-registry-2022-02-10-schema-set.yaml66
1 files changed, 0 insertions, 66 deletions
diff --git a/cps-ri/src/main/resources/changelog/db/changes/13-insert-dmi-registry-2022-02-10-schema-set.yaml b/cps-ri/src/main/resources/changelog/db/changes/13-insert-dmi-registry-2022-02-10-schema-set.yaml
deleted file mode 100644
index 3351b5419..000000000
--- a/cps-ri/src/main/resources/changelog/db/changes/13-insert-dmi-registry-2022-02-10-schema-set.yaml
+++ /dev/null
@@ -1,66 +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-load-revision-2022-02-10
- id: 13
- loadUpdateData:
- encoding: UTF-8
- file: 'changelog/db/changes/data/dmi/generated-csv/generated_yang_resource_dmi-registry@2022-02-10.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
- - column:
- header: module_name
- name: module_name
- type: STRING
- - column:
- header: revision
- name: revision
- type: STRING
- rollback:
- - sql:
- sql: delete from yang_resource where name = 'dmi-registry@2022-02-10.yang'
-
- - changeSet:
- author: cps
- label: dmi-registry-schema-load-revision-2022-02-10
- id: 13.1
- sql: INSERT INTO schema_set_yang_resources (schema_set_id, yang_resource_id)
- 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'));
- rollback:
- 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@2022-02-10.yang') \ No newline at end of file