Mercurial > dive4elements > river
diff flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/AnnotationsFactory.java @ 644:02c0cce0e469
Introduce a cache for the distance-info service
flys-artifacts/trunk@2028 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Mon, 30 May 2011 11:34:06 +0000 |
parents | bf4e12f1d025 |
children | bcef54a563ea |
line wrap: on
line diff
--- a/flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/AnnotationsFactory.java Mon May 30 09:19:57 2011 +0000 +++ b/flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/AnnotationsFactory.java Mon May 30 11:34:06 2011 +0000 @@ -1,6 +1,7 @@ package de.intevation.flys.artifacts.model; import java.util.List; +import java.util.Iterator; import de.intevation.flys.backend.SessionHolder; import de.intevation.flys.model.Annotation; @@ -33,5 +34,20 @@ query.setParameterList("ranges", ranges); return query.list(); } + + + public static Iterator<Annotation> getAnnotationsIterator(String river) { + Session session = SessionHolder.HOLDER.get(); + + Query rangesQuery = session.createQuery( + "from Range where river.name=:name"); + rangesQuery.setParameter("name", river); + List<Range> ranges = rangesQuery.list(); + + Query query = session.createQuery( + "from Annotation where range in (:ranges) order by range.a"); + query.setParameterList("ranges", ranges); + return (Iterator<Annotation>)query.iterate(); + } } // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf-8 :