teichmann@5831: package org.dive4elements.river.artifacts.model;
ingo@301: 
felix@1031: import java.math.BigDecimal;
felix@1031: 
ingo@301: import java.util.List;
sascha@644: import java.util.Iterator;
felix@1924: import java.util.Collections;
ingo@301: 
teichmann@5831: import org.dive4elements.river.backend.SessionHolder;
teichmann@5831: import org.dive4elements.river.model.Annotation;
teichmann@5831: import org.dive4elements.river.model.River;
ingo@301: 
ingo@301: import org.hibernate.Session;
ingo@301: import org.hibernate.Query;
ingo@301: 
ingo@301: /**
ingo@301:  * @author <a href="mailto:ingo.weinzierl@intevation.de">Ingo Weinzierl</a>
ingo@301:  */
ingo@301: public class AnnotationsFactory {
ingo@301: 
felix@1031:     /**
felix@1031:      * Get Annotations which do not have a "b" ("to")-value set.
felix@1031:      *
felix@1031:      * @param river name of the river of interest.
felix@1031:      *
felix@1031:      * @return List of Annotations for river which have only "a" ("from")
felix@1031:      *          value set.
felix@1031:      */
felix@1031:     public static List<Annotation> getPointAnnotations(String river) {
felix@1031:         Session session = SessionHolder.HOLDER.get();
felix@1031: 
felix@1031:         Query query = session.createQuery(
felix@1925:             "from Annotation as an " +
felix@1925:             "where an.range.b = null and an.range.river.name=:name " +
felix@1925:             "order by range.a");
felix@1925:         query.setParameter("name", river);
felix@1031:         return query.list();
felix@1031:     }
felix@1031: 
felix@1031: 
felix@1924:     public static List<Annotation> getAnnotations(River river) {
sascha@311:         Session session = SessionHolder.HOLDER.get();
ingo@301: 
sascha@311:         Query query = session.createQuery(
felix@1924:             "from Annotation as an where an.range.river = :river" +
felix@1924:             " order by an.range.a");
felix@1924:         query.setParameter("river", river);
sascha@311:         return query.list();
ingo@301:     }
sascha@644: 
ingo@2063: 
ingo@2063:     public static Annotation getAnnotation(String river, double km) {
ingo@2063:         Session session = SessionHolder.HOLDER.get();
ingo@2063: 
ingo@2063:         Query query = session.createQuery(
ingo@2063:             "from Annotation as a " +
ingo@2063:             "where a.range.river.name = :river AND a.range.a = :km");
ingo@2063: 
ingo@2063:         query.setParameter("river", river);
ingo@2063:         query.setParameter("km", BigDecimal.valueOf(km));
ingo@2063: 
ingo@2063:         List<Annotation> result = query.list();
ingo@2063: 
ingo@2063:         return result != null && result.size() > 0 ? result.get(0) : null;
ingo@2063:     }
ingo@2063: 
ingo@2063: 
felix@1031:     /**
felix@1031:      * Get minimal "a" ("from") and maximal "b" ("to") value of annotations'
felix@1031:      * ranges of a river.
felix@1031:      *
felix@1031:      * @param river name of the river of interest.
felix@1031:      *
felix@1031:      * @return Array containing minimal "a" and max "b" value of any
felix@1031:      *         annotation stored for the given river.
felix@1031:      */
felix@1031:     public static double[] getAnnotationsBreadth(String river) {
felix@1031:         Session session = SessionHolder.HOLDER.get();
felix@1031: 
felix@1031:         Query minAQuery = session.createQuery(
felix@1031:             "select min(a), max(b) from Range where river.name=:name");
felix@1031:         minAQuery.setParameter("name", river);
felix@1031: 
felix@1031:         double[] minAmaxB = {0.0f, 0.0f};
felix@1031:         Object[] row = (Object[]) minAQuery.list().iterator().next();
felix@1031:         minAmaxB[0] = ((BigDecimal) row[0]).doubleValue();
felix@1031:         minAmaxB[1] = ((BigDecimal) row[1]).doubleValue();
felix@1031:         return minAmaxB;
felix@1031:     }
felix@1031: 
felix@1031: 
felix@1924:     public static Iterator<Annotation> getAnnotationsIterator(
felix@1924:         String riverName
felix@1924:     ) {
sascha@644:         Session session = SessionHolder.HOLDER.get();
sascha@644: 
felix@1924:         Query riverQuery = session.createQuery(
felix@1924:             "from River where name = :name");
felix@1924:         riverQuery.setParameter("name", riverName);
felix@1924:         List<River> rivers = riverQuery.list();
felix@1924:         if (rivers.isEmpty()) {
ingo@3785:             return Collections.<Annotation>emptyList().iterator();
felix@1924:         }
sascha@644: 
sascha@644:         Query query = session.createQuery(
felix@1924:             "from Annotation as an" +
felix@1924:             " where an.range.river = :river order by an.range.a");
felix@1924:         query.setParameter("river", rivers.get(0));
felix@1924: 
sascha@644:         return (Iterator<Annotation>)query.iterate();
sascha@644:     }
ingo@301: }
ingo@301: // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf-8 :