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.daoImp;
23 import java.util.ArrayList;
24 import java.util.List;
27 import javax.script.SimpleBindings;
29 import org.hibernate.Criteria;
30 import org.hibernate.HibernateException;
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.Disjunction;
37 import org.hibernate.criterion.Projections;
38 import org.hibernate.criterion.Restrictions;
39 import org.onap.policy.common.logging.flexlogger.FlexLogger;
40 import org.onap.policy.common.logging.flexlogger.Logger;
41 import org.onap.policy.rest.dao.CommonClassDao;
42 import org.onap.policy.rest.jpa.PolicyRoles;
43 import org.onap.policy.xacml.api.XACMLErrorConstants;
44 import org.springframework.beans.factory.annotation.Autowired;
45 import org.springframework.stereotype.Service;
47 @Service("CommonClassDao")
48 public class CommonClassDaoImpl implements CommonClassDao{
50 private static final Logger LOGGER = FlexLogger.getLogger(CommonClassDaoImpl.class);
51 private static SessionFactory sessionfactory;
53 public static SessionFactory getSessionfactory() {
54 return sessionfactory;
57 public static void setSessionfactory(SessionFactory sessionfactory) {
58 CommonClassDaoImpl.sessionfactory = sessionfactory;
62 private CommonClassDaoImpl(SessionFactory sessionfactory){
63 CommonClassDaoImpl.sessionfactory = sessionfactory;
66 public CommonClassDaoImpl(){
72 @SuppressWarnings({ "unchecked", "rawtypes" })
74 public List<Object> getData(Class className) {
75 Session session = sessionfactory.openSession();
76 List<Object> data = null;
78 Criteria cr = session.createCriteria(className);
81 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
86 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);
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);
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);
162 public void update(Object entity) {
163 Session session = sessionfactory.openSession();
164 Transaction tx = session.beginTransaction();
166 session.update(entity);
169 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating data to Table"+e);
173 }catch(Exception e1){
174 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
181 @SuppressWarnings({ "unchecked", "rawtypes" })
183 public List<Object> checkDuplicateEntry(String value, String columnName, Class className) {
184 Session session = sessionfactory.openSession();
185 Transaction tx = session.beginTransaction();
186 List<Object> data = null;
187 String[] columnNames = null;
188 if(columnName != null && columnName.contains(":")){
189 columnNames = columnName.split(":");
191 String[] values = null;
192 if(value != null && value.contains(":")){
193 values = value.split(":");
196 Criteria cr = session.createCriteria(className);
197 if(columnNames != null && values != null && columnNames.length == values.length){
198 for (int i = 0; i < columnNames.length; i++){
199 cr.add(Restrictions.eq(columnNames[i],values[i]));
202 cr.add(Restrictions.eq(columnName,value));
206 } catch (Exception e) {
207 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying for Duplicate Entries for Table"+e + className);
211 }catch(Exception e1){
212 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
219 @SuppressWarnings("unchecked")
221 public List<PolicyRoles> getUserRoles() {
222 Session session = sessionfactory.openSession();
223 Transaction tx = session.beginTransaction();
224 List<PolicyRoles> rolesData = null;
226 Criteria cr = session.createCriteria(PolicyRoles.class);
227 Disjunction disjunction = Restrictions.disjunction();
228 Conjunction conjunction1 = Restrictions.conjunction();
229 conjunction1.add(Restrictions.eq("role", "admin"));
230 Conjunction conjunction2 = Restrictions.conjunction();
231 conjunction2.add(Restrictions.eq("role", "editor"));
232 Conjunction conjunction3 = Restrictions.conjunction();
233 conjunction3.add(Restrictions.eq("role", "guest"));
234 disjunction.add(conjunction1);
235 disjunction.add(conjunction2);
236 disjunction.add(conjunction3);
237 rolesData = cr.add(disjunction).list();
239 } catch (Exception e) {
240 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying PolicyRoles Table"+e);
244 }catch(Exception e1){
245 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
253 public List<Object> checkExistingGroupListforUpdate(String arg0, String arg1) {
259 public void deleteAll() {}
262 @SuppressWarnings("unchecked")
264 public List<Object> getDataByQuery(String query, SimpleBindings params) {
265 Session session = sessionfactory.openSession();
266 Transaction tx = session.beginTransaction();
267 List<Object> data = null;
269 Query hbquery = session.createQuery(query);
270 for (Map.Entry<String, Object> paramPair : params.entrySet()) {
271 if(paramPair.getValue() instanceof java.lang.Long){
272 hbquery.setLong(paramPair.getKey(), (long) paramPair.getValue());
275 hbquery.setParameter(paramPair.getKey(), paramPair.getValue());
278 data = hbquery.list();
280 } catch (Exception e) {
281 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Database Table"+e);
286 }catch(HibernateException e1){
287 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
294 @SuppressWarnings("rawtypes")
296 public Object getEntityItem(Class className, String columnName, String key) {
297 Session session = sessionfactory.openSession();
298 Transaction tx = session.beginTransaction();
301 Criteria cr = session.createCriteria(className);
302 if(columnName.contains(":") && key.contains(":")){
303 String[] columns = columnName.split(":");
304 String[] keys = key.split(":");
305 for(int i=0; i < columns.length; i++){
306 cr.add(Restrictions.eq(columns[i], keys[i]));
309 cr.add(Restrictions.eq(columnName, key));
311 data = cr.list().get(0);
313 } catch (Exception e) {
314 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Database Table"+e);
318 }catch(Exception e1){
319 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
327 public void updateClAlarms(String arg0, String arg1) {}
331 public void updateClYaml(String arg0, String arg1) {}
335 public void updateQuery(String query) {
336 Session session = sessionfactory.openSession();
337 Transaction tx = session.beginTransaction();
339 Query hbquery = session.createQuery(query);
340 hbquery.executeUpdate();
342 } catch (Exception e) {
343 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating Database Table"+e);
347 }catch(Exception e1){
348 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
355 @SuppressWarnings({ "rawtypes", "unchecked" })
357 public List<String> getDataByColumn(Class className, String columnName) {
358 Session session = sessionfactory.openSession();
359 List<String> data = null;
361 Criteria cr = session.createCriteria(className);
362 cr.setProjection(Projections.property(columnName));
365 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
370 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e);
377 @SuppressWarnings({ "rawtypes", "unchecked" })
379 public List<Object> getMultipleDataOnAddingConjunction(Class className, String columnName, List<String> data) {
380 Session session = sessionfactory.openSession();
381 Transaction tx = session.beginTransaction();
382 List<Object> entityData = null;
384 Criteria cr = session.createCriteria(className);
385 Disjunction disjunction = Restrictions.disjunction();
386 List<Conjunction> conjunctionList = new ArrayList<>();
387 String[] columNames = columnName.split(":");
388 for(int i =0; i < data.size(); i++){
389 String[] entiySplit = data.get(i).split(":");
390 Conjunction conjunction = Restrictions.conjunction();
391 conjunction.add(Restrictions.eq(columNames[0], entiySplit[0]));
392 conjunction.add(Restrictions.eq(columNames[1], entiySplit[1]));
393 conjunctionList.add(conjunction);
395 for(int j =0 ; j < conjunctionList.size(); j++){
396 disjunction.add(conjunctionList.get(j));
398 entityData = cr.add(disjunction).list();
400 } catch (Exception e) {
401 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table" +className +e);
405 }catch(Exception e1){
406 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);