* ============LICENSE_START=======================================================
* ONAP-PAP-REST
* ================================================================================
- * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
+ * Copyright (C) 2017-2019 AT&T Intellectual Property. All rights reserved.
* ================================================================================
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
- *
+ *
* http://www.apache.org/licenses/LICENSE-2.0
- *
+ *
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
*/
package org.onap.policy.pap.xacml.rest.controller;
- /*
- *
- *
- * */
+
+import au.com.bytecode.opencsv.CSVReader;
+
+import com.fasterxml.jackson.databind.DeserializationFeature;
+import com.fasterxml.jackson.databind.ObjectMapper;
+
import java.io.File;
import java.io.FileOutputStream;
import java.io.FileReader;
+import java.io.IOException;
import java.io.OutputStream;
import java.util.List;
import javax.servlet.http.HttpServletResponse;
import org.apache.commons.compress.utils.IOUtils;
+import org.onap.policy.common.logging.flexlogger.FlexLogger;
+import org.onap.policy.common.logging.flexlogger.Logger;
+import org.onap.policy.pap.xacml.rest.DictionaryNames;
import org.onap.policy.rest.dao.CommonClassDao;
import org.onap.policy.rest.jpa.ActionList;
import org.onap.policy.rest.jpa.ActionPolicyDict;
import org.onap.policy.rest.jpa.AddressGroup;
import org.onap.policy.rest.jpa.Attribute;
-import org.onap.policy.rest.jpa.BRMSParamTemplate;
+import org.onap.policy.rest.jpa.BrmsController;
+import org.onap.policy.rest.jpa.BrmsDependency;
+import org.onap.policy.rest.jpa.BrmsParamTemplate;
import org.onap.policy.rest.jpa.Category;
+import org.onap.policy.rest.jpa.ClosedLoopD2Services;
+import org.onap.policy.rest.jpa.ClosedLoopSite;
import org.onap.policy.rest.jpa.Datatype;
import org.onap.policy.rest.jpa.DecisionSettings;
import org.onap.policy.rest.jpa.DescriptiveScope;
-import org.onap.policy.rest.jpa.OnapName;
import org.onap.policy.rest.jpa.GroupServiceList;
-import org.onap.policy.rest.jpa.PEPOptions;
+import org.onap.policy.rest.jpa.MicroServiceModels;
+import org.onap.policy.rest.jpa.OnapName;
+import org.onap.policy.rest.jpa.PepOptions;
import org.onap.policy.rest.jpa.PrefixList;
import org.onap.policy.rest.jpa.ProtocolList;
import org.onap.policy.rest.jpa.SecurityZone;
import org.onap.policy.rest.jpa.ServiceList;
import org.onap.policy.rest.jpa.TermList;
import org.onap.policy.rest.jpa.UserInfo;
-import org.onap.policy.rest.jpa.VNFType;
-import org.onap.policy.rest.jpa.VSCLAction;
+import org.onap.policy.rest.jpa.VnfType;
+import org.onap.policy.rest.jpa.VsclAction;
import org.onap.policy.rest.jpa.VarbindDictionary;
import org.onap.policy.rest.jpa.Zone;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RequestMethod;
-import com.fasterxml.jackson.databind.DeserializationFeature;
-import com.fasterxml.jackson.databind.ObjectMapper;
+@Controller
+public class DictionaryImportController {
+ private static final Logger LOGGER = FlexLogger.getLogger(DictionaryImportController.class);
-import au.com.bytecode.opencsv.CSVReader;
+ private static CommonClassDao commonClassDao;
+ private static final String DESCRIPTION = "description";
+ private static final String ERROR = "Error";
+ private static final String DEPENDENCY = "dependency";
+ @Autowired
+ public DictionaryImportController(CommonClassDao commonClassDao) {
+ setCommonClassDao(commonClassDao);
+ }
-@Controller
-public class DictionaryImportController {
- private String newFile;
+ public static void setCommonClassDao(CommonClassDao commonClassDao) {
+ DictionaryImportController.commonClassDao = commonClassDao;
+ }
+
+ public DictionaryImportController() {
+ super();
+ }
+
+ @RequestMapping(value = {"/dictionary/import_dictionary"}, method = {RequestMethod.POST})
+ public void importDictionaryData(HttpServletRequest request, HttpServletResponse response) throws IOException {
+ ObjectMapper mapper = new ObjectMapper();
+ mapper.configure(DeserializationFeature.FAIL_ON_UNKNOWN_PROPERTIES, false);
+ String userId = request.getParameter("userId");
+ String dictionaryName = request.getParameter("dictionaryName");
+
+ if (dictionaryName == null || dictionaryName.isEmpty()) {
+ LOGGER.error("dictionaryName is null/empty");
+ response.setStatus(HttpServletResponse.SC_BAD_REQUEST);
+ response.getWriter().write(ERROR);
+ return;
+ }
+
+ // fix Fortify Path Manipulation issue
+ if (!isValidDictionaryName(dictionaryName)) {
+ LOGGER.error("dictionaryName is invalid");
+ response.setStatus(HttpServletResponse.SC_BAD_REQUEST);
+ response.getWriter().write(ERROR);
+ return;
+ }
+ File file = new File(dictionaryName);
+ try (OutputStream outputStream = new FileOutputStream(file);
+ FileReader fileReader = new FileReader(file.toString())) {
+ IOUtils.copy(request.getInputStream(), outputStream);
+ CSVReader csvReader = new CSVReader(fileReader);
+ List<String[]> dictSheet = csvReader.readAll();
+ if (dictionaryName.startsWith("Attribute")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ Attribute attribute = new Attribute("");
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("xacml_id".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Attribute ID".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setXacmlId(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ if ("priority".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setPriority(rows[j]);
+ }
+ if ("datatype".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Data Type".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ Datatype dataType = new Datatype();
+ if ("string".equalsIgnoreCase(rows[j])) {
+ dataType.setId(26);
+ } else if ("integer".equalsIgnoreCase(rows[j])) {
+ dataType.setId(12);
+ } else if ("double".equalsIgnoreCase(rows[j])) {
+ dataType.setId(25);
+ } else if ("boolean".equalsIgnoreCase(rows[j])) {
+ dataType.setId(18);
+ } else if ("user".equalsIgnoreCase(rows[j])) {
+ dataType.setId(29);
+ }
+ attribute.setDatatypeBean(dataType);
+ Category category = new Category();
+ category.setId(5);
+ attribute.setCategoryBean(category);
+ }
+ if ("attribute_value".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Attribute Value".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setAttributeValue(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("ActionPolicyDictionary")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ ActionPolicyDict attribute = new ActionPolicyDict();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("attribute_name".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Attribute Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setAttributeName(rows[j]);
+ }
+ if ("body".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setBody(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ if ("headers".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setHeader(rows[j]);
+ }
+ if ("method".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setMethod(rows[j]);
+ }
+ if ("type".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setType(rows[j]);
+ }
+ if ("url".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setUrl(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("OnapName")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ OnapName attribute = new OnapName();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("onap_name".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Onap Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+
+ if (dictionaryName.startsWith("MSPolicyDictionary")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ MicroServiceModels attribute = new MicroServiceModels();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("modelName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Micro Service Model".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setModelName(rows[j]);
+ }
+ if ("version".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Model Version".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setVersion(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ if (DEPENDENCY.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDependency(rows[j]);
+ }
+ if ("attributes".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setAttributes(rows[j]);
+ }
+ if ("enumValues".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setEnumValues(rows[j]);
+ }
+ if ("Ref Attributes".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setRefAttributes(rows[j]);
+ }
+ if ("Sub Attributes".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setSubAttributes(rows[j]);
+ }
+ if ("annotations".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setAnnotation(rows[j]);
+ }
+ }
+
+ commonClassDao.save(attribute);
+ }
+ }
+
+ if (dictionaryName.startsWith("OptimizationPolicyDictionary")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ MicroServiceModels attribute = new MicroServiceModels();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("modelName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Optimization Service Model".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setModelName(rows[j]);
+ }
+ if ("version".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Model Version".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setVersion(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ if (DEPENDENCY.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDependency(rows[j]);
+ }
+ if ("attributes".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setAttributes(rows[j]);
+ }
+ if ("enumValues".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setEnumValues(rows[j]);
+ }
+ if ("Ref Attributes".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setRefAttributes(rows[j]);
+ }
+ if ("Sub Attributes".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setSubAttributes(rows[j]);
+ }
+ if ("annotations".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setAnnotation(rows[j]);
+ }
+ }
- private static CommonClassDao commonClassDao;
-
- @Autowired
- public DictionaryImportController(CommonClassDao commonClassDao){
- DictionaryImportController.commonClassDao = commonClassDao;
- }
-
- public DictionaryImportController(){}
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("VNFType")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ VnfType attribute = new VnfType();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("vnf_type".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "VNF Type".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setType(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("VSCLAction")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ VsclAction attribute = new VsclAction();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("vscl_action".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "VSCL Action".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setAction(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("ClosedLoopService")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ ClosedLoopD2Services attribute = new ClosedLoopD2Services();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("serviceName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Service Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setServiceName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("ClosedLoopSite")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ ClosedLoopSite attribute = new ClosedLoopSite();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("siteName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Site Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setSiteName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("PepOptions")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ PepOptions attribute = new PepOptions();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("PEP_NAME".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "PEP Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setPepName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ if ("Actions".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setActions(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("VarbindDictionary")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ VarbindDictionary attribute = new VarbindDictionary();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("varbind_Name".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Varbind Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setVarbindName(rows[j]);
+ }
+ if ("varbind_Description".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Varbind Description".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setVarbindDescription(rows[j]);
+ }
+ if ("varbind_oid".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Varbind OID".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setVarbindOid(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("BRMSParamDictionary")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ BrmsParamTemplate attribute = new BrmsParamTemplate();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("param_template_name".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Rule Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setRuleName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ if ("rule".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setRule(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("BRMSControllerDictionary")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ BrmsController attribute = new BrmsController();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("controllerName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Controller Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setControllerName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ if ("controller".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setController(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("BRMSDependencyDictionary")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ BrmsDependency attribute = new BrmsDependency();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("dependencyName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Dependency Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDependencyName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ if (DEPENDENCY.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDependency(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("Settings")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ DecisionSettings attribute = new DecisionSettings();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("xacml_id".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Settings ID".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setXacmlId(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ if ("priority".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setPriority(rows[j]);
+ }
+ if ("datatype".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Data Type".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ Datatype dataType = new Datatype();
+ if ("string".equalsIgnoreCase(rows[j])) {
+ dataType.setId(26);
+ } else if ("integer".equalsIgnoreCase(rows[j])) {
+ dataType.setId(12);
+ } else if ("double".equalsIgnoreCase(rows[j])) {
+ dataType.setId(25);
+ } else if ("boolean".equalsIgnoreCase(rows[j])) {
+ dataType.setId(18);
+ } else if ("user".equalsIgnoreCase(rows[j])) {
+ dataType.setId(29);
+ }
+ attribute.setDatatypeBean(dataType);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("PrefixList")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ PrefixList attribute = new PrefixList();
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("prefixListName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "PrefixList Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setPrefixListName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setPrefixListValue(rows[j]);
+ }
+ if ("prefixListValue".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "PrefixList Value".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("SecurityZone")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ SecurityZone attribute = new SecurityZone();
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("zoneName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Zone Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setZoneName(rows[j]);
+ }
+ if ("zoneValue".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Zone Value".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setZoneValue(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("Zone")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ Zone attribute = new Zone();
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("zoneName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Zone Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setZoneName(rows[j]);
+ }
+ if ("zoneValue".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Zone Value".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setZoneValue(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("ServiceList")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ ServiceList attribute = new ServiceList();
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("serviceName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Service Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setServiceName(rows[j]);
+ }
+ if ("serviceDesc".equalsIgnoreCase(dictSheet.get(0)[j])
+ || DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setServiceDescription(rows[j]);
+ }
+ if ("serviceType".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Service Type".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setServiceType(rows[j]);
+ }
+ if ("serviceTrasProtocol".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Transport Protocol".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setServiceTransportProtocol(rows[j]);
+ }
+ if ("serviceAppProtocol".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "APP Protocol".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setServiceAppProtocol(rows[j]);
+ }
+ if ("servicePorts".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Ports".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setServicePorts(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("ServiceGroup")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ GroupServiceList attribute = new GroupServiceList();
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("name".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Group Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setGroupName(rows[j]);
+ }
+ if ("serviceList".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Service List".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setServiceList(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("AddressGroup")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ AddressGroup attribute = new AddressGroup();
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("name".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Group Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setGroupName(rows[j]);
+ }
+ if ("serviceList".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Prefix List".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setServiceList(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("ProtocolList")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ ProtocolList attribute = new ProtocolList();
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("protocolName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Protocol Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setProtocolName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("ActionList")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ ActionList attribute = new ActionList();
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("actionName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Action Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setActionName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("TermList")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ TermList attribute = new TermList();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("termName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Term-Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setTermName(rows[j]);
+ }
+ if ("Term-Description".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "termDescription".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ if ("fromZone".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "From Zone".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setFromZone(rows[j]);
+ }
+ if ("toZone".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "To Zone".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setToZone(rows[j]);
+ }
+ if ("srcIPList".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Source-IP-List".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setSrcIpList(rows[j]);
+ }
+ if ("destIPList".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Destination-IP-List".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDestIpList(rows[j]);
+ }
+ if ("srcPortList".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Source-Port-List".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setSrcPortList(rows[j]);
+ }
+ if ("destPortList".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Destination-Port-List".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDestPortList(rows[j]);
+ }
+ if ("action".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Action List".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setAction(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ if (dictionaryName.startsWith("SearchCriteria")) {
+ for (int i = 1; i < dictSheet.size(); i++) {
+ DescriptiveScope attribute = new DescriptiveScope();
+ UserInfo userinfo = new UserInfo();
+ userinfo.setUserLoginId(userId);
+ attribute.setUserCreatedBy(userinfo);
+ attribute.setUserModifiedBy(userinfo);
+ String[] rows = dictSheet.get(i);
+ for (int j = 0; j < rows.length; j++) {
+ if ("descriptiveScopeName".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Descriptive Scope Name".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setScopeName(rows[j]);
+ }
+ if (DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setDescription(rows[j]);
+ }
+ if ("search".equalsIgnoreCase(dictSheet.get(0)[j])
+ || "Search Criteria".equalsIgnoreCase(dictSheet.get(0)[j])) {
+ attribute.setSearch(rows[j]);
+ }
+ }
+ commonClassDao.save(attribute);
+ }
+ }
+ csvReader.close();
+ response.setStatus(HttpServletResponse.SC_OK);
+ response.getWriter().write("Success");
+ } catch (Exception e) {
+ LOGGER.error("Exception Occured while importing dictionary" + e);
+ response.setStatus(HttpServletResponse.SC_INTERNAL_SERVER_ERROR);
+ response.getWriter().write(ERROR);
+ } finally {
+ if (file != null && file.exists()) {
+ boolean deleted = file.delete();
+ LOGGER.error("Imported File has been deleted: " + deleted);
+ }
+ }
+ }
- @RequestMapping(value={"/dictionary/import_dictionary"}, method={org.springframework.web.bind.annotation.RequestMethod.POST})
- public void ImportDictionaryData(HttpServletRequest request, HttpServletResponse response) throws Exception{
- ObjectMapper mapper = new ObjectMapper();
- mapper.configure(DeserializationFeature.FAIL_ON_UNKNOWN_PROPERTIES, false);
- //JsonNode root = mapper.readTree(request.getReader());
- String userId = request.getParameter("userId");
- String dictionaryName = request.getParameter("dictionaryName");
+ public boolean isValidDictionaryName(String dictionaryName) {
- File file = new File(dictionaryName);
- OutputStream outputStream = new FileOutputStream(file);
- IOUtils.copy(request.getInputStream(), outputStream);
- outputStream.close();
- this.newFile = file.toString();
- CSVReader csvReader = new CSVReader(new FileReader(this.newFile));
- List<String[]> dictSheet = csvReader.readAll();
- if(dictionaryName.startsWith("Attribute")){
- for(int i = 1; i< dictSheet.size(); i++){
- Attribute attribute = new Attribute("");
- UserInfo userinfo = new UserInfo();
- userinfo.setUserLoginId(userId);
- attribute.setUserCreatedBy(userinfo);
- attribute.setUserModifiedBy(userinfo);
- String[] rows = dictSheet.get(i);
- for (int j=0 ; j<rows.length; j++ ){
- if(dictSheet.get(0)[j].equalsIgnoreCase("xacml_id") || dictSheet.get(0)[j].equalsIgnoreCase("Attribute ID")){
- attribute.setXacmlId(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("description")){
- attribute.setDescription(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("priority")){
- attribute.setPriority(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("datatype") || dictSheet.get(0)[j].equalsIgnoreCase("Data Type")){
- Datatype dataType = new Datatype();
- if(rows[j].equalsIgnoreCase("string")){
- dataType.setId(26);
- }else if(rows[j].equalsIgnoreCase("integer")){
- dataType.setId(12);
- }else if(rows[j].equalsIgnoreCase("double")){
- dataType.setId(25);
- }else if(rows[j].equalsIgnoreCase("boolean")){
- dataType.setId(18);
- }else if(rows[j].equalsIgnoreCase("user")){
- dataType.setId(29);
- }
- attribute.setDatatypeBean(dataType);
- Category category = new Category();
- category.setId(5);
- attribute.setCategoryBean(category);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("attribute_value") || dictSheet.get(0)[j].equalsIgnoreCase("Attribute Value")){
- attribute.setAttributeValue(rows[j]);
- }
- }
- commonClassDao.save(attribute);
- }
- }
- if(dictionaryName.startsWith("ActionPolicyDictionary")){
- for(int i = 1; i< dictSheet.size(); i++){
- ActionPolicyDict attribute = new ActionPolicyDict("", userId);
- UserInfo userinfo = new UserInfo();
- userinfo.setUserLoginId(userId);
- attribute.setUserCreatedBy(userinfo);
- attribute.setUserModifiedBy(userinfo);
- String[] rows = dictSheet.get(i);
- for (int j=0 ; j<rows.length; j++ ){
- if(dictSheet.get(0)[j].equalsIgnoreCase("attribute_name") || dictSheet.get(0)[j].equalsIgnoreCase("Attribute Name")){
- attribute.setAttributeName(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("body")){
- attribute.setBody(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("description")){
- attribute.setDescription(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("headers")){
- attribute.setHeader(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("method")){
- attribute.setMethod(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("type")){
- attribute.setMethod(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("url")){
- attribute.setMethod(rows[j]);
- }
- }
- commonClassDao.save(attribute);
- }
- }
- if(dictionaryName.startsWith("OnapName")){
- for(int i = 1; i< dictSheet.size(); i++){
- OnapName attribute = new OnapName("", userId);
- UserInfo userinfo = new UserInfo();
- userinfo.setUserLoginId(userId);
- attribute.setUserCreatedBy(userinfo);
- attribute.setUserModifiedBy(userinfo);
- String[] rows = dictSheet.get(i);
- for (int j=0 ; j<rows.length; j++ ){
- if(dictSheet.get(0)[j].equalsIgnoreCase("onap_name") || dictSheet.get(0)[j].equalsIgnoreCase("Onap Name")){
- attribute.setOnapName(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("description")){
- attribute.setDescription(rows[j]);
- }
- }
- commonClassDao.save(attribute);
- }
- }
- if(dictionaryName.startsWith("VNFType")){
- for(int i = 1; i< dictSheet.size(); i++){
- VNFType attribute = new VNFType("", userId);
- UserInfo userinfo = new UserInfo();
- userinfo.setUserLoginId(userId);
- attribute.setUserCreatedBy(userinfo);
- attribute.setUserModifiedBy(userinfo);
- String[] rows = dictSheet.get(i);
- for (int j=0 ; j<rows.length; j++ ){
- if(dictSheet.get(0)[j].equalsIgnoreCase("vnf_type") || dictSheet.get(0)[j].equalsIgnoreCase("VNF Type")){
- attribute.setVnftype(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("description")){
- attribute.setDescription(rows[j]);
- }
- }
- commonClassDao.save(attribute);
- }
- }
- if(dictionaryName.startsWith("VSCLAction")){
- for(int i = 1; i< dictSheet.size(); i++){
- VSCLAction attribute = new VSCLAction("", userId);
- UserInfo userinfo = new UserInfo();
- userinfo.setUserLoginId(userId);
- attribute.setUserCreatedBy(userinfo);
- attribute.setUserModifiedBy(userinfo);
- String[] rows = dictSheet.get(i);
- for (int j=0 ; j<rows.length; j++ ){
- if(dictSheet.get(0)[j].equalsIgnoreCase("vscl_action") || dictSheet.get(0)[j].equalsIgnoreCase("VSCL Action")){
- attribute.setVsclaction(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("description")){
- attribute.setDescription(rows[j]);
- }
- }
- commonClassDao.save(attribute);
- }
- }
- if(dictionaryName.startsWith("PEPOptions")){
- for(int i = 1; i< dictSheet.size(); i++){
- PEPOptions attribute = new PEPOptions("", userId);
- UserInfo userinfo = new UserInfo();
- userinfo.setUserLoginId(userId);
- attribute.setUserCreatedBy(userinfo);
- attribute.setUserModifiedBy(userinfo);
- String[] rows = dictSheet.get(i);
- for (int j=0 ; j<rows.length; j++ ){
- if(dictSheet.get(0)[j].equalsIgnoreCase("PEP_NAME") || dictSheet.get(0)[j].equalsIgnoreCase("PEP Name")){
- attribute.setPepName(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("description")){
- attribute.setDescription(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("Actions")){
- attribute.setActions(rows[j]);
- }
- }
- commonClassDao.save(attribute);
- }
- }
- if(dictionaryName.startsWith("VarbindDictionary")){
- for(int i = 1; i< dictSheet.size(); i++){
- VarbindDictionary attribute = new VarbindDictionary("", userId);
- UserInfo userinfo = new UserInfo();
- userinfo.setUserLoginId(userId);
- attribute.setUserCreatedBy(userinfo);
- attribute.setUserModifiedBy(userinfo);
- String[] rows = dictSheet.get(i);
- for (int j=0 ; j<rows.length; j++ ){
- if(dictSheet.get(0)[j].equalsIgnoreCase("varbind_Name") || dictSheet.get(0)[j].equalsIgnoreCase("Varbind Name")){
- attribute.setVarbindName(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("varbind_Description") || dictSheet.get(0)[j].equalsIgnoreCase("Varbind Description")){
- attribute.setVarbindDescription(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("varbind_oid") || dictSheet.get(0)[j].equalsIgnoreCase("Varbind OID")){
- attribute.setVarbindOID(rows[j]);
- }
- }
- commonClassDao.save(attribute);
- }
- }
- if(dictionaryName.startsWith("BRMSParamDictionary")){
- for(int i = 1; i< dictSheet.size(); i++){
- BRMSParamTemplate attribute = new BRMSParamTemplate();
- UserInfo userinfo = new UserInfo();
- userinfo.setUserLoginId(userId);
- attribute.setUserCreatedBy(userinfo);
- String[] rows = dictSheet.get(i);
- for (int j=0 ; j<rows.length; j++ ){
- if(dictSheet.get(0)[j].equalsIgnoreCase("param_template_name") || dictSheet.get(0)[j].equalsIgnoreCase("Rule Name")){
- attribute.setRuleName(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("DESCRIPTION") || dictSheet.get(0)[j].equalsIgnoreCase("Description")){
- attribute.setDescription(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("rule")){
- attribute.setRule(rows[j]);
- }
- }
- commonClassDao.save(attribute);
- }
- }
- if(dictionaryName.startsWith("Settings")){
- for(int i = 1; i< dictSheet.size(); i++){
- DecisionSettings attribute = new DecisionSettings("", userId);
- UserInfo userinfo = new UserInfo();
- userinfo.setUserLoginId(userId);
- attribute.setUserCreatedBy(userinfo);
- attribute.setUserModifiedBy(userinfo);
- String[] rows = dictSheet.get(i);
- for (int j=0 ; j<rows.length; j++ ){
- if(dictSheet.get(0)[j].equalsIgnoreCase("xacml_id") || dictSheet.get(0)[j].equalsIgnoreCase("Settings ID")){
- attribute.setXacmlId(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("description")){
- attribute.setDescription(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("priority")){
- attribute.setPriority(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("datatype") || dictSheet.get(0)[j].equalsIgnoreCase("Data Type")){
- Datatype dataType = new Datatype();
- if(rows[j].equalsIgnoreCase("string")){
- dataType.setId(26);
- }else if(rows[j].equalsIgnoreCase("integer")){
- dataType.setId(12);
- }else if(rows[j].equalsIgnoreCase("double")){
- dataType.setId(25);
- }else if(rows[j].equalsIgnoreCase("boolean")){
- dataType.setId(18);
- }else if(rows[j].equalsIgnoreCase("user")){
- dataType.setId(29);
- }
- attribute.setDatatypeBean(dataType);
- }
- }
- commonClassDao.save(attribute);
- }
- }
- if(dictionaryName.startsWith("PrefixList")){
- for(int i = 1; i< dictSheet.size(); i++){
- PrefixList attribute = new PrefixList("", userId);
- String[] rows = dictSheet.get(i);
- for (int j=0 ; j<rows.length; j++ ){
- if(dictSheet.get(0)[j].equalsIgnoreCase("prefixListName") || dictSheet.get(0)[j].equalsIgnoreCase("PrefixList Name")){
- attribute.setPrefixListName(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("description")){
- attribute.setPrefixListValue(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("prefixListValue") || dictSheet.get(0)[j].equalsIgnoreCase("PrefixList Value")){
- attribute.setDescription(rows[j]);
- }
- }
- commonClassDao.save(attribute);
- }
- }
- if(dictionaryName.startsWith("SecurityZone")){
- for(int i = 1; i< dictSheet.size(); i++){
- SecurityZone attribute = new SecurityZone("", userId);
- String[] rows = dictSheet.get(i);
- for (int j=0 ; j<rows.length; j++ ){
- if(dictSheet.get(0)[j].equalsIgnoreCase("zoneName") || dictSheet.get(0)[j].equalsIgnoreCase("Zone Name")){
- attribute.setZoneName(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("zoneValue") || dictSheet.get(0)[j].equalsIgnoreCase("Zone Value")){
- attribute.setZoneValue(rows[j]);
- }
- }
- commonClassDao.save(attribute);
- }
- }
- if(dictionaryName.startsWith("Zone")){
- for(int i = 1; i< dictSheet.size(); i++){
- Zone attribute = new Zone("", userId);
- String[] rows = dictSheet.get(i);
- for (int j=0 ; j<rows.length; j++ ){
- if(dictSheet.get(0)[j].equalsIgnoreCase("zoneName") || dictSheet.get(0)[j].equalsIgnoreCase("Zone Name")){
- attribute.setZoneName(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("zoneValue") || dictSheet.get(0)[j].equalsIgnoreCase("Zone Value")){
- attribute.setZoneValue(rows[j]);
- }
- }
- commonClassDao.save(attribute);
- }
- }
- if(dictionaryName.startsWith("ServiceList")){
- for(int i = 1; i< dictSheet.size(); i++){
- ServiceList attribute = new ServiceList("", userId);
- String[] rows = dictSheet.get(i);
- for (int j=0 ; j<rows.length; j++ ){
- if(dictSheet.get(0)[j].equalsIgnoreCase("serviceName") || dictSheet.get(0)[j].equalsIgnoreCase("Service Name")){
- attribute.setServiceName(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("serviceDesc") || dictSheet.get(0)[j].equalsIgnoreCase("Description")){
- attribute.setServiceDescription(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("serviceType") || dictSheet.get(0)[j].equalsIgnoreCase("Service Type")){
- attribute.setServiceType(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("serviceTrasProtocol") || dictSheet.get(0)[j].equalsIgnoreCase("Transport Protocol")){
- attribute.setServiceTransProtocol(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("serviceAppProtocol") || dictSheet.get(0)[j].equalsIgnoreCase("APP Protocol")){
- attribute.setServiceAppProtocol(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("servicePorts") || dictSheet.get(0)[j].equalsIgnoreCase("Ports")){
- attribute.setServicePorts(rows[j]);
- }
- }
- commonClassDao.save(attribute);
- }
- }
- if(dictionaryName.startsWith("ServiceGroup")){
- for(int i = 1; i< dictSheet.size(); i++){
- GroupServiceList attribute = new GroupServiceList("", userId);
- String[] rows = dictSheet.get(i);
- for (int j=0 ; j<rows.length; j++ ){
- if(dictSheet.get(0)[j].equalsIgnoreCase("name") || dictSheet.get(0)[j].equalsIgnoreCase("Group Name")){
- attribute.setGroupName(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("serviceList") || dictSheet.get(0)[j].equalsIgnoreCase("Service List")){
- attribute.setServiceList(rows[j]);
- }
- }
- commonClassDao.save(attribute);
- }
- }
- if(dictionaryName.startsWith("AddressGroup")){
- for(int i = 1; i< dictSheet.size(); i++){
- AddressGroup attribute = new AddressGroup("", userId);
- String[] rows = dictSheet.get(i);
- for (int j=0 ; j<rows.length; j++ ){
- if(dictSheet.get(0)[j].equalsIgnoreCase("name") || dictSheet.get(0)[j].equalsIgnoreCase("Group Name")){
- attribute.setGroupName(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("serviceList") || dictSheet.get(0)[j].equalsIgnoreCase("Prefix List")){
- attribute.setServiceList(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("description")){
- attribute.setDescription(rows[j]);
- }
- }
- commonClassDao.save(attribute);
- }
- }
- if(dictionaryName.startsWith("ProtocolList")){
- for(int i = 1; i< dictSheet.size(); i++){
- ProtocolList attribute = new ProtocolList("", userId);
- String[] rows = dictSheet.get(i);
- for (int j=0 ; j<rows.length; j++ ){
- if(dictSheet.get(0)[j].equalsIgnoreCase("protocolName") || dictSheet.get(0)[j].equalsIgnoreCase("Protocol Name")){
- attribute.setProtocolName(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("description")){
- attribute.setDescription(rows[j]);
- }
- }
- commonClassDao.save(attribute);
- }
- }
- if(dictionaryName.startsWith("ActionList")){
- for(int i = 1; i< dictSheet.size(); i++){
- ActionList attribute = new ActionList("", userId);
- String[] rows = dictSheet.get(i);
- for (int j=0 ; j<rows.length; j++ ){
- if(dictSheet.get(0)[j].equalsIgnoreCase("actionName") || dictSheet.get(0)[j].equalsIgnoreCase("Action Name")){
- attribute.setActionName(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("description")){
- attribute.setDescription(rows[j]);
- }
- }
- commonClassDao.save(attribute);
- }
- }
- if(dictionaryName.startsWith("TermList")){
- for(int i = 1; i< dictSheet.size(); i++){
- TermList attribute = new TermList("", userId);
- UserInfo userinfo = new UserInfo();
- userinfo.setUserLoginId(userId);
- attribute.setUserCreatedBy(userinfo);
- attribute.setUserModifiedBy(userinfo);
- String[] rows = dictSheet.get(i);
- for (int j=0 ; j<rows.length; j++ ){
- if(dictSheet.get(0)[j].equalsIgnoreCase("termName") || dictSheet.get(0)[j].equalsIgnoreCase("Term-Name")){
- attribute.setTermName(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("Term-Description") || dictSheet.get(0)[j].equalsIgnoreCase("termDescription")){
- attribute.setDescription(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("fromZone") || dictSheet.get(0)[j].equalsIgnoreCase("From Zone")){
- attribute.setFromZones(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("toZone") || dictSheet.get(0)[j].equalsIgnoreCase("To Zone")){
- attribute.setToZones(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("srcIPList") || dictSheet.get(0)[j].equalsIgnoreCase("Source-IP-List")){
- attribute.setSrcIPList(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("destIPList") || dictSheet.get(0)[j].equalsIgnoreCase("Destination-IP-List")){
- attribute.setDestIPList(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("srcPortList") || dictSheet.get(0)[j].equalsIgnoreCase("Source-Port-List")){
- attribute.setSrcPortList(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("destPortList") || dictSheet.get(0)[j].equalsIgnoreCase("Destination-Port-List")){
- attribute.setDestPortList(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("action") || dictSheet.get(0)[j].equalsIgnoreCase("Action List")){
- attribute.setAction(rows[j]);
- }
- }
- commonClassDao.save(attribute);
- }
- }
- if(dictionaryName.startsWith("SearchCriteria")){
- for(int i = 1; i< dictSheet.size(); i++){
- DescriptiveScope attribute = new DescriptiveScope("", userId);
- UserInfo userinfo = new UserInfo();
- userinfo.setUserLoginId(userId);
- attribute.setUserCreatedBy(userinfo);
- attribute.setUserModifiedBy(userinfo);
- String[] rows = dictSheet.get(i);
- for (int j=0 ; j<rows.length; j++ ){
- if(dictSheet.get(0)[j].equalsIgnoreCase("descriptiveScopeName") || dictSheet.get(0)[j].equalsIgnoreCase("Descriptive ScopeName")){
- attribute.setScopeName(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("description")){
- attribute.setDescription(rows[j]);
- }
- if(dictSheet.get(0)[j].equalsIgnoreCase("search") || dictSheet.get(0)[j].equalsIgnoreCase("Search Criteria")){
- attribute.setSearch(rows[j]);
- }
- }
- commonClassDao.save(attribute);
- }
- }
- csvReader.close();
- if(file.exists()){
- file.delete();
- }
- }
+ String nameCheck = dictionaryName.replace(".csv", "");
+ try {
+ DictionaryNames mode = DictionaryNames.valueOf(nameCheck);
+ switch (mode) {
+ case Attribute:
+ case ActionPolicyDictionary:
+ case OnapName:
+ case MSPolicyDictionary:
+ case OptimizationPolicyDictionary:
+ case VNFType:
+ case VSCLAction:
+ case ClosedLoopService:
+ case ClosedLoopSite:
+ case PepOptions:
+ case VarbindDictionary:
+ case BRMSParamDictionary:
+ case BRMSControllerDictionary:
+ case BRMSDependencyDictionary:
+ case Settings:
+ case PrefixList:
+ case SecurityZone:
+ case Zone:
+ case ServiceList:
+ case ServiceGroup:
+ case AddressGroup:
+ case ProtocolList:
+ case ActionList:
+ case TermList:
+ case SearchCriteria:
+ return true;
+ default:
+ return false;
+ }
+ } catch (Exception e) {
+ LOGGER.error("Dictionary not exits: " + dictionaryName + e);
+ return false;
+ }
+ }
}
Code Review / policy / engine.git / blobdiff