annotate backend/contrib/run_geo.sh @ 8605:b0e5a2ce0b09

(issue1750) Fix id handling with oracle On oracle the id is returned as BigDecimal. This could probably be done better with hibernate but checking the Object also works.
author Andre Heinecke <andre.heinecke@intevation.de>
date Fri, 20 Mar 2015 18:42:00 +0100
parents b2e167f193d7
children f7c49975cc15
rev   line source
7458
b2e167f193d7 run_geo.sh: allow logging as documented.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6815
diff changeset
1 #!/bin/bash
3683
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
2
4873
2b371e42a9af Add HWS Lines parameters and ogr_connection example
Andre Heinecke <aheinecke@intevation.de>
parents: 3683
diff changeset
3 # Set this to your target database for Oracle
3683
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
4 HOST=localhost
6658
89f856e24d27 Importer scripts: shpimporter needs backend name to play with Oracle.
Tom Gottfried <tom@intevation.de>
parents: 6651
diff changeset
5 BACKEND_NAME="XE"
3683
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
6 USER=flys28
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
7 PASS=flys28
4873
2b371e42a9af Add HWS Lines parameters and ogr_connection example
Andre Heinecke <aheinecke@intevation.de>
parents: 3683
diff changeset
8 # Alternatively you can provide a direct connection string:
2b371e42a9af Add HWS Lines parameters and ogr_connection example
Andre Heinecke <aheinecke@intevation.de>
parents: 3683
diff changeset
9 # OGR_CONNECTION="PG:dbname=flys host=localhost port=5432 user=flys password=flys"
3683
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
10
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
11 # Optional
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
12 VERBOSE=1
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
13 SKIP_AXIS=0
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
14 SKIP_KMS=0
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
15 SKIP_CROSSSECTIONS=0
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
16 SKIP_FIXPOINTS=0
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
17 SKIP_BUILDINGS=0
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
18 SKIP_FLOODPLAINS=0
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
19 SKIP_HYDR_BOUNDARIES=0
4873
2b371e42a9af Add HWS Lines parameters and ogr_connection example
Andre Heinecke <aheinecke@intevation.de>
parents: 3683
diff changeset
20 SKIP_HWS_LINES=0
2b371e42a9af Add HWS Lines parameters and ogr_connection example
Andre Heinecke <aheinecke@intevation.de>
parents: 3683
diff changeset
21 SKIP_HWS_POINTS=0
3683
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
22 SKIP_UESG=0
5035
1f33012cc02a Add skip-dgm option to example run script
Andre Heinecke <aheinecke@intevation.de>
parents: 4996
diff changeset
23 SKIP_DGM=0
5353
d086ce6c13d3 Add jetties importer
Andre Heinecke <aheinecke@intevation.de>
parents: 5074
diff changeset
24 SKIP_JETTIES=0
5545
ed149d5d7fb7 Add floodmarks importer
Andre Heinecke <aheinecke@intevation.de>
parents: 5353
diff changeset
25 SKIP_FLOODMARKS=0
3683
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
26
6651
8782ba5cb222 Importer scripts: add default encoding to correctly read gew-files
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
27 # Default encoding. Change here if necessary
8782ba5cb222 Importer scripts: add default encoding to correctly read gew-files
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
28 export LC_ALL=de_DE@euro
8782ba5cb222 Importer scripts: add default encoding to correctly read gew-files
Tom Gottfried <tom@intevation.de>
parents: 5838
diff changeset
29
5066
8208df10df79 Update run example scripts to work with the new packaging
Andre Heinecke <aheinecke@intevation.de>
parents: 5035
diff changeset
30 # There should be no need to change anything below this line
6805
0b2c9de5e681 Geo-importer: use commandline-argument instead of configuration for river selection.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6658
diff changeset
31 GEW_FILE="$1"
0b2c9de5e681 Geo-importer: use commandline-argument instead of configuration for river selection.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6658
diff changeset
32 RIVER_NAME=$(grep "Gew.sser" "$1" | sed 's/Gew.sser: //')
0b2c9de5e681 Geo-importer: use commandline-argument instead of configuration for river selection.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6658
diff changeset
33
0b2c9de5e681 Geo-importer: use commandline-argument instead of configuration for river selection.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6658
diff changeset
34 RIVER_PATH=$(grep "WSTDatei:" "$GEW_FILE" | awk '{print $2}')
0b2c9de5e681 Geo-importer: use commandline-argument instead of configuration for river selection.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6658
diff changeset
35 RIVER_PATH=$(dirname "$RIVER_PATH")/../..
0b2c9de5e681 Geo-importer: use commandline-argument instead of configuration for river selection.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6658
diff changeset
36 RIVER_PATH=$(readlink -f "$RIVER_PATH")
5066
8208df10df79 Update run example scripts to work with the new packaging
Andre Heinecke <aheinecke@intevation.de>
parents: 5035
diff changeset
37
3683
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
38 DIR=`dirname $0`
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
39 DIR=`readlink -f "$DIR"`
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
40
5074
90b9b80ffbbf Fix example run script to work with the new packaging
Andre Heinecke <aheinecke@intevation.de>
parents: 5066
diff changeset
41 OPTIONAL_LIBS="${DIR}"/opt
5066
8208df10df79 Update run example scripts to work with the new packaging
Andre Heinecke <aheinecke@intevation.de>
parents: 5035
diff changeset
42 if [ -d "$OPTIONAL_LIBS" ]; then
8208df10df79 Update run example scripts to work with the new packaging
Andre Heinecke <aheinecke@intevation.de>
parents: 5035
diff changeset
43 export PATH="$OPTIONAL_LIBS/bin:$PATH"
8208df10df79 Update run example scripts to work with the new packaging
Andre Heinecke <aheinecke@intevation.de>
parents: 5035
diff changeset
44 export LD_LIBRARY_PATH="$OPTIONAL_LIBS/lib:$LD_LIBRARY_PATH"
8208df10df79 Update run example scripts to work with the new packaging
Andre Heinecke <aheinecke@intevation.de>
parents: 5035
diff changeset
45 export LD_LIBRARY_PATH="$OPTIONAL_LIBS/lib64:$LD_LIBRARY_PATH"
8208df10df79 Update run example scripts to work with the new packaging
Andre Heinecke <aheinecke@intevation.de>
parents: 5035
diff changeset
46 export PYTHONPATH="$OPTIONAL_LIBS/lib/python2.6/site-packages:$PYTHONPATH"
5074
90b9b80ffbbf Fix example run script to work with the new packaging
Andre Heinecke <aheinecke@intevation.de>
parents: 5066
diff changeset
47 export PYTHONPATH="$OPTIONAL_LIBS/lib64/python2.6/site-packages:$PYTHONPATH"
90b9b80ffbbf Fix example run script to work with the new packaging
Andre Heinecke <aheinecke@intevation.de>
parents: 5066
diff changeset
48 export GDAL_DATA="$OPTIONAL_LIBS/share/gdal"
5066
8208df10df79 Update run example scripts to work with the new packaging
Andre Heinecke <aheinecke@intevation.de>
parents: 5035
diff changeset
49 fi
8208df10df79 Update run example scripts to work with the new packaging
Andre Heinecke <aheinecke@intevation.de>
parents: 5035
diff changeset
50
3683
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
51 exec python $DIR/shpimporter/shpimporter.py \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
52 --directory $RIVER_PATH \
5563
673f68bb19a4 Geo-importer: accept river names with white space
Tom Gottfried <tom@intevation.de>
parents: 5545
diff changeset
53 --river_name "$RIVER_NAME" \
4873
2b371e42a9af Add HWS Lines parameters and ogr_connection example
Andre Heinecke <aheinecke@intevation.de>
parents: 3683
diff changeset
54 --ogr_connection "$OGR_CONNECTION" \
6658
89f856e24d27 Importer scripts: shpimporter needs backend name to play with Oracle.
Tom Gottfried <tom@intevation.de>
parents: 6651
diff changeset
55 --host $HOST/$BACKEND_NAME \
3683
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
56 --user $USER \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
57 --password $PASS \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
58 --verbose $VERBOSE \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
59 --skip_axis $SKIP_AXIS \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
60 --skip_kms $SKIP_KMS \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
61 --skip_crosssections $SKIP_CROSSSECTIONS \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
62 --skip_fixpoints $SKIP_FIXPOINTS \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
63 --skip_buildings $SKIP_BUILDINGS \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
64 --skip_floodplains $SKIP_FLOODPLAINS \
4298ef9bd4a6 Added run scripts for both importers.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
65 --skip_hydr_boundaries $SKIP_HYDR_BOUNDARIES \
4873
2b371e42a9af Add HWS Lines parameters and ogr_connection example
Andre Heinecke <aheinecke@intevation.de>
parents: 3683
diff changeset
66 --skip_uesgs $SKIP_UESG \
2b371e42a9af Add HWS Lines parameters and ogr_connection example
Andre Heinecke <aheinecke@intevation.de>
parents: 3683
diff changeset
67 --skip_hws_lines $SKIP_HWS_LINES \
5035
1f33012cc02a Add skip-dgm option to example run script
Andre Heinecke <aheinecke@intevation.de>
parents: 4996
diff changeset
68 --skip_hws_points $SKIP_HWS_POINTS \
5353
d086ce6c13d3 Add jetties importer
Andre Heinecke <aheinecke@intevation.de>
parents: 5074
diff changeset
69 --skip_dgm $SKIP_DGM \
5545
ed149d5d7fb7 Add floodmarks importer
Andre Heinecke <aheinecke@intevation.de>
parents: 5353
diff changeset
70 --skip_jetties $SKIP_JETTIES \
7458
b2e167f193d7 run_geo.sh: allow logging as documented.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6815
diff changeset
71 --skip_floodmarks $SKIP_FLOODMARKS \
b2e167f193d7 run_geo.sh: allow logging as documented.
Tom Gottfried <tom.gottfried@intevation.de>
parents: 6815
diff changeset
72 2>&1

http://dive4elements.wald.intevation.org