Mercurial > dive4elements > river

annotate backend/contrib/dump-schema.sh @ 8470:c5a7aae52396

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
rev   line source
2348
8477965674ce Added a schema dump shell script.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
1 #!/bin/bash
8477965674ce Added a schema dump shell script.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
2
8477965674ce Added a schema dump shell script.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
3 DB_URL=jdbc:postgresql://czech-republic.atlas.intevation.de:5432/flys3
8477965674ce Added a schema dump shell script.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
4 DB_USER=flys
8477965674ce Added a schema dump shell script.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
5 DB_PASS=flys
8477965674ce Added a schema dump shell script.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
6 DB_DIALECT=org.hibernatespatial.oracle.OracleSpatial10gDialect
8477965674ce Added a schema dump shell script.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
7
8477965674ce Added a schema dump shell script.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
8 mvn compile package -e \
8477965674ce Added a schema dump shell script.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
9 -Dlog4j.configuration=file://`readlink -f contrib/log4j.properties` \
8477965674ce Added a schema dump shell script.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
10 -Dflys.backend.user=$DB_USER \
8477965674ce Added a schema dump shell script.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
11 -Dflys.backend.password=$DB_PASS \
8477965674ce Added a schema dump shell script.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
12 -Dflys.backend.dialect=$DB_DIALECT \
8477965674ce Added a schema dump shell script.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
13 -Dflys.backend.url=$DB_URL \
8477965674ce Added a schema dump shell script.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
14 -Dexec.mainClass=de.intevation.flys.App \
8477965674ce Added a schema dump shell script.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
15 exec:java
8477965674ce Added a schema dump shell script.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
16
http://dive4elements.wald.intevation.org