annotate backend/contrib/dump-schema.sh @ 6087:47775e3a8cf6

Datacage: Introduced <dc:virtual-column name="colname" type="type" expr="XPath"> dc:virtual-column can be used to virtual add or replace a column named 'colname' to the current result set. The value is determined by evaluating "XPath", the type is determined by "type" (possible values: number, bool, node, nodeset, string. defaults to string). Usage: <dc:virtual-column name="c" type="number" expr="$a+$b"> <dc:for-each> <dc:message>{$a} + {$b} = {$c}</dc:message> </dc:for-each> </dc:virtual-column> table a | b --+-- 1 | 2 3 | 4 will result in: 1 + 2 = 3 3 + 4 = 7
author Sascha L. Teichmann <teichmann@intevation.de>
date Fri, 24 May 2013 12:19:25 +0200
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