com.hangum.tadpole.monitoring.core.jobs.UserJOB.java Source code

Introduction

Here is the source code for com.hangum.tadpole.monitoring.core.jobs.UserJOB.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.monitoring.core.jobs;

import java.util.List;

import org.apache.commons.lang.StringUtils;
import org.apache.commons.lang.math.NumberUtils;
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.query.dao.system.ScheduleDAO;
import com.hangum.tadpole.engine.query.dao.system.ScheduleMainDAO;
import com.hangum.tadpole.engine.query.dao.system.UserDBDAO;
import com.hangum.tadpole.engine.query.sql.TadpoleSystem_Schedule;
import com.hangum.tadpole.engine.query.sql.TadpoleSystem_UserDBQuery;
import com.hangum.tadpole.monitoring.core.utils.Utils;
import com.hangum.tadpole.summary.report.DailySummaryReportJOB;

/**
 * User job
 * 
 * @author hangum
 *
 */
public class UserJOB implements Job {
    private static final Logger logger = Logger.getLogger(UserJOB.class);

    @Override
    public void execute(JobExecutionContext context) throws JobExecutionException {
        StringBuffer sbMailContent = new StringBuffer();

        String strKey = context.getJobDetail().getKey().toString();
        if (logger.isDebugEnabled())
            logger.debug("start job is " + strKey);
        String[] keys = StringUtils.split(StringUtils.removeStart(strKey, "DEFAULT."),
                PublicTadpoleDefine.DELIMITER);

        int dbSeq = NumberUtils.createInteger(keys[0]);
        int scheduleSeq = NumberUtils.createInteger(keys[1]);

        boolean isResult = true;
        String strMessage = "";
        try {
            UserDBDAO userDB = TadpoleSystem_UserDBQuery.getUserDBInstance(dbSeq);
            ScheduleMainDAO scheduleMainDao = TadpoleSystem_Schedule.findScheduleMain(scheduleSeq);
            List<ScheduleDAO> listSchedule = TadpoleSystem_Schedule.findSchedule(scheduleMainDao.getSeq());

            for (ScheduleDAO scheduleDAO : listSchedule) {
                try {
                    sbMailContent.append(
                            DailySummaryReportJOB.executSQL(userDB, scheduleDAO.getName(), scheduleDAO.getSql()));
                } catch (Exception e) {
                    sbMailContent.append("Rise Exception :" + e.getMessage());
                    strMessage += e.getMessage() + "\n";
                    isResult = false;
                }
            }

            DailySummaryReport report = new DailySummaryReport();
            String mailContent = report.makeFullSummaryReport(scheduleMainDao.getTitle(), sbMailContent.toString());

            Utils.sendEmail(scheduleMainDao.getUser_seq(), scheduleMainDao.getTitle(), mailContent);
            ;

            TadpoleSystem_Schedule.saveScheduleResult(scheduleSeq, isResult, strMessage);
        } catch (Exception e) {
            logger.error("execute User Job", e);

            try {
                TadpoleSystem_Schedule.saveScheduleResult(scheduleSeq, false, strMessage + e.getMessage());
            } catch (Exception e1) {
                logger.error("save schedule result", e1);
            }
        }

    }
}