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.context.annotation.Primary;
46 import org.springframework.stereotype.Service;
48 @Service("CommonClassDao")
50 public class CommonClassDaoImpl implements CommonClassDao{
52 private static final Logger LOGGER = FlexLogger.getLogger(CommonClassDaoImpl.class);
53 private static SessionFactory sessionfactory;
55 public static SessionFactory getSessionfactory() {
56 return sessionfactory;
59 public static void setSessionfactory(SessionFactory sessionfactory) {
60 CommonClassDaoImpl.sessionfactory = sessionfactory;
64 private CommonClassDaoImpl(SessionFactory sessionfactory){
65 CommonClassDaoImpl.sessionfactory = sessionfactory;
68 public CommonClassDaoImpl(){
74 @SuppressWarnings({ "unchecked", "rawtypes" })
76 public List<Object> getData(Class className) {
77 Session session = sessionfactory.openSession();
78 List<Object> data = null;
80 Criteria cr = session.createCriteria(className);
83 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
88 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e);
95 @SuppressWarnings({ "rawtypes", "unchecked" })
97 public List<Object> getDataById(Class className, String columnName, String key) {
98 Session session = sessionfactory.openSession();
99 List<Object> data = null;
101 Criteria cr = session.createCriteria(className);
102 if(columnName.contains(":") && key.contains(":")){
103 String[] columns = columnName.split(":");
104 String[] keys = key.split(":");
105 for(int i=0; i < columns.length; i++){
106 cr.add(Restrictions.eq(columns[i], keys[i]));
109 cr.add(Restrictions.eq(columnName, key));
112 } catch (Exception e) {
113 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
117 }catch(Exception e1){
118 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
125 public void save(Object entity) {
126 Session session = sessionfactory.openSession();
127 Transaction tx = session.beginTransaction();
129 session.persist(entity);
132 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Saving data to Table"+e);
136 }catch(Exception e1){
137 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
144 public void delete(Object entity) {
145 Session session = sessionfactory.openSession();
146 Transaction tx = session.beginTransaction();
148 session.delete(entity);
151 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Deleting data from Table"+e);
155 }catch(Exception e1){
156 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
164 public void update(Object entity) {
165 Session session = sessionfactory.openSession();
166 Transaction tx = session.beginTransaction();
168 session.update(entity);
171 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating data to Table"+e);
175 }catch(Exception e1){
176 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
183 @SuppressWarnings({ "unchecked", "rawtypes" })
185 public List<Object> checkDuplicateEntry(String value, String columnName, Class className) {
186 Session session = sessionfactory.openSession();
187 Transaction tx = session.beginTransaction();
188 List<Object> data = null;
189 String[] columnNames = null;
190 if(columnName != null && columnName.contains(":")){
191 columnNames = columnName.split(":");
193 String[] values = null;
194 if(value != null && value.contains(":")){
195 values = value.split(":");
198 Criteria cr = session.createCriteria(className);
199 if(columnNames != null && values != null && columnNames.length == values.length){
200 for (int i = 0; i < columnNames.length; i++){
201 cr.add(Restrictions.eq(columnNames[i],values[i]));
204 cr.add(Restrictions.eq(columnName,value));
208 } catch (Exception e) {
209 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying for Duplicate Entries for Table"+e + className);
213 }catch(Exception e1){
214 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
221 @SuppressWarnings("unchecked")
223 public List<PolicyRoles> getUserRoles() {
224 Session session = sessionfactory.openSession();
225 Transaction tx = session.beginTransaction();
226 List<PolicyRoles> rolesData = null;
228 Criteria cr = session.createCriteria(PolicyRoles.class);
229 Disjunction disjunction = Restrictions.disjunction();
230 Conjunction conjunction1 = Restrictions.conjunction();
231 conjunction1.add(Restrictions.eq("role", "admin"));
232 Conjunction conjunction2 = Restrictions.conjunction();
233 conjunction2.add(Restrictions.eq("role", "editor"));
234 Conjunction conjunction3 = Restrictions.conjunction();
235 conjunction3.add(Restrictions.eq("role", "guest"));
236 disjunction.add(conjunction1);
237 disjunction.add(conjunction2);
238 disjunction.add(conjunction3);
239 rolesData = cr.add(disjunction).list();
241 } catch (Exception e) {
242 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying PolicyRoles Table"+e);
246 }catch(Exception e1){
247 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
255 public List<Object> checkExistingGroupListforUpdate(String arg0, String arg1) {
261 public void deleteAll() {}
264 @SuppressWarnings("unchecked")
266 public List<Object> getDataByQuery(String query, SimpleBindings params) {
267 Session session = sessionfactory.openSession();
268 Transaction tx = session.beginTransaction();
269 List<Object> data = null;
271 Query hbquery = session.createQuery(query);
272 for (Map.Entry<String, Object> paramPair : params.entrySet()) {
273 if(paramPair.getValue() instanceof java.lang.Long){
274 hbquery.setLong(paramPair.getKey(), (long) paramPair.getValue());
277 hbquery.setParameter(paramPair.getKey(), paramPair.getValue());
280 data = hbquery.list();
282 } catch (Exception e) {
283 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Database Table"+e);
288 }catch(HibernateException e1){
289 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
296 @SuppressWarnings("rawtypes")
298 public Object getEntityItem(Class className, String columnName, String key) {
299 Session session = sessionfactory.openSession();
300 Transaction tx = session.beginTransaction();
303 Criteria cr = session.createCriteria(className);
304 if(columnName.contains(":") && key.contains(":")){
305 String[] columns = columnName.split(":");
306 String[] keys = key.split(":");
307 for(int i=0; i < columns.length; i++){
308 cr.add(Restrictions.eq(columns[i], keys[i]));
311 cr.add(Restrictions.eq(columnName, key));
313 data = cr.list().get(0);
315 } catch (Exception e) {
316 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Database Table"+e);
320 }catch(Exception e1){
321 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
329 public void updateClAlarms(String arg0, String arg1) {}
333 public void updateClYaml(String arg0, String arg1) {}
337 public void updateQuery(String query) {
338 Session session = sessionfactory.openSession();
339 Transaction tx = session.beginTransaction();
341 Query hbquery = session.createQuery(query);
342 hbquery.executeUpdate();
344 } catch (Exception e) {
345 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Updating Database Table"+e);
349 }catch(Exception e1){
350 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);
357 @SuppressWarnings({ "rawtypes", "unchecked" })
359 public List<String> getDataByColumn(Class className, String columnName) {
360 Session session = sessionfactory.openSession();
361 List<String> data = null;
363 Criteria cr = session.createCriteria(className);
364 cr.setProjection(Projections.property(columnName));
367 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table"+e);
372 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e);
379 @SuppressWarnings({ "rawtypes", "unchecked" })
381 public List<Object> getMultipleDataOnAddingConjunction(Class className, String columnName, List<String> data) {
382 Session session = sessionfactory.openSession();
383 Transaction tx = session.beginTransaction();
384 List<Object> entityData = null;
386 Criteria cr = session.createCriteria(className);
387 Disjunction disjunction = Restrictions.disjunction();
388 List<Conjunction> conjunctionList = new ArrayList<>();
389 String[] columNames = columnName.split(":");
390 for(int i =0; i < data.size(); i++){
391 String[] entiySplit = data.get(i).split(":");
392 Conjunction conjunction = Restrictions.conjunction();
393 conjunction.add(Restrictions.eq(columNames[0], entiySplit[0]));
394 conjunction.add(Restrictions.eq(columNames[1], entiySplit[1]));
395 conjunctionList.add(conjunction);
397 for(int j =0 ; j < conjunctionList.size(); j++){
398 disjunction.add(conjunctionList.get(j));
400 entityData = cr.add(disjunction).list();
402 } catch (Exception e) {
403 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying Table" +className +e);
407 }catch(Exception e1){
408 LOGGER.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement"+e1);