2 * Copyright © 2017-2018 AT&T Intellectual Property.
\r
3 * Modifications Copyright © 2018 IBM.
\r
5 * Licensed under the Apache License, Version 2.0 (the "License");
\r
6 * you may not use this file except in compliance with the License.
\r
7 * You may obtain a copy of the License at
\r
9 * http://www.apache.org/licenses/LICENSE-2.0
\r
11 * Unless required by applicable law or agreed to in writing, software
\r
12 * distributed under the License is distributed on an "AS IS" BASIS,
\r
13 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
\r
14 * See the License for the specific language governing permissions and
\r
15 * limitations under the License.
\r
18 package org.onap.ccsdk.features.data.adaptor.service;
\r
20 import java.nio.charset.Charset;
\r
21 import java.util.ArrayList;
\r
22 import java.util.Date;
\r
23 import java.util.HashMap;
\r
24 import java.util.List;
\r
25 import java.util.Map;
\r
26 import java.util.UUID;
\r
27 import org.apache.commons.io.IOUtils;
\r
28 import org.junit.Assert;
\r
29 import org.junit.Before;
\r
30 import org.junit.Test;
\r
31 import org.junit.runner.RunWith;
\r
32 import org.onap.ccsdk.features.data.adaptor.dao.ConfigPropertyMapDao;
\r
33 import org.onap.ccsdk.features.data.adaptor.dao.ConfigResourceDao;
\r
34 import org.onap.ccsdk.features.data.adaptor.dao.ConfigResourceDaoTest;
\r
35 import org.onap.ccsdk.features.data.adaptor.dao.NamedQueryExecutorDao;
\r
36 import org.onap.ccsdk.features.data.adaptor.dao.QueryExecutorDao;
\r
37 import org.onap.ccsdk.features.data.adaptor.dao.TransactionLogDao;
\r
38 import org.onap.ccsdk.features.data.adaptor.domain.ConfigResource;
\r
39 import org.onap.ccsdk.features.data.adaptor.domain.ResourceAssignmentData;
\r
40 import org.onap.ccsdk.features.data.adaptor.domain.TransactionLog;
\r
41 import org.onap.ccsdk.features.data.adaptor.service.ConfigResourceService;
\r
42 import org.onap.ccsdk.features.data.adaptor.service.ConfigResourceServiceImpl;
\r
43 import org.springframework.beans.factory.annotation.Autowired;
\r
44 import org.springframework.test.context.ContextConfiguration;
\r
45 import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
\r
47 @RunWith(SpringJUnit4ClassRunner.class)
\r
48 @ContextConfiguration(locations = {"classpath:test-context-h2db.xml"})
\r
49 public class ConfigResourceServiceTest {
\r
51 ConfigResourceService configResourceService;
\r
54 TransactionLogDao transactionLogDao;
\r
57 ConfigResourceDao configResourceDao;
\r
60 QueryExecutorDao queryExecutorDao;
\r
63 NamedQueryExecutorDao namedQueryExecutorDao;
\r
66 ConfigPropertyMapDao configPropertyMapDao;
\r
69 public void before() {
\r
70 configResourceService = new ConfigResourceServiceImpl(transactionLogDao, configResourceDao, queryExecutorDao,
\r
71 namedQueryExecutorDao, configPropertyMapDao);
\r
75 public void testUpdate() throws Exception {
\r
76 String sql = "INSERT INTO CONFIG_RESOURCE"
\r
77 + "(config_resource_id, resource_id, resource_type, template_name, recipe_name, request_id, resource_data, mask_data, created_date, updated_by) "
\r
78 + "VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )";
\r
80 new Object[] {"54321", "vUSP - vDBE-IPX HUB", "1234567", "activate-action", "vrr-service-template",
\r
81 "resource-data", "mask-data", null, new Date(System.currentTimeMillis()), "ab1234"};
\r
82 int result = configResourceService.update(sql, data);
\r
83 Assert.assertTrue(result == 1);
\r
85 sql = "SELECT * FROM CONFIG_RESOURCE WHERE config_resource_id = ?";
\r
86 data = new Object[] {"54321"};
\r
87 List<Map<String, Object>> queryResult = configResourceService.query(sql, data);
\r
88 Assert.assertTrue(queryResult.size() == 1);
\r
92 public void testSaveAndGetConfigResource() throws Exception {
\r
93 ConfigResource configResource = new ConfigResource();
\r
94 String resourceData = IOUtils.toString(
\r
95 ConfigResourceDaoTest.class.getClassLoader().getResourceAsStream("reference/resource_data.json"),
\r
96 Charset.defaultCharset());
\r
98 configResource.setResourceData(resourceData);
\r
99 configResource.setServiceTemplateName("sample-name");
\r
100 configResource.setServiceTemplateVersion("1.0.0");
\r
101 configResource.setResourceId("123456");
\r
102 configResource.setResourceType("vUSP - vDBE-IPX HUB");
\r
103 configResource.setRequestId("123456");
\r
104 configResource.setRecipeName("activate-action");
\r
105 configResource.setTemplateName("vrr-service-template");
\r
106 configResource.setMaskData(null);
\r
107 configResource.setStatus("success");
\r
108 configResource.setCreatedDate(new Date(System.currentTimeMillis()));
\r
109 configResource.setUpdatedBy("an188a");
\r
111 List<ResourceAssignmentData> resourceAssignments = new ArrayList<>();
\r
112 ResourceAssignmentData resourceAssignmentData = new ResourceAssignmentData();
\r
113 resourceAssignmentData.setDataType("string");
\r
114 resourceAssignmentData.setStatus("success");
\r
115 resourceAssignmentData.setMessage("success");
\r
116 resourceAssignmentData.setTemplateKeyName("sample");
\r
117 resourceAssignmentData.setResourceName("sample");
\r
118 // resourceAssignmentData.setResourceValue("sample123");
\r
119 resourceAssignmentData.setSource("input");
\r
120 resourceAssignments.add(resourceAssignmentData);
\r
121 configResource.setResourceAssignments(resourceAssignments);
\r
124 ConfigResource dbConfigResource = configResourceService.saveConfigResource(configResource);
\r
125 Assert.assertNotNull("ConfigResource is null", dbConfigResource);
\r
126 Assert.assertNotNull("Resource Assignment Data is null", dbConfigResource.getResourceAssignments());
\r
127 Assert.assertEquals("Resource Assignment Data count missmatch", true,
\r
128 dbConfigResource.getResourceAssignments().size() > 0);
\r
129 Assert.assertEquals(configResource.getServiceTemplateVersion(), dbConfigResource.getServiceTemplateVersion());
\r
132 configResource.setServiceTemplateVersion("1.0.1");
\r
133 dbConfigResource = configResourceService.saveConfigResource(configResource);
\r
134 Assert.assertNotNull("ConfigResource is null", dbConfigResource);
\r
135 Assert.assertNotNull("Resource Assignment Data is null", dbConfigResource.getResourceAssignments());
\r
136 Assert.assertEquals("Resource Assignment Data count missmatch", true,
\r
137 dbConfigResource.getResourceAssignments().size() > 0);
\r
138 Assert.assertEquals(configResource.getServiceTemplateVersion(), dbConfigResource.getServiceTemplateVersion());
\r
141 ConfigResource configResourceInput = new ConfigResource();
\r
142 configResourceInput.setResourceId(configResource.getResourceId());
\r
143 configResourceInput.setTemplateName(configResource.getTemplateName());
\r
144 configResourceInput.setServiceTemplateName(configResource.getServiceTemplateName());
\r
145 configResourceInput.setServiceTemplateVersion(configResource.getServiceTemplateVersion());
\r
146 configResourceInput.setRequestId(configResource.getRequestId());
\r
147 configResourceInput.setRecipeName(configResource.getRecipeName());
\r
148 configResourceInput.setResourceType(configResource.getResourceType());
\r
149 List<ConfigResource> dbConfigResources = configResourceService.getConfigResource(configResourceInput);
\r
150 Assert.assertNotNull("ConfigResources is null", dbConfigResources);
\r
151 Assert.assertEquals("ConfigResources size missmatch", true, dbConfigResources.size() > 0);
\r
153 for (ConfigResource dbConfigResouce : dbConfigResources) {
\r
154 Assert.assertNotNull("ConfigResources Assignments is null", dbConfigResouce.getResourceAssignments());
\r
155 Assert.assertTrue("ConfigResources Assignments size miss mathch ",
\r
156 dbConfigResouce.getResourceAssignments().size() > 0);
\r
161 public void testSaveAndGetTransactionLog() throws Exception {
\r
162 TransactionLog transactionLog = new TransactionLog();
\r
163 transactionLog.setMessage("message");
\r
164 transactionLog.setMessageType("messageType");
\r
165 transactionLog.setRequestId("requestId");
\r
167 configResourceService.save(transactionLog);
\r
169 List<TransactionLog> transactions =
\r
170 configResourceService.getTransactionsByRequestId(transactionLog.getRequestId());
\r
171 Assert.assertTrue(transactions.size() == 1);
\r
172 transactions = configResourceService.getTransactionsByRequestId(transactionLog.getRequestId(),
\r
173 transactionLog.getMessageType());
\r
174 Assert.assertTrue(transactions.size() == 1);
\r
178 public void testNamedQueryExecutorUpdateNQuery() throws Exception {
\r
179 Map<String, Object> parameters = new HashMap<>();
\r
180 parameters.put("config_transaction_log_id", UUID.randomUUID().toString());
\r
181 parameters.put("request_id", "requestId123");
\r
182 parameters.put("message_type", "messageType");
\r
183 parameters.put("message", "message");
\r
184 configResourceService.update(
\r
185 "INSERT INTO CONFIG_TRANSACTION_LOG ( config_transaction_log_id, request_id, message_type, message ) VALUES (:config_transaction_log_id, :request_id, :message_type, :message) ",
\r
188 List<Map<String, Object>> result = configResourceService
\r
189 .query("SELECT * FROM CONFIG_TRANSACTION_LOG WHERE request_id = :request_id", parameters);
\r
191 Assert.assertTrue(!result.isEmpty());
\r
192 Assert.assertNotNull(configResourceService.getNamedParameterJdbcTemplate());
\r