view artifacts/bin/createDatacage.sh @ 9661:9b8ba3b83a15

Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name, localized vegetation type names by querying the database instead of translating by resource property, detecting and cancelling the import of a second vegetation zone file for a river, detecting, logging, cancelling in case of wrong column titles, detecting, logging and ignoring lines with missing (color) values, comparing vegetation zone name and class with the database and logging+ignoring in case of inconsistencies, starting the most elevated zone with 0 instead of -1 overflow days
author mschaefer
date Mon, 23 Mar 2020 16:38:12 +0100
parents 6b8410ba48cb
children
line wrap: on
line source
#!/bin/bash

mkdir -p datacagedb

DIR=`dirname $0`
DIR=`readlink -f "$DIR"`

if [ $# != 1 ]; then
    SCHEMA="$DIR/../doc/conf/datacage.sql"
else
    SCHEMA="$1"
fi

URL="jdbc:h2:`readlink -f datacagedb`/datacage"

mvn -e -Dexec.mainClass=org.h2.tools.RunScript exec:java \
    -Dexec.args="-url $URL -script $SCHEMA"

http://dive4elements.wald.intevation.org