blueprints-processor/adaptors/data-adaptor-provider/src/test/java/org/onap/ccsdk/features/data/adaptor/service/ConfigResourceServiceTest.java

   1 /*\r
   2  * Copyright © 2017-2018 AT&T Intellectual Property.\r
   3  * Modifications Copyright © 2018 IBM.\r
   4  * \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
   8  * \r
   9  * http://www.apache.org/licenses/LICENSE-2.0\r
  10  * \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
  16  */\r
  17 \r
  18 package org.onap.ccsdk.features.data.adaptor.service;\r
  19 \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
  46 \r
  47 @RunWith(SpringJUnit4ClassRunner.class)\r
  48 @ContextConfiguration(locations = {"classpath:test-context-h2db.xml"})\r
  49 public class ConfigResourceServiceTest {\r
  50 \r
  51     ConfigResourceService configResourceService;\r
  52 \r
  53     @Autowired\r
  54     TransactionLogDao transactionLogDao;\r
  55 \r
  56     @Autowired\r
  57     ConfigResourceDao configResourceDao;\r
  58 \r
  59     @Autowired\r
  60     QueryExecutorDao queryExecutorDao;\r
  61 \r
  62     @Autowired\r
  63     NamedQueryExecutorDao namedQueryExecutorDao;\r
  64 \r
  65     @Autowired\r
  66     ConfigPropertyMapDao configPropertyMapDao;\r
  67 \r
  68     @Before\r
  69     public void before() {\r
  70         configResourceService = new ConfigResourceServiceImpl(transactionLogDao, configResourceDao, queryExecutorDao,\r
  71                 namedQueryExecutorDao, configPropertyMapDao);\r
  72     }\r
  73 \r
  74     @Test\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
  79         Object[] data =\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
  84 \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
  89     }\r
  90 \r
  91     @Test\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
  97 \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
 110 \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
 122 \r
 123         // save\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
 130 \r
 131         // update\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
 139 \r
 140         // find\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
 152 \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
 157         }\r
 158     }\r
 159 \r
 160     @Test\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
 166 \r
 167         configResourceService.save(transactionLog);\r
 168 \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
 175     }\r
 176 \r
 177     @Test\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
 186                 parameters);\r
 187 \r
 188         List<Map<String, Object>> result = configResourceService\r
 189                 .query("SELECT * FROM CONFIG_TRANSACTION_LOG WHERE request_id = :request_id", parameters);\r
 190 \r
 191         Assert.assertTrue(!result.isEmpty());\r
 192         Assert.assertNotNull(configResourceService.getNamedParameterJdbcTemplate());\r
 193     }\r
 194 }\r