MetricDAOImpl.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/>.
 */
package org.squale.squalecommon.daolayer.result;

import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

import org.squale.jraf.commons.exception.JrafDaoException;
import org.squale.jraf.provider.persistence.hibernate.AbstractDAOImpl;
import org.squale.jraf.spi.persistence.ISession;
import org.squale.squalecommon.daolayer.DAOUtils;
import org.squale.squalecommon.enterpriselayer.businessobject.component.ApplicationBO;
import org.squale.squalecommon.enterpriselayer.businessobject.component.AuditBO;
import org.squale.squalecommon.enterpriselayer.businessobject.result.IntegerMetricBO;
import org.squale.squalecommon.enterpriselayer.businessobject.result.MetricBO;
import org.squale.squalecommon.util.mapping.Mapping;

/**
 */
public class MetricDAOImpl
    extends AbstractDAOImpl
{

    /**
     * Instance singleton
     */
    private static MetricDAOImpl instance = null;

    /** initialisation du singleton */
    static
    {
        instance = new MetricDAOImpl();
    }

    /**
     * Constructeur prive
     * 
     * @throws JrafDaoException
     */
    private MetricDAOImpl()
    {
        initialize( MetricBO.class );
    }

    /**
     * Retourne un singleton du DAO
     * 
     * @return singleton du DAO
     */
    public static MetricDAOImpl getInstance()
    {
        return instance;
    }

    /**
     * Retourne la volum�trie d'un projet
     * 
     * @param pSession le session
     * @param pProjectId l'id du projet
     * @return la volum�trie des applis du site
     * @throws JrafDaoException en cas d'�chec
     */
    public int getVolumetry( ISession pSession, Long pProjectId )
        throws JrafDaoException
    {
        String whereClause = " where " + getAlias() + ".name='sloc'";
        whereClause += " AND " + getAlias() + ".measure.component=" + pProjectId;
        Collection coll = findWhere( pSession, whereClause );
        int counter = 0;
        Iterator it = coll.iterator();
        while ( it.hasNext() )
        {
            IntegerMetricBO value = (IntegerMetricBO) it.next();
            counter += ( (Integer) value.getValue() ).intValue();
        }
        return counter;
    }

    /**
     * Retourne la volum�trie d'un site
     * 
     * @param pSession le session
     * @param pSiteId l'id du site
     * @return la volum�trie des applis du site
     * @throws JrafDaoException en cas d'�chec
     */
    public int getVolumetryBySite( ISession pSession, long pSiteId )
        throws JrafDaoException
    {
        String whereClause = " where " + getAlias() + ".name='sloc'";
        whereClause += " AND " + getAlias() + ".measure.component.parent.serveurBO.serveurId='" + pSiteId + "'";
        Collection coll = findWhere( pSession, whereClause );
        int counter = 0;
        Iterator it = coll.iterator();
        while ( it.hasNext() )
        {
            IntegerMetricBO value = (IntegerMetricBO) it.next();
            counter += ( (Integer) value.getValue() ).intValue();
        }
        return counter;
    }

    /**
     * Retourne la volum�trie des derniers audits r�ussis par rapport � un site et � un profil pour les derniers audits
     * ex�cut�s (r�ussis ou partiels)
     * 
     * @param pSession le session
     * @param pSiteId l'id du site
     * @param pProfile le profil du projet (java, cpp...)
     * @return la volum�trie des applis du site
     * @throws JrafDaoException en cas d'�chec
     */
    public int getVolumetryBySiteAndProfil( ISession pSession, long pSiteId, String pProfile , ArrayList<String> treKeyList )
        throws JrafDaoException
    {
        
        StringBuffer whereClause = new StringBuffer(" where (");
        // On s�lectionne le nom de la m�trique correspondant au nombre de lignes
        Iterator<String> treKeyIt = treKeyList.iterator();
        while( treKeyIt.hasNext() )
        {
            String treKey = treKeyIt.next();
            whereClause.append( "(" );
            whereClause.append( getAlias() );
            whereClause.append( ".measure.class=" );
            whereClause.append( Mapping.getMetricClass( treKey ).getName() );
            whereClause.append( " AND " );
            whereClause.append( getAlias() );
            whereClause.append( ".name='" );
            whereClause.append( treKey.substring( treKey.lastIndexOf( '.' ) + 1 ) );
            whereClause.append( "')" );
            if(treKeyIt.hasNext())
            {
                whereClause.append( " OR " );
            }
            else
            {
                whereClause.append( ")" );
            }
        }
        
        // crit�re du site
        whereClause.append( " AND " );
        whereClause.append( getAlias() );        
        whereClause.append( ".measure.component.parent.serveurBO.serveurId='");
        whereClause.append( pSiteId );
        whereClause.append( "'");
        
        // on ne prend pas en compte les applications supprim�es
        whereClause.append( " AND ");
        whereClause.append( getAlias());
        whereClause.append( ".measure.component.parent.status!=");
        whereClause.append( ApplicationBO.DELETED);
        
        // crit�re du profil
        whereClause.append( " AND " );
        whereClause.append( getAlias() );
        whereClause.append( ".measure.component.profile.name='");
        whereClause.append( pProfile );
        whereClause.append( "'");
        
        
        // Les audits doivent �tre supprim�s ou partiels
        whereClause.append( " AND (" );
        whereClause.append( getAlias() );
        whereClause.append(".measure.audit.status=" );
        whereClause.append( AuditBO.TERMINATED);
        
        whereClause.append( " OR " );
        whereClause.append( getAlias() );
        whereClause.append(".measure.audit.status=");
        whereClause.append(AuditBO.PARTIAL);
        whereClause.append(")");
        
        whereClause.append( " order by " );
        whereClause.append( getAlias() );
        whereClause.append( ".measure.component.id, ");
        whereClause.append( getAlias() );
        whereClause.append( ".measure.audit.status asc, coalesce(");
        whereClause.append( getAlias() );
        whereClause.append( ".measure.audit.historicalDate, ");
        whereClause.append( getAlias() );
        whereClause.append( ".measure.audit.date) desc");
        List results = findWhere( pSession, whereClause.toString() );
        int result = 0;
        long lastProjectId = -1;
        long lastAuditId = -1;
        for ( int i = 0; i < results.size(); i++ )
        {
            MetricBO cur = (MetricBO) results.get( i );
            if ( cur.getMeasure().getComponent().getId() != lastProjectId )
            {
           		// Il s'agit d'entiers
           		if ( cur.getValue()!=null)
           		{
           			result += ( (Integer) cur.getValue() ).intValue();
           		}
           		lastAuditId = cur.getMeasure().getAudit().getId();
            }
            else if ( cur.getMeasure().getAudit().getId() == lastAuditId )
            {
                // On ajoute la valeur car il s'agit d'une volum�trie diff�rente
            	if ( cur.getValue()!=null)
            	{
            		result += ( (Integer) cur.getValue() ).intValue();
            	}
            }
            lastProjectId = cur.getMeasure().getComponent().getId();
        }
        return result;
    }

    /**
     * R�cup�ration des mesures sur un audit
     * 
     * @param pSession session Hibernate
     * @param pAppliID identifiant de l'appli
     * @param pSince la date a partir de laquelle on veut calculer les ROI
     * @return ensemble des mesures � l'exclusion des transgressions
     * @throws JrafDaoException exception DAO
     */
    public Collection findROIWhereApplicationSinceDate( ISession pSession, Long pAppliID, Date pSince )
        throws JrafDaoException
    {
        String whereClause = "where ";
        whereClause += getAlias() + ".measure.component.id = '" + pAppliID + "'";
        whereClause += " and ";
        whereClause += getAlias() + ".measure.class = 'Roi'";
        whereClause += " and ";
        whereClause += getAlias() + ".measure.audit.date > " + DAOUtils.makeQueryDate( pSince );
        // Un nom de subclass correspondant � une transgression doit finir par 'Transgression'
        // TODO : Il faudra s�rement consid�rer les transgressions comme des mesures � part...
        whereClause += " and " + getAlias() + ".class not like '%Transgression'";
        Collection col = findWhere( pSession, whereClause );
        return col;
    }

    /**
     * Retourne les valeur distinct de mesure de type Integer donn�es par leur TRE
     * 
     * @param pSession Session Jraf
     * @param pProjectId Id du projet
     * @param pAuditId Id de l'audit courant
     * @param pTreKey Liste des Tre � recuperer / tri�
     * @return Liste de masures distinctes (Collection de Object[])
     * @throws JrafDaoException si pb de BD
     */
    public IntegerMetricBO findIntegerMetricWhere( ISession pSession, long pProjectId, long pAuditId, String pTreKey )
        throws JrafDaoException
    {
        IntegerMetricBO result = null;
        StringBuffer whereClause = new StringBuffer( "where " );
        whereClause.append( getAlias() );
        whereClause.append( ".measure.audit.id=" );
        whereClause.append( pAuditId );
        whereClause.append( " and " );
        whereClause.append( getAlias() );
        whereClause.append( ".measure.component.id=" );
        whereClause.append( pProjectId );
        whereClause.append( " and " );
        whereClause.append( getAlias() );
        whereClause.append( ".measure.class=" );
        whereClause.append( Mapping.getMetricClass( pTreKey ).getName() );
        whereClause.append( " and " );
        whereClause.append( getAlias() );
        whereClause.append( ".name='" );
        whereClause.append( pTreKey.substring( pTreKey.lastIndexOf( '.' ) + 1 ) );
        whereClause.append( "'" );
        whereClause.append( " and " );
        whereClause.append( getAlias() );
        whereClause.append( ".class='Int'" );
        List results = findWhere( pSession, whereClause.toString() );
        if ( results.size() > 0 )
        {
            result = (IntegerMetricBO) results.get( 0 );
        }
        return result;
    }

}