view backend/README @ 6655:86b17c675374

Cast ld values to varchar in user artifacts statement The problem appears to be that now with v in the artifactsdb as a TEXT datatype that we get CLOBS as a result here. To make the old stuff work we cast the ld_ values that are evalutated in datacage functions back to varchar and thus to strings.
author Andre Heinecke <aheinecke@intevation.de>
date Wed, 24 Jul 2013 19:03:33 +0200
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