diff flys-backend/src/main/java/de/intevation/flys/importer/ImportSedimentDensityValue.java @ 4524:be9e28cff0c4

Parse and store year in sediment densities. * Year is parsed ('guessed') from description column in .csv file.
author Raimund Renkert <rrenkert@intevation.de>
date Wed, 14 Nov 2012 17:24:55 +0100
parents 8979f2294af9
children db6c7268b08e
line wrap: on
line diff
--- a/flys-backend/src/main/java/de/intevation/flys/importer/ImportSedimentDensityValue.java	Wed Nov 14 17:19:54 2012 +0100
+++ b/flys-backend/src/main/java/de/intevation/flys/importer/ImportSedimentDensityValue.java	Wed Nov 14 17:24:55 2012 +0100
@@ -25,16 +25,20 @@
 
     protected BigDecimal density;
 
+    private BigDecimal year;
+
     protected String description;
 
 
     public ImportSedimentDensityValue(
         BigDecimal station,
         BigDecimal density,
+        BigDecimal year,
         String     description
     ) {
         this.station     = station;
         this.density     = density;
+        this.year        = year;
         this.description = description;
     }
 
@@ -57,11 +61,13 @@
                 "   sedimentDensity=:sedimentDensity and " +
                 "   station=:station and " +
                 "   density=:density and " +
+                "   year=:year and " +
                 "   description=:description");
 
             query.setParameter("sedimentDensity", sedimentDensity);
             query.setParameter("station", station);
             query.setParameter("density", density);
+            query.setParameter("year", year);
             query.setParameter("description", description);
 
             List<SedimentDensityValue> values = query.list();
@@ -72,6 +78,7 @@
                     sedimentDensity,
                     station,
                     density,
+                    year,
                     description);
 
                 session.save(peer);

http://dive4elements.wald.intevation.org