2 * ============LICENSE_START=======================================================
4 * ================================================================================
5 * Copyright (C) 2017-2018 AT&T Intellectual Property. All rights reserved.
6 * ================================================================================
7 * Copyright (C) 2017 Amdocs
8 * ================================================================================
9 * Copyright (C) 2018 IBM
10 * =============================================================================
11 * Licensed under the Apache License, Version 2.0 (the "License");
12 * you may not use this file except in compliance with the License.
13 * You may obtain a copy of the License at
15 * http://www.apache.org/licenses/LICENSE-2.0
17 * Unless required by applicable law or agreed to in writing, software
18 * distributed under the License is distributed on an "AS IS" BASIS,
19 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
20 * See the License for the specific language governing permissions and
21 * limitations under the License.
23 * ============LICENSE_END=========================================================
25 package org.onap.appc.data.services.db;
27 import static org.junit.Assert.assertEquals;
28 import java.io.IOException;
29 import org.apache.commons.io.IOUtils;
30 import org.apache.commons.lang.StringEscapeUtils;
31 import org.junit.Test;
32 import org.onap.ccsdk.sli.core.sli.SvcLogicContext;
33 import org.onap.ccsdk.sli.core.sli.SvcLogicException;
34 import org.onap.ccsdk.sli.core.sli.SvcLogicResource.QueryStatus;
35 import org.onap.appc.data.services.db.DGGeneralDBService;
37 public class TestDGGeneralDBService {
38 DGGeneralDBService dbService;
39 private static String STRING_ENCODING = "utf-8";
42 public void testGetUploadConfig() throws SvcLogicException {
44 SvcLogicContext ctx = new SvcLogicContext();
45 ctx.setAttribute("vnf-name", "test");
46 ctx.setAttribute("vnf-id", "test");
47 MockDGGeneralDBService dbService = MockDGGeneralDBService.initialise();
48 QueryStatus status = dbService.getUploadConfigInfo(ctx, "test");
49 assertEquals(status, QueryStatus.SUCCESS);
54 public void testGetDeviceProtocolByVnfType() throws SvcLogicException {
55 SvcLogicContext ctx = new SvcLogicContext();
56 ctx.setAttribute("vnf-type", "test");
57 MockDGGeneralDBService dbService = MockDGGeneralDBService.initialise();
58 QueryStatus status = dbService.getDeviceProtocolByVnfType(ctx, "test");
59 assertEquals(status, QueryStatus.SUCCESS);
63 public void testGettConfigFileReferenceByFileTypeNVnfType() throws SvcLogicException {
64 SvcLogicContext ctx = new SvcLogicContext();
65 ctx.setAttribute("vnf-type", "test");
66 MockDGGeneralDBService dbService = MockDGGeneralDBService.initialise();
67 QueryStatus status = dbService.getConfigFileReferenceByFileTypeNVnfType(ctx, "test", "device_configuration");
68 assertEquals(status, QueryStatus.SUCCESS);
73 public void testGetDeviceAuthenticationByVnfType() throws Exception {
74 SvcLogicContext ctx = new SvcLogicContext();
75 ctx.setAttribute("vnf-type", "test");
76 MockDGGeneralDBService dbService = MockDGGeneralDBService.initialise();
77 QueryStatus status = dbService.getDeviceAuthenticationByVnfType(ctx, "test");
78 assertEquals(status, QueryStatus.SUCCESS);
83 public void testGetTemplate() throws Exception {
84 SvcLogicContext ctx = new SvcLogicContext();
85 ctx.setAttribute("vnfc-type", "test");
86 ctx.setAttribute("request-action", "Configure");
87 MockDGGeneralDBService dbService = MockDGGeneralDBService.initialise();
88 QueryStatus status = dbService.getTemplate(ctx, "test", "config_template");
89 assertEquals(status, QueryStatus.SUCCESS);
94 public void testGetTemplateByVnfTypeNAction() throws Exception {
95 SvcLogicContext ctx = new SvcLogicContext();
96 ctx.setAttribute("vnf-type", "test");
97 ctx.setAttribute("request-action", "ConfigScaleOut");
98 MockDGGeneralDBService dbService = MockDGGeneralDBService.initialise();
99 QueryStatus status = dbService.getTemplateByVnfTypeNAction(ctx, "test", "config_template");
100 assertEquals(status, QueryStatus.SUCCESS);
105 public void testGetTemplateByTemplateName() throws Exception {
106 SvcLogicContext ctx = new SvcLogicContext();
107 ctx.setAttribute("request-action", "Configure");
108 ctx.setAttribute("vnf-type", "test");
109 MockDGGeneralDBService dbService = MockDGGeneralDBService.initialise();
110 QueryStatus status = dbService.getTemplateByTemplateName(ctx, "test", "template.json");
111 assertEquals(status, QueryStatus.SUCCESS);
116 public void testGetTemplateByVnfType() throws SvcLogicException {
118 SvcLogicContext ctx = new SvcLogicContext();
119 ctx.setAttribute("vnf-type", "test");
120 MockDGGeneralDBService dbService = MockDGGeneralDBService.initialise();
121 QueryStatus status = dbService.getTemplateByVnfType(ctx, "test", "config_template");
122 assertEquals(status, QueryStatus.SUCCESS);
127 public void testGetConfigureActionDGByVnfTypeNAction() throws SvcLogicException {
129 SvcLogicContext ctx = new SvcLogicContext();
130 ctx.setAttribute("vnf-type", "test");
131 ctx.setAttribute("request-action", "ConfigModify");
132 MockDGGeneralDBService dbService = MockDGGeneralDBService.initialise();
133 QueryStatus status = dbService.getConfigureActionDGByVnfTypeNAction(ctx, "test");
134 assertEquals(status, QueryStatus.SUCCESS);
139 public void testGetConfigureActionDGByVnfType() throws SvcLogicException {
140 SvcLogicContext ctx = new SvcLogicContext();
141 ctx.setAttribute("vnf-type", "test");
142 MockDGGeneralDBService dbService = MockDGGeneralDBService.initialise();
143 QueryStatus status = dbService.getConfigureActionDGByVnfType(ctx, "test");
144 assertEquals(status, QueryStatus.SUCCESS);
149 public void testGetMaxConfigFileId() throws SvcLogicException {
151 SvcLogicContext ctx = new SvcLogicContext();
152 ctx.setAttribute("vnf-id", "test");
153 ctx.setAttribute("vm-name", "test");
154 MockDGGeneralDBService dbService = MockDGGeneralDBService.initialise();
155 QueryStatus status = dbService.getMaxConfigFileId(ctx, "test", "device_configuration");
156 assertEquals(status, QueryStatus.SUCCESS);
161 public void testGetConfigFilesByVnfVmNCategory() throws SvcLogicException {
163 SvcLogicContext ctx = new SvcLogicContext();
164 ctx.setAttribute("vnf-id", "test");
165 ctx.setAttribute("vm-name", "test");
166 MockDGGeneralDBService dbService = MockDGGeneralDBService.initialise();
167 QueryStatus status = dbService.getConfigFilesByVnfVmNCategory(ctx, "test", "device_configuration", "test",
169 assertEquals(status, QueryStatus.SUCCESS);
174 public void testGetDownloadConfigTemplateByVnf() throws SvcLogicException {
176 SvcLogicContext ctx = new SvcLogicContext();
177 ctx.setAttribute("vnf-type", "test");
178 MockDGGeneralDBService dbService = MockDGGeneralDBService.initialise();
179 QueryStatus status = dbService.getDownloadConfigTemplateByVnf(ctx, "test");
180 assertEquals(status, QueryStatus.SUCCESS);
184 public void testSaveConfigTxLog() throws SvcLogicException, IOException {
186 SvcLogicContext ctx = new SvcLogicContext();
187 String message = IOUtils.toString(
188 TestDGGeneralDBService.class.getClassLoader().getResourceAsStream("query/message3.txt"),
190 ctx.setAttribute("request-id", "1234");
191 String escapedMessage = StringEscapeUtils.escapeSql(message);
192 ctx.setAttribute("log-message", escapedMessage);
193 ctx.setAttribute("log-message-type", "request");
194 MockDGGeneralDBService dbService = MockDGGeneralDBService.initialise();
195 QueryStatus status = dbService.saveConfigTransactionLog(ctx, "test");
196 assertEquals(status, QueryStatus.SUCCESS);
200 public void testGetVnfcReferenceByVnfTypeNActionWithTemplateModelId() throws Exception {
201 MockDGGeneralDBService dbService = MockDGGeneralDBService.initialise();
202 SvcLogicContext ctx = new SvcLogicContext();
203 String prefix="test";
204 String templateModelId = "template001";
205 dbService.getVnfcReferenceByVnfTypeNActionWithTemplateModelId(ctx, prefix, templateModelId);
209 public void testGetTemplateWithTemplateModelId() throws Exception {
210 MockDGGeneralDBService dbService = MockDGGeneralDBService.initialise();
211 SvcLogicContext ctx = new SvcLogicContext();
212 String prefix="test";
213 String templateModelId = "template001";
214 String fileCategory="testCategory";
215 dbService.getTemplateWithTemplateModelId(ctx, prefix, fileCategory, templateModelId);
219 public void testgetTemplateByVnfTypeNActionWithTemplateModelId() throws Exception {
220 MockDGGeneralDBService dbService = MockDGGeneralDBService.initialise();
221 SvcLogicContext ctx = new SvcLogicContext();
222 String prefix="test";
223 String templateModelId = "template001";
224 String fileCategory="testCategory";
225 dbService.getTemplateByVnfTypeNActionWithTemplateModelId(ctx, prefix, fileCategory, templateModelId);
229 public void testGetConfigFileReferenceByVnfType() throws Exception {
230 SvcLogicContext ctx = new SvcLogicContext();
231 ctx.setAttribute("vnf-type", "test");
232 ctx.setAttribute("request-action", "Configure");
233 MockDGGeneralDBService dbService = MockDGGeneralDBService.initialise();
234 QueryStatus status = dbService.getConfigFileReferenceByVnfType(ctx, "test");
235 assertEquals(status, QueryStatus.SUCCESS);