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

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