ONAP-PAP-REST/src/main/java/org/onap/policy/pap/xacml/rest/controller/DictionaryImportController.java

   1 /*-
   2  * ============LICENSE_START=======================================================
   3  * ONAP-PAP-REST
   4  * ================================================================================
   5  * Copyright (C) 2017-2018 AT&T Intellectual Property. All rights reserved.
   6  * ================================================================================
   7  * Licensed under the Apache License, Version 2.0 (the "License");
   8  * you may not use this file except in compliance with the License.
   9  * You may obtain a copy of the License at
  10  *
  11  *      http://www.apache.org/licenses/LICENSE-2.0
  12  *
  13  * Unless required by applicable law or agreed to in writing, software
  14  * distributed under the License is distributed on an "AS IS" BASIS,
  15  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  16  * See the License for the specific language governing permissions and
  17  * limitations under the License.
  18  * ============LICENSE_END=========================================================
  19  */
  20
  21 package org.onap.policy.pap.xacml.rest.controller;
  22
  23 import java.io.File;
  24 import java.io.FileOutputStream;
  25 import java.io.FileReader;
  26 import java.io.IOException;
  27 import java.io.OutputStream;
  28 import java.util.List;
  29
  30 import javax.servlet.http.HttpServletRequest;
  31 import javax.servlet.http.HttpServletResponse;
  32
  33 import org.apache.commons.compress.utils.IOUtils;
  34 import org.onap.policy.common.logging.flexlogger.FlexLogger;
  35 import org.onap.policy.common.logging.flexlogger.Logger;
  36 import org.onap.policy.pap.xacml.rest.DictionaryNames;
  37 import org.onap.policy.rest.dao.CommonClassDao;
  38 import org.onap.policy.rest.jpa.ActionList;
  39 import org.onap.policy.rest.jpa.ActionPolicyDict;
  40 import org.onap.policy.rest.jpa.AddressGroup;
  41 import org.onap.policy.rest.jpa.Attribute;
  42 import org.onap.policy.rest.jpa.BRMSController;
  43 import org.onap.policy.rest.jpa.BRMSDependency;
  44 import org.onap.policy.rest.jpa.BRMSParamTemplate;
  45 import org.onap.policy.rest.jpa.Category;
  46 import org.onap.policy.rest.jpa.ClosedLoopD2Services;
  47 import org.onap.policy.rest.jpa.ClosedLoopSite;
  48 import org.onap.policy.rest.jpa.Datatype;
  49 import org.onap.policy.rest.jpa.DecisionSettings;
  50 import org.onap.policy.rest.jpa.DescriptiveScope;
  51 import org.onap.policy.rest.jpa.GroupServiceList;
  52 import org.onap.policy.rest.jpa.MicroServiceModels;
  53 import org.onap.policy.rest.jpa.OnapName;
  54 import org.onap.policy.rest.jpa.PEPOptions;
  55 import org.onap.policy.rest.jpa.PrefixList;
  56 import org.onap.policy.rest.jpa.ProtocolList;
  57 import org.onap.policy.rest.jpa.SecurityZone;
  58 import org.onap.policy.rest.jpa.ServiceList;
  59 import org.onap.policy.rest.jpa.TermList;
  60 import org.onap.policy.rest.jpa.UserInfo;
  61 import org.onap.policy.rest.jpa.VNFType;
  62 import org.onap.policy.rest.jpa.VSCLAction;
  63 import org.onap.policy.rest.jpa.VarbindDictionary;
  64 import org.onap.policy.rest.jpa.Zone;
  65 import org.springframework.beans.factory.annotation.Autowired;
  66 import org.springframework.stereotype.Controller;
  67 import org.springframework.web.bind.annotation.RequestMapping;
  68 import org.springframework.web.bind.annotation.RequestMethod;
  69
  70 import com.fasterxml.jackson.databind.DeserializationFeature;
  71 import com.fasterxml.jackson.databind.ObjectMapper;
  72
  73 import au.com.bytecode.opencsv.CSVReader;
  74
  75
  76 @Controller
  77 public class DictionaryImportController {
  78     private static final Logger LOGGER  = FlexLogger.getLogger(DictionaryImportController.class);
  79
  80     private static CommonClassDao commonClassDao;
  81     private static final String DESCRIPTION= "description";
  82     private static final String ERROR= "Error";
  83     private static final String DEPENDENCY= "dependency";
  84
  85     @Autowired
  86     public DictionaryImportController(CommonClassDao commonClassDao){
  87         setCommonClassDao(commonClassDao);
  88     }
  89
  90     public static void setCommonClassDao(CommonClassDao commonClassDao) {
  91         DictionaryImportController.commonClassDao = commonClassDao;
  92     }
  93
  94     public DictionaryImportController(){
  95         super();
  96     }
  97
  98     @RequestMapping(value={"/dictionary/import_dictionary"}, method={RequestMethod.POST})
  99     public void importDictionaryData(HttpServletRequest request, HttpServletResponse response) throws IOException{
 100         ObjectMapper mapper = new ObjectMapper();
 101         mapper.configure(DeserializationFeature.FAIL_ON_UNKNOWN_PROPERTIES, false);
 102         String userId = request.getParameter("userId");
 103         String dictionaryName = request.getParameter("dictionaryName");
 104
 105         if(dictionaryName == null || dictionaryName.isEmpty()){
 106             LOGGER.error("dictionaryName is null/empty");
 107             response.setStatus(HttpServletResponse.SC_BAD_REQUEST);
 108             response.getWriter().write(ERROR);
 109             return;
 110         }
 111
 112         // fix Fortify Path Manipulation issue
 113         if(!isValidDictionaryName(dictionaryName)){
 114             LOGGER.error("dictionaryName is invalid");
 115             response.setStatus(HttpServletResponse.SC_BAD_REQUEST);
 116             response.getWriter().write(ERROR);
 117             return;
 118         }
 119         File file = new File(dictionaryName);
 120         try(OutputStream outputStream = new FileOutputStream(file); FileReader fileReader = new FileReader(file.toString())){
 121             IOUtils.copy(request.getInputStream(), outputStream);
 122             CSVReader csvReader = new CSVReader(fileReader);
 123             List<String[]> dictSheet = csvReader.readAll();
 124             if(dictionaryName.startsWith("Attribute")){
 125                 for(int i = 1; i< dictSheet.size(); i++){
 126                     Attribute attribute = new Attribute("");
 127                     UserInfo userinfo = new UserInfo();
 128                     userinfo.setUserLoginId(userId);
 129                     attribute.setUserCreatedBy(userinfo);
 130                     attribute.setUserModifiedBy(userinfo);
 131                     String[] rows = dictSheet.get(i);
 132                     for (int j=0 ; j<rows.length; j++ ){
 133                         if("xacml_id".equalsIgnoreCase(dictSheet.get(0)[j]) || "Attribute ID".equalsIgnoreCase(dictSheet.get(0)[j])){
 134                             attribute.setXacmlId(rows[j]);
 135                         }
 136                         if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 137                             attribute.setDescription(rows[j]);
 138                         }
 139                         if("priority".equalsIgnoreCase(dictSheet.get(0)[j])){
 140                             attribute.setPriority(rows[j]);
 141                         }
 142                         if("datatype".equalsIgnoreCase(dictSheet.get(0)[j]) || "Data Type".equalsIgnoreCase(dictSheet.get(0)[j])){
 143                             Datatype dataType = new Datatype();
 144                             if("string".equalsIgnoreCase(rows[j])){
 145                                 dataType.setId(26);
 146                             }else if("integer".equalsIgnoreCase(rows[j])){
 147                                 dataType.setId(12);
 148                             }else if("double".equalsIgnoreCase(rows[j])){
 149                                 dataType.setId(25);
 150                             }else if("boolean".equalsIgnoreCase(rows[j])){
 151                                 dataType.setId(18);
 152                             }else if("user".equalsIgnoreCase(rows[j])){
 153                                 dataType.setId(29);
 154                             }
 155                             attribute.setDatatypeBean(dataType);
 156                             Category category = new Category();
 157                             category.setId(5);
 158                             attribute.setCategoryBean(category);
 159                         }
 160                         if("attribute_value".equalsIgnoreCase(dictSheet.get(0)[j]) || "Attribute Value".equalsIgnoreCase(dictSheet.get(0)[j])){
 161                             attribute.setAttributeValue(rows[j]);
 162                         }
 163                     }
 164                     commonClassDao.save(attribute);
 165                 }
 166             }
 167             if(dictionaryName.startsWith("ActionPolicyDictionary")){
 168                 for(int i = 1; i< dictSheet.size(); i++){
 169                     ActionPolicyDict attribute = new ActionPolicyDict();
 170                     UserInfo userinfo = new UserInfo();
 171                     userinfo.setUserLoginId(userId);
 172                     attribute.setUserCreatedBy(userinfo);
 173                     attribute.setUserModifiedBy(userinfo);
 174                     String[] rows = dictSheet.get(i);
 175                     for (int j=0 ; j<rows.length; j++ ){
 176                         if("attribute_name".equalsIgnoreCase(dictSheet.get(0)[j]) || "Attribute Name".equalsIgnoreCase(dictSheet.get(0)[j])){
 177                             attribute.setAttributeName(rows[j]);
 178                         }
 179                         if("body".equalsIgnoreCase(dictSheet.get(0)[j])){
 180                             attribute.setBody(rows[j]);
 181                         }
 182                         if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 183                             attribute.setDescription(rows[j]);
 184                         }
 185                         if("headers".equalsIgnoreCase(dictSheet.get(0)[j])){
 186                             attribute.setHeader(rows[j]);
 187                         }
 188                         if("method".equalsIgnoreCase(dictSheet.get(0)[j])){
 189                             attribute.setMethod(rows[j]);
 190                         }
 191                         if("type".equalsIgnoreCase(dictSheet.get(0)[j])){
 192                             attribute.setType(rows[j]);
 193                         }
 194                         if("url".equalsIgnoreCase(dictSheet.get(0)[j])){
 195                             attribute.setUrl(rows[j]);
 196                         }
 197                     }
 198                     commonClassDao.save(attribute);
 199                 }
 200             }
 201             if(dictionaryName.startsWith("OnapName")){
 202                 for(int i = 1; i< dictSheet.size(); i++){
 203                     OnapName attribute = new OnapName();
 204                     UserInfo userinfo = new UserInfo();
 205                     userinfo.setUserLoginId(userId);
 206                     attribute.setUserCreatedBy(userinfo);
 207                     attribute.setUserModifiedBy(userinfo);
 208                     String[] rows = dictSheet.get(i);
 209                     for (int j=0 ; j<rows.length; j++ ){
 210                         if("onap_name".equalsIgnoreCase(dictSheet.get(0)[j]) || "Onap Name".equalsIgnoreCase(dictSheet.get(0)[j])){
 211                             attribute.setOnapName(rows[j]);
 212                         }
 213                         if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 214                             attribute.setDescription(rows[j]);
 215                         }
 216                     }
 217                     commonClassDao.save(attribute);
 218                 }
 219             }
 220
 221             if(dictionaryName.startsWith("MSPolicyDictionary")){
 222                 for(int i = 1; i< dictSheet.size(); i++){
 223                     MicroServiceModels attribute = new MicroServiceModels();
 224                     UserInfo userinfo = new UserInfo();
 225                     userinfo.setUserLoginId(userId);
 226                     attribute.setUserCreatedBy(userinfo);
 227                     String[] rows = dictSheet.get(i);
 228                     for (int j=0 ; j<rows.length; j++ ){
 229                         if("modelName".equalsIgnoreCase(dictSheet.get(0)[j]) || "Micro Service Model".equalsIgnoreCase(dictSheet.get(0)[j])){
 230                             attribute.setModelName(rows[j]);
 231                         }
 232                         if("version".equalsIgnoreCase(dictSheet.get(0)[j]) || "Model Version".equalsIgnoreCase(dictSheet.get(0)[j])){
 233                             attribute.setVersion(rows[j]);
 234                         }
 235                         if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 236                             attribute.setDescription(rows[j]);
 237                         }
 238                         if(DEPENDENCY.equalsIgnoreCase(dictSheet.get(0)[j])){
 239                             attribute.setDependency(rows[j]);
 240                         }
 241                         if("attributes".equalsIgnoreCase(dictSheet.get(0)[j])){
 242                             attribute.setAttributes(rows[j]);
 243                         }
 244                         if("enumValues".equalsIgnoreCase(dictSheet.get(0)[j])){
 245                             attribute.setEnumValues(rows[j]);
 246                         }
 247                         if("Ref Attributes".equalsIgnoreCase(dictSheet.get(0)[j])){
 248                             attribute.setRef_attributes(rows[j]);
 249                         }
 250                         if("Sub Attributes".equalsIgnoreCase(dictSheet.get(0)[j])){
 251                             attribute.setSub_attributes(rows[j]);
 252                         }
 253                         if("annotations".equalsIgnoreCase(dictSheet.get(0)[j])) {
 254                             attribute.setAnnotation(rows[j]);
 255                         }
 256                     }
 257
 258                     commonClassDao.save(attribute);
 259                 }
 260             }
 261
 262             if(dictionaryName.startsWith("OptimizationPolicyDictionary")){
 263                 for(int i = 1; i< dictSheet.size(); i++){
 264                     MicroServiceModels attribute = new MicroServiceModels();
 265                     UserInfo userinfo = new UserInfo();
 266                     userinfo.setUserLoginId(userId);
 267                     attribute.setUserCreatedBy(userinfo);
 268                     String[] rows = dictSheet.get(i);
 269                     for (int j=0 ; j<rows.length; j++ ){
 270                         if("modelName".equalsIgnoreCase(dictSheet.get(0)[j]) || "Optimization Service Model".equalsIgnoreCase(dictSheet.get(0)[j])){
 271                             attribute.setModelName(rows[j]);
 272                         }
 273                         if("version".equalsIgnoreCase(dictSheet.get(0)[j]) || "Model Version".equalsIgnoreCase(dictSheet.get(0)[j])){
 274                             attribute.setVersion(rows[j]);
 275                         }
 276                         if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 277                             attribute.setDescription(rows[j]);
 278                         }
 279                         if(DEPENDENCY.equalsIgnoreCase(dictSheet.get(0)[j])){
 280                             attribute.setDependency(rows[j]);
 281                         }
 282                         if("attributes".equalsIgnoreCase(dictSheet.get(0)[j])){
 283                             attribute.setAttributes(rows[j]);
 284                         }
 285                         if("enumValues".equalsIgnoreCase(dictSheet.get(0)[j])){
 286                             attribute.setEnumValues(rows[j]);
 287                         }
 288                         if("Ref Attributes".equalsIgnoreCase(dictSheet.get(0)[j])){
 289                             attribute.setRef_attributes(rows[j]);
 290                         }
 291                         if("Sub Attributes".equalsIgnoreCase(dictSheet.get(0)[j])){
 292                             attribute.setSub_attributes(rows[j]);
 293                         }
 294                         if("annotations".equalsIgnoreCase(dictSheet.get(0)[j])) {
 295                             attribute.setAnnotation(rows[j]);
 296                         }
 297                     }
 298
 299                     commonClassDao.save(attribute);
 300                 }
 301             }
 302
 303             if(dictionaryName.startsWith("VNFType")){
 304                 for(int i = 1; i< dictSheet.size(); i++){
 305                     VNFType attribute = new VNFType();
 306                     UserInfo userinfo = new UserInfo();
 307                     userinfo.setUserLoginId(userId);
 308                     attribute.setUserCreatedBy(userinfo);
 309                     attribute.setUserModifiedBy(userinfo);
 310                     String[] rows = dictSheet.get(i);
 311                     for (int j=0 ; j<rows.length; j++ ){
 312                         if("vnf_type".equalsIgnoreCase(dictSheet.get(0)[j]) || "VNF Type".equalsIgnoreCase(dictSheet.get(0)[j])){
 313                             attribute.setVnftype(rows[j]);
 314                         }
 315                         if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 316                             attribute.setDescription(rows[j]);
 317                         }
 318                     }
 319                     commonClassDao.save(attribute);
 320                 }
 321             }
 322             if(dictionaryName.startsWith("VSCLAction")){
 323                 for(int i = 1; i< dictSheet.size(); i++){
 324                     VSCLAction attribute = new VSCLAction();
 325                     UserInfo userinfo = new UserInfo();
 326                     userinfo.setUserLoginId(userId);
 327                     attribute.setUserCreatedBy(userinfo);
 328                     attribute.setUserModifiedBy(userinfo);
 329                     String[] rows = dictSheet.get(i);
 330                     for (int j=0 ; j<rows.length; j++ ){
 331                         if("vscl_action".equalsIgnoreCase(dictSheet.get(0)[j]) || "VSCL Action".equalsIgnoreCase(dictSheet.get(0)[j])){
 332                             attribute.setVsclaction(rows[j]);
 333                         }
 334                         if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 335                             attribute.setDescription(rows[j]);
 336                         }
 337                     }
 338                     commonClassDao.save(attribute);
 339                 }
 340             }
 341             if(dictionaryName.startsWith("ClosedLoopService")){
 342                 for(int i = 1; i< dictSheet.size(); i++){
 343                     ClosedLoopD2Services attribute = new ClosedLoopD2Services();
 344                     UserInfo userinfo = new UserInfo();
 345                     userinfo.setUserLoginId(userId);
 346                     attribute.setUserCreatedBy(userinfo);
 347                     attribute.setUserModifiedBy(userinfo);
 348                     String[] rows = dictSheet.get(i);
 349                     for (int j=0 ; j<rows.length; j++ ){
 350                         if("serviceName".equalsIgnoreCase(dictSheet.get(0)[j]) || "Service Name".equalsIgnoreCase(dictSheet.get(0)[j])){
 351                             attribute.setServiceName(rows[j]);
 352                         }
 353                         if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 354                             attribute.setDescription(rows[j]);
 355                         }
 356                     }
 357                     commonClassDao.save(attribute);
 358                 }
 359             }
 360             if(dictionaryName.startsWith("ClosedLoopSite")){
 361                 for(int i = 1; i< dictSheet.size(); i++){
 362                     ClosedLoopSite attribute = new ClosedLoopSite();
 363                     UserInfo userinfo = new UserInfo();
 364                     userinfo.setUserLoginId(userId);
 365                     attribute.setUserCreatedBy(userinfo);
 366                     attribute.setUserModifiedBy(userinfo);
 367                     String[] rows = dictSheet.get(i);
 368                     for (int j=0 ; j<rows.length; j++ ){
 369                         if("siteName".equalsIgnoreCase(dictSheet.get(0)[j]) || "Site Name".equalsIgnoreCase(dictSheet.get(0)[j])){
 370                             attribute.setSiteName(rows[j]);
 371                         }
 372                         if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 373                             attribute.setDescription(rows[j]);
 374                         }
 375                     }
 376                     commonClassDao.save(attribute);
 377                 }
 378             }
 379             if(dictionaryName.startsWith("PEPOptions")){
 380                 for(int i = 1; i< dictSheet.size(); i++){
 381                     PEPOptions attribute = new PEPOptions();
 382                     UserInfo userinfo = new UserInfo();
 383                     userinfo.setUserLoginId(userId);
 384                     attribute.setUserCreatedBy(userinfo);
 385                     attribute.setUserModifiedBy(userinfo);
 386                     String[] rows = dictSheet.get(i);
 387                     for (int j=0 ; j<rows.length; j++ ){
 388                         if("PEP_NAME".equalsIgnoreCase(dictSheet.get(0)[j]) || "PEP Name".equalsIgnoreCase(dictSheet.get(0)[j])){
 389                             attribute.setPepName(rows[j]);
 390                         }
 391                         if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 392                             attribute.setDescription(rows[j]);
 393                         }
 394                         if("Actions".equalsIgnoreCase(dictSheet.get(0)[j])){
 395                             attribute.setActions(rows[j]);
 396                         }
 397                     }
 398                     commonClassDao.save(attribute);
 399                 }
 400             }
 401             if(dictionaryName.startsWith("VarbindDictionary")){
 402                 for(int i = 1; i< dictSheet.size(); i++){
 403                     VarbindDictionary attribute = new VarbindDictionary();
 404                     UserInfo userinfo = new UserInfo();
 405                     userinfo.setUserLoginId(userId);
 406                     attribute.setUserCreatedBy(userinfo);
 407                     attribute.setUserModifiedBy(userinfo);
 408                     String[] rows = dictSheet.get(i);
 409                     for (int j=0 ; j<rows.length; j++ ){
 410                         if("varbind_Name".equalsIgnoreCase(dictSheet.get(0)[j]) || "Varbind Name".equalsIgnoreCase(dictSheet.get(0)[j])){
 411                             attribute.setVarbindName(rows[j]);
 412                         }
 413                         if("varbind_Description".equalsIgnoreCase(dictSheet.get(0)[j]) || "Varbind Description".equalsIgnoreCase(dictSheet.get(0)[j])){
 414                             attribute.setVarbindDescription(rows[j]);
 415                         }
 416                         if("varbind_oid".equalsIgnoreCase(dictSheet.get(0)[j]) || "Varbind OID".equalsIgnoreCase(dictSheet.get(0)[j])){
 417                             attribute.setVarbindOID(rows[j]);
 418                         }
 419                     }
 420                     commonClassDao.save(attribute);
 421                 }
 422             }
 423             if(dictionaryName.startsWith("BRMSParamDictionary")){
 424                 for(int i = 1; i< dictSheet.size(); i++){
 425                     BRMSParamTemplate attribute = new BRMSParamTemplate();
 426                     UserInfo userinfo = new UserInfo();
 427                     userinfo.setUserLoginId(userId);
 428                     attribute.setUserCreatedBy(userinfo);
 429                     String[] rows = dictSheet.get(i);
 430                     for (int j=0 ; j<rows.length; j++ ){
 431                         if("param_template_name".equalsIgnoreCase(dictSheet.get(0)[j]) || "Rule Name".equalsIgnoreCase(dictSheet.get(0)[j])){
 432                             attribute.setRuleName(rows[j]);
 433                         }
 434                         if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 435                             attribute.setDescription(rows[j]);
 436                         }
 437                         if("rule".equalsIgnoreCase(dictSheet.get(0)[j])){
 438                             attribute.setRule(rows[j]);
 439                         }
 440                     }
 441                     commonClassDao.save(attribute);
 442                 }
 443             }
 444             if(dictionaryName.startsWith("BRMSControllerDictionary")){
 445                 for(int i = 1; i< dictSheet.size(); i++){
 446                     BRMSController attribute = new BRMSController();
 447                     UserInfo userinfo = new UserInfo();
 448                     userinfo.setUserLoginId(userId);
 449                     attribute.setUserCreatedBy(userinfo);
 450                     String[] rows = dictSheet.get(i);
 451                     for (int j=0 ; j<rows.length; j++ ){
 452                         if("controllerName".equalsIgnoreCase(dictSheet.get(0)[j]) || "Controller Name".equalsIgnoreCase(dictSheet.get(0)[j])){
 453                             attribute.setControllerName(rows[j]);
 454                         }
 455                         if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 456                             attribute.setDescription(rows[j]);
 457                         }
 458                         if("controller".equalsIgnoreCase(dictSheet.get(0)[j])){
 459                             attribute.setController(rows[j]);
 460                         }
 461                     }
 462                     commonClassDao.save(attribute);
 463                 }
 464             }
 465             if(dictionaryName.startsWith("BRMSDependencyDictionary")){
 466                 for(int i = 1; i< dictSheet.size(); i++){
 467                     BRMSDependency attribute = new BRMSDependency();
 468                     UserInfo userinfo = new UserInfo();
 469                     userinfo.setUserLoginId(userId);
 470                     attribute.setUserCreatedBy(userinfo);
 471                     String[] rows = dictSheet.get(i);
 472                     for (int j=0 ; j<rows.length; j++ ){
 473                         if("dependencyName".equalsIgnoreCase(dictSheet.get(0)[j]) || "Dependency Name".equalsIgnoreCase(dictSheet.get(0)[j])){
 474                             attribute.setDependencyName(rows[j]);
 475                         }
 476                         if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 477                             attribute.setDescription(rows[j]);
 478                         }
 479                         if(DEPENDENCY.equalsIgnoreCase(dictSheet.get(0)[j])){
 480                             attribute.setDependency(rows[j]);
 481                         }
 482                     }
 483                     commonClassDao.save(attribute);
 484                 }
 485             }
 486             if(dictionaryName.startsWith("Settings")){
 487                 for(int i = 1; i< dictSheet.size(); i++){
 488                     DecisionSettings attribute = new DecisionSettings();
 489                     UserInfo userinfo = new UserInfo();
 490                     userinfo.setUserLoginId(userId);
 491                     attribute.setUserCreatedBy(userinfo);
 492                     attribute.setUserModifiedBy(userinfo);
 493                     String[] rows = dictSheet.get(i);
 494                     for (int j=0 ; j<rows.length; j++ ){
 495                         if("xacml_id".equalsIgnoreCase(dictSheet.get(0)[j]) || "Settings ID".equalsIgnoreCase(dictSheet.get(0)[j])){
 496                             attribute.setXacmlId(rows[j]);
 497                         }
 498                         if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 499                             attribute.setDescription(rows[j]);
 500                         }
 501                         if("priority".equalsIgnoreCase(dictSheet.get(0)[j])){
 502                             attribute.setPriority(rows[j]);
 503                         }
 504                         if("datatype".equalsIgnoreCase(dictSheet.get(0)[j]) || "Data Type".equalsIgnoreCase(dictSheet.get(0)[j])){
 505                             Datatype dataType = new Datatype();
 506                             if("string".equalsIgnoreCase(rows[j])){
 507                                 dataType.setId(26);
 508                             }else if("integer".equalsIgnoreCase(rows[j])){
 509                                 dataType.setId(12);
 510                             }else if("double".equalsIgnoreCase(rows[j])){
 511                                 dataType.setId(25);
 512                             }else if("boolean".equalsIgnoreCase(rows[j])){
 513                                 dataType.setId(18);
 514                             }else if("user".equalsIgnoreCase(rows[j])){
 515                                 dataType.setId(29);
 516                             }
 517                             attribute.setDatatypeBean(dataType);
 518                         }
 519                     }
 520                     commonClassDao.save(attribute);
 521                 }
 522             }
 523             if(dictionaryName.startsWith("PrefixList")){
 524                 for(int i = 1; i< dictSheet.size(); i++){
 525                     PrefixList attribute = new PrefixList();
 526                     String[] rows = dictSheet.get(i);
 527                     for (int j=0 ; j<rows.length; j++ ){
 528                         if("prefixListName".equalsIgnoreCase(dictSheet.get(0)[j]) || "PrefixList Name".equalsIgnoreCase(dictSheet.get(0)[j])){
 529                             attribute.setPrefixListName(rows[j]);
 530                         }
 531                         if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 532                             attribute.setPrefixListValue(rows[j]);
 533                         }
 534                         if("prefixListValue".equalsIgnoreCase(dictSheet.get(0)[j]) || "PrefixList Value".equalsIgnoreCase(dictSheet.get(0)[j])){
 535                             attribute.setDescription(rows[j]);
 536                         }
 537                     }
 538                     commonClassDao.save(attribute);
 539                 }
 540             }
 541             if(dictionaryName.startsWith("SecurityZone")){
 542                 for(int i = 1; i< dictSheet.size(); i++){
 543                     SecurityZone attribute = new SecurityZone();
 544                     String[] rows = dictSheet.get(i);
 545                     for (int j=0 ; j<rows.length; j++ ){
 546                         if("zoneName".equalsIgnoreCase(dictSheet.get(0)[j]) || "Zone Name".equalsIgnoreCase(dictSheet.get(0)[j])){
 547                             attribute.setZoneName(rows[j]);
 548                         }
 549                         if("zoneValue".equalsIgnoreCase(dictSheet.get(0)[j])  || "Zone Value".equalsIgnoreCase(dictSheet.get(0)[j])){
 550                             attribute.setZoneValue(rows[j]);
 551                         }
 552                     }
 553                     commonClassDao.save(attribute);
 554                 }
 555             }
 556             if(dictionaryName.startsWith("Zone")){
 557                 for(int i = 1; i< dictSheet.size(); i++){
 558                     Zone attribute = new Zone();
 559                     String[] rows = dictSheet.get(i);
 560                     for (int j=0 ; j<rows.length; j++ ){
 561                         if("zoneName".equalsIgnoreCase(dictSheet.get(0)[j]) || "Zone Name".equalsIgnoreCase(dictSheet.get(0)[j])){
 562                             attribute.setZoneName(rows[j]);
 563                         }
 564                         if("zoneValue".equalsIgnoreCase(dictSheet.get(0)[j])  || "Zone Value".equalsIgnoreCase(dictSheet.get(0)[j])){
 565                             attribute.setZoneValue(rows[j]);
 566                         }
 567                     }
 568                     commonClassDao.save(attribute);
 569                 }
 570             }
 571             if(dictionaryName.startsWith("ServiceList")){
 572                 for(int i = 1; i< dictSheet.size(); i++){
 573                     ServiceList attribute = new ServiceList();
 574                     String[] rows = dictSheet.get(i);
 575                     for (int j=0 ; j<rows.length; j++ ){
 576                         if("serviceName".equalsIgnoreCase(dictSheet.get(0)[j]) || "Service Name".equalsIgnoreCase(dictSheet.get(0)[j])){
 577                             attribute.setServiceName(rows[j]);
 578                         }
 579                         if("serviceDesc".equalsIgnoreCase(dictSheet.get(0)[j])  || DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 580                             attribute.setServiceDescription(rows[j]);
 581                         }
 582                         if("serviceType".equalsIgnoreCase(dictSheet.get(0)[j])  || "Service Type".equalsIgnoreCase(dictSheet.get(0)[j])){
 583                             attribute.setServiceType(rows[j]);
 584                         }
 585                         if("serviceTrasProtocol".equalsIgnoreCase(dictSheet.get(0)[j])  || "Transport Protocol".equalsIgnoreCase(dictSheet.get(0)[j])){
 586                             attribute.setServiceTransProtocol(rows[j]);
 587                         }
 588                         if("serviceAppProtocol".equalsIgnoreCase(dictSheet.get(0)[j])  || "APP Protocol".equalsIgnoreCase(dictSheet.get(0)[j])){
 589                             attribute.setServiceAppProtocol(rows[j]);
 590                         }
 591                         if("servicePorts".equalsIgnoreCase(dictSheet.get(0)[j])  || "Ports".equalsIgnoreCase(dictSheet.get(0)[j])){
 592                             attribute.setServicePorts(rows[j]);
 593                         }
 594                     }
 595                     commonClassDao.save(attribute);
 596                 }
 597             }
 598             if(dictionaryName.startsWith("ServiceGroup")){
 599                 for(int i = 1; i< dictSheet.size(); i++){
 600                     GroupServiceList attribute = new GroupServiceList();
 601                     String[] rows = dictSheet.get(i);
 602                     for (int j=0 ; j<rows.length; j++ ){
 603                         if("name".equalsIgnoreCase(dictSheet.get(0)[j]) || "Group Name".equalsIgnoreCase(dictSheet.get(0)[j])){
 604                             attribute.setGroupName(rows[j]);
 605                         }
 606                         if("serviceList".equalsIgnoreCase(dictSheet.get(0)[j])  || "Service List".equalsIgnoreCase(dictSheet.get(0)[j])){
 607                             attribute.setServiceList(rows[j]);
 608                         }
 609                     }
 610                     commonClassDao.save(attribute);
 611                 }
 612             }
 613             if(dictionaryName.startsWith("AddressGroup")){
 614                 for(int i = 1; i< dictSheet.size(); i++){
 615                     AddressGroup attribute = new AddressGroup();
 616                     String[] rows = dictSheet.get(i);
 617                     for (int j=0 ; j<rows.length; j++ ){
 618                         if("name".equalsIgnoreCase(dictSheet.get(0)[j]) || "Group Name".equalsIgnoreCase(dictSheet.get(0)[j])){
 619                             attribute.setGroupName(rows[j]);
 620                         }
 621                         if("serviceList".equalsIgnoreCase(dictSheet.get(0)[j])  || "Prefix List".equalsIgnoreCase(dictSheet.get(0)[j])){
 622                             attribute.setServiceList(rows[j]);
 623                         }
 624                         if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 625                             attribute.setDescription(rows[j]);
 626                         }
 627                     }
 628                     commonClassDao.save(attribute);
 629                 }
 630             }
 631             if(dictionaryName.startsWith("ProtocolList")){
 632                 for(int i = 1; i< dictSheet.size(); i++){
 633                     ProtocolList attribute = new ProtocolList();
 634                     String[] rows = dictSheet.get(i);
 635                     for (int j=0 ; j<rows.length; j++ ){
 636                         if("protocolName".equalsIgnoreCase(dictSheet.get(0)[j]) || "Protocol Name".equalsIgnoreCase(dictSheet.get(0)[j])){
 637                             attribute.setProtocolName(rows[j]);
 638                         }
 639                         if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 640                             attribute.setDescription(rows[j]);
 641                         }
 642                     }
 643                     commonClassDao.save(attribute);
 644                 }
 645             }
 646             if(dictionaryName.startsWith("ActionList")){
 647                 for(int i = 1; i< dictSheet.size(); i++){
 648                     ActionList attribute = new ActionList();
 649                     String[] rows = dictSheet.get(i);
 650                     for (int j=0 ; j<rows.length; j++ ){
 651                         if("actionName".equalsIgnoreCase(dictSheet.get(0)[j]) || "Action Name".equalsIgnoreCase(dictSheet.get(0)[j])){
 652                             attribute.setActionName(rows[j]);
 653                         }
 654                         if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 655                             attribute.setDescription(rows[j]);
 656                         }
 657                     }
 658                     commonClassDao.save(attribute);
 659                 }
 660             }
 661             if(dictionaryName.startsWith("TermList")){
 662                 for(int i = 1; i< dictSheet.size(); i++){
 663                     TermList attribute = new TermList();
 664                     UserInfo userinfo = new UserInfo();
 665                     userinfo.setUserLoginId(userId);
 666                     attribute.setUserCreatedBy(userinfo);
 667                     attribute.setUserModifiedBy(userinfo);
 668                     String[] rows = dictSheet.get(i);
 669                     for (int j=0 ; j<rows.length; j++ ){
 670                         if("termName".equalsIgnoreCase(dictSheet.get(0)[j]) || "Term-Name".equalsIgnoreCase(dictSheet.get(0)[j])){
 671                             attribute.setTermName(rows[j]);
 672                         }
 673                         if("Term-Description".equalsIgnoreCase(dictSheet.get(0)[j]) || "termDescription".equalsIgnoreCase(dictSheet.get(0)[j])){
 674                             attribute.setDescription(rows[j]);
 675                         }
 676                         if("fromZone".equalsIgnoreCase(dictSheet.get(0)[j])  || "From Zone".equalsIgnoreCase(dictSheet.get(0)[j])){
 677                             attribute.setFromZones(rows[j]);
 678                         }
 679                         if("toZone".equalsIgnoreCase(dictSheet.get(0)[j]) || "To Zone".equalsIgnoreCase(dictSheet.get(0)[j])){
 680                             attribute.setToZones(rows[j]);
 681                         }
 682                         if("srcIPList".equalsIgnoreCase(dictSheet.get(0)[j]) || "Source-IP-List".equalsIgnoreCase(dictSheet.get(0)[j])){
 683                             attribute.setSrcIPList(rows[j]);
 684                         }
 685                         if("destIPList".equalsIgnoreCase(dictSheet.get(0)[j]) || "Destination-IP-List".equalsIgnoreCase(dictSheet.get(0)[j])){
 686                             attribute.setDestIPList(rows[j]);
 687                         }
 688                         if("srcPortList".equalsIgnoreCase(dictSheet.get(0)[j]) || "Source-Port-List".equalsIgnoreCase(dictSheet.get(0)[j])){
 689                             attribute.setSrcPortList(rows[j]);
 690                         }
 691                         if("destPortList".equalsIgnoreCase(dictSheet.get(0)[j]) || "Destination-Port-List".equalsIgnoreCase(dictSheet.get(0)[j])){
 692                             attribute.setDestPortList(rows[j]);
 693                         }
 694                         if("action".equalsIgnoreCase(dictSheet.get(0)[j]) || "Action List".equalsIgnoreCase(dictSheet.get(0)[j])){
 695                             attribute.setAction(rows[j]);
 696                         }
 697                     }
 698                     commonClassDao.save(attribute);
 699                 }
 700             }
 701             if(dictionaryName.startsWith("SearchCriteria")){
 702                 for(int i = 1; i< dictSheet.size(); i++){
 703                     DescriptiveScope attribute = new DescriptiveScope();
 704                     UserInfo userinfo = new UserInfo();
 705                     userinfo.setUserLoginId(userId);
 706                     attribute.setUserCreatedBy(userinfo);
 707                     attribute.setUserModifiedBy(userinfo);
 708                     String[] rows = dictSheet.get(i);
 709                     for (int j=0 ; j<rows.length; j++ ){
 710                         if("descriptiveScopeName".equalsIgnoreCase(dictSheet.get(0)[j]) || "Descriptive Scope Name".equalsIgnoreCase(dictSheet.get(0)[j])){
 711                             attribute.setScopeName(rows[j]);
 712                         }
 713                         if(DESCRIPTION.equalsIgnoreCase(dictSheet.get(0)[j])){
 714                             attribute.setDescription(rows[j]);
 715                         }
 716                         if("search".equalsIgnoreCase(dictSheet.get(0)[j]) || "Search Criteria".equalsIgnoreCase(dictSheet.get(0)[j])){
 717                             attribute.setSearch(rows[j]);
 718                         }
 719                     }
 720                     commonClassDao.save(attribute);
 721                 }
 722             }
 723             csvReader.close();
 724             response.setStatus(HttpServletResponse.SC_OK);
 725             response.getWriter().write("Success");
 726         }catch(Exception e){
 727             LOGGER.error("Exception Occured while importing dictionary"+e);
 728             response.setStatus(HttpServletResponse.SC_INTERNAL_SERVER_ERROR);
 729             response.getWriter().write(ERROR);
 730         }finally{
 731             if(file != null && file.exists()){
 732                 boolean deleted = file.delete();
 733                 LOGGER.error("Imported File has been deleted: "+deleted);
 734             }
 735         }
 736     }
 737
 738     public boolean isValidDictionaryName(String dictionaryName){
 739
 740         String nameCheck = dictionaryName.replace(".csv", "");
 741         try{
 742             DictionaryNames mode = DictionaryNames.valueOf(nameCheck);
 743             switch (mode){
 744                 case Attribute:
 745                 case ActionPolicyDictionary:
 746                 case OnapName:
 747                 case MSPolicyDictionary:
 748                 case OptimizationPolicyDictionary:
 749                 case VNFType:
 750                 case VSCLAction:
 751                 case ClosedLoopService:
 752                 case ClosedLoopSite:
 753                 case PEPOptions:
 754                 case VarbindDictionary:
 755                 case BRMSParamDictionary:
 756                 case BRMSControllerDictionary:
 757                 case BRMSDependencyDictionary:
 758                 case Settings:
 759                 case PrefixList:
 760                 case SecurityZone:
 761                 case Zone:
 762                 case ServiceList:
 763                 case ServiceGroup:
 764                 case AddressGroup:
 765                 case ProtocolList:
 766                 case ActionList:
 767                 case TermList:
 768                 case SearchCriteria:
 769                     return true;
 770                 default:
 771                     return false;
 772             }
 773         }catch(Exception e){
 774             LOGGER.error("Dictionary not exits: " +dictionaryName +e);
 775             return false;
 776         }
 777     }
 778 }