lada/lada-server: src/main/java/de/intevation/lada/data/importer/LAFImporter.java annotate

annotate src/main/java/de/intevation/lada/data/importer/LAFImporter.java @ 321:5844d7457dde

Completed importer for LAF format. Ort objects still need some attention.

author	Raimund Renkert <rrenkert@intevation.de>
date	Fri, 23 Aug 2013 11:35:24 +0200
parents	821557a17e5e
children	5d11428e6a09

rev	line source
310 821557a17e5e First version of the LAF importer. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	1 package de.intevation.lada.data.importer;
821557a17e5e First version of the LAF importer. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	2
321 5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	3 import java.math.BigInteger;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	4 import java.util.HashMap;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	5 import java.util.List;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	6 import java.util.Map;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	7
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	8 import javax.ejb.Stateless;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	9 import javax.ejb.TransactionAttribute;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	10 import javax.ejb.TransactionAttributeType;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	11 import javax.inject.Inject;
310 821557a17e5e First version of the LAF importer. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	12 import javax.inject.Named;
321 5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	13 import javax.persistence.EntityManager;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	14 import javax.persistence.Query;
310 821557a17e5e First version of the LAF importer. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	15
821557a17e5e First version of the LAF importer. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	16 import de.intevation.lada.auth.AuthenticationResponse;
321 5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	17 import de.intevation.lada.data.Repository;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	18 import de.intevation.lada.model.LKommentarM;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	19 import de.intevation.lada.model.LKommentarP;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	20 import de.intevation.lada.model.LMessung;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	21 import de.intevation.lada.model.LMesswert;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	22 import de.intevation.lada.model.LOrt;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	23 import de.intevation.lada.model.LProbe;
310 821557a17e5e First version of the LAF importer. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	24 import de.intevation.lada.rest.Response;
321 5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	25 import de.intevation.lada.validation.ValidationException;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	26 import de.intevation.lada.validation.Validator;
310 821557a17e5e First version of the LAF importer. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	27
821557a17e5e First version of the LAF importer. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	28 @Named("lafimporter")
321 5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	29 @Stateless
310 821557a17e5e First version of the LAF importer. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	30 public class LAFImporter
821557a17e5e First version of the LAF importer. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	31 implements Importer
821557a17e5e First version of the LAF importer. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	32 {
321 5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	33
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	34 @Inject
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	35 private EntityManager em;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	36
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	37 @Inject
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	38 private LAFParser parser;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	39
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	40 @Inject
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	41 @Named("lprobevalidator")
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	42 private Validator probeValidator;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	43 @Inject
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	44 @Named("lmessungvalidator")
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	45 private Validator messungValidator;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	46 @Inject
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	47 @Named("lortvalidator")
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	48 private Validator ortValidator;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	49 @Inject
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	50 @Named("lmesswertvalidator")
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	51 private Validator messwertValidator;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	52
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	53 @Inject
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	54 @Named("lproberepository")
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	55 private Repository probeRepository;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	56 @Inject
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	57 @Named("lmessungrepository")
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	58 private Repository messungRepository;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	59 @Inject
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	60 @Named("lortrepository")
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	61 private Repository ortRepository;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	62 @Inject
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	63 @Named("lkommentarRepository")
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	64 private Repository pKommentarRepository;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	65 @Inject
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	66 @Named("lkommentarmrepository")
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	67 private Repository mKommentarRepository;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	68 @Inject
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	69 @Named("lmesswertrepository")
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	70 private Repository messwertRepository;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	71
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	72 private Map<String, Map<String, Integer>> warnings;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	73 private Map<String, Map<String, Integer>> errors;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	74
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	75 public LAFImporter() {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	76 warnings = new HashMap<String, Map<String, Integer>>();
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	77 errors = new HashMap<String, Map<String, Integer>>();
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	78 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	79
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	80 /**
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	81 * @return the warnings
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	82 */
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	83 public Map<String, Map<String, Integer>> getWarnings() {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	84 return warnings;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	85 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	86
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	87 /**
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	88 * @return the errors
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	89 */
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	90 public Map<String, Map<String, Integer>> getErrors() {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	91 return errors;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	92 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	93
310 821557a17e5e First version of the LAF importer. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	94 @Override
321 5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	95 public boolean importData(String content, AuthenticationResponse auth) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	96 try {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	97 boolean success = parser.parse(content);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	98 if (success) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	99 List<LProbe> proben = parser.getProben();
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	100 List<LMessung> messungen = parser.getMessungen();
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	101 List<LOrt> orte = parser.getOrte();
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	102 List<LKommentarP> pKommentare = parser.getProbeKommentare();
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	103 List<LKommentarM> mKommentare = parser.getMessungKommentare();
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	104 List<LMesswert> messwerte = parser.getMesswerte();
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	105 writeProben(auth, proben);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	106 writeMessungen(auth, messungen);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	107 //writeOrte(auth, orte);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	108 writePKommentare(auth, pKommentare);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	109 writeMKommentare(auth, mKommentare);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	110 writeMesswerte(auth, messwerte);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	111 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	112 else {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	113 Map<String, Integer> err = new HashMap<String, Integer>();
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	114 err.put("no success", 660);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	115 errors.put("parser", err);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	116 return false;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	117 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	118 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	119 catch (LAFParserException e) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	120 Map<String, Integer> err = new HashMap<String, Integer>();
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	121 err.put(e.getMessage(), 660);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	122 errors.put("parser", err);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	123 return false;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	124 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	125 Map<String, Map<String, Map<String, Integer>>> data =
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	126 new HashMap<String, Map<String,Map<String, Integer>>>();
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	127 data.put("warnings", warnings);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	128 data.put("errors", errors);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	129 return true;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	130 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	131
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	132 private void writeMessungen(
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	133 AuthenticationResponse auth,
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	134 List<LMessung> messungen
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	135 ) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	136 for(LMessung messung: messungen) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	137 try {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	138
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	139 Map<String, Integer> warn =
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	140 messungValidator.validate(messung, false);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	141 messungRepository.create(messung);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	142 if (warn != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	143 warnings.put(
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	144 messung.getMessungsId().toString(),
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	145 warn);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	146 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	147 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	148 catch (ValidationException e) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	149 errors.put(messung.getProbeId(), e.getErrors());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	150 warnings.put(
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	151 messung.getProbeId(),
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	152 e.getWarnings());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	153 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	154 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	155 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	156
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	157 @TransactionAttribute(TransactionAttributeType.REQUIRED)
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	158 private void writeMesswerte(
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	159 AuthenticationResponse auth,
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	160 List<LMesswert> messwerte
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	161 ) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	162 for(LMesswert messwert: messwerte) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	163 try {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	164 Map<String, Integer> warn =
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	165 messwertValidator.validate(messwert, false);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	166 Response r = messwertRepository.create(messwert);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	167 if (warn != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	168 warnings.put(
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	169 messwert.getProbeId(),
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	170 warn);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	171 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	172 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	173 catch (ValidationException e) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	174 errors.put(messwert.getProbeId(), e.getErrors());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	175 warnings.put(
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	176 messwert.getProbeId(),
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	177 e.getWarnings());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	178 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	179 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	180 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	181
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	182 @TransactionAttribute(TransactionAttributeType.REQUIRED)
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	183 private void writePKommentare(
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	184 AuthenticationResponse auth,
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	185 List<LKommentarP> kommentare
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	186 ) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	187 for(LKommentarP kommentar: kommentare) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	188 try {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	189 pKommentarRepository.create(kommentar);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	190 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	191 catch(Exception e) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	192 Map<String, Integer> err = new HashMap<String, Integer>();
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	193 err.put(
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	194 kommentar.getProbeId() + " - " +
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	195 kommentar.getkId(), 661);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	196 errors.put("lkommentarp", err);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	197 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	198 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	199 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	200
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	201 @TransactionAttribute(TransactionAttributeType.REQUIRED)
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	202 private void writeMKommentare(
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	203 AuthenticationResponse auth,
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	204 List<LKommentarM> kommentare
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	205 ) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	206 for(LKommentarM kommentar: kommentare) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	207 Query q =
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	208 em.createNativeQuery(
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	209 "select nextval('kommentar_m_id_seq')");
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	210 BigInteger seqId = (BigInteger)q.getSingleResult();
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	211 kommentar.getId().setKId(seqId.intValue());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	212 mKommentarRepository.create(kommentar);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	213 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	214 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	215
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	216 @TransactionAttribute(TransactionAttributeType.REQUIRED)
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	217 private void writeOrte(
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	218 AuthenticationResponse auth,
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	219 List<LOrt> orte
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	220 ) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	221 for(LOrt ort: orte) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	222 try {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	223 Map<String, Integer> warn =
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	224 ortValidator.validate(ort, false);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	225 ortRepository.create(ort);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	226 if (warn != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	227 warnings.put(String.valueOf(ort.getOrtId()), warn);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	228 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	229 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	230 catch (ValidationException e) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	231 errors.put(String.valueOf(ort.getOrtId()), e.getErrors());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	232 warnings.put(
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	233 String.valueOf(ort.getOrtId()),
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	234 e.getWarnings());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	235 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	236 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	237 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	238
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	239 @TransactionAttribute(TransactionAttributeType.REQUIRED)
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	240 private void writeProben(AuthenticationResponse auth, List<LProbe> proben) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	241 for (LProbe probe: proben) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	242 if (!authorized(probe, auth)) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	243 Map<String, Integer> err = new HashMap<String, Integer>();
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	244 err.put("not authorized", 699);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	245 errors.put(probe.getProbeId(), err);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	246 continue;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	247 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	248 try {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	249 Map<String, Integer> warn =
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	250 probeValidator.validate(probe, false);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	251 if (warn != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	252 warnings.put(probe.getProbeId(), warn);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	253 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	254 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	255 catch (ValidationException e) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	256 errors.put(probe.getProbeId(), e.getErrors());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	257 warnings.put(probe.getProbeId(), e.getWarnings());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	258 continue;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	259 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	260 persist(probe);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	261 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	262 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	263
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	264 private boolean authorized(LProbe probe, AuthenticationResponse auth) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	265 if (auth.getNetzbetreiber().contains(probe.getNetzbetreiberId()) &&
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	266 auth.getMst().contains(probe.getMstId())) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	267 return true;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	268 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	269 return false;
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	270 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	271
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	272 @TransactionAttribute(TransactionAttributeType.REQUIRED)
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	273 private void persist(LProbe probe) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	274 String queryColumns = "insert into l_probe (probe_id, ba_id, test," +
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	275 " datenbasis_id, netzbetreiber_id, mst_id, probenart_id, umw_id";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	276 String queryParameter = " values (:probe_id, :ba_id, :test," +
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	277 " :datenbasis_id, :netzbetreiber_id, :mst_id, :probenart_id," +
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	278 " :umw_id";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	279 if (probe.getErzeugerId() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	280 queryColumns += ", erzeuger_id";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	281 queryParameter += ", :erzeuger_id";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	282 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	283 if (probe.getHauptprobenNr() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	284 queryColumns += ", hauptproben_nr";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	285 queryParameter += ", :hauptproben_nr";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	286 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	287 if (probe.getLetzteAenderung() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	288 queryColumns += ", letzte_aenderung";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	289 queryParameter += ", :letzte_aenderung";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	290 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	291 if (probe.getMedia() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	292 queryColumns += ", media";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	293 queryParameter += ", :media";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	294 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	295 if (probe.getMediaDesk() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	296 queryColumns += ", media_desk";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	297 queryParameter += ", :media_desk";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	298 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	299 if (probe.getMittelungsdauer() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	300 queryColumns += ", mittelungsdauer";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	301 queryParameter += ", :mittelungsdauer";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	302 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	303 if (probe.getMpKat() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	304 queryColumns += ", mp_kat";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	305 queryParameter += ", mp_kat";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	306 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	307 if (probe.getMplId() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	308 queryColumns += ", mpl_id";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	309 queryParameter += ", :mpl_id";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	310 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	311 if (probe.getMprId() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	312 queryColumns += ", mpr_id";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	313 queryParameter += ", :mpr_id";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	314 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	315 if (probe.getProbeNehmerId() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	316 queryColumns += ", probe_nehmer_id";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	317 queryParameter += ", :probe_nehmer_id";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	318 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	319 if (probe.getProbeentnahmeBeginn() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	320 queryColumns += ", probeentnahme_beginn";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	321 queryParameter += ", :probeentnahme_beginn";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	322 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	323 if (probe.getProbeentnahmeEnde() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	324 queryColumns += ", probeentnahme_ende";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	325 queryParameter += ", :probeentnahme_ende";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	326 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	327 if (probe.getSolldatumBeginn() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	328 queryColumns += ", solldatum_beginn";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	329 queryParameter += ", :solldatum_beginn";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	330 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	331 if (probe.getSolldatumEnde() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	332 queryColumns += ", solldatum_ende";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	333 queryParameter += ", :solldatum_ende";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	334 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	335 queryColumns += ") " + queryParameter + ")";
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	336
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	337 Query insert = em.createNativeQuery(queryColumns);
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	338 insert.setParameter("probe_id", probe.getProbeId());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	339 insert.setParameter("ba_id", probe.getBaId());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	340 insert.setParameter("datenbasis_id", probe.getDatenbasisId());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	341 insert.setParameter("mst_id", probe.getMstId());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	342 insert.setParameter("netzbetreiber_id", probe.getNetzbetreiberId());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	343 insert.setParameter("probenart_id", probe.getProbenartId());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	344 insert.setParameter("test", probe.isTest());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	345 insert.setParameter("umw_id", probe.getUmwId());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	346 if (probe.getErzeugerId() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	347 insert.setParameter("erzeuger_id", probe.getErzeugerId());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	348 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	349 if (probe.getHauptprobenNr() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	350 insert.setParameter("hauptproben_nr", probe.getHauptprobenNr());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	351 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	352 if (probe.getLetzteAenderung() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	353 insert.setParameter("letzte_aenderung", probe.getLetzteAenderung());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	354 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	355 if (probe.getMedia() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	356 insert.setParameter("media", probe.getMedia());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	357 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	358 if (probe.getMediaDesk() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	359 insert.setParameter("media_desk", probe.getMediaDesk());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	360 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	361 if (probe.getMittelungsdauer() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	362 insert.setParameter("mittelungsdauer", probe.getMittelungsdauer());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	363 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	364 if (probe.getMpKat() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	365 insert.setParameter("mp_kat", probe.getMpKat());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	366 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	367 if (probe.getMplId() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	368 insert.setParameter("mpl_id", probe.getMplId());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	369 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	370 if (probe.getMprId() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	371 insert.setParameter("mpr_id", probe.getMprId());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	372 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	373 if (probe.getProbeNehmerId() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	374 insert.setParameter("probe_nehmer_id", probe.getProbeNehmerId());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	375 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	376 if (probe.getProbeentnahmeBeginn() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	377 insert.setParameter("probeentnahme_beginn", probe.getProbeentnahmeBeginn());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	378 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	379 if (probe.getProbeentnahmeEnde() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	380 insert.setParameter("probeentnahme_ende", probe.getProbeentnahmeEnde());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	381 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	382 if (probe.getSolldatumBeginn() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	383 insert.setParameter("solldatum_beginn", probe.getSolldatumBeginn());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	384 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	385 if (probe.getSolldatumEnde() != null) {
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	386 insert.setParameter("solldatum_ende", probe.getSolldatumEnde());
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	387 }
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	388 int res = insert.executeUpdate();
5844d7457dde Completed importer for LAF format. Ort objects still need some attention. Raimund Renkert <rrenkert@intevation.de> parents: 310 diff changeset	389 int i = res;
310 821557a17e5e First version of the LAF importer. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	390 }
821557a17e5e First version of the LAF importer. Raimund Renkert <rrenkert@intevation.de> parents: diff changeset	391 }

Mercurial > lada > lada-server

annotate src/main/java/de/intevation/lada/data/importer/LAFImporter.java @ 321:5844d7457dde