diff db_schema/setup-db.sh @ 1319:512616ea3228 release-2.5

fix somme test data
author Michael Stanko <mstanko@bfs.de>
date Thu, 23 Mar 2017 09:02:26 +0100
parents 6692b3bdc49d
children bfbbd390c9a8
line wrap: on
line diff
--- a/db_schema/setup-db.sh	Mon Mar 20 15:52:22 2017 +0100
+++ b/db_schema/setup-db.sh	Thu Mar 23 09:02:26 2017 +0100
@@ -40,7 +40,7 @@
 DB_CONNECT_STRING="$DB_CONNECT_STRING -U postgres"
 echo "DB_CONNECT_STRING = $DB_CONNECT_STRING"
 
-if [ `psql $DB_CONNECT_STRING -t --command "SELECT count(*) FROM pg_catalog.pg_user WHERE usename = '$ROLE_NAME'"` -eq 0 ] ; then
+if [ `psql $DB_CONNECT_STRING -t --quiet --command "SELECT count(*) FROM pg_catalog.pg_user WHERE usename = '$ROLE_NAME'"` -eq 0 ] ; then
   echo create user $ROLE_NAME
   psql $DB_CONNECT_STRING --command "CREATE USER $ROLE_NAME PASSWORD '$ROLE_PW';"
 fi
@@ -72,6 +72,11 @@
             ON ALL TABLES IN SCHEMA stammdaten, land TO $ROLE_NAME;"
 
 if [ "$NO_DATA" != "true" ]; then
+    if [ -f $DIR/lada_private_data.zip ]; then
+        echo inclue private data
+        unzip -o lada_private_data.zip
+    fi
+
     echo import stammdaten.verwaltungseinheit
     psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_data_verwaltungseinheit.sql
 
@@ -127,9 +132,8 @@
             http://sg.geodatenzentrum.de/web_download/vg/vg250_${TS}/utm32s/shape/vg250_${TS}.utm32s.shape.ebenen.zip
     fi
     unzip -u vg250_${TS}.utm32s.shape.ebenen.zip "*VG250_GEM*"
-#    cd vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/
+
     shp2pgsql -s 25832:4326 vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/VG250_GEM geo.gem_utm | psql -q $DB_CONNECT_STRING -d $DB_NAME
-#   rm -rf vg250_${TS}.utm32s.shape.ebenen
 
     echo fille stammdaten.verwaltungsgrenze
     psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_fill_verwaltungsgrenze.sql
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)