Mercurial > lada > lada-server
comparison db_schema/setup-db.sh @ 1329:46aa15c8cfb2
Merged branch release-2.5 into default.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 27 Mar 2017 16:31:11 +0200 |
| parents | b5ab25b7ac2c 22c9bbb88d1a |
| children |
comparison
equal
deleted
inserted
replaced
| 1327:f2e574204e38 | 1329:46aa15c8cfb2 |
|---|---|
| 41 DB_CONNECT_STRING="$DB_CONNECT_STRING -p $DB_PORT" | 41 DB_CONNECT_STRING="$DB_CONNECT_STRING -p $DB_PORT" |
| 42 fi | 42 fi |
| 43 DB_CONNECT_STRING="$DB_CONNECT_STRING -U postgres" | 43 DB_CONNECT_STRING="$DB_CONNECT_STRING -U postgres" |
| 44 echo "DB_CONNECT_STRING = $DB_CONNECT_STRING" | 44 echo "DB_CONNECT_STRING = $DB_CONNECT_STRING" |
| 45 | 45 |
| 46 if [ `psql $DB_CONNECT_STRING -t --command "SELECT count(*) FROM pg_catalog.pg_user WHERE usename = '$ROLE_NAME'"` -eq 0 ] ; then | 46 if [ `psql $DB_CONNECT_STRING -t --quiet --command "SELECT count(*) FROM pg_catalog.pg_user WHERE usename = '$ROLE_NAME'"` -eq 0 ] ; then |
| 47 echo create user $ROLE_NAME | 47 echo create user $ROLE_NAME |
| 48 psql $DB_CONNECT_STRING --command "CREATE USER $ROLE_NAME PASSWORD '$ROLE_PW';" | 48 psql $DB_CONNECT_STRING --command "CREATE USER $ROLE_NAME PASSWORD '$ROLE_PW';" |
| 49 fi | 49 fi |
| 50 | 50 |
| 51 if [ "$DROP_DB" = "true" ] && psql $DB_CONNECT_STRING -l | grep -q "^ $DB_NAME " ; then | 51 if [ "$DROP_DB" = "true" ] && psql $DB_CONNECT_STRING -l | grep -q "^ $DB_NAME " ; then |
| 121 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_init_sequences.sql | 121 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_init_sequences.sql |
| 122 | 122 |
| 123 echo import lada test data | 123 echo import lada test data |
| 124 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_data.sql | 124 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_data.sql |
| 125 | 125 |
| 126 echo import lada messprogramm | |
| 127 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_messprogramm.sql | |
| 128 | |
| 126 echo create schema geo | 129 echo create schema geo |
| 127 psql $DB_CONNECT_STRING -d $DB_NAME --command "CREATE SCHEMA geo AUTHORIZATION $ROLE_NAME" | 130 psql $DB_CONNECT_STRING -d $DB_NAME --command "CREATE SCHEMA geo AUTHORIZATION $ROLE_NAME" |
| 128 | 131 |
| 129 echo downlaod and import german administrative borders | 132 echo downlaod and import german administrative borders |
| 130 TS="0101" | 133 TS="0101" |
| 132 if [ ! -f vg250_${TS}.utm32s.shape.ebenen.zip ]; then | 135 if [ ! -f vg250_${TS}.utm32s.shape.ebenen.zip ]; then |
| 133 curl -O \ | 136 curl -O \ |
| 134 http://sg.geodatenzentrum.de/web_download/vg/vg250_${TS}/utm32s/shape/vg250_${TS}.utm32s.shape.ebenen.zip | 137 http://sg.geodatenzentrum.de/web_download/vg/vg250_${TS}/utm32s/shape/vg250_${TS}.utm32s.shape.ebenen.zip |
| 135 fi | 138 fi |
| 136 unzip -u vg250_${TS}.utm32s.shape.ebenen.zip "*VG250_GEM*" | 139 unzip -u vg250_${TS}.utm32s.shape.ebenen.zip "*VG250_GEM*" |
| 137 # cd vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/ | 140 |
| 138 shp2pgsql -s 25832:4326 vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/VG250_GEM geo.gem_utm | psql -q $DB_CONNECT_STRING -d $DB_NAME | 141 shp2pgsql -s 25832:4326 vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/VG250_GEM geo.gem_utm | psql -q $DB_CONNECT_STRING -d $DB_NAME |
| 139 # rm -rf vg250_${TS}.utm32s.shape.ebenen | |
| 140 | 142 |
| 141 echo fille stammdaten.verwaltungsgrenze | 143 echo fille stammdaten.verwaltungsgrenze |
| 142 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_fill_verwaltungsgrenze.sql | 144 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_fill_verwaltungsgrenze.sql |
| 143 | 145 |
| 144 if [ -f $DIR/lada_auth.sql ]; then | 146 if [ -f $DIR/lada_auth.sql ]; then |