Mercurial > dive4elements > river
view backend/README @ 6721:df402b3e0281
minfo-schema-change/issue1393: add kind column to sediment_yield table.
To change existing databases, issue following sql command:
ALTER TABLE sediment_yield ADD kind INT DEFAULT 0;
For oracles it might look like
ALTER TABLE sediment_yield ADD kind NUMBER(38,0) DEFAULT 0;
.
author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
---|---|
date | Wed, 31 Jul 2013 11:10:11 +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