--- a/backend/src/main/java/org/dive4elements/river/model/sinfo/Tkh.java	Fri Apr 20 16:04:34 2018 +0200
+++ b/backend/src/main/java/org/dive4elements/river/model/sinfo/Tkh.java	Mon Apr 23 15:18:48 2018 +0200
@@ -26,7 +26,10 @@
 import javax.persistence.SequenceGenerator;
 import javax.persistence.Table;
 
+import org.dive4elements.river.backend.SessionHolder;
 import org.dive4elements.river.model.River;
+import org.hibernate.Query;
+import org.hibernate.Session;
 
 /**
  * Hibernate binding for the DB table tkh
@@ -171,4 +174,15 @@
     public void addColumn(final TkhColumn value) {
         this.columns.add(value);
     }
+
+    /**
+     * Selects a tkh series by id from the database
+     */
+    public static Tkh getTkhById(final int id) {
+        final Session session = SessionHolder.HOLDER.get();
+        final Query query = session.createQuery("FROM Tkh WHERE id=:id");
+        query.setParameter("id", id);
+        final List<Tkh> rows = query.list();
+        return (rows != null) ? rows.get(0) : null;
+    }
 }
\ No newline at end of file