--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/backend/src/main/java/org/dive4elements/river/importer/ImportOfficialLine.java	Fri Jun 14 17:56:52 2013 +0200
@@ -0,0 +1,65 @@
+/* Copyright (C) 2011, 2012, 2013 by Bundesanstalt für Gewässerkunde
+ * Software engineering by Intevation GmbH
+ *
+ * This file is Free Software under the GNU AGPL (>=v3)
+ * and comes with ABSOLUTELY NO WARRANTY! Check out the
+ * documentation coming with Dive4Elements River for details.
+ */
+
+package org.dive4elements.river.importer;
+
+import java.util.List;
+
+import org.dive4elements.river.model.NamedMainValue;
+import org.dive4elements.river.model.OfficialLine;
+import org.dive4elements.river.model.River;
+import org.dive4elements.river.model.WstColumn;
+import org.hibernate.Query;
+import org.hibernate.Session;
+
+public class ImportOfficialLine
+{
+    protected String name;
+    protected ImportWstColumn wstColumn;
+
+    protected OfficialLine peer;
+
+    public ImportOfficialLine() {
+    }
+
+    public ImportOfficialLine(String name, ImportWstColumn wstColumn) {
+        this.name = name;
+        this.wstColumn = wstColumn;
+    }
+
+    public OfficialLine getPeer(River river) {
+        if (peer == null) {
+            // XXX: This is a bit odd. We do not have not enough infos here
+            // to create a new NamedMainValue. So we just look for existing ones.
+            Session session = ImporterSession.getInstance().getDatabaseSession();
+            NamedMainValue nmv = NamedMainValue.fetchByName(name, session);
+            if (nmv == null) {
+                // failed -> failed to create OfficialLine
+                return null;
+            }
+            WstColumn wc = wstColumn.getPeer(river);
+            Query query = session.createQuery(
+                "from OfficialLine " +
+                "where namedMainValue = :nmv and wstColumn = :wc");
+            query.setParameter("nmv", nmv);
+            query.setParameter("wc", wc);
+            List<OfficialLine> lines = query.list();
+            if (lines.isEmpty()) {
+                peer = new OfficialLine(wc, nmv);
+                session.save(peer);
+            }
+            else {
+                peer = lines.get(0);
+            }
+
+        }
+        return peer;
+    }
+}
+// vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :
+

--- a/backend/src/main/java/org/dive4elements/river/model/NamedMainValue.java	Fri Jun 14 17:11:33 2013 +0200
+++ b/backend/src/main/java/org/dive4elements/river/model/NamedMainValue.java	Fri Jun 14 17:56:52 2013 +0200
@@ -9,6 +9,7 @@
 package org.dive4elements.river.model;
 
 import java.io.Serializable;
+import java.util.List;
 
 import javax.persistence.Entity;
 import javax.persistence.Id;
@@ -20,6 +21,9 @@
 import javax.persistence.OneToOne;
 import javax.persistence.JoinColumn;
 
+import org.hibernate.Query;
+import org.hibernate.Session;
+
 @Entity
 @Table(name = "named_main_values")
 public class NamedMainValue
@@ -72,5 +76,13 @@
     public void setType(MainValueType type) {
         this.type = type;
     }
+
+    public static NamedMainValue fetchByName(String name, Session session) {
+        Query query = session.createQuery(
+            "from NamedMainValue where name=:name");
+        query.setString("name", name);
+        List<NamedMainValue> named = query.list();
+        return named.isEmpty() ? null : named.get(0);
+    }
 }
 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :