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.HibernateException;
32 import org.hibernate.Query;
33 import org.hibernate.Session;
34 import org.hibernate.SessionFactory;
35 import org.hibernate.Transaction;
36 import org.hibernate.criterion.Conjunction;
37 import org.hibernate.criterion.Criterion;
38 import org.hibernate.criterion.Disjunction;
39 import org.hibernate.criterion.Projections;
40 import org.hibernate.criterion.Restrictions;
41 import org.onap.policy.rest.dao.CommonClassDao;
42 import org.onap.policy.rest.jpa.ClosedLoops;
43 import org.onap.policy.rest.jpa.GroupPolicyScopeList;
44 import org.onap.policy.rest.jpa.PolicyRoles;
45 import org.onap.policy.xacml.api.XACMLErrorConstants;
46 import org.springframework.beans.factory.annotation.Autowired;
47 import org.springframework.context.annotation.Primary;
48 import org.springframework.stereotype.Component;
49 import org.springframework.stereotype.Service;
51 @Service("CommonClassDao")
53 public class CommonClassDaoImpl implements CommonClassDao{
55 private static final Log LOGGER = LogFactory.getLog(CommonClassDaoImpl.class);
58 private static SessionFactory sessionFactory;
62 private CommonClassDaoImpl(SessionFactory sessionFactory){
63 CommonClassDaoImpl.sessionFactory = sessionFactory;
66 public CommonClassDaoImpl(){
70 @SuppressWarnings({ "unchecked", "rawtypes" })
72 public List<Object> getData(Class className) {
73 Session session = sessionFactory.openSession();
74 List<Object> data = null;
76 Criteria cr = session.createCriteria(className);
79 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
84 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e);
91 @SuppressWarnings({ "rawtypes", "unchecked" })
93 public List<Object> getDataById(Class className, String columnName, String key) {
94 Session session = sessionFactory.openSession();
95 List<Object> data = null;
97 Criteria cr = session.createCriteria(className);
98 if(columnName.contains(":") && key.contains(":")){
99 String[] columns = columnName.split(":");
100 String[] keys = key.split(":");
101 for(int i=0; i < columns.length; i++){
102 cr.add(Restrictions.eq(columns[i], keys[i]));
105 cr.add(Restrictions.eq(columnName, key));
108 } catch (Exception e) {
109 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
113 }catch(Exception e1){
114 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
120 @SuppressWarnings({ "unchecked", "rawtypes" })
122 public List<String> getDataByColumn(Class className, String columnName) {
123 Session session = sessionFactory.openSession();
124 List<String> data = null;
126 Criteria cr = session.createCriteria(className);
127 cr.setProjection(Projections.property(columnName));
130 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
135 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e);
142 public void save(Object entity) {
143 Session session = sessionFactory.openSession();
144 Transaction tx = session.beginTransaction();
146 session.persist(entity);
149 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Saving data to Table"+e);
153 }catch(Exception e1){
154 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
161 public void delete(Object entity) {
162 Session session = sessionFactory.openSession();
163 Transaction tx = session.beginTransaction();
165 session.delete(entity);
168 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Deleting data from Table"+e);
172 }catch(Exception e1){
173 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
181 public void update(Object entity) {
182 Session session = sessionFactory.openSession();
183 Transaction tx = session.beginTransaction();
185 session.update(entity);
188 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating data to Table"+e);
192 }catch(Exception e1){
193 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
200 @SuppressWarnings({ "unchecked", "rawtypes" })
202 public List<Object> checkDuplicateEntry(String value, String columnName, Class className) {
203 Session session = sessionFactory.openSession();
204 Transaction tx = session.beginTransaction();
205 List<Object> data = null;
207 String[] columnNames = null;
208 if(columnName != null && columnName.contains(":")){
209 columnNames = columnName.split(":");
211 String[] values = null;
212 if(value != null && value.contains(":")){
213 values = value.split(":");
216 Criteria cr = session.createCriteria(className);
217 if(columnNames != null && values != null && columnNames.length == values.length){
218 for (int i = 0; i < columnNames.length; i++){
219 cr.add(Restrictions.eq(columnNames[i],values[i]));
222 cr.add(Restrictions.eq(columnName,value));
227 } catch (Exception e) {
228 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying for Duplicate Entries for Table"+e + className);
232 }catch(Exception e1){
233 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
240 @SuppressWarnings("unchecked")
242 public List<Object> getDataByQuery(String query, SimpleBindings params) {
243 Session session = sessionFactory.openSession();
244 Transaction tx = session.beginTransaction();
245 List<Object> data = null;
247 Query hbquery = session.createQuery(query);
248 for (Map.Entry<String, Object> paramPair : params.entrySet()) {
249 if(paramPair.getValue() instanceof java.lang.Long){
250 hbquery.setLong(paramPair.getKey(), (long) paramPair.getValue());
253 hbquery.setParameter(paramPair.getKey(), paramPair.getValue());
256 data = hbquery.list();
258 } catch (Exception e) {
259 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Database Table"+e);
264 }catch(HibernateException e1){
265 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement",e1);
273 public void updateQuery(String query) {
274 Session session = sessionFactory.openSession();
275 Transaction tx = session.beginTransaction();
277 Query hbquery = session.createQuery(query);
278 hbquery.executeUpdate();
280 } catch (Exception e) {
281 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating Database Table"+e);
285 }catch(Exception e1){
286 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
292 @SuppressWarnings("rawtypes")
294 public Object getEntityItem(Class className, String columnName, String key) {
295 Session session = sessionFactory.openSession();
296 Transaction tx = session.beginTransaction();
299 Criteria cr = session.createCriteria(className);
300 if(columnName.contains(":") && key.contains(":")){
301 String[] columns = columnName.split(":");
302 String[] keys = key.split(":");
303 for(int i=0; i < columns.length; i++){
304 cr.add(Restrictions.eq(columns[i], keys[i]));
307 cr.add(Restrictions.eq(columnName, key));
309 data = cr.list().get(0);
311 } catch (Exception e) {
312 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Database Table"+e);
316 }catch(Exception e1){
317 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
324 @SuppressWarnings("unchecked")
326 public List<PolicyRoles> getUserRoles() {
327 Session session = sessionFactory.openSession();
328 Transaction tx = session.beginTransaction();
329 List<PolicyRoles> rolesData = null;
331 Criteria cr = session.createCriteria(PolicyRoles.class);
332 Disjunction disjunction = Restrictions.disjunction();
333 Conjunction conjunction1 = Restrictions.conjunction();
334 conjunction1.add(Restrictions.eq("role", "admin"));
335 Conjunction conjunction2 = Restrictions.conjunction();
336 conjunction2.add(Restrictions.eq("role", "editor"));
337 Conjunction conjunction3 = Restrictions.conjunction();
338 conjunction3.add(Restrictions.eq("role", "guest"));
339 disjunction.add(conjunction1);
340 disjunction.add(conjunction2);
341 disjunction.add(conjunction3);
342 rolesData = cr.add(disjunction).list();
344 } catch (Exception e) {
345 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying PolicyRoles Table"+e);
349 }catch(Exception e1){
350 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
357 @SuppressWarnings("unchecked")
359 public void updateClAlarms(String clName, String alarms) {
360 Session session = sessionFactory.openSession();
361 List<ClosedLoops> closedloopsdata = null;
362 Transaction tx = session.beginTransaction();
364 Criteria cr = session.createCriteria(ClosedLoops.class);
365 cr.add(Restrictions.eq("closedLoopControlName",clName));
366 closedloopsdata = cr.list();
367 ClosedLoops closedloop = closedloopsdata.get(0);
368 closedloop.setAlarmConditions(alarms);
369 session.update(closedloop);
372 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating ClosedLoops Table"+e);
379 @SuppressWarnings("unchecked")
381 public void updateClYaml(String clName, String yaml) {
382 Session session = sessionFactory.openSession();
383 List<ClosedLoops> closedloopsdata = null;
384 Transaction tx = session.beginTransaction();
386 Criteria cr = session.createCriteria(ClosedLoops.class);
387 cr.add(Restrictions.eq("closedLoopControlName",clName));
388 closedloopsdata = cr.list();
389 ClosedLoops closedloop = closedloopsdata.get(0);
390 closedloop.setYaml(yaml);
391 session.update(closedloop);
394 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating ClosedLoops Table"+e);
401 @SuppressWarnings("unchecked")
403 public void deleteAll() {
404 Session session = sessionFactory.openSession();
405 Transaction tx = session.beginTransaction();
406 List<ClosedLoops> closedloopsdata = null;
408 Criteria cr = session.createCriteria(ClosedLoops.class);
409 closedloopsdata = cr.list();
411 if(closedloopsdata!=null && !closedloopsdata.isEmpty()) {
412 LOGGER.info("ClosedLoops exist in the database, we need to delete them in our first step to buildCache().");
413 for(int i=0; i < closedloopsdata.size(); i++) {
414 ClosedLoops cl = closedloopsdata.get(i);
418 LOGGER.info("No ClosedLoops exist in the database, no need to delete.");
422 }catch(Exception e) {
423 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error while deleting ClosedLoops from the table"+e);
429 @SuppressWarnings({ "unchecked"})
431 public List<Object> checkExistingGroupListforUpdate(String groupListValue, String groupNameValue) {
432 Session session = sessionFactory.openSession();
433 Transaction tx = session.beginTransaction();
434 List<Object> data = null;
436 Criteria cr = session.createCriteria(GroupPolicyScopeList.class);
437 cr.add(Restrictions.eq("groupList",groupListValue));
438 Criterion expression = Restrictions.eq("name", groupNameValue);
439 cr.add(Restrictions.not(expression));
442 } catch (Exception e) {
443 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying for Duplicate Entries for GroupPolicyScopeList Table"+e);
447 }catch(Exception e1){
448 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
456 public List<Object> getMultipleDataOnAddingConjunction(@SuppressWarnings("rawtypes") Class className, String columnName, List<String> data) {
460 public static void setSessionfactory(SessionFactory sessionfactory) {
461 sessionFactory = sessionfactory;