lada/lada-server: src/main/java/de/intevation/lada/importer/laf/AttributeMapper.java annotate

annotate src/main/java/de/intevation/lada/importer/laf/AttributeMapper.java @ 616:e62d1703f099

Removed @Stateless annotations.

author	Raimund Renkert <raimund.renkert@intevation.de>
date	Fri, 17 Apr 2015 13:22:45 +0200
parents	3f57484e06f1
children	9e733f44d8b0

rev	line source
610 374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	1 package de.intevation.lada.importer.laf;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	2
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	3 import java.math.BigInteger;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	4 import java.sql.Timestamp;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	5 import java.text.DateFormat;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	6 import java.text.ParseException;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	7 import java.text.SimpleDateFormat;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	8 import java.util.ArrayList;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	9 import java.util.Date;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	10 import java.util.List;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	11 import java.util.regex.Matcher;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	12 import java.util.regex.Pattern;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	13
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	14 import javax.ejb.Stateless;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	15 import javax.inject.Inject;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	16 import javax.persistence.Query;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	17
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	18 import org.apache.log4j.Logger;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	19
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	20 import de.intevation.lada.importer.ReportItem;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	21 import de.intevation.lada.model.land.LKommentarM;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	22 import de.intevation.lada.model.land.LKommentarP;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	23 import de.intevation.lada.model.land.LMessung;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	24 import de.intevation.lada.model.land.LMesswert;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	25 import de.intevation.lada.model.land.LProbe;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	26 import de.intevation.lada.model.land.LZusatzWert;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	27 import de.intevation.lada.model.land.MessungTranslation;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	28 import de.intevation.lada.model.land.ProbeTranslation;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	29 import de.intevation.lada.util.annotation.RepositoryConfig;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	30 import de.intevation.lada.util.data.QueryBuilder;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	31 import de.intevation.lada.util.data.Repository;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	32 import de.intevation.lada.util.data.RepositoryType;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	33 import de.intevation.lada.util.rest.Response;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	34
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	35 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	36 * The AttributeMapper is used to set object attributes via string based
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	37 * key value pairs. The key represents a member of an entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	38 *
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	39 * @author <a href="mailto:rrenkert@intevation.de">Raimund Renkert</a>
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	40 */
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	41 public class AttributeMapper
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	42 {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	43
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	44 @Inject
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	45 private Logger logger;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	46
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	47 @Inject
615 3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	48 @RepositoryConfig(type=RepositoryType.RO)
610 374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	49 private Repository repository;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	50
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	51 private List<ReportItem> warnings;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	52 private List<ReportItem> errors;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	53
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	54 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	55 * Default constructor to create a new AttributeMapper object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	56 */
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	57 public AttributeMapper() {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	58 this.warnings = new ArrayList<ReportItem>();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	59 this.errors = new ArrayList<ReportItem>();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	60 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	61
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	62 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	63 * Add an attribute to the given LProbe object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	64 *
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	65 * @param key The key mapping to a object member.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	66 * @param value The value to set.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	67 * @param probe The entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	68 * @return The updated entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	69 */
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	70 public LProbe addAttribute(String key, Object value, LProbe probe) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	71 DateFormat format = new SimpleDateFormat("yyyyMMdd HHmm");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	72 if ("datenbasis_s".equals(key) && probe.getDatenbasisId() == null) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	73 Integer v = Integer.valueOf(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	74 probe.setDatenbasisId(v);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	75 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	76 else if ("datenbasis_s".equals(key) && probe.getDatenbasisId() != null){
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	77 this.warnings.add(new ReportItem(key, value.toString(), 672));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	78 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	79
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	80 if ("datenbasis".equals(key) && probe.getDatenbasisId() == null) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	81 String nativeQuery = "select id from stammdaten.datenbasis where datenbasis = '";
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	82 nativeQuery += value.toString() + "'";
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	83 Query query = repository.entityManager("land").createNativeQuery(nativeQuery);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	84 List<Object[]> result = query.getResultList();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	85
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	86 Integer v = Integer.valueOf(result.get(0)[0].toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	87 probe.setDatenbasisId(v);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	88 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	89 else if ("datenbasis".equals(key) && probe.getDatenbasisId() != null){
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	90 this.warnings.add(new ReportItem(key, value.toString(), 672));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	91 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	92
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	93 if ("hauptprobennummer".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	94 probe.setHauptprobenNr(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	95 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	96
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	97 if ("mpr_id".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	98 Integer v = Integer.valueOf(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	99 probe.setMprId(v);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	100 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	101
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	102 if ("netzkennung".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	103 probe.setNetzbetreiberId(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	104 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	105
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	106 if ("messstelle".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	107 probe.setMstId(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	108 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	109
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	110 if ("messprogramm_s".equals(key) && probe.getBaId() == null) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	111 probe.setBaId(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	112 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	113 else if ("messprogramm_s".equals(key) && probe.getBaId() != null){
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	114 this.warnings.add(new ReportItem(key, value.toString(), 672));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	115 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	116
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	117 if ("soll_datum_uhrzeit_a".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	118 try {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	119 Date d = format.parse(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	120 probe.setSolldatumBeginn(new Timestamp(d.getTime()));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	121 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	122 catch (ParseException e) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	123 this.warnings.add(new ReportItem(key, value.toString(), 674));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	124 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	125 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	126 if ("soll_datum_uhrzeit_e".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	127 try {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	128 Date d = format.parse(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	129 probe.setSolldatumEnde(new Timestamp(d.getTime()));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	130 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	131 catch (ParseException e) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	132 this.warnings.add(new ReportItem(key, value.toString(), 674));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	133 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	134 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	135 if ("probenahme_datum_uhrzeit_a".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	136 try {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	137 Date d = format.parse(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	138 probe.setProbeentnahmeBeginn(new Timestamp(d.getTime()));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	139 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	140 catch (ParseException e) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	141 this.warnings.add(new ReportItem(key, value.toString(), 674));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	142 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	143 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	144 if ("probenahme_datum_uhrzeit_e".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	145 try {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	146 Date d = format.parse(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	147 probe.setProbeentnahmeEnde(new Timestamp(d.getTime()));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	148 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	149 catch (ParseException e) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	150 this.warnings.add(new ReportItem(key, value.toString(), 674));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	151 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	152 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	153
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	154 if ("umweltbereich_s".equals(key) && probe.getUmwId() == null) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	155 probe.setUmwId(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	156 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	157 else if ("umweltbereich_s".equals(key) && probe.getUmwId() != null){
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	158 this.warnings.add(new ReportItem(key, value.toString(), 672));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	159 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	160 if ("umweltbereich_c".equals(key) && probe.getUmwId() == null) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	161 String nativeQuery = "select id from stammdaten.umwelt where umwelt_bereich= '";
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	162 int length = value.toString().length() > 80 ? 80 : value.toString().length();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	163 nativeQuery += value.toString().substring(0, length) + "'";
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	164 Query query = repository.entityManager("land").createNativeQuery(nativeQuery);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	165 List<Object[]> result = query.getResultList();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	166 probe.setUmwId(result.get(0)[0].toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	167 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	168 else if ("umweltbereich_c".equals(key) && probe.getUmwId() != null){
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	169 this.warnings.add(new ReportItem(key, value.toString(), 672));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	170 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	171
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	172 if ("deskriptoren".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	173 probe.setMediaDesk(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	174 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	175
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	176 if ("testdaten".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	177 if (!value.toString().equals("0")) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	178 probe.setTest(true);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	179 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	180 else {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	181 probe.setTest(false);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	182 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	183 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	184
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	185 if ("medium".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	186 probe.setMedia(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	187 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	188
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	189 if ("probenart".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	190 String nativeQuery = "select id from stammdaten.probenart where probenart = '";
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	191 nativeQuery += value.toString() + "'";
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	192 Query query = repository.entityManager("land").createNativeQuery(nativeQuery);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	193 List<Object> result = query.getResultList();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	194 probe.setProbenartId(Integer.valueOf(result.get(0).toString()));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	195 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	196 return probe;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	197 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	198
615 3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	199 public ProbeTranslation addAttribute(
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	200 String key,
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	201 Object value,
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	202 ProbeTranslation probeTranslation
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	203 ) {
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	204 if ("probe_id".equals(key)) {
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	205 QueryBuilder<ProbeTranslation> builder =
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	206 new QueryBuilder<ProbeTranslation>(
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	207 repository.entityManager("land"), ProbeTranslation.class);
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	208 builder.and("probeIdAlt", value);
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	209 Response response =
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	210 repository.filter(builder.getQuery(), "land");
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	211 List<ProbeTranslation> info = (List<ProbeTranslation>)response.getData();
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	212 if (info != null && info.size() > 0) {
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	213 errors.add(new ReportItem("probe_id", value.toString(), 671));
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	214 return null;
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	215 }
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	216 probeTranslation.setProbeIdAlt(value.toString());
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	217 }
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	218 return probeTranslation;
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	219 }
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	220
610 374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	221 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	222 * Add an attribute to the given LKommentarP object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	223 *
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	224 * @param key The key mapping to a object member.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	225 * @param value The value to set.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	226 * @param kommentar The entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	227 * @return The updated entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	228 */
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	229 public LKommentarP addAttribute(
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	230 String key,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	231 Object value,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	232 LKommentarP kommentar
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	233 ) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	234 DateFormat format = new SimpleDateFormat("yyyyMMdd HHmm");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	235 String v = value.toString();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	236 String erzeuger = v.substring(1, 6);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	237 String date = v.substring(8, 21);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	238 Date d;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	239 try {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	240 d = format.parse(date);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	241 kommentar.setDatum(new Timestamp(d.getTime()));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	242 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	243 catch (ParseException e) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	244 this.warnings.add(new ReportItem(key, value.toString(), 674));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	245 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	246 String text = v.substring(23, v.length() -1);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	247 kommentar.setErzeuger(erzeuger);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	248 kommentar.setText(text);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	249 return kommentar;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	250 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	251
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	252 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	253 * Add an attribute to the given LKommentarM object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	254 *
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	255 * @param key The key mapping to a object member.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	256 * @param value The value to set.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	257 * @param kommentar The entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	258 * @return The updated entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	259 */
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	260 public LKommentarM addAttribute(
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	261 String key,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	262 Object value,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	263 LKommentarM kommentar
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	264 ) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	265 DateFormat format = new SimpleDateFormat("yyyyMMdd HHmm");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	266 String v = value.toString();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	267 String erzeuger = v.substring(1, 6);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	268 String date = v.substring(8, 21);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	269 Date d;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	270 try {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	271 d = format.parse(date);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	272 kommentar.setDatum(new Timestamp(d.getTime()));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	273 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	274 catch (ParseException e) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	275 this.warnings.add(new ReportItem(key, value.toString(), 674));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	276 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	277 String text = v.substring(23, v.length() -1);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	278 kommentar.setErzeuger(erzeuger);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	279 kommentar.setText(text);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	280 return kommentar;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	281 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	282
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	283 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	284 * Add an attribute to the given LMessung object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	285 *
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	286 * @param key The key mapping to a object member.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	287 * @param value The value to set.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	288 * @param messung The entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	289 * @return The updated entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	290 */
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	291 public LMessung addAttribute(
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	292 String key,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	293 Object value,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	294 LMessung messung
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	295 ) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	296 DateFormat format = new SimpleDateFormat("yyyyMMdd HHmm");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	297 if ("nebenprobennummer".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	298 messung.setNebenprobenNr(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	299 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	300 else if ("mess_datum_uhrzeit".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	301 try {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	302 Date d = format.parse(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	303 messung.setMesszeitpunkt(new Timestamp(d.getTime()));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	304 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	305 catch (ParseException e) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	306 this.warnings.add(new ReportItem(key, value.toString(), 674));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	307 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	308 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	309 else if ("messzeit_sekunden".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	310 Integer i = Integer.valueOf(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	311 messung.setMessdauer(i);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	312 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	313 else if ("messmethode_s".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	314 messung.setMmtId(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	315 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	316 else if ("bearbeitungsstatus".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	317 //ignored.!?
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	318 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	319 else if ("erfassung_abgeschlossen".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	320 if(!value.toString().equals("0")) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	321 messung.setFertig(true);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	322 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	323 else {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	324 messung.setFertig(false);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	325 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	326 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	327 return messung;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	328 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	329
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	330 public MessungTranslation addAttribute(
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	331 String key,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	332 Object value,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	333 MessungTranslation mt
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	334 ) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	335 if ("messungs_id".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	336 mt.setMessungsIdAlt(Integer.valueOf(value.toString()));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	337 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	338 return mt;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	339 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	340
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	341 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	342 * Add an attribute to the given LMesswert object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	343 *
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	344 * @param key The key mapping to a object member.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	345 * @param value The value to set.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	346 * @param messwert The entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	347 * @return The updated entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	348 */
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	349 public LMesswert addAttribute(
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	350 String key,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	351 Object value,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	352 LMesswert messwert
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	353 ) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	354 Pattern p = Pattern.compile(
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	355 "(\".+\")( .+ )(\".+\")( .*)( .{1,12})( .{1,9})(.{0,9})(.{0,3})");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	356 //TODO Does not perfectly match... Use better matching for floats.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	357 Matcher m = p.matcher(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	358 if (m.matches()) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	359 String messgroesse = m.group(1).substring(1, m.group(1).length() - 1);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	360 String wert = m.group(2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	361 String einheit = m.group(3).substring(1, m.group(3).length() - 1);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	362 if (wert.startsWith(" <")) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	363 wert = wert.substring(2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	364 messwert.setGrenzwertueberschreitung(false);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	365 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	366 else if (wert.startsWith(" >")) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	367 wert = wert.substring(2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	368 messwert.setGrenzwertueberschreitung(true);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	369 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	370 float fWert = Float.valueOf(wert);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	371 messwert.setMesswert(fWert);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	372
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	373 String nativeQuery = "select id from stammdaten.mess_einheit where einheit = '";
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	374 nativeQuery += einheit + "'";
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	375 Query query = repository.entityManager("land").createNativeQuery(nativeQuery);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	376 List<Object> result = query.getResultList();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	377
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	378 if (result.isEmpty()) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	379 this.errors.add(new ReportItem("messeinheit", "null", 673));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	380 return null;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	381 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	382 else {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	383 messwert.setMehId((Integer)result.get(0));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	384 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	385
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	386 String nativeQuery2 = "select id from stammdaten.messgroesse where messgroesse = '";
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	387 nativeQuery2 += messgroesse + "'";
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	388 Query query2 = repository.entityManager("land").createNativeQuery(nativeQuery2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	389 List<Object> result2 = query2.getResultList();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	390
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	391 if (result2.isEmpty()) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	392 this.errors.add(new ReportItem("messgroesse", "null", 673));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	393 return null;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	394 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	395 else {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	396 messwert.setMessgroesseId((Integer)result2.get(0));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	397 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	398 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	399 return messwert;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	400 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	401
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	402 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	403 * Add an attribute to the OrtCreator. The creator is used to build the
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	404 * two objects Ort and LOrt.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	405 *
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	406 * @param key The key mapping to a object member.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	407 * @param value The value to set.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	408 * @param ort The creator object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	409 * @return The updated creator object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	410 */
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	411 public OrtCreator addAttribute(
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	412 String key,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	413 Object value,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	414 OrtCreator ort
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	415 ) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	416 if ("ort_code".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	417 ort.setOrtCode(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	418 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	419 if ("ort_typ".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	420 ort.setOrtTyp(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	421 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	422 if ("ort_zusatz".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	423 ort.setZusatztext(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	424 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	425 if ("ort_land_lang".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	426 ort.setLandLang(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	427 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	428 if ("ort_land_kurz".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	429 ort.setLandKurz(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	430 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	431 if ("ort_land_s".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	432 ort.setLandS(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	433 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	434 if ("ort_gemeindeschlüssel".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	435 ort.setGemSchluessel(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	436 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	437 if ("ort_bezeichnung".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	438 ort.setBezeichnung(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	439 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	440 if ("ort_beschreibung".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	441 ort.setBeschreibung(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	442 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	443 if ("ort_nuts_code".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	444 ort.setNuts(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	445 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	446 if ("ort_hoehe_land".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	447 ort.setHoehe(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	448 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	449 if ("ort_koordinaten".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	450 ort.setKoordinaten(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	451 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	452 if ("ort_koordinaten_s".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	453 ort.setKoordinatenS(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	454 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	455 return ort;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	456 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	457
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	458 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	459 * Add an attribute to the given LZusatzwert object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	460 *
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	461 * @param lKey The key mapping to a object member.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	462 * @param value The value to set.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	463 * @param wert The entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	464 * @return The updated entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	465 */
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	466 public LZusatzWert addAttribute(
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	467 String lKey,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	468 Object value,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	469 LZusatzWert wert
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	470 ) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	471 String v = value.toString().substring(1);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	472 int ndx = v.indexOf("\"");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	473 String groesse = v.substring(0, ndx);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	474 v = v.substring(ndx + 2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	475 ndx = v.indexOf(" ");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	476 String w = v.substring(0, ndx);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	477 v = v.substring(ndx + 2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	478 ndx = v.indexOf("\"");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	479 String einheit = v.substring(0, ndx);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	480 String fehler = v.substring(ndx + 2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	481
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	482 String nativeQuery = "select id from stammdaten.probenzusatz where zusatzwert = '";
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	483 nativeQuery += groesse + "'";
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	484 Query query = repository.entityManager("land").createNativeQuery(nativeQuery);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	485 List<Object[]> result = query.getResultList();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	486
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	487 if (result == null \|\| result.isEmpty()) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	488 this.errors.add(new ReportItem(lKey, "zusatzwert", 673));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	489 return null;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	490 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	491 wert.setPzsId(result.get(0)[0].toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	492 wert.setMesswertPzs(Float.valueOf(w));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	493 wert.setMessfehler(Float.valueOf(fehler));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	494 return wert;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	495 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	496
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	497 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	498 * Add an attribute to the given LZusatzwert object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	499 *
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	500 * @param lKey The key mapping to a object member.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	501 * @param value The value to set.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	502 * @param wert The entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	503 * @return The updated entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	504 */
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	505 public LZusatzWert addAttributeS(
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	506 String lKey,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	507 Object value,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	508 LZusatzWert wert
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	509 ) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	510 String v = value.toString().substring(1);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	511 int ndx = v.indexOf("\"");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	512 String groesse = v.substring(0, ndx);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	513 v = v.substring(ndx + 2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	514 ndx = v.indexOf(" ");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	515 String w = v.substring(0, ndx);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	516 v = v.substring(ndx + 2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	517 ndx = v.indexOf(" ");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	518 String einheit = v.substring(0, ndx);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	519 String fehler = v.substring(ndx + 2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	520 wert.setPzsId(groesse);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	521 wert.setMesswertPzs(Float.valueOf(w));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	522 wert.setMessfehler(Float.valueOf(fehler));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	523 return wert;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	524 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	525
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	526 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	527 * @return the warnings
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	528 */
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	529 public List<ReportItem> getWarnings() {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	530 return warnings;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	531 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	532
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	533 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	534 * @return the errors
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	535 */
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	536 public List<ReportItem> getErrors() {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	537 return errors;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	538 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	539
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	540 public void reset() {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	541 errors = new ArrayList<ReportItem>();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	542 warnings = new ArrayList<ReportItem>();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	543 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	544 }

Mercurial > lada > lada-server

annotate src/main/java/de/intevation/lada/importer/laf/AttributeMapper.java @ 616:e62d1703f099