dive4elements/river: flys-backend/src/main/java/de/intevation/flys/utils/DgmSqlConverter.java annotate

annotate flys-backend/src/main/java/de/intevation/flys/utils/DgmSqlConverter.java @ 4963:1469066cc7d9 dami

Importer: Fix the order of the config check

author	Andre Heinecke <aheinecke@intevation.de>
date	Mon, 04 Feb 2013 17:54:39 +0100
parents	f5912365619c
children

rev	line source
3951 89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	1 package de.intevation.flys.utils;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	2
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	3 import java.io.BufferedInputStream;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	4 import java.io.BufferedWriter;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	5 import java.io.File;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	6 import java.io.FileInputStream;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	7 import java.io.FileNotFoundException;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	8 import java.io.FileWriter;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	9 import java.io.IOException;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	10 import java.io.InputStream;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	11 import java.io.InputStreamReader;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	12 import java.io.Reader;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	13 import java.util.ArrayList;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	14 import java.util.List;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	15
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	16 import au.com.bytecode.opencsv.CSVReader;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	17
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	18
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	19 /**
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	20 * A converter for CSV files with DGM information. The result of a conversion
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	21 * is an SQL file with "INSERT INTO dem ..." statements.
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	22 * <br>
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	23 * To start the converter, at least the following three system properties are
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	24 * required:
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	25 * <br>
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	26 * <ul>
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	27 * <ol><b>gew.dir</b>: This property must point to the directory where all
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	28 * rivers are stored.</ol>
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	29 * <ol><b>csv</b>: This property must point to the CSV file that contains the
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	30 * DGM information.</ol>
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	31 * <ol><b>sql</b>: This property must point to a (not yet existing) file that
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	32 * will be generated by this converter.</ol>
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	33 * </ul>
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	34 * <br>
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	35 * In addiation, the following properties are accepted to modify log messages,
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	36 * etc.
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	37 * <ul>
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	38 * <ol><b>verbose</b>: Accepts integer values (0, 1, 2, 3) to modify the log
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	39 * messages. The higher the value the more log messages are printed to STDOUT.
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	40 * </ol>
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	41 * <ol><b>full</b>: Accepts true\|false values. If true is set, all rivers
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	42 * included in the CSV file are taken into account while parsing. Otherwise,
3952 5d8db3349b77 Backend: Code simplification. Removed trailing whietspace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3951 diff changeset	43 * the converter reads information for 'Saar', 'Mosel' and 'Eble' only.</ol>
3951 89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	44 * </ul>
3952 5d8db3349b77 Backend: Code simplification. Removed trailing whietspace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3951 diff changeset	45 *
3951 89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	46 * @author Ingo Weinzierl <a href="mailto:ingo.weinzierl@intevation.de">
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	47 * ingo.weinzierl@intevation.de</a>
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	48 *
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	49 */
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	50 public class DgmSqlConverter {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	51
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	52 public static final String SQL_INSERT = "INSERT INTO dem (river_id, name, lower, upper, year_from, year_to,"
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	53 + "projection, elevation_state, format, border_break, resolution, description, path) VALUES ("
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	54 + "%s, '%s', %s, %s, %s, %s, '%s', '%s', '%s', %s, '%s', '%s', '%s');";
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	55
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	56 public static final String SQL_SELECT_RIVER = "(SELECT id from rivers WHERE name = '%s')";
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	57
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	58 public static final char DEFAULT_SEPERATOR = ',';
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	59 public static final char DEFAULT_QUOTE = '"';
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	60 public static final int DEFAULT_LOG_LEVEL = 2;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	61
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	62 public static final boolean FULL_MODE = Boolean.getBoolean("full");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	63 public static final String GEW_DIR = System.getProperty("gew.dir", null);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	64 public static final String CSV_FILE = System.getProperty("csv");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	65 public static final String SQL_FILE = System.getProperty("sql");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	66 public static final int LOG_LEVEL = Integer.getInteger("verbose",
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	67 DEFAULT_LOG_LEVEL);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	68
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	69 public static final int MIN_COLUMN_COUNT = 15;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	70
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	71 public static final int IDX_RIVERNAME = 0;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	72 public static final int IDX_NAME = 12;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	73 public static final int IDX_LOWER = 1;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	74 public static final int IDX_UPPER = 2;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	75 public static final int IDX_YEAR_FROM = 3;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	76 public static final int IDX_YEAR_TO = 4;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	77 public static final int IDX_PROJECTION = 7;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	78 public static final int IDX_ELEVATION_STATE = 8;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	79 public static final int IDX_FORMAT = 9;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	80 public static final int IDX_BORDER_BREAK = 10;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	81 public static final int IDX_RESOLUTION = 11;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	82 public static final int IDX_DESCRIPTION = 14;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	83 public static final int IDX_FILE_NAME = 5;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	84 public static final int IDX_FILE_PATH = 6;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	85
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	86 private class DGM {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	87
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	88 public String river;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	89 public String name;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	90 public String projection;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	91 public String elevationState;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	92 public String format;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	93 public String resolution;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	94 public String description;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	95 public String path;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	96
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	97 public double lower;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	98 public double upper;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	99 public Integer yearFrom;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	100 public Integer yearTo;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	101
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	102 public boolean borderBreak;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	103
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	104 public DGM() {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	105 borderBreak = false;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	106 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	107
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	108 public String toSQL() {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	109 String riverId = String.format(SQL_SELECT_RIVER, river);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	110 String lower = String.valueOf(this.lower);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	111 String upper = String.valueOf(this.upper);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	112 String yearFrom = this.yearFrom != null ? String
3961 f5912365619c Adapted the spatial schema for DEMs and the DgmSqlConverter. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3952 diff changeset	113 .valueOf(this.yearFrom) : "";
3951 89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	114 String yearTo = this.yearTo != null ? String.valueOf(this.yearTo)
3961 f5912365619c Adapted the spatial schema for DEMs and the DgmSqlConverter. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: 3952 diff changeset	115 : "";
3951 89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	116
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	117 return String.format(SQL_INSERT, riverId, name, lower, upper,
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	118 yearFrom, yearTo, projection, elevationState, format,
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	119 borderBreak, resolution, description, path);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	120 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	121 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	122
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	123 private File riverDir;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	124 private File csv;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	125 private File sql;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	126
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	127 private List<DGM> dgms;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	128
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	129 public static void debug(String msg) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	130 if (LOG_LEVEL >= 3) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	131 System.out.println("DEBUG: " + msg);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	132 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	133 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	134
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	135 public static void info(String msg) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	136 if (LOG_LEVEL >= 2) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	137 System.out.println("INFO: " + msg);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	138 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	139 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	140
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	141 public static void warn(String msg) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	142 if (LOG_LEVEL >= 1) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	143 System.out.println("WARN: " + msg);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	144 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	145 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	146
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	147 public static void error(String msg) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	148 System.out.println("ERROR: " + msg);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	149 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	150
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	151 public static File getRiverDir(String[] args) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	152 if (GEW_DIR != null && GEW_DIR.length() > 0) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	153 return new File(GEW_DIR);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	154 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	155 else if (args != null && args.length > 0) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	156 return new File(args[0]);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	157 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	158
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	159 return null;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	160 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	161
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	162 public static File getCSVFile(String[] args) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	163 if (CSV_FILE != null && CSV_FILE.length() > 0) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	164 return new File(CSV_FILE);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	165 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	166 else if (args != null && args.length > 1) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	167 return new File(args[1]);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	168 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	169
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	170 return null;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	171 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	172
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	173 public static File getSQLFile(String[] args) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	174 if (SQL_FILE != null && SQL_FILE.length() > 0) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	175 return new File(SQL_FILE);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	176 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	177 else if (args != null && args.length > 2) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	178 return new File(args[2]);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	179 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	180
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	181 return null;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	182 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	183
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	184 public static void main(String[] args) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	185 info("Start convering CSV -> SQL statements");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	186
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	187 if (!FULL_MODE) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	188 info("You are running in DEMO mode; other rivers than 'Saar', 'Mosel' and 'Elbe' are ignored.");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	189 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	190
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	191 File riverDir = getRiverDir(args);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	192
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	193 if (riverDir == null) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	194 warn("No rivers directory specified!");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	195 return;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	196 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	197 else if (!riverDir.isDirectory()) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	198 warn("Specified rivers directory is not a directory!");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	199 return;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	200 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	201 else if (!riverDir.canRead()) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	202 warn("Unable to read '" + riverDir.toString() + "'");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	203 return;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	204 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	205
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	206 File csv = getCSVFile(args);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	207
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	208 if (csv == null) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	209 warn("No CSV file specified!");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	210 return;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	211 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	212 else if (csv.isDirectory()) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	213 warn("Specified CSV file is a directory!");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	214 return;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	215 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	216 else if (!csv.canRead()) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	217 warn("Unable to read '" + csv.toString() + "'");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	218 return;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	219 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	220
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	221 File sql = getSQLFile(args);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	222
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	223 if (sql == null) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	224 warn("No destination file specified!");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	225 return;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	226 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	227 else if (sql.isDirectory()) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	228 warn("Specified destination file is a directory!");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	229 return;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	230 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	231 else if (sql.exists() && !sql.canWrite()) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	232 warn("Unable to write to '" + sql.toString() + "'");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	233 return;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	234 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	235 else if (!sql.exists()) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	236 try {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	237 sql.createNewFile();
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	238 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	239 catch (IOException ioe) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	240 warn("Unable to write to '" + sql.toString() + "'");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	241 return;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	242 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	243 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	244
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	245 info("Start parsing CSV file '" + csv.toString() + "'");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	246
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	247 try {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	248 DgmSqlConverter parser = new DgmSqlConverter(riverDir, csv, sql);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	249 parser.read();
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	250 parser.write();
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	251 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	252 catch (Exception e) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	253 error("Unexpected error: " + e.getMessage());
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	254 e.printStackTrace();
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	255 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	256
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	257 info("Finished converting CSV -> SQL regularly.");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	258 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	259
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	260 public DgmSqlConverter(File riverDir, File csv, File sql) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	261 this.riverDir = riverDir;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	262 this.csv = csv;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	263 this.sql = sql;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	264 this.dgms = new ArrayList<DGM>();
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	265 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	266
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	267 public void read() {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	268 info("Read DGM information from CSV file: " + csv.getAbsolutePath());
3952 5d8db3349b77 Backend: Code simplification. Removed trailing whietspace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3951 diff changeset	269
3951 89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	270 InputStream in = null;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	271
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	272 try {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	273 in = new BufferedInputStream(new FileInputStream(csv));
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	274 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	275 catch (FileNotFoundException e) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	276 error("File not found: " + e.getMessage());
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	277 return;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	278 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	279
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	280 Reader reader = new InputStreamReader(in);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	281 CSVReader csvReader = new CSVReader(reader, DEFAULT_SEPERATOR,
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	282 DEFAULT_QUOTE);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	283
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	284 List<String[]> rows = new ArrayList<String[]>();
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	285
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	286 int success = 0;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	287
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	288 try {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	289 rows = csvReader.readAll();
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	290
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	291 for (int idx = 0; idx < rows.size(); idx++) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	292 String[] row = rows.get(idx);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	293 if (readRow(row)) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	294 success++;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	295 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	296 else {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	297 warn("Unable to parse row " + (idx + 1));
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	298 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	299 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	300 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	301 catch (IOException e) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	302 error("Error while parsing CSV: " + e.getMessage());
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	303 return;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	304 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	305
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	306 info("Parsed CSV file: " + rows.size() + " lines.");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	307 info("Parsed " + success + " line successful");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	308 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	309
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	310 private boolean readRow(String[] row) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	311 if (row == null) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	312 warn("Row is null!");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	313 return false;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	314 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	315
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	316 if (row.length < MIN_COLUMN_COUNT) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	317 warn("invalid column count: " + row.length);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	318 return false;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	319 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	320
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	321 StringBuffer rowBuffer = new StringBuffer();
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	322 for (String col : row) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	323 rowBuffer.append(col);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	324 rowBuffer.append(" \| ");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	325 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	326 debug(rowBuffer.toString());
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	327
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	328 try {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	329 DGM dgm = new DGM();
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	330 dgm.river = readRiver(row[IDX_RIVERNAME]);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	331 dgm.name = row[IDX_NAME];
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	332 dgm.projection = row[IDX_PROJECTION];
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	333 dgm.elevationState = row[IDX_ELEVATION_STATE];
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	334 dgm.format = row[IDX_FORMAT];
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	335 dgm.resolution = row[IDX_RESOLUTION];
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	336 dgm.description = row[IDX_DESCRIPTION];
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	337 dgm.lower = readLower(row[IDX_LOWER]);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	338 dgm.upper = readUpper(row[IDX_UPPER]);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	339 dgm.yearFrom = readFromYear(row[IDX_YEAR_FROM]);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	340 dgm.yearTo = readToYear(row[IDX_YEAR_TO]);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	341 dgm.borderBreak = readBorderBreak(row[IDX_BORDER_BREAK]);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	342 dgm.path = readPath(dgm.river, row[IDX_FILE_PATH],
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	343 row[IDX_FILE_NAME]);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	344
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	345 dgms.add(dgm);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	346
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	347 return true;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	348 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	349 catch (IllegalArgumentException iae) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	350 warn(iae.getMessage());
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	351 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	352
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	353 return false;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	354 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	355
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	356 private String readRiver(String rivername) throws IllegalArgumentException {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	357 if (rivername == null \|\| rivername.length() == 0) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	358 throw new IllegalAccessError("Invalid rivername: " + rivername);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	359 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	360
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	361 if (!FULL_MODE
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	362 && !(rivername.equals("Saar") \|\| rivername.equals("Mosel") \|\| rivername
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	363 .equals("Elbe"))) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	364 throw new IllegalArgumentException("In DEMO mode; skip river: "
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	365 + rivername);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	366 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	367
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	368 return rivername;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	369 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	370
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	371 private Double readLower(String lower) throws IllegalArgumentException {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	372 try {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	373 return Double.valueOf(lower);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	374 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	375 catch (NumberFormatException nfe) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	376 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	377
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	378 throw new IllegalArgumentException("Attribute 'lower' invalid: "
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	379 + lower);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	380 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	381
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	382 private Double readUpper(String upper) throws IllegalArgumentException {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	383 try {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	384 return Double.valueOf(upper);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	385 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	386 catch (NumberFormatException nfe) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	387 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	388
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	389 throw new IllegalArgumentException("Attribute 'upper' invalid: "
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	390 + upper);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	391 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	392
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	393 private Integer readFromYear(String from) throws IllegalArgumentException {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	394 try {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	395 return Integer.valueOf(from);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	396 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	397 catch (NumberFormatException nfe) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	398 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	399
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	400 return null;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	401 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	402
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	403 private Integer readToYear(String to) throws IllegalArgumentException {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	404 try {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	405 return Integer.valueOf(to);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	406 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	407 catch (NumberFormatException nfe) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	408 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	409
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	410 return null;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	411 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	412
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	413 private String readPath(String rivername, String dir, String filename)
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	414 throws IllegalArgumentException {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	415 File riverDir = new File(this.riverDir, rivername);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	416 File dgmDir = new File(riverDir, dir);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	417 File dgmFile = new File(dgmDir, filename);
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	418
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	419 try {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	420 debug("Path of DGM = " + dgmFile.getAbsolutePath());
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	421
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	422 if (dgmFile == null \|\| !dgmFile.exists()) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	423 throw new IllegalAccessError(
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	424 "Specified DGM file does not exist: "
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	425 + dgmFile.getAbsolutePath());
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	426 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	427
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	428 if (!dgmFile.isFile()) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	429 throw new IllegalArgumentException(
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	430 "Specified DGM file is no file: "
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	431 + dgmFile.getAbsolutePath());
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	432 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	433 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	434 catch (IllegalAccessError iae) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	435 throw new IllegalArgumentException("Cannot find DGM file (river="
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	436 + rivername + " \| directory=" + dir + " \| filename=" + filename
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	437 + ")");
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	438 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	439
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	440 return dgmFile.getAbsolutePath();
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	441 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	442
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	443 private boolean readBorderBreak(String borderBreak) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	444 if (borderBreak == null \|\| borderBreak.length() == 0) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	445 return true;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	446 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	447 else if (borderBreak.toLowerCase().equals("ja")) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	448 return true;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	449 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	450 else if (borderBreak.toLowerCase().equals("nein")) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	451 return false;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	452 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	453 else {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	454 return true;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	455 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	456 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	457
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	458 public void write() {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	459 info("Write DEM information to SQL file: " + sql.getAbsolutePath());
3952 5d8db3349b77 Backend: Code simplification. Removed trailing whietspace. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3951 diff changeset	460
3951 89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	461 BufferedWriter bufferedWriter = null;
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	462 try {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	463 bufferedWriter = new BufferedWriter(new FileWriter(sql));
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	464
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	465 for (DGM dgm : dgms) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	466 bufferedWriter.write(dgm.toSQL());
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	467 bufferedWriter.newLine();
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	468 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	469 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	470 catch (IOException ioe) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	471 error(ioe.getMessage());
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	472 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	473 finally {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	474 if (bufferedWriter != null) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	475 try {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	476 bufferedWriter.close();
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	477 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	478 catch (IOException ioe) {
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	479 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	480 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	481 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	482 }
89ada0b9083f Modified the schema for DGMs; added converter for CSV to SQL for DGM information. Ingo Weinzierl <ingo.weinzierl@intevation.de> parents: diff changeset	483 }

Mercurial > dive4elements > river

annotate flys-backend/src/main/java/de/intevation/flys/utils/DgmSqlConverter.java @ 4963:1469066cc7d9 dami