Mercurial > dive4elements > river

annotate flys-backend/contrib/dump-schema.sh @ 5321:6dd354e7abfc

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
SCHEMA CHANGE: removed bad triggers and foreign keys from schema
author Tom Gottfried <tom@intevation.de>
date Fri, 15 Mar 2013 16:43:00 +0100
parents 8477965674ce
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