TaskCheckUpdateMessageRessources.java

/**
 * 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 d�c. 05
 *
 * Pour changer le mod�le de ce fichier g�n�r�, allez � :
 * Fen�tre>Pr�f�rences>Java>G�n�ration de code>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 mod�le de ce commentaire de type g�n�r�, allez � :
 *         Fen�tre>Pr�f�rences>Java>G�n�ration de code>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;
    }

}