annotate flys-backend/contrib/dump-schema.sh @ 5509:627584bc0586

Datacage: Added <dc:filter> element. This allows cleaner way to narrow the datasets. Example: <dc:context> <dc:statement> SELECT DISTINCT name AS hws_name, official AS hws_official, kind_id AS hws_kind FROM hws_lines WHERE river_id = ${river_id} </dc:statement> <dc:if test="dc:has-result()"> <lines> <dc:macro name="hws-lines"> <dc:elements> <hws factory="hwsfactory" name="{$hws_name}"/> </dc:elements> </dc:macro> <dc:filter expr="$hws_official=1"> <dc:if test="dc:has-result()"> <official> <dc:filter expr="$hws_kind=1"> <dc:if test="dc:has-result()"> <Durchlass><dc:call-macro name="hws-lines"></Durchlass> </dc:if> </dc:filter> <dc:filter expr="$hws_kind=2"> <dc:if test="dc:has-result()"> <Damm><dc:call-macro name="hws-lines"></Damm> </dc:if> </dc:filter> <dc:filter expr="$hws_kind=3"> <dc:if test="dc:has-result()"> <Graben><dc:call-macro name="hws-lines"></Graben> </dc:if> </dc:filter> </official> </dc:if> </dc:filter> </lines> </dc:if> </dc:context>
author Sascha L. Teichmann <teichmann@intevation.de>
date Thu, 28 Mar 2013 16:51:15 +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