--- a/flys-backend/src/main/java/de/intevation/flys/importer/ImportRange.java	Thu Mar 17 18:07:13 2011 +0000
+++ b/flys-backend/src/main/java/de/intevation/flys/importer/ImportRange.java	Fri Mar 18 12:10:33 2011 +0000
@@ -1,10 +1,26 @@
 package de.intevation.flys.importer;
 
+import de.intevation.flys.model.Range;
+import de.intevation.flys.model.River;
+
+import org.hibernate.Session;
+import org.hibernate.Query;
+
+import java.util.List;
+
+import java.math.BigDecimal;
+
+import org.apache.log4j.Logger;
+
 public class ImportRange
 implements   Comparable<ImportRange>
 {
-    public Double from;
-    public Double to;
+    private static Logger log = Logger.getLogger(ImportRange.class);
+
+    protected Double from;
+    protected Double to;
+
+    protected Range peer;
 
     public ImportRange() {
     }
@@ -48,5 +64,27 @@
     public void setTo(Double to) {
         this.to = to;
     }
+
+    public Range getPeer(River river) {
+        if (peer == null) {
+            Session session = Importer.sessionHolder.get();
+            Query query = session.createQuery(
+                "from Range where a=:a and b=:b and river.id=:river");
+            BigDecimal a = from != null ? BigDecimal.valueOf(from) : null;
+            BigDecimal b = to   != null ? BigDecimal.valueOf(to) : null;
+            query.setParameter("a", a);
+            query.setParameter("b", b);
+            query.setParameter("river", river.getId());
+            List<Range> ranges = query.list();
+            if (ranges.isEmpty()) {
+                peer = new Range(a, b, river);
+                session.save(peer);
+            }
+            else {
+                peer = ranges.get(0);
+            }
+        }
+        return peer;
+    }
 }
 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :