com.hangum.tadpole.summary.report.DailySummaryReportJOB.java Source code

Introduction

Here is the source code for com.hangum.tadpole.summary.report.DailySummaryReportJOB.java

Source

/*******************************************************************************
 * Copyright (c) 2014 hangum.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the GNU Lesser Public License v2.1
 * which accompanies this distribution, and is available at
 * http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
 * 
 * Contributors:
 *     hangum - initial API and implementation
 ******************************************************************************/
package com.hangum.tadpole.summary.report;

import java.sql.ResultSet;
import java.sql.Statement;
import java.util.List;

import org.apache.commons.lang.StringUtils;
import org.apache.log4j.Logger;
import org.quartz.Job;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;

import com.hangum.tadpole.commons.libs.core.define.PublicTadpoleDefine;
import com.hangum.tadpole.commons.libs.core.mails.template.DailySummaryReport;
import com.hangum.tadpole.engine.define.DBDefine;
import com.hangum.tadpole.engine.manager.TadpoleSQLManager;
import com.hangum.tadpole.engine.query.dao.system.UserDBDAO;
import com.hangum.tadpole.engine.query.sql.TadpoleSystem_UserDBQuery;
import com.hangum.tadpole.monitoring.core.utils.Utils;
import com.ibatis.sqlmap.client.SqlMapClient;

/**
 * daily summary report
 * 
 * @author hangum
 *
 */
public class DailySummaryReportJOB implements Job {
    private static final Logger logger = Logger.getLogger(DailySummaryReportJOB.class);

    @Override
    public void execute(JobExecutionContext arg0) throws JobExecutionException {
        logger.info("daily summary report");

        try {
            // db  .
            List<UserDBDAO> listUserDB = TadpoleSystem_UserDBQuery.getDailySummaryReportDB();

            // ?  .
            for (UserDBDAO userDBDAO : listUserDB) {
                StringBuffer strMailContent = new StringBuffer();

                // (14.06.02) mysql ?   ? ?.
                if (PublicTadpoleDefine.YES_NO.YES.name().equals(userDBDAO.getIs_summary_report())) {
                    if (userDBDAO.getDBDefine() == DBDefine.MYSQL_DEFAULT
                            || userDBDAO.getDBDefine() == DBDefine.MARIADB_DEFAULT) {

                        String strSummarySQl = MySQLSummaryReport.getSQL(userDBDAO.getDb());
                        String[] arrySQLS = StringUtils.split(strSummarySQl, ";");
                        for (String strSQL : arrySQLS) {
                            String strTitle = StringUtils.split(StringUtils.trim(strSQL),
                                    PublicTadpoleDefine.LINE_SEPARATOR)[0];

                            String strResult = executSQL(userDBDAO, strTitle, strSQL);
                            strMailContent.append(strResult);
                        }

                        DailySummaryReport report = new DailySummaryReport();
                        String mailContent = report.makeFullSummaryReport(userDBDAO.getDisplay_name(),
                                strMailContent.toString());

                        //  .                  
                        Utils.sendEmail(userDBDAO.getUser_seq(), userDBDAO.getDisplay_name(), mailContent);

                        if (logger.isDebugEnabled())
                            logger.debug(mailContent);
                    } // end mysql db
                } // if yes
            } // for (UserDBDAO userDBDAO

        } catch (Exception e) {
            logger.error("daily summary report", e);
        }
    }

    /**
     * ? quote sql? ? .
     * 
     * @param userDB
     * @param strDML
     * @param args
     */
    public static String executSQL(UserDBDAO userDB, String strTitle, String strDML) throws Exception {
        if (logger.isDebugEnabled())
            logger.debug("execute query " + strDML);

        java.sql.Connection javaConn = null;
        Statement stmt = null;
        ResultSet rs = null;
        try {
            SqlMapClient client = TadpoleSQLManager.getInstance(userDB);
            javaConn = client.getDataSource().getConnection();
            stmt = javaConn.createStatement();
            rs = stmt.executeQuery(strDML);

            return DailySummaryReport.makeResultSetTOHTML(strTitle, rs, 100);
        } finally {
            try {
                if (rs != null)
                    rs.close();
            } catch (Exception e) {
            }
            try {
                if (stmt != null)
                    stmt.close();
            } catch (Exception e) {
            }
            try {
                if (javaConn != null)
                    javaConn.close();
            } catch (Exception e) {
            }
        }
    }

}