ca.hec.cdm.jobs.CreateCatalogDescriptionJob.java Source code

Introduction

Here is the source code for ca.hec.cdm.jobs.CreateCatalogDescriptionJob.java

Source

/******************************************************************************
 * $Id: $
 ******************************************************************************
 *
 * Copyright (c) 2012 The Sakai Foundation, The Sakai Quebec Team.
 *
 * Licensed under the Educational Community License, Version 1.0
 * (the "License"); you may not use this file except in compliance with the
 * License.
 * You may obtain a copy of the License at
 *
 *      http://www.opensource.org/licenses/ecl1.php
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 ******************************************************************************/
package ca.hec.cdm.jobs;

import java.sql.Date;
import java.util.List;

import lombok.Getter;
import lombok.Setter;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.quartz.Job;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;

import ca.hec.cdm.api.CatalogDescriptionDao;
import ca.hec.cdm.exception.DatabaseException;
import ca.hec.cdm.exception.StaleDataException;
import ca.hec.cdm.jobs.model.CourseOffering;
import ca.hec.cdm.model.CatalogDescription;
import ca.hec.commons.utils.FormatUtils;

public class CreateCatalogDescriptionJob implements Job {

    @Getter
    @Setter
    private CatalogDescriptionJobDao courseOfferingDao;

    @Getter
    @Setter
    private CatalogDescriptionDao catalogDescriptionDao;

    CatalogDescription cd = null;

    private static Log log = LogFactory.getLog(CreateCatalogDescriptionJob.class);

    public void execute(JobExecutionContext arg0) throws JobExecutionException {
        List<CourseOffering> listCo = courseOfferingDao.getListCourseOffering();
        List<String> listCourseId = catalogDescriptionDao.getListCourseId();

        // First we set to "Inactive" status all catalog descriptions
        catalogDescriptionDao.setCatalogDescriptionToInactive();

        // Then we create or update catalog descriptions
        for (CourseOffering co : listCo) {
            cd = new CatalogDescription();
            cd.setCourseId(FormatUtils.formatCourseId(co.getCatalog_nbr()));
            cd.setTitle(co.getCourse_title_long());
            cd.setDepartment(co.getAcad_org());
            cd.setCareer(co.getAcad_career());
            cd.setCredits(co.getCredits());
            cd.setLanguage(co.getLanguage());
            cd.setRequirements(co.getRequirement());
            cd.setCreatedDate(new Date(java.util.Calendar.getInstance().getTimeInMillis()));
            cd.setActive(true);
            cd.setCreatedBy("quartz job");

            // we create catalog description only if it is not already created
            if (!listCourseId.contains(cd.getCourseId())) {
                try {
                    catalogDescriptionDao.saveCatalogDescription(cd);
                    log.debug("the folowing catalog description was created successfully: " + cd.getCourseId());
                } catch (StaleDataException e) {
                    log.error("Exception during catalog description creation :" + e);
                } catch (DatabaseException e) {
                    log.error("Exception during catalog description creation :" + e);
                }
                // otherwise, we update the catalog description and set "Active" status to true
            } else {
                CatalogDescription cdToUpdate = catalogDescriptionDao
                        .getLastVersionCatalogDescription(cd.getCourseId());

                cdToUpdate.setTitle(cd.getTitle());
                cdToUpdate.setDepartment(cd.getDepartment());
                cdToUpdate.setCareer(cd.getCareer());
                cdToUpdate.setCredits(cd.getCredits());
                cdToUpdate.setLanguage(cd.getLanguage());
                cdToUpdate.setRequirements(cd.getRequirements());

                cdToUpdate.setActive(true);

                try {
                    catalogDescriptionDao.saveCatalogDescription(cdToUpdate);

                    log.debug("the folowing catalog description was successfully updated to 'active' status: "
                            + cd.getCourseId());
                } catch (StaleDataException e) {
                    log.error("Exception during catalog description update :" + e);
                } catch (DatabaseException e) {
                    log.error("Exception during catalog description update :" + e);
                }
            }
        }
    }

}