2 * ============LICENSE_START=======================================================
3 * Copyright (C) 2024 Ericsson
4 * Modifications Copyright (C) 2024 OpenInfra Foundation Europe
5 * ================================================================================
6 * Licensed under the Apache License, Version 2.0 (the "License");
7 * you may not use this file except in compliance with the License.
8 * You may obtain a copy of the License at
10 * http://www.apache.org/licenses/LICENSE-2.0
12 * Unless required by applicable law or agreed to in writing, software
13 * distributed under the License is distributed on an "AS IS" BASIS,
14 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
15 * See the License for the specific language governing permissions and
16 * limitations under the License.
18 * SPDX-License-Identifier: Apache-2.0
19 * ============LICENSE_END=========================================================
21 package org.oran.smo.teiv.pgsqlgenerator.schema.model;
24 import java.io.IOException;
25 import java.nio.file.Files;
26 import java.nio.file.StandardCopyOption;
27 import java.util.List;
29 import org.oran.smo.teiv.pgsqlgenerator.schema.BackwardCompatibilityChecker;
30 import org.oran.smo.teiv.pgsqlgenerator.schema.SchemaParser;
31 import org.springframework.beans.factory.annotation.Value;
32 import org.springframework.stereotype.Component;
33 import org.springframework.util.ResourceUtils;
35 import org.oran.smo.teiv.pgsqlgenerator.Entity;
36 import org.oran.smo.teiv.pgsqlgenerator.Module;
37 import org.oran.smo.teiv.pgsqlgenerator.PgSchemaGeneratorException;
38 import org.oran.smo.teiv.pgsqlgenerator.Relationship;
39 import org.oran.smo.teiv.pgsqlgenerator.schema.SchemaGenerator;
40 import org.oran.smo.teiv.pgsqlgenerator.schema.Table;
41 import lombok.RequiredArgsConstructor;
42 import lombok.extern.slf4j.Slf4j;
46 @RequiredArgsConstructor
47 public class ModelSchemaGenerator extends SchemaGenerator {
48 @Value("${schema.model.output}")
49 private String modelOutputFileName;
50 @Value("${schema.model.skeleton}")
51 private String skeletonModelSchemaFileClassPath;
52 @Value("${schema.model.baseline}")
53 private String baselineModelSchemaFileClassPath;
54 @Value("${schema.model.temp-baseline}")
55 private String tempBaselineModelSchemaFileClassPath;
56 @Value("${green-field-installation}")
57 private boolean isGreenFieldInstallation;
59 private final HashInfoDataGenerator hashInfoDataGenerator;
60 private final BackwardCompatibilityChecker backwardCompatibilityChecker;
63 protected void prepareSchema() {
65 File skeletonFile = ResourceUtils.getFile("classpath:" + skeletonModelSchemaFileClassPath);
66 File newGeneratedModelFile = new File(modelOutputFileName);
67 Files.copy(skeletonFile.toPath(), newGeneratedModelFile.toPath(), StandardCopyOption.REPLACE_EXISTING);
68 if (!isGreenFieldInstallation) {
69 File helmBaseline = ResourceUtils.getFile(baselineModelSchemaFileClassPath);
70 File modelBaseline = new File(tempBaselineModelSchemaFileClassPath);
71 Files.copy(helmBaseline.toPath(), modelBaseline.toPath(), StandardCopyOption.REPLACE_EXISTING);
73 this.schema = newGeneratedModelFile;
74 } catch (IOException exception) {
75 throw PgSchemaGeneratorException.prepareBaselineException("ties.model", exception);
80 protected void setSqlStatements(List<Module> modules, List<Entity> entities, List<Relationship> relationships) {
81 if (!isGreenFieldInstallation) {
82 // Get relationships from baseline sql
83 List<Relationship> relFromBaselineSql = SchemaParser.extractFromModelBaseline(
84 tempBaselineModelSchemaFileClassPath);
86 backwardCompatibilityChecker.checkForNBCChangesInModel(relFromBaselineSql, relationships);
88 StringBuilder tiesModelSql = new StringBuilder();
89 tiesModelSql.append(prepareCopyStatement(hashInfoDataGenerator.getHashInfoRowsList().stream().toList()));
90 tiesModelSql.append(prepareCopyStatement(modules));
91 tiesModelSql.append(prepareCopyStatement(entities));
92 tiesModelSql.append(prepareCopyStatement(relationships));
93 tiesModelSql.append(";\n").append("\nCOMMIT;");
94 this.sqlStatements = tiesModelSql.toString();
97 private StringBuilder prepareCopyStatement(List<? extends Table> table) {
98 StringBuilder copyStatement = new StringBuilder();
99 if (!table.isEmpty()) {
100 copyStatement.append("COPY ties_model.").append(table.get(0).getTableName()).append(table.get(0)
101 .getColumnsForCopyStatement()).append(" FROM stdin;\n");
102 table.forEach(table1 -> copyStatement.append(table1.getRecordForCopyStatement()));
103 copyStatement.append("\\.\n\n");
105 return copyStatement;