2 * ============LICENSE_START=======================================================
4 * ================================================================================
5 * Copyright (C) 2017, 2019 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.daoImp;
23 import java.util.ArrayList;
24 import java.util.Collections;
25 import java.util.List;
28 import javax.script.SimpleBindings;
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.Disjunction;
38 import org.hibernate.criterion.Projections;
39 import org.hibernate.criterion.Restrictions;
40 import org.onap.policy.common.logging.flexlogger.FlexLogger;
41 import org.onap.policy.common.logging.flexlogger.Logger;
42 import org.onap.policy.rest.dao.CommonClassDao;
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.context.annotation.Primary;
47 import org.springframework.stereotype.Service;
49 @Service("CommonClassDao")
51 public class CommonClassDaoImpl implements CommonClassDao {
53 private static final Logger LOGGER = FlexLogger.getLogger(CommonClassDaoImpl.class);
54 private static SessionFactory sessionfactory;
56 public static SessionFactory getSessionfactory() {
57 return sessionfactory;
60 public static void setSessionfactory(SessionFactory sessionfactory) {
61 CommonClassDaoImpl.sessionfactory = sessionfactory;
65 private CommonClassDaoImpl(SessionFactory sessionfactory) {
66 CommonClassDaoImpl.sessionfactory = sessionfactory;
69 public CommonClassDaoImpl() {
70 // Default Constructor
73 @SuppressWarnings({"unchecked", "rawtypes"})
75 public List<Object> getData(Class className) {
76 Session session = sessionfactory.openSession();
77 List<Object> data = null;
79 Criteria cr = session.createCriteria(className);
81 } catch (Exception e) {
82 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table" + e);
86 } catch (Exception e) {
87 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement" + e);
93 @SuppressWarnings({"rawtypes", "unchecked"})
95 public List<Object> getDataById(Class className, String columnName, String key) {
96 Session session = sessionfactory.openSession();
97 List<Object> data = null;
99 Criteria cr = session.createCriteria(className);
100 if (columnName.contains(":") && key.contains(":")) {
101 String[] columns = columnName.split(":");
102 String[] keys = key.split(":");
103 for (int i = 0; i < columns.length; i++) {
104 cr.add(Restrictions.eq(columns[i], keys[i]));
107 cr.add(Restrictions.eq(columnName, key));
110 } catch (Exception e) {
111 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table" + e);
115 } catch (Exception e1) {
116 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement" + e1);
123 public void save(Object entity) {
124 Session session = sessionfactory.openSession();
125 Transaction tx = session.beginTransaction();
127 session.persist(entity);
129 } catch (Exception e) {
130 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Saving data to Table" + e);
134 } catch (Exception e1) {
135 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement" + e1);
142 public void delete(Object entity) {
143 Session session = sessionfactory.openSession();
144 Transaction tx = session.beginTransaction();
146 session.delete(entity);
148 } catch (Exception e) {
149 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Deleting data from Table" + e);
153 } catch (Exception e1) {
154 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement" + e1);
161 public void update(Object entity) {
162 Session session = sessionfactory.openSession();
163 Transaction tx = session.beginTransaction();
165 session.update(entity);
167 } catch (Exception e) {
168 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating data to Table" + e);
172 } catch (Exception e1) {
173 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement" + e1);
179 @SuppressWarnings({"unchecked", "rawtypes"})
181 public List<Object> checkDuplicateEntry(String value, String columnName, Class className) {
182 Session session = sessionfactory.openSession();
183 Transaction tx = session.beginTransaction();
184 List<Object> data = null;
185 String[] columnNames = null;
186 if (columnName != null && columnName.contains(":")) {
187 columnNames = columnName.split(":");
189 String[] values = null;
190 if (value != null && value.contains(":")) {
191 values = value.split(":");
194 Criteria cr = session.createCriteria(className);
195 if (columnNames != null && values != null && columnNames.length == values.length) {
196 for (int i = 0; i < columnNames.length; i++) {
197 cr.add(Restrictions.eq(columnNames[i], values[i]));
200 cr.add(Restrictions.eq(columnName, value));
204 } catch (Exception e) {
205 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying for Duplicate Entries for Table"
210 } catch (Exception e1) {
211 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement" + e1);
217 @SuppressWarnings("unchecked")
219 public List<PolicyRoles> getUserRoles() {
220 Session session = sessionfactory.openSession();
221 Transaction tx = session.beginTransaction();
222 List<PolicyRoles> rolesData = null;
224 final Criteria cr = session.createCriteria(PolicyRoles.class);
225 final Disjunction disjunction = Restrictions.disjunction();
226 Conjunction conjunction1 = Restrictions.conjunction();
227 conjunction1.add(Restrictions.eq("role", "admin"));
228 Conjunction conjunction2 = Restrictions.conjunction();
229 conjunction2.add(Restrictions.eq("role", "editor"));
230 Conjunction conjunction3 = Restrictions.conjunction();
231 conjunction3.add(Restrictions.eq("role", "guest"));
232 disjunction.add(conjunction1);
233 disjunction.add(conjunction2);
234 disjunction.add(conjunction3);
235 rolesData = cr.add(disjunction).list();
237 } catch (Exception e) {
238 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying PolicyRoles Table" + e);
242 } catch (Exception e1) {
243 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement" + e1);
250 public List<Object> checkExistingGroupListforUpdate(String arg0, String arg1) {
251 return Collections.emptyList();
255 public void deleteAll() {
258 @SuppressWarnings("unchecked")
260 public List<Object> getDataByQuery(String query, SimpleBindings params) {
261 Session session = sessionfactory.openSession();
262 Transaction tx = session.beginTransaction();
263 List<Object> data = null;
265 Query hbquery = session.createQuery(query);
266 for (Map.Entry<String, Object> paramPair : params.entrySet()) {
267 if (paramPair.getValue() instanceof java.lang.Long) {
268 hbquery.setLong(paramPair.getKey(), (long) paramPair.getValue());
270 hbquery.setParameter(paramPair.getKey(), paramPair.getValue());
273 data = hbquery.list();
275 } catch (Exception e) {
276 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Database Table" + e);
281 } catch (HibernateException 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 public void updateClAlarms(String arg0, String arg1) {
321 // why is there no code here?
325 public void updateClYaml(String arg0, String arg1) {
326 // why is there no code here?
330 public void updateQuery(String query) {
331 Session session = sessionfactory.openSession();
332 Transaction tx = session.beginTransaction();
334 Query hbquery = session.createQuery(query);
335 hbquery.executeUpdate();
337 } catch (Exception e) {
338 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating Database Table" + e);
342 } catch (Exception e1) {
343 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement" + e1);
349 @SuppressWarnings({"rawtypes", "unchecked"})
351 public List<String> getDataByColumn(Class className, String columnName) {
352 Session session = sessionfactory.openSession();
353 List<String> data = null;
355 Criteria cr = session.createCriteria(className);
356 cr.setProjection(Projections.property(columnName));
358 } catch (Exception e) {
359 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table" + e);
363 } catch (Exception e) {
364 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement" + e);
370 @SuppressWarnings({"rawtypes", "unchecked"})
372 public List<Object> getMultipleDataOnAddingConjunction(Class className, String columnName, List<String> data) {
373 Session session = sessionfactory.openSession();
374 Transaction tx = session.beginTransaction();
375 List<Object> entityData = null;
377 Criteria cr = session.createCriteria(className);
378 Disjunction disjunction = Restrictions.disjunction();
379 List<Conjunction> conjunctionList = new ArrayList<>();
380 String[] columNames = columnName.split(":");
381 for (int i = 0; i < data.size(); i++) {
382 String[] entiySplit = data.get(i).split(":");
383 Conjunction conjunction = Restrictions.conjunction();
384 conjunction.add(Restrictions.eq(columNames[0], entiySplit[0]));
385 conjunction.add(Restrictions.eq(columNames[1], entiySplit[1]));
386 conjunctionList.add(conjunction);
388 for (int j = 0; j < conjunctionList.size(); j++) {
389 disjunction.add(conjunctionList.get(j));
391 entityData = cr.add(disjunction).list();
393 } catch (Exception e) {
394 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table" + className + e);
398 } catch (Exception e1) {
399 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement" + e1);