1 # ============LICENSE_START=======================================================
2 # Copyright (C) 2021-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
8 # http://www.apache.org/licenses/LICENSE-2.0
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.
16 # SPDX-License-Identifier: Apache-2.0
17 # ============LICENSE_END=========================================================
22 label: dmi-registry-schema-preload
26 file: 'changelog/db/changes/data/dmi/dataspace.csv'
31 tableName: 'dataspace'
34 sql: delete from dataspace where name = 'NCMP-Admin'
38 label: dmi-registry-schema-preload
42 file: 'changelog/db/changes/data/dmi/schema_set.csv'
47 tableName: 'schema_set'
50 sql: delete from schema_set where name = 'ncmp-dmi-registry-model'
54 label: dmi-registry-schema-preload
58 file: 'changelog/db/changes/data/dmi/yang_resource.csv'
63 tableName: 'yang_resource'
79 sql: delete from yang_resource where name = 'dmi-registry@2021-05-20.yang'
83 label: dmi-registry-schema-preload
87 file: 'changelog/db/changes/data/dmi/schema_set_yang_resources.csv'
89 primaryKey: 'schema_set_id,yang_resource_id'
91 tableName: 'schema_set_yang_resources'
92 usePreparedStatements: true
96 delete from schema_set_yang_resources
97 where schema_set_id = (select id from schema_set where name = 'ncmp-dmi-registry-model')
98 and yang_resource_id = (select id from yang_resource where name = 'dmi-registry@2021-05-20.yang')
102 label: dmi-registry-schema-preload
106 file: 'changelog/db/changes/data/dmi/anchor.csv'
114 sql: delete from anchor where name = 'ncmp-dmi-registry'
118 label: dmi-registry-schema-preload
122 file: 'changelog/db/changes/data/dmi/yang_resource@2021-10-20.csv'
127 tableName: 'yang_resource'
143 sql: delete from yang_resource where name = 'dmi-registry@2021-10-20.yang'
147 label: dmi-registry-schema-preload
151 file: 'changelog/db/changes/data/dmi/schema_set_yang_resources@2021-10-20.csv'
153 primaryKey: 'schema_set_id,yang_resource_id'
155 tableName: 'schema_set_yang_resources'
156 usePreparedStatements: true
160 delete from schema_set_yang_resources
161 where schema_set_id = (select id from schema_set where name = 'ncmp-dmi-registry-model')
162 and yang_resource_id = (select id from yang_resource where name = 'dmi-registry@2021-10-20.yang')
166 label: dmi-registry-schema-preload
170 file: 'changelog/db/changes/data/dmi//generated-csv/generated_yang_resource_dmi-registry@2021-12-13.csv'
175 tableName: 'yang_resource'
191 sql: delete from yang_resource where name = 'dmi-registry@2021-12-13.yang'
195 label: dmi-registry-schema-preload
199 file: 'changelog/db/changes/data/dmi/schema_set_yang_resources@2021-12-13.csv'
201 primaryKey: 'schema_set_id,yang_resource_id'
203 tableName: 'schema_set_yang_resources'
204 usePreparedStatements: true
208 delete from schema_set_yang_resources
209 where schema_set_id = (select id from schema_set where name = 'ncmp-dmi-registry-model')
210 and yang_resource_id = (select id from yang_resource where name = 'dmi-registry@2021-12-13.yang')