Mercurial > dive4elements > river
diff flys-backend/src/main/java/de/intevation/flys/model/BedHeightSingle.java @ 2872:bcfdaa3a5bfc
Added functions to BedHeightSingle and BedHeightEpoch to get instances from db by id or river.
flys-backend/trunk@4434 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
---|---|
date | Fri, 18 May 2012 07:01:47 +0000 |
parents | f283212966e8 |
children | 444e52222941 |
line wrap: on
line diff
--- a/flys-backend/src/main/java/de/intevation/flys/model/BedHeightSingle.java Tue May 15 14:19:55 2012 +0000 +++ b/flys-backend/src/main/java/de/intevation/flys/model/BedHeightSingle.java Fri May 18 07:01:47 2012 +0000 @@ -15,6 +15,11 @@ import javax.persistence.OneToOne; import javax.persistence.OneToMany; +import org.hibernate.Session; +import org.hibernate.Query; + +import de.intevation.flys.backend.SessionHolder; + @Entity @Table(name = "bed_height_single") @@ -216,5 +221,31 @@ public void setValues(List<BedHeightSingleValue> values) { this.values = values; } + + + public static List<BedHeightSingle> getBedHeightSingles(River river) { + Session session = SessionHolder.HOLDER.get(); + + Query query = session.createQuery( + "from BedHeightSingle where river=:river"); + + query.setParameter("river", river); + + return query.list(); + } + + + public static BedHeightSingle getBedHeightSingleById(int id) { + Session session = SessionHolder.HOLDER.get(); + + Query query = session.createQuery( + "from BedHeightSingle where id=:id"); + + query.setParameter("id", id); + + List<BedHeightSingle> singles = query.list(); + + return singles != null ? singles.get(0) : null; + } } // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :