org.polymap.wbv.mdb.GmkCsvPrinter.java Source code

Introduction

Here is the source code for org.polymap.wbv.mdb.GmkCsvPrinter.java

Source

/* 
 * polymap.org
 * Copyright (C) 2015-2016 Polymap GmbH. All rights reserved.
 *
 * This is free software; you can redistribute it and/or modify it
 * under the terms of the GNU Lesser General Public License as
 * published by the Free Software Foundation; either version 3.0 of
 * the License, or (at your option) any later version.
 *
 * This software is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
 * Lesser General Public License for more details.
 */
package org.polymap.wbv.mdb;

import java.util.Arrays;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Set;
import java.util.TreeMap;
import java.util.TreeSet;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import org.supercsv.io.CsvListReader;
import org.supercsv.io.ICsvListReader;
import org.supercsv.prefs.CsvPreference;

import org.apache.commons.io.FileUtils;
import org.apache.commons.io.FilenameUtils;
import org.apache.commons.lang3.StringUtils;

import com.healthmarketscience.jackcess.Database;
import com.healthmarketscience.jackcess.DatabaseBuilder;
import com.healthmarketscience.jackcess.Row;
import com.healthmarketscience.jackcess.Table;
import com.healthmarketscience.jackcess.util.LinkResolver;

/**
 *
 * 
 * @author <a href="http://www.polymap.de">Falko Brutigam</a>
 */
public class GmkCsvPrinter {

    public static final String FILE_REVIERE = "Gemarkungen-Forstreviere.csv";

    public static void main(String[] args) throws Exception {
        GmkCsvPrinter printer = new GmkCsvPrinter();
        for (File mdb : FileUtils.listFiles(WvkImporter.BASEDIR, new String[] { "mdb" }, true)) {
            log("\n*** ", mdb.getName());
            printer.printCSV(mdb);
        }
    }

    // instance *******************************************

    /** Interner Gemarkungsschlssel -> Name */
    private Map<String, String> gmks = new HashMap();

    /** Interner Gemeindeschlssel -> Name */
    private Map<String, String> gmds = new HashMap();

    /** Neue, offizielle, eindeutige Gemarkungsschlssel: "gemeinde/gemarkung" -> Schlssel */
    private Map<String, String> neueGmks = new TreeMap();

    private Set<String> keys = new TreeSet();

    public GmkCsvPrinter() throws IOException {
        CsvPreference prefs = new CsvPreference('"', ',', "\r\n"); // quoteChar, delimiterChar, endOfLineSymbols

        // neue Gemarkungen aus CSV
        File f = new File(WvkImporter.BASEDIR, FILE_REVIERE);
        if (f.exists()) {
            try (InputStream in = new FileInputStream(f)) {
                ICsvListReader csv = new CsvListReader(new InputStreamReader(in, "UTF-8"), prefs);

                for (List<String> l = csv.read(); l != null; l = csv.read()) {
                    final String[] line = l.toArray(new String[l.size()]);
                    String id = line[0];
                    if (!StringUtils.isNumeric(id)) {
                        System.err.println("Skipping header line: " + Arrays.toString(line));
                        continue;
                    }
                    String gmkSchl = line[0];
                    String gemarkung = line[1];
                    String gemeinde = line[2];
                    String key = gemeinde + "/" + gemarkung;
                    neueGmks.put(key, gmkSchl);
                }
            }
        } else {
            System.err.println("Keine " + FILE_REVIERE + "! Import Modus?");
            neueGmks = null;
        }
    }

    public void printCSV(File mdb) throws IOException {
        try (Database db = DatabaseBuilder.open(mdb)) {
            db.setLinkResolver(new LinkResolver() {
                @Override
                public Database resolveLinkedDatabase(Database linkerDb, String linkeeFileName) throws IOException {
                    return DatabaseBuilder.open(new File(FilenameUtils.getName(linkeeFileName)));
                }
            });

            // Gemarkung: id -> name
            Table table = db.getTable("ESt_Gemarkung");
            for (Row row = table.getNextRow(); row != null; row = table.getNextRow()) {
                String id = row.get("ID_Gemarkung").toString();
                gmks.put(id, (String) row.get("Gemarkung_Name"));
                //log( id, " - ", gmks.get( id ) );
            }

            // Gemeinden: id -> name
            table = db.getTable("ESt_Gemeinde");
            for (Row row = table.getNextRow(); row != null; row = table.getNextRow()) {
                String id = row.get("ID_Gemeinde").toString();
                gmds.put(id, (String) row.get("Gemeinde_Name"));
                //log( id, " - ", gmds.get( id ) );
            }

            // alle Flurstcke
            table = db.getTable("FL_Flurstck");
            for (Row row = table.getNextRow(); row != null; row = table.getNextRow()) {
                String gemeindeId = String.valueOf(row.get("FL_Gemeinde"));
                String gemeindeName = gmds.get(gemeindeId);
                if (gemeindeName == null) {
                    //log( "Keine Gemeinde fr: " + gemeindeId + " -> " + gemeindeName );
                    continue;
                }

                String gemarkungId = String.valueOf(row.get("FL_Gemarkung"));
                String gemarkungName = gmks.get(gemarkungId);
                if (gemarkungName == null) {
                    //log( "Keine Gemarkung fr: " + gemarkungId + " -> " + gemarkungName );
                    continue;
                }

                String key = gemeindeName + "/" + gemarkungName;
                if (!keys.contains(key)) {
                    keys.add(key);
                    String hint = neueGmks.get(key);
                    log(gemeindeName, ",", gemarkungName, ",", gemeindeId, ",", gemarkungId, ",",
                            hint != null ? hint : "???");
                }
            }
        }
    }

    protected static void log(Object... parts) {
        StringBuilder buf = new StringBuilder(256);
        for (Object part : parts) {
            buf.append(part != null ? part.toString() : "[null]");
        }
        System.out.println(buf.toString());
    }

}