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.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(){
75 @SuppressWarnings({ "unchecked", "rawtypes" })
77 public List<Object> getData(Class className) {
78 Session session = sessionfactory.openSession();
79 List<Object> data = null;
81 Criteria cr = session.createCriteria(className);
84 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
89 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e);
96 @SuppressWarnings({ "rawtypes", "unchecked" })
98 public List<Object> getDataById(Class className, String columnName, String key) {
99 Session session = sessionfactory.openSession();
100 List<Object> data = null;
102 Criteria cr = session.createCriteria(className);
103 if(columnName.contains(":") && key.contains(":")){
104 String[] columns = columnName.split(":");
105 String[] keys = key.split(":");
106 for(int i=0; i < columns.length; i++){
107 cr.add(Restrictions.eq(columns[i], keys[i]));
110 cr.add(Restrictions.eq(columnName, key));
113 } catch (Exception e) {
114 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
118 }catch(Exception e1){
119 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
126 public void save(Object entity) {
127 Session session = sessionfactory.openSession();
128 Transaction tx = session.beginTransaction();
130 session.persist(entity);
133 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Saving data to Table"+e);
137 }catch(Exception e1){
138 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
145 public void delete(Object entity) {
146 Session session = sessionfactory.openSession();
147 Transaction tx = session.beginTransaction();
149 session.delete(entity);
152 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Deleting data from Table"+e);
156 }catch(Exception e1){
157 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
165 public void update(Object entity) {
166 Session session = sessionfactory.openSession();
167 Transaction tx = session.beginTransaction();
169 session.update(entity);
172 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating data to Table"+e);
176 }catch(Exception e1){
177 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
184 @SuppressWarnings({ "unchecked", "rawtypes" })
186 public List<Object> checkDuplicateEntry(String value, String columnName, Class className) {
187 Session session = sessionfactory.openSession();
188 Transaction tx = session.beginTransaction();
189 List<Object> data = null;
190 String[] columnNames = null;
191 if(columnName != null && columnName.contains(":")){
192 columnNames = columnName.split(":");
194 String[] values = null;
195 if(value != null && value.contains(":")){
196 values = value.split(":");
199 Criteria cr = session.createCriteria(className);
200 if(columnNames != null && values != null && columnNames.length == values.length){
201 for (int i = 0; i < columnNames.length; i++){
202 cr.add(Restrictions.eq(columnNames[i],values[i]));
205 cr.add(Restrictions.eq(columnName,value));
209 } catch (Exception e) {
210 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying for Duplicate Entries for Table"+e + className);
214 }catch(Exception e1){
215 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
222 @SuppressWarnings("unchecked")
224 public List<PolicyRoles> getUserRoles() {
225 Session session = sessionfactory.openSession();
226 Transaction tx = session.beginTransaction();
227 List<PolicyRoles> rolesData = null;
229 Criteria cr = session.createCriteria(PolicyRoles.class);
230 Disjunction disjunction = Restrictions.disjunction();
231 Conjunction conjunction1 = Restrictions.conjunction();
232 conjunction1.add(Restrictions.eq("role", "admin"));
233 Conjunction conjunction2 = Restrictions.conjunction();
234 conjunction2.add(Restrictions.eq("role", "editor"));
235 Conjunction conjunction3 = Restrictions.conjunction();
236 conjunction3.add(Restrictions.eq("role", "guest"));
237 disjunction.add(conjunction1);
238 disjunction.add(conjunction2);
239 disjunction.add(conjunction3);
240 rolesData = cr.add(disjunction).list();
242 } catch (Exception e) {
243 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying PolicyRoles Table"+e);
247 }catch(Exception e1){
248 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
256 public List<Object> checkExistingGroupListforUpdate(String arg0, String arg1) {
257 return Collections.emptyList();
262 public void deleteAll() {}
265 @SuppressWarnings("unchecked")
267 public List<Object> getDataByQuery(String query, SimpleBindings params) {
268 Session session = sessionfactory.openSession();
269 Transaction tx = session.beginTransaction();
270 List<Object> data = null;
272 Query hbquery = session.createQuery(query);
273 for (Map.Entry<String, Object> paramPair : params.entrySet()) {
274 if(paramPair.getValue() instanceof java.lang.Long){
275 hbquery.setLong(paramPair.getKey(), (long) paramPair.getValue());
278 hbquery.setParameter(paramPair.getKey(), paramPair.getValue());
281 data = hbquery.list();
283 } catch (Exception e) {
284 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Database Table"+e);
289 }catch(HibernateException e1){
290 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
297 @SuppressWarnings("rawtypes")
299 public Object getEntityItem(Class className, String columnName, String key) {
300 Session session = sessionfactory.openSession();
301 Transaction tx = session.beginTransaction();
304 Criteria cr = session.createCriteria(className);
305 if(columnName.contains(":") && key.contains(":")){
306 String[] columns = columnName.split(":");
307 String[] keys = key.split(":");
308 for(int i=0; i < columns.length; i++){
309 cr.add(Restrictions.eq(columns[i], keys[i]));
312 cr.add(Restrictions.eq(columnName, key));
314 data = cr.list().get(0);
316 } catch (Exception e) {
317 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Database Table"+e);
321 }catch(Exception e1){
322 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
330 public void updateClAlarms(String arg0, String arg1) {}
334 public void updateClYaml(String arg0, String arg1) {}
338 public void updateQuery(String query) {
339 Session session = sessionfactory.openSession();
340 Transaction tx = session.beginTransaction();
342 Query hbquery = session.createQuery(query);
343 hbquery.executeUpdate();
345 } catch (Exception e) {
346 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating Database Table"+e);
350 }catch(Exception e1){
351 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
358 @SuppressWarnings({ "rawtypes", "unchecked" })
360 public List<String> getDataByColumn(Class className, String columnName) {
361 Session session = sessionfactory.openSession();
362 List<String> data = null;
364 Criteria cr = session.createCriteria(className);
365 cr.setProjection(Projections.property(columnName));
368 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
373 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e);
380 @SuppressWarnings({ "rawtypes", "unchecked" })
382 public List<Object> getMultipleDataOnAddingConjunction(Class className, String columnName, List<String> data) {
383 Session session = sessionfactory.openSession();
384 Transaction tx = session.beginTransaction();
385 List<Object> entityData = null;
387 Criteria cr = session.createCriteria(className);
388 Disjunction disjunction = Restrictions.disjunction();
389 List<Conjunction> conjunctionList = new ArrayList<>();
390 String[] columNames = columnName.split(":");
391 for(int i =0; i < data.size(); i++){
392 String[] entiySplit = data.get(i).split(":");
393 Conjunction conjunction = Restrictions.conjunction();
394 conjunction.add(Restrictions.eq(columNames[0], entiySplit[0]));
395 conjunction.add(Restrictions.eq(columNames[1], entiySplit[1]));
396 conjunctionList.add(conjunction);
398 for(int j =0 ; j < conjunctionList.size(); j++){
399 disjunction.add(conjunctionList.get(j));
401 entityData = cr.add(disjunction).list();
403 } catch (Exception e) {
404 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table" +className +e);
408 }catch(Exception e1){
409 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);