blueprints-processor/adaptors/data-adaptor-provider/src/test/java/org/onap/ccsdk/config/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.config.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.config.data.adaptor.dao.ConfigPropertyMapDao;\r
  33 import org.onap.ccsdk.config.data.adaptor.dao.ConfigResourceDao;\r
  34 import org.onap.ccsdk.config.data.adaptor.dao.ConfigResourceDaoTest;\r
  35 import org.onap.ccsdk.config.data.adaptor.dao.NamedQueryExecutorDao;\r
  36 import org.onap.ccsdk.config.data.adaptor.dao.QueryExecutorDao;\r
  37 import org.onap.ccsdk.config.data.adaptor.dao.TransactionLogDao;\r
  38 import org.onap.ccsdk.config.data.adaptor.domain.ConfigResource;\r
  39 import org.onap.ccsdk.config.data.adaptor.domain.ResourceAssignmentData;\r
  40 import org.onap.ccsdk.config.data.adaptor.domain.TransactionLog;\r
  41 import org.springframework.beans.factory.annotation.Autowired;\r
  42 import org.springframework.test.context.ContextConfiguration;\r
  43 import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;\r
  44 \r
  45 @RunWith(SpringJUnit4ClassRunner.class)\r
  46 @ContextConfiguration(locations = {"classpath:test-context-h2db.xml"})\r
  47 public class ConfigResourceServiceTest {\r
  48 \r
  49     ConfigResourceService configResourceService;\r
  50 \r
  51     @Autowired\r
  52     TransactionLogDao transactionLogDao;\r
  53 \r
  54     @Autowired\r
  55     ConfigResourceDao configResourceDao;\r
  56 \r
  57     @Autowired\r
  58     QueryExecutorDao queryExecutorDao;\r
  59 \r
  60     @Autowired\r
  61     NamedQueryExecutorDao namedQueryExecutorDao;\r
  62 \r
  63     @Autowired\r
  64     ConfigPropertyMapDao configPropertyMapDao;\r
  65 \r
  66     @Before\r
  67     public void before() {\r
  68         configResourceService = new ConfigResourceServiceImpl(transactionLogDao, configResourceDao, queryExecutorDao,\r
  69                 namedQueryExecutorDao, configPropertyMapDao);\r
  70     }\r
  71 \r
  72     @Test\r
  73     public void testUpdate() throws Exception {\r
  74         String sql = "INSERT INTO CONFIG_RESOURCE"\r
  75                 + "(config_resource_id, resource_id, resource_type, template_name, recipe_name, request_id, resource_data, mask_data, created_date, updated_by) "\r
  76                 + "VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )";\r
  77         Object[] data =\r
  78                 new Object[] {"54321", "vUSP - vDBE-IPX HUB", "1234567", "activate-action", "vrr-service-template",\r
  79                         "resource-data", "mask-data", null, new Date(System.currentTimeMillis()), "ab1234"};\r
  80         int result = configResourceService.update(sql, data);\r
  81         Assert.assertTrue(result == 1);\r
  82 \r
  83         sql = "SELECT * FROM CONFIG_RESOURCE WHERE config_resource_id = ?";\r
  84         data = new Object[] {"54321"};\r
  85         List<Map<String, Object>> queryResult = configResourceService.query(sql, data);\r
  86         Assert.assertTrue(queryResult.size() == 1);\r
  87     }\r
  88 \r
  89     @Test\r
  90     public void testSaveAndGetConfigResource() throws Exception {\r
  91         ConfigResource configResource = new ConfigResource();\r
  92         String resourceData = IOUtils.toString(\r
  93                 ConfigResourceDaoTest.class.getClassLoader().getResourceAsStream("reference/resource_data.json"),\r
  94                 Charset.defaultCharset());\r
  95 \r
  96         configResource.setResourceData(resourceData);\r
  97         configResource.setServiceTemplateName("sample-name");\r
  98         configResource.setServiceTemplateVersion("1.0.0");\r
  99         configResource.setResourceId("123456");\r
 100         configResource.setResourceType("vUSP - vDBE-IPX HUB");\r
 101         configResource.setRequestId("123456");\r
 102         configResource.setRecipeName("activate-action");\r
 103         configResource.setTemplateName("vrr-service-template");\r
 104         configResource.setMaskData(null);\r
 105         configResource.setStatus("success");\r
 106         configResource.setCreatedDate(new Date(System.currentTimeMillis()));\r
 107         configResource.setUpdatedBy("an188a");\r
 108 \r
 109         List<ResourceAssignmentData> resourceAssignments = new ArrayList<>();\r
 110         ResourceAssignmentData resourceAssignmentData = new ResourceAssignmentData();\r
 111         resourceAssignmentData.setDataType("string");\r
 112         resourceAssignmentData.setStatus("success");\r
 113         resourceAssignmentData.setMessage("success");\r
 114         resourceAssignmentData.setTemplateKeyName("sample");\r
 115         resourceAssignmentData.setResourceName("sample");\r
 116         // resourceAssignmentData.setResourceValue("sample123");\r
 117         resourceAssignmentData.setSource("input");\r
 118         resourceAssignments.add(resourceAssignmentData);\r
 119         configResource.setResourceAssignments(resourceAssignments);\r
 120 \r
 121         // save\r
 122         ConfigResource dbConfigResource = configResourceService.saveConfigResource(configResource);\r
 123         Assert.assertNotNull("ConfigResource is null", dbConfigResource);\r
 124         Assert.assertNotNull("Resource Assignment Data is null", dbConfigResource.getResourceAssignments());\r
 125         Assert.assertEquals("Resource Assignment Data count missmatch", true,\r
 126                 dbConfigResource.getResourceAssignments().size() > 0);\r
 127         Assert.assertEquals(configResource.getServiceTemplateVersion(), dbConfigResource.getServiceTemplateVersion());\r
 128 \r
 129         // update\r
 130         configResource.setServiceTemplateVersion("1.0.1");\r
 131         dbConfigResource = configResourceService.saveConfigResource(configResource);\r
 132         Assert.assertNotNull("ConfigResource is null", dbConfigResource);\r
 133         Assert.assertNotNull("Resource Assignment Data is null", dbConfigResource.getResourceAssignments());\r
 134         Assert.assertEquals("Resource Assignment Data count missmatch", true,\r
 135                 dbConfigResource.getResourceAssignments().size() > 0);\r
 136         Assert.assertEquals(configResource.getServiceTemplateVersion(), dbConfigResource.getServiceTemplateVersion());\r
 137 \r
 138         // find\r
 139         ConfigResource configResourceInput = new ConfigResource();\r
 140         configResourceInput.setResourceId(configResource.getResourceId());\r
 141         configResourceInput.setTemplateName(configResource.getTemplateName());\r
 142         configResourceInput.setServiceTemplateName(configResource.getServiceTemplateName());\r
 143         configResourceInput.setServiceTemplateVersion(configResource.getServiceTemplateVersion());\r
 144         configResourceInput.setRequestId(configResource.getRequestId());\r
 145         configResourceInput.setRecipeName(configResource.getRecipeName());\r
 146         configResourceInput.setResourceType(configResource.getResourceType());\r
 147         List<ConfigResource> dbConfigResources = configResourceService.getConfigResource(configResourceInput);\r
 148         Assert.assertNotNull("ConfigResources is null", dbConfigResources);\r
 149         Assert.assertEquals("ConfigResources size missmatch", true, dbConfigResources.size() > 0);\r
 150 \r
 151         for (ConfigResource dbConfigResouce : dbConfigResources) {\r
 152             Assert.assertNotNull("ConfigResources Assignments is null", dbConfigResouce.getResourceAssignments());\r
 153             Assert.assertTrue("ConfigResources Assignments size miss mathch ",\r
 154                     dbConfigResouce.getResourceAssignments().size() > 0);\r
 155         }\r
 156     }\r
 157 \r
 158     @Test\r
 159     public void testSaveAndGetTransactionLog() throws Exception {\r
 160         TransactionLog transactionLog = new TransactionLog();\r
 161         transactionLog.setMessage("message");\r
 162         transactionLog.setMessageType("messageType");\r
 163         transactionLog.setRequestId("requestId");\r
 164 \r
 165         configResourceService.save(transactionLog);\r
 166 \r
 167         List<TransactionLog> transactions =\r
 168                 configResourceService.getTransactionsByRequestId(transactionLog.getRequestId());\r
 169         Assert.assertTrue(transactions.size() == 1);\r
 170         transactions = configResourceService.getTransactionsByRequestId(transactionLog.getRequestId(),\r
 171                 transactionLog.getMessageType());\r
 172         Assert.assertTrue(transactions.size() == 1);\r
 173     }\r
 174 \r
 175     @Test\r
 176     public void testNamedQueryExecutorUpdateNQuery() throws Exception {\r
 177         Map<String, Object> parameters = new HashMap<>();\r
 178         parameters.put("config_transaction_log_id", UUID.randomUUID().toString());\r
 179         parameters.put("request_id", "requestId123");\r
 180         parameters.put("message_type", "messageType");\r
 181         parameters.put("message", "message");\r
 182         configResourceService.update(\r
 183                 "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
 184                 parameters);\r
 185 \r
 186         List<Map<String, Object>> result = configResourceService\r
 187                 .query("SELECT * FROM CONFIG_TRANSACTION_LOG WHERE request_id = :request_id", parameters);\r
 188 \r
 189         Assert.assertTrue(!result.isEmpty());\r
 190         Assert.assertNotNull(configResourceService.getNamedParameterJdbcTemplate());\r
 191     }\r
 192 }\r