source: ether_ndacc_bis/persistence/implementation/com/ether/dao/instrument/InstrumentDAOImpl.java @ 827

package com.ether.dao.instrument;

import java.util.List;

import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.jetbrains.annotations.NotNull;
import org.jetbrains.annotations.Nullable;

import com.ether.PersistenceException;
import com.ether.dao.DomainAccessObjectImpl;
import com.ether.instrument.Instrument;
import com.ether.instrument.InstrumentType;

/**
 * @author vmipsl
 * @date 24 jan 2011
 */
public class InstrumentDAOImpl extends DomainAccessObjectImpl<Instrument, Long>
        implements InstrumentDAO
{
    protected InstrumentDAOImpl() {
        super(Instrument.class);
    }

    public Integer getNbInstruments() throws PersistenceException
    {
        final DetachedCriteria criteria = DetachedCriteria.forClass(Instrument.class)
                .setProjection(Projections.property("id"));

        return count(criteria);
    }

    @Nullable
    public List<Instrument> getInstrumentsByStationId( @NotNull final Long stationId ) throws PersistenceException
    {
        final DetachedCriteria criteria = DetachedCriteria.forClass(Instrument.class)
                .add(Restrictions.eq("station.id", stationId));

        return selectAllByCriteria(Instrument.class, criteria);
    }

    @Nullable
    public List<Instrument> getInstrumentsByType( @NotNull final InstrumentType type ) throws PersistenceException
    {
        final DetachedCriteria criteria = DetachedCriteria.forClass(Instrument.class)
                .add(Restrictions.eq("type", type));

        return selectAllByCriteria(Instrument.class, criteria);
    }
}