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