ecomp-sdk-app/src/main/java/org/openecomp/policy/daoImp/PolicyEditorScopesDaoImpl.java

   1 /*-
   2  * ============LICENSE_START=======================================================
   3  * ECOMP Policy Engine
   4  * ================================================================================
   5  * Copyright (C) 2017 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.openecomp.policy.daoImp;
  22
  23
  24 import java.util.ArrayList;
  25 import java.util.List;
  26
  27 import org.apache.commons.logging.Log;
  28 import org.apache.commons.logging.LogFactory;
  29 import org.hibernate.Criteria;
  30 import org.hibernate.Query;
  31 import org.hibernate.Session;
  32 import org.hibernate.SessionFactory;
  33 import org.hibernate.Transaction;
  34 import org.openecomp.policy.dao.PolicyEditorScopesDao;
  35 import org.openecomp.policy.rest.jpa.PolicyEditorScopes;
  36 import org.springframework.beans.factory.annotation.Autowired;
  37 import org.springframework.stereotype.Service;
  38
  39 import org.openecomp.policy.xacml.api.XACMLErrorConstants;
  40
  41 @Service("PolicyEditorScopesDao")
  42 public class PolicyEditorScopesDaoImpl implements PolicyEditorScopesDao {
  43         private static final Log logger = LogFactory.getLog(PolicyEditorScopesDaoImpl.class);
  44         @Autowired
  45         SessionFactory sessionfactory;
  46
  47         @SuppressWarnings("unchecked")
  48         @Override
  49         public List<PolicyEditorScopes> getPolicyEditorScopesData() {
  50                 Session session = sessionfactory.openSession();
  51                 Transaction tx = session.beginTransaction();
  52                 List<PolicyEditorScopes> scopeNameData = null;
  53                 try {
  54                         Criteria cr = session.createCriteria(PolicyEditorScopes.class);
  55                         scopeNameData = cr.list();
  56                         tx.commit();
  57                 } catch (Exception e) {
  58                         logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying PolicyEditorScopes Table"+e);
  59                 }finally{
  60                         try{
  61                                 session.close();
  62                         }catch(Exception e1){
  63                                 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
  64                         }
  65                 }
  66                 return scopeNameData;
  67         }
  68
  69         @SuppressWarnings("unchecked")
  70         @Override
  71         public List<String> getPolicyEditorScopesDataByName() {
  72                 Session session = sessionfactory.openSession();
  73                 Transaction tx = session.beginTransaction();
  74                 List<String> data = new ArrayList<String>();
  75                 try {
  76                         Criteria cr = session.createCriteria(PolicyEditorScopes.class);
  77                         List<PolicyEditorScopes> scopeNameData = cr.list();
  78                         for(int i = 0; i < scopeNameData.size(); i++){
  79                                 data.add(scopeNameData.get(i).getScopeName());
  80                         }
  81                         tx.commit();
  82                 } catch (Exception e) {
  83                         logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying PolicyEditorScopes Table"+e);
  84                 }finally{
  85                         try{
  86                                 session.close();
  87                         }catch(Exception e1){
  88                                 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
  89                         }
  90                 }
  91                 return data;
  92         }
  93
  94         @Override
  95         public void Save(PolicyEditorScopes policyEditorScopes) {
  96                 Session session = sessionfactory.openSession();
  97                 Transaction tx = session.beginTransaction();
  98                 try {
  99                         session.persist(policyEditorScopes);
 100                         tx.commit();
 101                 }catch(Exception e){
 102                         logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Saving PolicyEditorScopes Table"+e);
 103                 }finally{
 104                         try{
 105                                 session.close();
 106                         }catch(Exception e1){
 107                                 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
 108                         }
 109                 }
 110
 111         }
 112
 113         @Override
 114         public void delete(PolicyEditorScopes policyEditorScopes) {
 115                 Session session = sessionfactory.openSession();
 116                 Transaction tx = session.beginTransaction();
 117                 try {
 118                         session.delete(policyEditorScopes);
 119                         tx.commit();
 120                 }catch(Exception e){
 121                         logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Deleting PolicyEditorScopes Table"+e);
 122                 }finally{
 123                         try{
 124                                 session.close();
 125                         }catch(Exception e1){
 126                                 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
 127                         }
 128                 }
 129
 130         }
 131
 132         @Override
 133         public void update(PolicyEditorScopes policyEditorScopes) {
 134                 Session session = sessionfactory.openSession();
 135                 Transaction tx = session.beginTransaction();
 136                 try {
 137                         session.update(policyEditorScopes);
 138                         tx.commit();
 139                 }catch(Exception e){
 140                         logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating PolicyEditorScopes Table"+e);
 141                 }finally{
 142                         try{
 143                                 session.close();
 144                         }catch(Exception e1){
 145                                 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
 146                         }
 147                 }
 148
 149         }
 150
 151         @SuppressWarnings("unchecked")
 152         @Override
 153         public List<PolicyEditorScopes> getListOfPolicyScopes(String query) {
 154                 Session session = sessionfactory.openSession();
 155                 Transaction tx = session.beginTransaction();
 156                 List<PolicyEditorScopes> data = null;
 157                 try {
 158                         Query hbquery = session.createQuery(query);
 159                         data = hbquery.list();
 160                         tx.commit();
 161                 } catch (Exception e) {
 162                         logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying PolicyEditorScopes Table"+e);
 163                 }finally{
 164                         try{
 165                                 session.close();
 166                         }catch(Exception e1){
 167                                 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
 168                         }
 169                 }
 170                 return data;
 171         }
 172
 173         @Override
 174         public void updateQuery(String policyScopeQuery) {
 175                 Session session = sessionfactory.openSession();
 176                 Transaction tx = session.beginTransaction();
 177                 try {
 178                         Query hbquery = session.createQuery(policyScopeQuery);
 179                         hbquery.executeUpdate();
 180                         tx.commit();
 181                 } catch (Exception e) {
 182                         logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating PolicyEditorScopes Table"+e);
 183                 }finally{
 184                         try{
 185                                 session.close();
 186                         }catch(Exception e1){
 187                                 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
 188                         }
 189                 }
 190
 191         }
 192
 193 }