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.onap.policy.pap.xacml.rest.daoimpl;
23 import java.util.List;
26 import javax.script.SimpleBindings;
28 import org.apache.commons.logging.Log;
29 import org.apache.commons.logging.LogFactory;
30 import org.hibernate.Criteria;
31 import org.hibernate.Query;
32 import org.hibernate.Session;
33 import org.hibernate.SessionFactory;
34 import org.hibernate.Transaction;
35 import org.hibernate.criterion.Conjunction;
36 import org.hibernate.criterion.Criterion;
37 import org.hibernate.criterion.Disjunction;
38 import org.hibernate.criterion.Projections;
39 import org.hibernate.criterion.Restrictions;
40 import org.onap.policy.rest.dao.CommonClassDao;
41 import org.onap.policy.rest.jpa.ClosedLoops;
42 import org.onap.policy.rest.jpa.GroupPolicyScopeList;
43 import org.onap.policy.rest.jpa.PolicyRoles;
44 import org.onap.policy.xacml.api.XACMLErrorConstants;
45 import org.springframework.beans.factory.annotation.Autowired;
46 import org.springframework.stereotype.Service;
48 @Service("CommonClassDao")
49 public class CommonClassDaoImpl implements CommonClassDao{
51 private static final Log LOGGER = LogFactory.getLog(CommonClassDaoImpl.class);
54 private static SessionFactory sessionFactory;
57 private CommonClassDaoImpl(SessionFactory sessionFactory){
58 CommonClassDaoImpl.sessionFactory = sessionFactory;
61 public CommonClassDaoImpl(){
65 @SuppressWarnings({ "unchecked", "rawtypes" })
67 public List<Object> getData(Class className) {
68 Session session = sessionFactory.openSession();
69 List<Object> data = null;
71 Criteria cr = session.createCriteria(className);
74 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
79 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e);
86 @SuppressWarnings({ "rawtypes", "unchecked" })
88 public List<Object> getDataById(Class className, String columnName, String key) {
89 Session session = sessionFactory.openSession();
90 List<Object> data = null;
92 Criteria cr = session.createCriteria(className);
93 if(columnName.contains(":") && key.contains(":")){
94 String[] columns = columnName.split(":");
95 String[] keys = key.split(":");
96 for(int i=0; i < columns.length; i++){
97 cr.add(Restrictions.eq(columns[i], keys[i]));
100 cr.add(Restrictions.eq(columnName, key));
103 } catch (Exception e) {
104 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
108 }catch(Exception e1){
109 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
115 @SuppressWarnings({ "unchecked", "rawtypes" })
117 public List<String> getDataByColumn(Class className, String columnName) {
118 Session session = sessionFactory.openSession();
119 List<String> data = null;
121 Criteria cr = session.createCriteria(className);
122 cr.setProjection(Projections.property(columnName));
125 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
130 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e);
137 public void save(Object entity) {
138 Session session = sessionFactory.openSession();
139 Transaction tx = session.beginTransaction();
141 session.persist(entity);
144 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Saving data to Table"+e);
148 }catch(Exception e1){
149 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
156 public void delete(Object entity) {
157 Session session = sessionFactory.openSession();
158 Transaction tx = session.beginTransaction();
160 session.delete(entity);
163 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Deleting data from Table"+e);
167 }catch(Exception e1){
168 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
176 public void update(Object entity) {
177 Session session = sessionFactory.openSession();
178 Transaction tx = session.beginTransaction();
180 session.update(entity);
183 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating data to Table"+e);
187 }catch(Exception e1){
188 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
195 @SuppressWarnings({ "unchecked", "rawtypes" })
197 public List<Object> checkDuplicateEntry(String value, String columnName, Class className) {
198 Session session = sessionFactory.openSession();
199 Transaction tx = session.beginTransaction();
200 List<Object> data = null;
202 String[] columnNames = null;
203 if(columnName != null && columnName.contains(":")){
204 columnNames = columnName.split(":");
206 String[] values = null;
207 if(value != null && value.contains(":")){
208 values = value.split(":");
211 Criteria cr = session.createCriteria(className);
212 if(columnNames != null && values != null && columnNames.length == values.length){
213 for (int i = 0; i < columnNames.length; i++){
214 cr.add(Restrictions.eq(columnNames[i],values[i]));
217 cr.add(Restrictions.eq(columnName,value));
222 } catch (Exception e) {
223 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying for Duplicate Entries for Table"+e + className);
227 }catch(Exception e1){
228 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
235 @SuppressWarnings("unchecked")
237 public List<Object> getDataByQuery(String query, SimpleBindings params) {
238 Session session = sessionFactory.openSession();
239 Transaction tx = session.beginTransaction();
240 List<Object> data = null;
242 Query hbquery = session.createQuery(query);
243 for (Map.Entry<String, Object> paramPair : params.entrySet()) {
244 hbquery.setParameter(paramPair.getKey(), paramPair.getValue());
246 data = hbquery.list();
248 } catch (Exception e) {
249 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Database Table"+e);
254 }catch(Exception e1){
255 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
264 public void updateQuery(String query) {
265 Session session = sessionFactory.openSession();
266 Transaction tx = session.beginTransaction();
268 Query hbquery = session.createQuery(query);
269 hbquery.executeUpdate();
271 } catch (Exception e) {
272 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating Database Table"+e);
276 }catch(Exception e1){
277 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
283 @SuppressWarnings("rawtypes")
285 public Object getEntityItem(Class className, String columnName, String key) {
286 Session session = sessionFactory.openSession();
287 Transaction tx = session.beginTransaction();
290 Criteria cr = session.createCriteria(className);
291 if(columnName.contains(":") && key.contains(":")){
292 String[] columns = columnName.split(":");
293 String[] keys = key.split(":");
294 for(int i=0; i < columns.length; i++){
295 cr.add(Restrictions.eq(columns[i], keys[i]));
298 cr.add(Restrictions.eq(columnName, key));
300 data = cr.list().get(0);
302 } catch (Exception e) {
303 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Database Table"+e);
307 }catch(Exception e1){
308 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
315 @SuppressWarnings("unchecked")
317 public List<PolicyRoles> getUserRoles() {
318 Session session = sessionFactory.openSession();
319 Transaction tx = session.beginTransaction();
320 List<PolicyRoles> rolesData = null;
322 Criteria cr = session.createCriteria(PolicyRoles.class);
323 Disjunction disjunction = Restrictions.disjunction();
324 Conjunction conjunction1 = Restrictions.conjunction();
325 conjunction1.add(Restrictions.eq("role", "admin"));
326 Conjunction conjunction2 = Restrictions.conjunction();
327 conjunction2.add(Restrictions.eq("role", "editor"));
328 Conjunction conjunction3 = Restrictions.conjunction();
329 conjunction3.add(Restrictions.eq("role", "guest"));
330 disjunction.add(conjunction1);
331 disjunction.add(conjunction2);
332 disjunction.add(conjunction3);
333 rolesData = cr.add(disjunction).list();
335 } catch (Exception e) {
336 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying PolicyRoles Table"+e);
340 }catch(Exception e1){
341 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
348 @SuppressWarnings("unchecked")
350 public void updateClAlarms(String clName, String alarms) {
351 Session session = sessionFactory.openSession();
352 List<ClosedLoops> closedloopsdata = null;
353 Transaction tx = session.beginTransaction();
355 Criteria cr = session.createCriteria(ClosedLoops.class);
356 cr.add(Restrictions.eq("closedLoopControlName",clName));
357 closedloopsdata = cr.list();
358 ClosedLoops closedloop = closedloopsdata.get(0);
359 closedloop.setAlarmConditions(alarms);
360 session.update(closedloop);
363 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating ClosedLoops Table"+e);
370 @SuppressWarnings("unchecked")
372 public void updateClYaml(String clName, String yaml) {
373 Session session = sessionFactory.openSession();
374 List<ClosedLoops> closedloopsdata = null;
375 Transaction tx = session.beginTransaction();
377 Criteria cr = session.createCriteria(ClosedLoops.class);
378 cr.add(Restrictions.eq("closedLoopControlName",clName));
379 closedloopsdata = cr.list();
380 ClosedLoops closedloop = closedloopsdata.get(0);
381 closedloop.setYaml(yaml);
382 session.update(closedloop);
385 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating ClosedLoops Table"+e);
392 @SuppressWarnings("unchecked")
394 public void deleteAll() {
395 Session session = sessionFactory.openSession();
396 Transaction tx = session.beginTransaction();
397 List<ClosedLoops> closedloopsdata = null;
399 Criteria cr = session.createCriteria(ClosedLoops.class);
400 closedloopsdata = cr.list();
402 if(closedloopsdata!=null && !closedloopsdata.isEmpty()) {
403 LOGGER.info("ClosedLoops exist in the database, we need to delete them in our first step to buildCache().");
404 for(int i=0; i < closedloopsdata.size(); i++) {
405 ClosedLoops cl = closedloopsdata.get(i);
409 LOGGER.info("No ClosedLoops exist in the database, no need to delete.");
413 }catch(Exception e) {
414 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error while deleting ClosedLoops from the table"+e);
420 @SuppressWarnings({ "unchecked"})
422 public List<Object> checkExistingGroupListforUpdate(String groupListValue, String groupNameValue) {
423 Session session = sessionFactory.openSession();
424 Transaction tx = session.beginTransaction();
425 List<Object> data = null;
427 Criteria cr = session.createCriteria(GroupPolicyScopeList.class);
428 cr.add(Restrictions.eq("groupList",groupListValue));
429 Criterion expression = Restrictions.eq("name", groupNameValue);
430 cr.add(Restrictions.not(expression));
433 } catch (Exception e) {
434 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying for Duplicate Entries for GroupPolicyScopeList Table"+e);
438 }catch(Exception e1){
439 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
447 public List<Object> getMultipleDataOnAddingConjunction(@SuppressWarnings("rawtypes") Class className, String columnName, List<String> data) {