view backend/README @ 8470:c5a7aae52396

Added a validation SQL query to database backends. Enable it by storing something like "SELECT 1 FROM DUAL" in config under /artifact-database/backend-database/validation-query/text() or /artifact-database/seddb-database/validation-query/text().
author Sascha L. Teichmann <teichmann@intevation.de>
date Wed, 12 Nov 2014 13:31:53 +0100
parents 5aa05a7a34b7
children
line wrap: on
line source
For the artifact database
# su - postgres
$ createuser --no-createrole --no-superuser --pwprompt --no-createdb artifacts
$ createdb --encoding=UTF-8 --owner artifacts artifactsdb

For the flys database

# su - postgres
$ createuser --no-createrole --no-superuser --pwprompt --no-createdb flys
$ createdb --encoding=UTF-8 --owner flys flystest1


Build an importer package:
mvn -f pom.xml clean compile assembly:single
Alternatively with oracle:
mvn -f pom-oracle.xml clean compile assembly:single

Standalone DateGuesser testing example:

mvn -e -Dexec.mainClass=de.intevation.flys.utils.DateGuesser -Dexec.args="110803" exec:java <<EOF
110803
EOF

Some importer allow standalone usage:
mvn -e -Dexec.mainClass=de.intevation.flys.importer.parsers.AtFileParser -Dexec.args=/home/felix/.bashrc exec:java

http://dive4elements.wald.intevation.org