--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/flys-backend/src/main/java/de/intevation/flys/importer/ImportDischargeTableValue.java	Tue Mar 22 12:15:18 2011 +0000
@@ -0,0 +1,59 @@
+package de.intevation.flys.importer;
+
+import java.math.BigDecimal;
+import java.util.List;
+
+import org.hibernate.Session;
+import org.hibernate.Query;
+
+import de.intevation.flys.model.DischargeTable;
+import de.intevation.flys.model.DischargeTableValue;
+
+
+public class ImportDischargeTableValue
+{
+    private Integer id;
+
+    private BigDecimal q;
+    private BigDecimal w;
+
+    private ImportDischargeTable dischargeTable;
+
+    private DischargeTableValue peer;
+
+
+    public ImportDischargeTableValue() {
+    }
+
+
+    public ImportDischargeTableValue(BigDecimal q, BigDecimal w) {
+        this.dischargeTable = dischargeTable;
+        this.q              = q;
+        this.w              = w;
+    }
+
+
+    public DischargeTableValue getPeer(DischargeTable dischargeTable) {
+        if (peer == null) {
+            Session session = Importer.sessionHolder.get();
+
+            Query query = session.createQuery(
+                "from DischargeTableValue where " +
+                "dischargeTable.id=:tableId and q=:q and w=:w");
+            query.setParameter("tableId", dischargeTable.getId());
+            query.setParameter("q", q);
+            query.setParameter("w", w);
+
+            List<DischargeTableValue> dischargeTableValues = query.list();
+            if (dischargeTableValues.isEmpty()) {
+                peer = new DischargeTableValue(dischargeTable, q, w);
+                session.save(peer);
+            }
+            else {
+                peer = dischargeTableValues.get(0);
+            }
+        }
+
+        return peer;
+    }
+}