Mercurial > dive4elements > river
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 |