dive4elements/river: backend/src/main/java/org/dive4elements/river/importer/parsers/SQRelationParser.java annotate

annotate backend/src/main/java/org/dive4elements/river/importer/parsers/SQRelationParser.java @ 6328:53d08f33d094

Backend: Moved guessing of main values and there time intervals out of the STA parser. Same come will be useful to extend the WST parser to better handle official lines.

author	Sascha L. Teichmann <teichmann@intevation.de>
date	Thu, 13 Jun 2013 17:15:34 +0200
parents	4c3ccf2b0304
children	c894b7b45c4c

rev	line source
5844 4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	1 /* Copyright (C) 2011, 2012, 2013 by Bundesanstalt für Gewässerkunde
4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	2 * Software engineering by Intevation GmbH
4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	3 *
5992 4c3ccf2b0304 Removed trailing whitespace. Sascha L. Teichmann <teichmann@intevation.de> parents: 5845 diff changeset	4 * This file is Free Software under the GNU AGPL (>=v3)
5844 4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	5 * and comes with ABSOLUTELY NO WARRANTY! Check out the
5992 4c3ccf2b0304 Removed trailing whitespace. Sascha L. Teichmann <teichmann@intevation.de> parents: 5845 diff changeset	6 * documentation coming with Dive4Elements River for details.
5844 4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	7 */
4dd33b86dc61 Added header to river backend. Sascha L. Teichmann <teichmann@intevation.de> parents: 5838 diff changeset	8
5829 18619c1e7c2a Repaired internal references. Sascha L. Teichmann <teichmann@intevation.de> parents: 5828 diff changeset	9 package org.dive4elements.river.importer.parsers;
3328 a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	10
3329 cc8fc6b29649 Store sq relations into database after parsing. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3328 diff changeset	11 import java.io.File;
cc8fc6b29649 Store sq relations into database after parsing. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3328 diff changeset	12 import java.io.IOException;
3328 a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	13 import java.text.NumberFormat;
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	14 import java.text.ParseException;
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	15 import java.util.ArrayList;
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	16 import java.util.List;
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	17 import java.util.regex.Matcher;
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	18 import java.util.regex.Pattern;
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	19
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	20 import org.apache.log4j.Logger;
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	21
5829 18619c1e7c2a Repaired internal references. Sascha L. Teichmann <teichmann@intevation.de> parents: 5828 diff changeset	22 import org.dive4elements.river.importer.ImportSQRelation;
18619c1e7c2a Repaired internal references. Sascha L. Teichmann <teichmann@intevation.de> parents: 5828 diff changeset	23 import org.dive4elements.river.importer.ImportSQRelationValue;
18619c1e7c2a Repaired internal references. Sascha L. Teichmann <teichmann@intevation.de> parents: 5828 diff changeset	24 import org.dive4elements.river.importer.ImportTimeInterval;
3328 a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	25
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	26
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	27 public class SQRelationParser extends LineParser {
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	28
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	29 private static final Logger log =
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	30 Logger.getLogger(SQRelationParser.class);
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	31
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	32 private static final Pattern TIMERANGE_REGEX =
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	33 Pattern.compile(".Zeitraum.\\s(\\w)-(\\w).*");
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	34
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	35 private static final NumberFormat nf =
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	36 NumberFormat.getInstance(DEFAULT_LOCALE);
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	37
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	38
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	39 private List<ImportSQRelation> relations;
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	40
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	41 private ImportSQRelation current;
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	42
3329 cc8fc6b29649 Store sq relations into database after parsing. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3328 diff changeset	43 private String currentDescription;
cc8fc6b29649 Store sq relations into database after parsing. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3328 diff changeset	44
3328 a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	45
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	46 public SQRelationParser() {
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	47 relations = new ArrayList<ImportSQRelation>();
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	48 }
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	49
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	50
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	51 public List<ImportSQRelation> getSQRelations() {
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	52 return relations;
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	53 }
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	54
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	55 @Override
3329 cc8fc6b29649 Store sq relations into database after parsing. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3328 diff changeset	56 public void parse(File file) throws IOException {
cc8fc6b29649 Store sq relations into database after parsing. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3328 diff changeset	57 this.currentDescription = file.getName();
cc8fc6b29649 Store sq relations into database after parsing. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3328 diff changeset	58 super.parse(file);
cc8fc6b29649 Store sq relations into database after parsing. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3328 diff changeset	59 }
cc8fc6b29649 Store sq relations into database after parsing. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3328 diff changeset	60
cc8fc6b29649 Store sq relations into database after parsing. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3328 diff changeset	61
cc8fc6b29649 Store sq relations into database after parsing. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3328 diff changeset	62 @Override
3328 a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	63 protected void reset() {
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	64 current = new ImportSQRelation();
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	65 }
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	66
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	67
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	68 @Override
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	69 protected void finish() {
3329 cc8fc6b29649 Store sq relations into database after parsing. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3328 diff changeset	70 if (current != null) {
cc8fc6b29649 Store sq relations into database after parsing. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3328 diff changeset	71 current.setDescription(currentDescription);
cc8fc6b29649 Store sq relations into database after parsing. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3328 diff changeset	72 relations.add(current);
cc8fc6b29649 Store sq relations into database after parsing. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3328 diff changeset	73 }
3328 a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	74 }
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	75
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	76
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	77 @Override
4193 f63b39799d2d Adapted DB schema (added relation measurement_station); improved importer to read files from filesystem with measurement stations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3329 diff changeset	78 protected void handleLine(int lineNum, String line) {
3328 a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	79 if (line.startsWith(START_META_CHAR)) {
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	80 handleMetaLine(stripMetaLine(line));
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	81 }
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	82 else {
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	83 handleDataLine(line);
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	84 }
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	85 }
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	86
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	87
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	88 protected void handleMetaLine(String line) {
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	89 Matcher m = TIMERANGE_REGEX.matcher(line);
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	90
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	91 if (m.matches()) {
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	92 String lo = m.group(1);
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	93 String hi = m.group(2);
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	94
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	95 log.debug("Found timerange " + lo + " - " + hi);
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	96
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	97 try {
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	98 int low = nf.parse(lo).intValue();
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	99 int high = nf.parse(hi).intValue();
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	100
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	101 current.setTimeInterval(new ImportTimeInterval(
5845 1830dae8cb9b Importer-Parser: set time intevals for complete years when parsing years Tom Gottfried <tom.gottfried@intevation.de> parents: 5844 diff changeset	102 getStartDateFromYear(low),
1830dae8cb9b Importer-Parser: set time intevals for complete years when parsing years Tom Gottfried <tom.gottfried@intevation.de> parents: 5844 diff changeset	103 getEndDateFromYear(high)
3328 a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	104 ));
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	105 }
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	106 catch (ParseException nfe) {
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	107 log.warn("Cannot parse time range.", nfe);
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	108 }
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	109 }
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	110 }
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	111
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	112
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	113 protected void handleDataLine(String line) {
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	114 String[] cols = line.split(SEPERATOR_CHAR);
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	115
5429 13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	116 if (cols.length < 14) {
3328 a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	117 log.warn("skip invalid data line: '" + line + "'");
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	118 return;
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	119 }
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	120
5429 13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	121 Double km = parseDouble(cols[3], line);
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	122 Double a = parseDouble(cols[6], line);
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	123 Double b = parseDouble(cols[7], line);
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	124 Double qMax = parseDouble(cols[8], line);
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	125 Double rSq = parseDouble(cols[9], line);
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	126 Integer nTot = parseInteger(cols[10], line);
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	127 Integer nOutlier = parseInteger(cols[11], line);
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	128 Double cFer = parseDouble(cols[12], line);
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	129 Double cDuan = parseDouble(cols[13], line);
5992 4c3ccf2b0304 Removed trailing whitespace. Sascha L. Teichmann <teichmann@intevation.de> parents: 5845 diff changeset	130 if (km == null \|\| a == null \|\| b == null \|\|
5498 d459a885c51f Schema change: make sq_relation_value.qmax NOT NULL and more informative messages in parser Tom Gottfried <tom.gottfried@intevation.de> parents: 5482 diff changeset	131 qMax == null \|\| cols[1].length() == 0) {
d459a885c51f Schema change: make sq_relation_value.qmax NOT NULL and more informative messages in parser Tom Gottfried <tom.gottfried@intevation.de> parents: 5482 diff changeset	132 if (km == null) {
d459a885c51f Schema change: make sq_relation_value.qmax NOT NULL and more informative messages in parser Tom Gottfried <tom.gottfried@intevation.de> parents: 5482 diff changeset	133 log.error("No km for measurement station: Can not reference measurement station: "
d459a885c51f Schema change: make sq_relation_value.qmax NOT NULL and more informative messages in parser Tom Gottfried <tom.gottfried@intevation.de> parents: 5482 diff changeset	134 + line);
d459a885c51f Schema change: make sq_relation_value.qmax NOT NULL and more informative messages in parser Tom Gottfried <tom.gottfried@intevation.de> parents: 5482 diff changeset	135 }
5992 4c3ccf2b0304 Removed trailing whitespace. Sascha L. Teichmann <teichmann@intevation.de> parents: 5845 diff changeset	136 if ( a == null \|\| b == null \|\|
5498 d459a885c51f Schema change: make sq_relation_value.qmax NOT NULL and more informative messages in parser Tom Gottfried <tom.gottfried@intevation.de> parents: 5482 diff changeset	137 qMax == null \|\| cols[1].length() == 0) {
d459a885c51f Schema change: make sq_relation_value.qmax NOT NULL and more informative messages in parser Tom Gottfried <tom.gottfried@intevation.de> parents: 5482 diff changeset	138 log.error("Incomplete SQ-relation row (missing a, b, Qmax or parameter): "
d459a885c51f Schema change: make sq_relation_value.qmax NOT NULL and more informative messages in parser Tom Gottfried <tom.gottfried@intevation.de> parents: 5482 diff changeset	139 + line);
d459a885c51f Schema change: make sq_relation_value.qmax NOT NULL and more informative messages in parser Tom Gottfried <tom.gottfried@intevation.de> parents: 5482 diff changeset	140 }
d459a885c51f Schema change: make sq_relation_value.qmax NOT NULL and more informative messages in parser Tom Gottfried <tom.gottfried@intevation.de> parents: 5482 diff changeset	141 return;
5429 13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	142 }
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	143 current.addValue(new ImportSQRelationValue(
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	144 cols[1],
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	145 km,
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	146 a,
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	147 b,
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	148 qMax,
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	149 rSq,
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	150 nTot,
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	151 nOutlier,
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	152 cFer,
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	153 cDuan));
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	154 }
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	155
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	156 private Double parseDouble(String value, String line) {
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	157 Double result = null;
3328 a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	158 try {
5429 13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	159 result = Double.valueOf(value.replace(",", "."));
3328 a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	160 }
5429 13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	161 catch (NumberFormatException nfe) {
5498 d459a885c51f Schema change: make sq_relation_value.qmax NOT NULL and more informative messages in parser Tom Gottfried <tom.gottfried@intevation.de> parents: 5482 diff changeset	162 log.warn("Unparseable " + value + " in sq relation row: " + line);
3328 a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	163 }
5429 13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	164 return result;
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	165 }
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	166
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	167 private Integer parseInteger(String value, String line) {
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	168 Integer result = null;
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	169 try {
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	170 result = Integer.valueOf(value);
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	171 }
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	172 catch (NumberFormatException nfe) {
5498 d459a885c51f Schema change: make sq_relation_value.qmax NOT NULL and more informative messages in parser Tom Gottfried <tom.gottfried@intevation.de> parents: 5482 diff changeset	173 log.warn("Unparseable " + value + " in sq relation row: " + line);
5429 13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	174 }
13596605e81f Added new columns to sq relation importer to import all values from csv and use Raimund Renkert <rrenkert@intevation.de> parents: 4193 diff changeset	175 return result;
3328 a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	176 }
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	177 }
a41f279a66e2 Added parser and import classes to import MINFO sq relations. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	178 // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :

Mercurial > dive4elements > river

annotate backend/src/main/java/org/dive4elements/river/importer/parsers/SQRelationParser.java @ 6328:53d08f33d094