gerrit.onap Code Review - ccsdk/features.git/blob

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