annotate backend/contrib/dump-schema.sh @ 7471:fff862f4ef76

Experimental caching of datacage recommendations. The respective hook is called a lot and running the datacage over and over again when loading data can be expensive. So the generated recommendations are cached for some time. Hopefully this improves the overall speed of loading data from the datacage.
author Sascha L. Teichmann <teichmann@intevation.de>
date Wed, 30 Oct 2013 15:26:21 +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