Initial OpenECOMP policy/engine commit
[policy/engine.git] / ecomp-sdk-app / src / main / java / org / openecomp / policy / daoImp / ActionPolicyDictDaoImpl.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.Session;
31 import org.hibernate.SessionFactory;
32 import org.hibernate.Transaction;
33 import org.hibernate.criterion.Restrictions;
34 import org.openecomp.policy.rest.dao.ActionPolicyDictDao;
35 import org.openecomp.policy.rest.jpa.ActionPolicyDict;
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 import org.openecomp.policy.common.logging.flexlogger.FlexLogger; 
42 import org.openecomp.policy.common.logging.flexlogger.Logger;
43
44 @Service("ActionPolicyDictDao")
45 public class ActionPolicyDictDaoImpl implements ActionPolicyDictDao {
46         private static final Logger logger = FlexLogger.getLogger(ActionPolicyDictDaoImpl.class);
47         @Autowired
48         SessionFactory sessionfactory;
49         
50         @SuppressWarnings("unchecked")
51         @Override
52         public List<ActionPolicyDict> getActionDictData() {
53                 Session session = sessionfactory.openSession();
54                 Transaction tx = session.beginTransaction();
55                 
56         List<ActionPolicyDict> actionDictData = null;
57         try {
58                 Criteria cr = session.createCriteria(ActionPolicyDict.class);
59                 actionDictData = cr.list();
60                         tx.commit();
61                 } catch (Exception e) {
62                         logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying ActionDictionary Table"+e); 
63                 }finally{
64                         try{
65                                 session.close();
66                         }catch(Exception e1){
67                                 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
68                         }
69                 }
70                 return actionDictData;
71         }
72
73         @Override
74         public void Save(ActionPolicyDict action) {
75                 Session session = sessionfactory.openSession();
76                 Transaction tx = session.beginTransaction();
77                 try {
78                         session.persist(action);
79                         tx.commit();    
80                 }catch(Exception e){
81                         logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Saving ActionDictionary Table"+e);   
82                 }finally{
83                         try{
84                                 session.close();
85                         }catch(Exception e1){
86                                 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
87                         }
88                 }
89         }
90
91         @Override
92         public void delete(ActionPolicyDict action) {
93                 Session session = sessionfactory.openSession();
94                 Transaction tx = session.beginTransaction();
95                 try {
96                         session.delete(action);
97                         tx.commit();    
98                 }catch(Exception e){
99                         logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Deleting ActionDictionary Table"+e); 
100                 }finally{
101                         try{
102                                 session.close();
103                         }catch(Exception e1){
104                                 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
105                         }
106                 }
107         }
108
109         @Override
110         public void update(ActionPolicyDict action) {
111                 Session session = sessionfactory.openSession();
112                 Transaction tx = session.beginTransaction();
113                 try {
114                         session.update(action);
115                         tx.commit();    
116                 }catch(Exception e){
117                         logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating ActionDictionary Table"+e); 
118                 }finally{
119                         try{
120                                 session.close();
121                         }catch(Exception e1){
122                                 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
123                         }
124                 }
125                 
126         }
127
128         @SuppressWarnings("unchecked")
129         @Override
130         public List<String> getActionDictDataByName() {
131                 Session session = sessionfactory.openSession();
132                 Transaction tx = session.beginTransaction();
133                 List<String> data = new ArrayList<String>();
134                 try {
135                         Criteria cr = session.createCriteria(ActionPolicyDict.class);
136                         List<ActionPolicyDict> attributeData = cr.list();  
137                         for(int i = 0; i < attributeData.size(); i++){
138                                 data.add(attributeData.get(i).getAttributeName());
139                         }       
140                         tx.commit();                    
141                 } catch (Exception e) {
142                         logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying ActionDictionary Table"+e);                 
143                 }finally{
144                         try{
145                                 session.close();
146                         }catch(Exception e1){
147                                 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
148                         }
149                 }
150                 return data;
151         }
152
153         @SuppressWarnings("unchecked")
154         @Override
155         public ActionPolicyDict getActionEntityDatabyId(String action) {
156                 Session session = sessionfactory.openSession();
157                 Transaction tx = session.beginTransaction();
158                 ActionPolicyDict data = null;
159                 try {
160                         Criteria cr = session.createCriteria(ActionPolicyDict.class);   
161                         List<ActionPolicyDict> attributeData = cr.add(Restrictions.eq("attributeName", action)).list();
162                         for(Object entity : attributeData){
163                                 data = (ActionPolicyDict) entity;
164                         }               
165                         tx.commit();                    
166                 } catch (Exception e) {
167                         logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying ActionDictionary Table"+e);         
168                 }finally{
169                         try{
170                                 session.close();
171                         }catch(Exception e1){
172                                 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
173                         }
174                 }
175                 return data;
176         }
177
178 }