2 * ============LICENSE_START=======================================================
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
11 * http://www.apache.org/licenses/LICENSE-2.0
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=========================================================
21 package org.openecomp.policy.daoImp;
24 import java.util.ArrayList;
25 import java.util.List;
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;
39 import org.openecomp.policy.xacml.api.XACMLErrorConstants;
41 @Service("PolicyEditorScopesDao")
42 public class PolicyEditorScopesDaoImpl implements PolicyEditorScopesDao {
43 private static final Log logger = LogFactory.getLog(PolicyEditorScopesDaoImpl.class);
45 SessionFactory sessionfactory;
47 @SuppressWarnings("unchecked")
49 public List<PolicyEditorScopes> getPolicyEditorScopesData() {
50 Session session = sessionfactory.openSession();
51 Transaction tx = session.beginTransaction();
52 List<PolicyEditorScopes> scopeNameData = null;
54 Criteria cr = session.createCriteria(PolicyEditorScopes.class);
55 scopeNameData = cr.list();
57 } catch (Exception e) {
58 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying PolicyEditorScopes Table"+e);
63 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
69 @SuppressWarnings("unchecked")
71 public List<String> getPolicyEditorScopesDataByName() {
72 Session session = sessionfactory.openSession();
73 Transaction tx = session.beginTransaction();
74 List<String> data = new ArrayList<String>();
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());
82 } catch (Exception e) {
83 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying PolicyEditorScopes Table"+e);
88 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
95 public void Save(PolicyEditorScopes policyEditorScopes) {
96 Session session = sessionfactory.openSession();
97 Transaction tx = session.beginTransaction();
99 session.persist(policyEditorScopes);
102 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Saving PolicyEditorScopes Table"+e);
106 }catch(Exception e1){
107 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
114 public void delete(PolicyEditorScopes policyEditorScopes) {
115 Session session = sessionfactory.openSession();
116 Transaction tx = session.beginTransaction();
118 session.delete(policyEditorScopes);
121 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Deleting PolicyEditorScopes Table"+e);
125 }catch(Exception e1){
126 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
133 public void update(PolicyEditorScopes policyEditorScopes) {
134 Session session = sessionfactory.openSession();
135 Transaction tx = session.beginTransaction();
137 session.update(policyEditorScopes);
140 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating PolicyEditorScopes Table"+e);
144 }catch(Exception e1){
145 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
151 @SuppressWarnings("unchecked")
153 public List<PolicyEditorScopes> getListOfPolicyScopes(String query) {
154 Session session = sessionfactory.openSession();
155 Transaction tx = session.beginTransaction();
156 List<PolicyEditorScopes> data = null;
158 Query hbquery = session.createQuery(query);
159 data = hbquery.list();
161 } catch (Exception e) {
162 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying PolicyEditorScopes Table"+e);
166 }catch(Exception e1){
167 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
174 public void updateQuery(String policyScopeQuery) {
175 Session session = sessionfactory.openSession();
176 Transaction tx = session.beginTransaction();
178 Query hbquery = session.createQuery(policyScopeQuery);
179 hbquery.executeUpdate();
181 } catch (Exception e) {
182 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating PolicyEditorScopes Table"+e);
186 }catch(Exception e1){
187 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);