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.List;
25 import org.hibernate.Criteria;
26 import org.hibernate.Session;
27 import org.hibernate.Transaction;
28 import org.hibernate.criterion.Restrictions;
29 import org.onap.policy.common.logging.flexlogger.FlexLogger;
30 import org.onap.policy.common.logging.flexlogger.Logger;
31 import org.onap.policy.conf.HibernateSession;
32 import org.onap.policy.controller.PolicyController;
33 import org.onap.policy.dao.SystemLogDbDao;
34 import org.onap.policy.rest.jpa.SystemLogDB;
35 import org.onap.policy.xacml.api.XACMLErrorConstants;
36 import org.springframework.stereotype.Service;
38 @Service("SystemLogDbDao")
39 public class SystemLogDbDaoImpl implements SystemLogDbDao {
40 private static final Logger logger = FlexLogger.getLogger(SystemLogDbDaoImpl.class);
42 @SuppressWarnings("unchecked")
44 public List<SystemLogDB> getLoggingData() {
45 Session session = HibernateSession.getSession();
46 Transaction tx = session.beginTransaction();
47 List<SystemLogDB> system = null;
49 String sqlWhere = null;
50 if (PolicyController.isjUnit()) {
53 sqlWhere = "date > DATE_SUB(curdate(), INTERVAL 5 DAY) ORDER BY date DESC limit "
54 + PolicyController.getLogTableLimit() + "";
56 Criteria cr = session.createCriteria(SystemLogDB.class);
57 cr.add(Restrictions.sqlRestriction(sqlWhere));
60 } catch (Exception e) {
61 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying SystemLogDB Table" + e);
65 } catch (Exception e1) {
66 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement" + e1);
72 @SuppressWarnings("unchecked")
74 public List<SystemLogDB> getSystemAlertData() {
75 Session session = HibernateSession.getSession();
76 Transaction tx = session.beginTransaction();
77 List<SystemLogDB> system = null;
79 String sqlWhere = null;
80 if (PolicyController.isjUnit()) {
83 sqlWhere = "date > DATE_SUB(curdate(), INTERVAL 5 DAY) and logtype = 'error' ORDER BY date DESC limit "
84 + PolicyController.getSystemAlertTableLimit() + "";
86 Criteria cr = session.createCriteria(SystemLogDB.class);
87 cr.add(Restrictions.sqlRestriction(sqlWhere));
90 } catch (Exception e) {
91 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Querying SystemLogDB Table" + e);
95 } catch (Exception e1) {
96 logger.error(XACMLErrorConstants.ERROR_PROCESS_FLOW + "Error While Closing Connection/Statement" + e1);