Mercurial > dive4elements > river

diff backend/src/main/java/org/dive4elements/river/model/sinfo/Infrastructure.java @ 9115:a165cd63099f
Added datacage select and chart display for river infrastructure heights loaded from database
author: mschaefer
date: Mon, 04 Jun 2018 11:55:08 +0200
parents: 4c5eeaff554c
children: 1614cb14308f
--- a/backend/src/main/java/org/dive4elements/river/model/sinfo/Infrastructure.java	Mon Jun 04 11:25:29 2018 +0200
+++ b/backend/src/main/java/org/dive4elements/river/model/sinfo/Infrastructure.java	Mon Jun 04 11:55:08 2018 +0200
@@ -25,8 +25,11 @@
 import javax.persistence.SequenceGenerator;
 import javax.persistence.Table;
 
+import org.dive4elements.river.backend.SessionHolder;
 import org.dive4elements.river.model.AnnotationType;
 import org.dive4elements.river.model.River;
+import org.hibernate.Query;
+import org.hibernate.Session;
 
 /**
  * Hibernate binding for the DB table infrastructure
@@ -84,6 +87,7 @@
         this.values = new ArrayList<>();
     }
 
+
     /***** METHODS *****/
 
     @Id
@@ -185,4 +189,14 @@
     public void addValue(final InfrastructureValue value) {
         this.values.add(value);
     }
+
+    /**
+     * Get data series by id
+     */
+    public static Infrastructure getSeries(final int id) {
+        final Session session = SessionHolder.HOLDER.get();
+        final Query query = session.createQuery("FROM Infrastructure WHERE (id=:id)");
+        query.setParameter("id", id);
+        return (Infrastructure) query.list().get(0);
+    }
 }
\ No newline at end of file