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.stereotype.Service;
49 @Service("CommonClassDao")
50 public class CommonClassDaoImpl implements CommonClassDao{
52 private static final Log LOGGER = LogFactory.getLog(CommonClassDaoImpl.class);
55 private static SessionFactory sessionFactory;
58 private CommonClassDaoImpl(SessionFactory sessionFactory){
59 CommonClassDaoImpl.sessionFactory = sessionFactory;
62 public CommonClassDaoImpl(){
66 @SuppressWarnings({ "unchecked", "rawtypes" })
68 public List<Object> getData(Class className) {
69 Session session = sessionFactory.openSession();
70 List<Object> data = null;
72 Criteria cr = session.createCriteria(className);
75 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
80 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e);
87 @SuppressWarnings({ "rawtypes", "unchecked" })
89 public List<Object> getDataById(Class className, String columnName, String key) {
90 Session session = sessionFactory.openSession();
91 List<Object> data = null;
93 Criteria cr = session.createCriteria(className);
94 if(columnName.contains(":") && key.contains(":")){
95 String[] columns = columnName.split(":");
96 String[] keys = key.split(":");
97 for(int i=0; i < columns.length; i++){
98 cr.add(Restrictions.eq(columns[i], keys[i]));
101 cr.add(Restrictions.eq(columnName, key));
104 } catch (Exception e) {
105 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
109 }catch(Exception e1){
110 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
116 @SuppressWarnings({ "unchecked", "rawtypes" })
118 public List<String> getDataByColumn(Class className, String columnName) {
119 Session session = sessionFactory.openSession();
120 List<String> data = null;
122 Criteria cr = session.createCriteria(className);
123 cr.setProjection(Projections.property(columnName));
126 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
131 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e);
138 public void save(Object entity) {
139 Session session = sessionFactory.openSession();
140 Transaction tx = session.beginTransaction();
142 session.persist(entity);
145 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Saving data to Table"+e);
149 }catch(Exception e1){
150 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
157 public void delete(Object entity) {
158 Session session = sessionFactory.openSession();
159 Transaction tx = session.beginTransaction();
161 session.delete(entity);
164 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Deleting data from Table"+e);
168 }catch(Exception e1){
169 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
177 public void update(Object entity) {
178 Session session = sessionFactory.openSession();
179 Transaction tx = session.beginTransaction();
181 session.update(entity);
184 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating data to Table"+e);
188 }catch(Exception e1){
189 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
196 @SuppressWarnings({ "unchecked", "rawtypes" })
198 public List<Object> checkDuplicateEntry(String value, String columnName, Class className) {
199 Session session = sessionFactory.openSession();
200 Transaction tx = session.beginTransaction();
201 List<Object> data = null;
203 String[] columnNames = null;
204 if(columnName != null && columnName.contains(":")){
205 columnNames = columnName.split(":");
207 String[] values = null;
208 if(value != null && value.contains(":")){
209 values = value.split(":");
212 Criteria cr = session.createCriteria(className);
213 if(columnNames != null && values != null && columnNames.length == values.length){
214 for (int i = 0; i < columnNames.length; i++){
215 cr.add(Restrictions.eq(columnNames[i],values[i]));
218 cr.add(Restrictions.eq(columnName,value));
223 } catch (Exception e) {
224 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying for Duplicate Entries for Table"+e + className);
228 }catch(Exception e1){
229 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
236 @SuppressWarnings("unchecked")
238 public List<Object> getDataByQuery(String query, SimpleBindings params) {
239 Session session = sessionFactory.openSession();
240 Transaction tx = session.beginTransaction();
241 List<Object> data = null;
243 Query hbquery = session.createQuery(query);
244 for (Map.Entry<String, Object> paramPair : params.entrySet()) {
245 if(paramPair.getValue() instanceof java.lang.Long){
246 hbquery.setLong(paramPair.getKey(), (long) paramPair.getValue());
249 hbquery.setParameter(paramPair.getKey(), paramPair.getValue());
252 data = hbquery.list();
254 } catch (Exception e) {
255 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Database Table"+e);
260 }catch(HibernateException e1){
261 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement",e1);
269 public void updateQuery(String query) {
270 Session session = sessionFactory.openSession();
271 Transaction tx = session.beginTransaction();
273 Query hbquery = session.createQuery(query);
274 hbquery.executeUpdate();
276 } catch (Exception e) {
277 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating Database Table"+e);
281 }catch(Exception e1){
282 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
288 @SuppressWarnings("rawtypes")
290 public Object getEntityItem(Class className, String columnName, String key) {
291 Session session = sessionFactory.openSession();
292 Transaction tx = session.beginTransaction();
295 Criteria cr = session.createCriteria(className);
296 if(columnName.contains(":") && key.contains(":")){
297 String[] columns = columnName.split(":");
298 String[] keys = key.split(":");
299 for(int i=0; i < columns.length; i++){
300 cr.add(Restrictions.eq(columns[i], keys[i]));
303 cr.add(Restrictions.eq(columnName, key));
305 data = cr.list().get(0);
307 } catch (Exception e) {
308 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Database Table"+e);
312 }catch(Exception e1){
313 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
320 @SuppressWarnings("unchecked")
322 public List<PolicyRoles> getUserRoles() {
323 Session session = sessionFactory.openSession();
324 Transaction tx = session.beginTransaction();
325 List<PolicyRoles> rolesData = null;
327 Criteria cr = session.createCriteria(PolicyRoles.class);
328 Disjunction disjunction = Restrictions.disjunction();
329 Conjunction conjunction1 = Restrictions.conjunction();
330 conjunction1.add(Restrictions.eq("role", "admin"));
331 Conjunction conjunction2 = Restrictions.conjunction();
332 conjunction2.add(Restrictions.eq("role", "editor"));
333 Conjunction conjunction3 = Restrictions.conjunction();
334 conjunction3.add(Restrictions.eq("role", "guest"));
335 disjunction.add(conjunction1);
336 disjunction.add(conjunction2);
337 disjunction.add(conjunction3);
338 rolesData = cr.add(disjunction).list();
340 } catch (Exception e) {
341 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying PolicyRoles Table"+e);
345 }catch(Exception e1){
346 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
353 @SuppressWarnings("unchecked")
355 public void updateClAlarms(String clName, String alarms) {
356 Session session = sessionFactory.openSession();
357 List<ClosedLoops> closedloopsdata = null;
358 Transaction tx = session.beginTransaction();
360 Criteria cr = session.createCriteria(ClosedLoops.class);
361 cr.add(Restrictions.eq("closedLoopControlName",clName));
362 closedloopsdata = cr.list();
363 ClosedLoops closedloop = closedloopsdata.get(0);
364 closedloop.setAlarmConditions(alarms);
365 session.update(closedloop);
368 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating ClosedLoops Table"+e);
375 @SuppressWarnings("unchecked")
377 public void updateClYaml(String clName, String yaml) {
378 Session session = sessionFactory.openSession();
379 List<ClosedLoops> closedloopsdata = null;
380 Transaction tx = session.beginTransaction();
382 Criteria cr = session.createCriteria(ClosedLoops.class);
383 cr.add(Restrictions.eq("closedLoopControlName",clName));
384 closedloopsdata = cr.list();
385 ClosedLoops closedloop = closedloopsdata.get(0);
386 closedloop.setYaml(yaml);
387 session.update(closedloop);
390 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating ClosedLoops Table"+e);
397 @SuppressWarnings("unchecked")
399 public void deleteAll() {
400 Session session = sessionFactory.openSession();
401 Transaction tx = session.beginTransaction();
402 List<ClosedLoops> closedloopsdata = null;
404 Criteria cr = session.createCriteria(ClosedLoops.class);
405 closedloopsdata = cr.list();
407 if(closedloopsdata!=null && !closedloopsdata.isEmpty()) {
408 LOGGER.info("ClosedLoops exist in the database, we need to delete them in our first step to buildCache().");
409 for(int i=0; i < closedloopsdata.size(); i++) {
410 ClosedLoops cl = closedloopsdata.get(i);
414 LOGGER.info("No ClosedLoops exist in the database, no need to delete.");
418 }catch(Exception e) {
419 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error while deleting ClosedLoops from the table"+e);
425 @SuppressWarnings({ "unchecked"})
427 public List<Object> checkExistingGroupListforUpdate(String groupListValue, String groupNameValue) {
428 Session session = sessionFactory.openSession();
429 Transaction tx = session.beginTransaction();
430 List<Object> data = null;
432 Criteria cr = session.createCriteria(GroupPolicyScopeList.class);
433 cr.add(Restrictions.eq("groupList",groupListValue));
434 Criterion expression = Restrictions.eq("name", groupNameValue);
435 cr.add(Restrictions.not(expression));
438 } catch (Exception e) {
439 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying for Duplicate Entries for GroupPolicyScopeList Table"+e);
443 }catch(Exception e1){
444 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
452 public List<Object> getMultipleDataOnAddingConjunction(@SuppressWarnings("rawtypes") Class className, String columnName, List<String> data) {
456 public static void setSessionfactory(SessionFactory sessionfactory) {
457 sessionFactory = sessionfactory;