org.squale.welcom.addons.message.synchro.TaskCheckUpdateMessageRessources.java Source code

Introduction

Here is the source code for org.squale.welcom.addons.message.synchro.TaskCheckUpdateMessageRessources.java

Source

/**
 * Copyright (C) 2008-2010, Squale Project - http://www.squale.org
 *
 * This file is part of Squale.
 *
 * Squale is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Lesser General Public License as
 * published by the Free Software Foundation, either version 3 of the
 * License, or any later version.
 *
 * Squale is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * along with Squale.  If not, see <http://www.gnu.org/licenses/>.
 */
/*
 * Cr le 23 dc. 05
 *
 * Pour changer le modle de ce fichier gnr, allez  :
 * Fentre&gt;Prfrences&gt;Java&gt;Gnration de code&gt;Code et commentaires
 */
package org.squale.welcom.addons.message.synchro;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
import java.util.TimerTask;

import javax.servlet.ServletContext;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.struts.Globals;
import org.squale.welcom.addons.message.MessageResourcesAddons;
import org.squale.welcom.addons.message.WAddOnsMessageManager;
import org.squale.welcom.outils.jdbc.WJdbcMagic;
import org.squale.welcom.outils.jdbc.WStatement;

/**
 * @author M327837 Pour changer le modle de ce commentaire de type gnr, allez  :
 *         Fentre&gt;Prfrences&gt;Java&gt;Gnration de code&gt;Code et commentaires
 */
public class TaskCheckUpdateMessageRessources extends TimerTask {

    /** logger */
    private static Log log = LogFactory.getLog(TaskCheckUpdateMessageRessources.class);

    /** Date de derniere maj */
    private Date internalLastDate;

    /** */
    private ServletContext servletContext;

    /**
     * Initilise le verificateur de synchronisation des messages
     * 
     * @param pServletContext : servelet
     */
    public TaskCheckUpdateMessageRessources(final ServletContext pServletContext) {
        servletContext = pServletContext;
    }

    /**
     * (non-Javadoc)
     * 
     * @see java.lang.Runnable#run()
     */
    public void run() {

        final Date lastDateInBD = getTimeStampBD(WAddOnsMessageManager.ADDONS_MESSAGEMANAGER_NAME);

        if (lastDateInBD != null) {

            if (internalLastDate == null) {
                internalLastDate = lastDateInBD;
            }

            if (internalLastDate.getTime() < lastDateInBD.getTime()) {

                log.info("Synchronisation des MessageResources, suite a mise  jour");

                // Reset
                ((MessageResourcesAddons) servletContext.getAttribute(Globals.MESSAGES_KEY)).resetCache();

                // Memorise le nouveau
                internalLastDate = lastDateInBD;
            }

        }

    }

    /**
     * @return Derniere date de modification, null si la table n'existe pas
     * @param addonName : nom de l'addons
     */
    private Date getTimeStampBD(final String addonName) {
        Date bdDate = null;
        WJdbcMagic jdbcMagic = null;
        try {
            jdbcMagic = new WJdbcMagic();
            final WStatement sta = jdbcMagic.getWStatement();
            sta.add("select * from WEL_ADDONS where");
            sta.addParameter("NAME=?", addonName);
            final ResultSet rs = sta.executeQuery();
            if ((rs != null) && rs.next()) {
                bdDate = new Date(rs.getLong("PARAMETERS"));
            }
            sta.close();

        } catch (final SQLException e) {
            return null;
        } finally {
            if (jdbcMagic != null) {
                jdbcMagic.close();
            }
        }
        return bdDate;
    }

}