--- a/flys-backend/src/main/java/de/intevation/flys/importer/ImportPosition.java	Thu Mar 17 17:43:57 2011 +0000
+++ b/flys-backend/src/main/java/de/intevation/flys/importer/ImportPosition.java	Thu Mar 17 18:07:13 2011 +0000
@@ -1,10 +1,19 @@
 package de.intevation.flys.importer;
 
+import de.intevation.flys.model.Position;
+
+import org.hibernate.Session;
+import org.hibernate.Query;
+
+import java.util.List;
+
 public class ImportPosition
 implements   Comparable<ImportPosition>
 {
     protected String value;
 
+    protected Position peer;
+
     public ImportPosition() {
     }
 
@@ -23,6 +32,23 @@
     public void setValue(String value) {
         this.value = value;
     }
+
+    public Position getPeer() {
+        if (peer != null) {
+            Session session = Importer.sessionHolder.get();
+            Query query = session.createQuery("from Position where value=:value");
+            query.setString("value", value);
+            List<Position> positions = query.list();
+            if (positions.isEmpty()) {
+                peer = new Position(value);
+                session.save(peer);
+            }
+            else {
+                peer = positions.get(0);
+            }
+        }
+        return peer;
+    }
 }
 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :