Mercurial > dive4elements > river
annotate contrib/make_flys_release/h2/createDatacage.sh @ 6110:5ba28b563614
Fix datacage for user data by adding facet filtering.
Now the facets are joined in the user data select statement
and afterwards we just filter on the facet name where previously
new queryies were created.
Grouping also fixes the repeating folders caused by the change
in the statements during the large perfomance cleanup.
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Mon, 27 May 2013 15:36:56 +0200 |
| parents | 3ba2917e49d3 |
| children | 19472d3877d6 |
| rev | line source |
|---|---|
|
4065
9d404069f361
Added build script for FLYS release.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
1 #!/bin/bash |
|
9d404069f361
Added build script for FLYS release.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
2 |
|
5250
3ba2917e49d3
Remove old artifacts-h2.sql and datacage.sql and expect the
Andre Heinecke <aheinecke@intevation.de>
parents:
4065
diff
changeset
|
3 mkdir -p datacagedb |
|
4065
9d404069f361
Added build script for FLYS release.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
4 |
|
9d404069f361
Added build script for FLYS release.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
5 DIR=`dirname $0` |
|
9d404069f361
Added build script for FLYS release.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
6 DIR=`readlink -f "$DIR"` |
|
9d404069f361
Added build script for FLYS release.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
7 |
|
9d404069f361
Added build script for FLYS release.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
8 CLASSPATH= |
|
9d404069f361
Added build script for FLYS release.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
9 for l in `find "$DIR" -name \*.jar -print`; do |
|
9d404069f361
Added build script for FLYS release.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
10 CLASSPATH=$CLASSPATH:$l |
|
9d404069f361
Added build script for FLYS release.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
11 done |
|
9d404069f361
Added build script for FLYS release.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
12 |
|
9d404069f361
Added build script for FLYS release.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
13 export CLASSPATH |
|
5250
3ba2917e49d3
Remove old artifacts-h2.sql and datacage.sql and expect the
Andre Heinecke <aheinecke@intevation.de>
parents:
4065
diff
changeset
|
14 if [ $# != 1 ]; then |
|
3ba2917e49d3
Remove old artifacts-h2.sql and datacage.sql and expect the
Andre Heinecke <aheinecke@intevation.de>
parents:
4065
diff
changeset
|
15 echo "Usage: $0 <schema_file>" |
|
3ba2917e49d3
Remove old artifacts-h2.sql and datacage.sql and expect the
Andre Heinecke <aheinecke@intevation.de>
parents:
4065
diff
changeset
|
16 fi |
|
4065
9d404069f361
Added build script for FLYS release.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
17 |
|
9d404069f361
Added build script for FLYS release.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
18 java org.h2.tools.RunScript \ |
|
9d404069f361
Added build script for FLYS release.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff
changeset
|
19 -url jdbc:h2:`readlink -f datacagedb`/datacage \ |
|
5250
3ba2917e49d3
Remove old artifacts-h2.sql and datacage.sql and expect the
Andre Heinecke <aheinecke@intevation.de>
parents:
4065
diff
changeset
|
20 -script "$1" |