ingo@301: package de.intevation.flys.artifacts.model;
ingo@301:
felix@1031: import java.math.BigDecimal;
felix@1031:
ingo@301: import java.util.List;
sascha@644: import java.util.Iterator;
ingo@301:
ingo@315: import de.intevation.flys.backend.SessionHolder;
ingo@301: import de.intevation.flys.model.Annotation;
ingo@301: import de.intevation.flys.model.Range;
ingo@301: import de.intevation.flys.model.River;
ingo@301:
ingo@301: import org.hibernate.Session;
ingo@301: import org.hibernate.Query;
ingo@301:
ingo@301: /**
ingo@301: * @author Ingo Weinzierl
ingo@301: */
ingo@301: public class AnnotationsFactory {
ingo@301:
ingo@301: public static List getAnnotations(River river) {
ingo@301: return getAnnotations(river.getName());
ingo@301: }
ingo@301:
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 getPointAnnotations(String river) {
felix@1031: Session session = SessionHolder.HOLDER.get();
felix@1031:
felix@1031: Query rangesQuery = session.createQuery(
felix@1031: "from Range where river.name=:name and b = null");
felix@1031: rangesQuery.setParameter("name", river);
felix@1031: List ranges = rangesQuery.list();
felix@1031:
felix@1031: Query query = session.createQuery(
felix@1031: "from Annotation where range in (:ranges) order by range.a");
felix@1031: query.setParameterList("ranges", ranges);
felix@1031: return query.list();
felix@1031: }
felix@1031:
felix@1031:
ingo@301: public static List getAnnotations(String river) {
sascha@311: Session session = SessionHolder.HOLDER.get();
ingo@301:
sascha@311: Query rangesQuery = session.createQuery(
sascha@311: "from Range where river.name=:name");
sascha@311: rangesQuery.setParameter("name", river);
sascha@311: List ranges = rangesQuery.list();
ingo@301:
sascha@311: Query query = session.createQuery(
ingo@332: "from Annotation where range in (:ranges) order by range.a");
sascha@311: query.setParameterList("ranges", ranges);
sascha@311: return query.list();
ingo@301: }
sascha@644:
sascha@644:
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:
sascha@644: public static Iterator getAnnotationsIterator(String river) {
sascha@644: Session session = SessionHolder.HOLDER.get();
sascha@644:
sascha@644: Query rangesQuery = session.createQuery(
sascha@644: "from Range where river.name=:name");
sascha@644: rangesQuery.setParameter("name", river);
sascha@644: List ranges = rangesQuery.list();
sascha@644:
sascha@644: Query query = session.createQuery(
sascha@644: "from Annotation where range in (:ranges) order by range.a");
sascha@644: query.setParameterList("ranges", ranges);
sascha@644: return (Iterator)query.iterate();
sascha@644: }
ingo@301: }
ingo@301: // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf-8 :