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 @ 626:9e733f44d8b0

Code style and comments.

author	Raimund Renkert <raimund.renkert@intevation.de>
date	Mon, 20 Apr 2015 17:45:22 +0200
parents	e62d1703f099
children	331cd2bb3109

rev	line source
626 9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	1 /* Copyright (C) 2013 by Bundesamt fuer Strahlenschutz
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	2 * Software engineering by Intevation GmbH
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	3 *
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	4 * This file is Free Software under the GNU GPL (v>=3)
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	5 * and comes with ABSOLUTELY NO WARRANTY! Check out
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	6 * the documentation coming with IMIS-Labordaten-Application for details.
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	7 */
610 374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	8 package de.intevation.lada.importer.laf;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	9
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	10 import java.sql.Timestamp;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	11 import java.text.DateFormat;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	12 import java.text.ParseException;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	13 import java.text.SimpleDateFormat;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	14 import java.util.ArrayList;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	15 import java.util.Date;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	16 import java.util.List;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	17 import java.util.regex.Matcher;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	18 import java.util.regex.Pattern;
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 javax.inject.Inject;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	21 import javax.persistence.Query;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	22
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	23 import de.intevation.lada.importer.ReportItem;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	24 import de.intevation.lada.model.land.LKommentarM;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	25 import de.intevation.lada.model.land.LKommentarP;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	26 import de.intevation.lada.model.land.LMessung;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	27 import de.intevation.lada.model.land.LMesswert;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	28 import de.intevation.lada.model.land.LProbe;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	29 import de.intevation.lada.model.land.LZusatzWert;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	30 import de.intevation.lada.model.land.MessungTranslation;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	31 import de.intevation.lada.model.land.ProbeTranslation;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	32 import de.intevation.lada.util.annotation.RepositoryConfig;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	33 import de.intevation.lada.util.data.QueryBuilder;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	34 import de.intevation.lada.util.data.Repository;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	35 import de.intevation.lada.util.data.RepositoryType;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	36 import de.intevation.lada.util.rest.Response;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	37
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 * 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	40 * 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	41 *
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	42 * @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	43 */
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	44 public class AttributeMapper
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	45 {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	46
626 9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	47 /**
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	48 * The repository used to read data.
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	49 */
610 374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	50 @Inject
615 3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	51 @RepositoryConfig(type=RepositoryType.RO)
610 374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	52 private Repository repository;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	53
626 9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	54 /**
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	55 * List of warnings.
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	56 */
610 374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	57 private List<ReportItem> warnings;
626 9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	58
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	59 /**
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	60 * List of errors.
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	61 */
610 374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	62 private List<ReportItem> errors;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	63
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 * 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	66 */
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	67 public AttributeMapper() {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	68 this.warnings = new ArrayList<ReportItem>();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	69 this.errors = new ArrayList<ReportItem>();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	70 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	71
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	72 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	73 * 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	74 *
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	75 * @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	76 * @param value The value to set.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	77 * @param probe The entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	78 * @return The updated entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	79 */
626 9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	80 @SuppressWarnings("unchecked")
610 374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	81 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	82 DateFormat format = new SimpleDateFormat("yyyyMMdd HHmm");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	83 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	84 Integer v = Integer.valueOf(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	85 probe.setDatenbasisId(v);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	86 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	87 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	88 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	89 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	90
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	91 if ("datenbasis".equals(key) && probe.getDatenbasisId() == null) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	92 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	93 nativeQuery += value.toString() + "'";
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	94 Query query = repository.entityManager("land").createNativeQuery(nativeQuery);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	95 List<Object[]> result = query.getResultList();
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 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	98 probe.setDatenbasisId(v);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	99 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	100 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	101 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	102 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	103
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	104 if ("hauptprobennummer".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	105 probe.setHauptprobenNr(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	106 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	107
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	108 if ("mpr_id".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	109 Integer v = Integer.valueOf(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	110 probe.setMprId(v);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	111 }
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 if ("netzkennung".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	114 probe.setNetzbetreiberId(value.toString());
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 ("messstelle".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	118 probe.setMstId(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	119 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	120
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	121 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	122 probe.setBaId(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	123 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	124 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	125 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	126 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	127
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	128 if ("soll_datum_uhrzeit_a".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	129 try {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	130 Date d = format.parse(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	131 probe.setSolldatumBeginn(new Timestamp(d.getTime()));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	132 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	133 catch (ParseException e) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	134 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	135 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	136 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	137 if ("soll_datum_uhrzeit_e".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	138 try {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	139 Date d = format.parse(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	140 probe.setSolldatumEnde(new Timestamp(d.getTime()));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	141 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	142 catch (ParseException e) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	143 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	144 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	145 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	146 if ("probenahme_datum_uhrzeit_a".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	147 try {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	148 Date d = format.parse(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	149 probe.setProbeentnahmeBeginn(new Timestamp(d.getTime()));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	150 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	151 catch (ParseException e) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	152 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	153 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	154 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	155 if ("probenahme_datum_uhrzeit_e".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	156 try {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	157 Date d = format.parse(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	158 probe.setProbeentnahmeEnde(new Timestamp(d.getTime()));
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 catch (ParseException e) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	161 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	162 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	163 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	164
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	165 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	166 probe.setUmwId(value.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_s".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 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	172 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	173 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	174 nativeQuery += value.toString().substring(0, length) + "'";
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	175 Query query = repository.entityManager("land").createNativeQuery(nativeQuery);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	176 List<Object[]> result = query.getResultList();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	177 probe.setUmwId(result.get(0)[0].toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	178 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	179 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	180 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	181 }
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 if ("deskriptoren".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	184 probe.setMediaDesk(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	185 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	186
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	187 if ("testdaten".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	188 if (!value.toString().equals("0")) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	189 probe.setTest(true);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	190 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	191 else {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	192 probe.setTest(false);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	193 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	194 }
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 if ("medium".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	197 probe.setMedia(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	198 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	199
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	200 if ("probenart".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	201 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	202 nativeQuery += value.toString() + "'";
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	203 Query query = repository.entityManager("land").createNativeQuery(nativeQuery);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	204 List<Object> result = query.getResultList();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	205 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	206 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	207 return probe;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	208 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	209
626 9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	210 /**
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	211 * Add an attribute to the given ProbeTranslation object.
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	212 *
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	213 * @param key The key mapping to a object member.
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	214 * @param value The value to set.
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	215 * @param probeTranslation The entity object.
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	216 * @return The updated entity.
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	217 */
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	218 @SuppressWarnings("unchecked")
615 3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	219 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	220 String key,
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	221 Object value,
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	222 ProbeTranslation probeTranslation
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	223 ) {
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	224 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	225 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	226 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	227 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	228 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	229 Response response =
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	230 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	231 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	232 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	233 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	234 return null;
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	235 }
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	236 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	237 }
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	238 return probeTranslation;
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	239 }
3f57484e06f1 Updated importer: Do validation and object creation in the correct order. Raimund Renkert <raimund.renkert@intevation.de> parents: 610 diff changeset	240
610 374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	241 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	242 * 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	243 *
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	244 * @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	245 * @param value The value to set.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	246 * @param kommentar The entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	247 * @return The updated entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	248 */
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	249 public LKommentarP addAttribute(
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	250 String key,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	251 Object value,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	252 LKommentarP kommentar
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	253 ) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	254 DateFormat format = new SimpleDateFormat("yyyyMMdd HHmm");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	255 String v = value.toString();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	256 String erzeuger = v.substring(1, 6);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	257 String date = v.substring(8, 21);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	258 Date d;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	259 try {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	260 d = format.parse(date);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	261 kommentar.setDatum(new Timestamp(d.getTime()));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	262 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	263 catch (ParseException e) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	264 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	265 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	266 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	267 kommentar.setErzeuger(erzeuger);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	268 kommentar.setText(text);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	269 return kommentar;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	270 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	271
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	272 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	273 * 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	274 *
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	275 * @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	276 * @param value The value to set.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	277 * @param kommentar The entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	278 * @return The updated entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	279 */
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	280 public LKommentarM addAttribute(
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	281 String key,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	282 Object value,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	283 LKommentarM kommentar
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	284 ) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	285 DateFormat format = new SimpleDateFormat("yyyyMMdd HHmm");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	286 String v = value.toString();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	287 String erzeuger = v.substring(1, 6);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	288 String date = v.substring(8, 21);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	289 Date d;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	290 try {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	291 d = format.parse(date);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	292 kommentar.setDatum(new Timestamp(d.getTime()));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	293 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	294 catch (ParseException e) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	295 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	296 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	297 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	298 kommentar.setErzeuger(erzeuger);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	299 kommentar.setText(text);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	300 return kommentar;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	301 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	302
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	303 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	304 * 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	305 *
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	306 * @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	307 * @param value The value to set.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	308 * @param messung The entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	309 * @return The updated entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	310 */
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	311 public LMessung addAttribute(
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	312 String key,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	313 Object value,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	314 LMessung messung
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 DateFormat format = new SimpleDateFormat("yyyyMMdd HHmm");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	317 if ("nebenprobennummer".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	318 messung.setNebenprobenNr(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	319 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	320 else if ("mess_datum_uhrzeit".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	321 try {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	322 Date d = format.parse(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	323 messung.setMesszeitpunkt(new Timestamp(d.getTime()));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	324 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	325 catch (ParseException e) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	326 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	327 }
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 else if ("messzeit_sekunden".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	330 Integer i = Integer.valueOf(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	331 messung.setMessdauer(i);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	332 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	333 else if ("messmethode_s".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	334 messung.setMmtId(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	335 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	336 else if ("bearbeitungsstatus".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	337 //ignored.!?
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	338 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	339 else if ("erfassung_abgeschlossen".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	340 if(!value.toString().equals("0")) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	341 messung.setFertig(true);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	342 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	343 else {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	344 messung.setFertig(false);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	345 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	346 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	347 return messung;
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
626 9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	350 /**
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	351 * Add an attribute to the given MessungTranslation object.
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	352 *
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	353 * @param key The key mapping to a object member.
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	354 * @param value The value to set.
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	355 * @param mt The entity object.
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	356 * @return The updated entity.
9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	357 */
610 374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	358 public MessungTranslation addAttribute(
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	359 String key,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	360 Object value,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	361 MessungTranslation mt
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	362 ) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	363 if ("messungs_id".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	364 mt.setMessungsIdAlt(Integer.valueOf(value.toString()));
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 return mt;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	367 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	368
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 * 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	371 *
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	372 * @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	373 * @param value The value to set.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	374 * @param messwert The entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	375 * @return The updated entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	376 */
626 9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	377 @SuppressWarnings("unchecked")
610 374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	378 public LMesswert addAttribute(
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	379 String key,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	380 Object value,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	381 LMesswert messwert
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	382 ) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	383 Pattern p = Pattern.compile(
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	384 "(\".+\")( .+ )(\".+\")( .*)( .{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	385 //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	386 Matcher m = p.matcher(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	387 if (m.matches()) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	388 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	389 String wert = m.group(2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	390 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	391 if (wert.startsWith(" <")) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	392 wert = wert.substring(2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	393 messwert.setGrenzwertueberschreitung(false);
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 if (wert.startsWith(" >")) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	396 wert = wert.substring(2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	397 messwert.setGrenzwertueberschreitung(true);
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 float fWert = Float.valueOf(wert);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	400 messwert.setMesswert(fWert);
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 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	403 nativeQuery += einheit + "'";
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	404 Query query = repository.entityManager("land").createNativeQuery(nativeQuery);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	405 List<Object> result = query.getResultList();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	406
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	407 if (result.isEmpty()) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	408 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	409 return null;
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 else {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	412 messwert.setMehId((Integer)result.get(0));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	413 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	414
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	415 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	416 nativeQuery2 += messgroesse + "'";
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	417 Query query2 = repository.entityManager("land").createNativeQuery(nativeQuery2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	418 List<Object> result2 = query2.getResultList();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	419
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	420 if (result2.isEmpty()) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	421 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	422 return null;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	423 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	424 else {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	425 messwert.setMessgroesseId((Integer)result2.get(0));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	426 }
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 return messwert;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	429 }
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 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	432 * 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	433 * two objects Ort and LOrt.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	434 *
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	435 * @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	436 * @param value The value to set.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	437 * @param ort The creator object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	438 * @return The updated creator object.
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 public OrtCreator addAttribute(
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	441 String key,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	442 Object value,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	443 OrtCreator ort
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	444 ) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	445 if ("ort_code".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	446 ort.setOrtCode(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	447 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	448 if ("ort_typ".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	449 ort.setOrtTyp(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	450 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	451 if ("ort_zusatz".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	452 ort.setZusatztext(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	453 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	454 if ("ort_land_lang".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	455 ort.setLandLang(value.toString());
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 if ("ort_land_kurz".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	458 ort.setLandKurz(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	459 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	460 if ("ort_land_s".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	461 ort.setLandS(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	462 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	463 if ("ort_gemeindeschlüssel".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	464 ort.setGemSchluessel(value.toString());
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 if ("ort_bezeichnung".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	467 ort.setBezeichnung(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	468 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	469 if ("ort_beschreibung".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	470 ort.setBeschreibung(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	471 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	472 if ("ort_nuts_code".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	473 ort.setNuts(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	474 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	475 if ("ort_hoehe_land".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	476 ort.setHoehe(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	477 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	478 if ("ort_koordinaten".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	479 ort.setKoordinaten(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	480 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	481 if ("ort_koordinaten_s".equals(key)) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	482 ort.setKoordinatenS(value.toString());
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	483 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	484 return ort;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	485 }
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 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	488 * 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	489 *
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	490 * @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	491 * @param value The value to set.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	492 * @param wert The entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	493 * @return The updated entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	494 */
626 9e733f44d8b0 Code style and comments. Raimund Renkert <raimund.renkert@intevation.de> parents: 616 diff changeset	495 @SuppressWarnings("unchecked")
610 374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	496 public LZusatzWert addAttribute(
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	497 String lKey,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	498 Object value,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	499 LZusatzWert wert
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	500 ) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	501 String v = value.toString().substring(1);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	502 int ndx = v.indexOf("\"");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	503 String groesse = v.substring(0, ndx);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	504 v = v.substring(ndx + 2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	505 ndx = v.indexOf(" ");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	506 String w = v.substring(0, ndx);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	507 v = v.substring(ndx + 2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	508 ndx = v.indexOf("\"");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	509 String fehler = v.substring(ndx + 2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	510
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	511 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	512 nativeQuery += groesse + "'";
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	513 Query query = repository.entityManager("land").createNativeQuery(nativeQuery);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	514 List<Object[]> result = query.getResultList();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	515
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	516 if (result == null \|\| result.isEmpty()) {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	517 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	518 return null;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	519 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	520 wert.setPzsId(result.get(0)[0].toString());
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 * 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	528 *
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	529 * @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	530 * @param value The value to set.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	531 * @param wert The entity object.
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	532 * @return The updated entity object.
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 public LZusatzWert addAttributeS(
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	535 String lKey,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	536 Object value,
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	537 LZusatzWert wert
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 String v = value.toString().substring(1);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	540 int ndx = v.indexOf("\"");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	541 String groesse = v.substring(0, ndx);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	542 v = v.substring(ndx + 2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	543 ndx = v.indexOf(" ");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	544 String w = v.substring(0, ndx);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	545 v = v.substring(ndx + 2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	546 ndx = v.indexOf(" ");
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	547 String fehler = v.substring(ndx + 2);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	548 wert.setPzsId(groesse);
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	549 wert.setMesswertPzs(Float.valueOf(w));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	550 wert.setMessfehler(Float.valueOf(fehler));
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	551 return wert;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	552 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	553
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	554 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	555 * @return the warnings
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	556 */
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	557 public List<ReportItem> getWarnings() {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	558 return warnings;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	559 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	560
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	561 /**
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	562 * @return the errors
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	563 */
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	564 public List<ReportItem> getErrors() {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	565 return errors;
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	566 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	567
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	568 public void reset() {
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	569 errors = new ArrayList<ReportItem>();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	570 warnings = new ArrayList<ReportItem>();
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	571 }
374a2e78cec5 Added importer impl for laf file format. Raimund Renkert <raimund.renkert@intevation.de> parents: diff changeset	572 }

Mercurial > lada > lada-server

annotate src/main/java/de/intevation/lada/importer/laf/AttributeMapper.java @ 626:9e733f44d8b0