Mercurial > lada > lada-server
comparison db_schema/setup-db.sh @ 1085:1d1c50b7a23b
Run psql quietly when running large SQL scripts.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 13 Oct 2016 17:01:31 +0200 |
| parents | 4ce4bd48c260 |
| children | 186d602e031a |
comparison
equal
deleted
inserted
replaced
| 1083:99c6c644773b | 1085:1d1c50b7a23b |
|---|---|
| 57 echo create postgis extension | 57 echo create postgis extension |
| 58 psql $DB_CONNECT_STRING -d $DB_NAME --command \ | 58 psql $DB_CONNECT_STRING -d $DB_NAME --command \ |
| 59 "CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public" | 59 "CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public" |
| 60 | 60 |
| 61 echo create stammdaten schema | 61 echo create stammdaten schema |
| 62 psql $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_schema.sql | 62 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_schema.sql |
| 63 | 63 |
| 64 echo create lada schema | 64 echo create lada schema |
| 65 psql $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_schema.sql | 65 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_schema.sql |
| 66 echo set grants | 66 echo set grants |
| 67 psql $DB_CONNECT_STRING -d $DB_NAME --command \ | 67 psql $DB_CONNECT_STRING -d $DB_NAME --command \ |
| 68 "GRANT USAGE ON SCHEMA stammdaten, bund, land TO $ROLE_NAME; | 68 "GRANT USAGE ON SCHEMA stammdaten, bund, land TO $ROLE_NAME; |
| 69 GRANT USAGE | 69 GRANT USAGE |
| 70 ON ALL SEQUENCES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME; | 70 ON ALL SEQUENCES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME; |
| 71 GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES | 71 GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES |
| 72 ON ALL TABLES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME;" | 72 ON ALL TABLES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME;" |
| 73 | 73 |
| 74 if [ "$NO_DATA" != "true" ]; then | 74 if [ "$NO_DATA" != "true" ]; then |
| 75 echo import stammdaten | 75 echo import stammdaten |
| 76 psql $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_data.sql | 76 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_data.sql |
| 77 | 77 |
| 78 echo import lada test data | 78 echo import lada test data |
| 79 psql $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_data.sql | 79 psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_data.sql |
| 80 | 80 |
| 81 echo create user $ROLE_NAME | 81 echo create user $ROLE_NAME |
| 82 psql $DB_CONNECT_STRING -d $DB_NAME --command "CREATE SCHEMA geo AUTHORIZATION $ROLE_NAME" | 82 psql $DB_CONNECT_STRING -d $DB_NAME --command "CREATE SCHEMA geo AUTHORIZATION $ROLE_NAME" |
| 83 | 83 |
| 84 TS="0101" | 84 TS="0101" |
| 87 curl -O \ | 87 curl -O \ |
| 88 http://sg.geodatenzentrum.de/web_download/vg/vg250_${TS}/utm32s/shape/vg250_${TS}.utm32s.shape.ebenen.zip | 88 http://sg.geodatenzentrum.de/web_download/vg/vg250_${TS}/utm32s/shape/vg250_${TS}.utm32s.shape.ebenen.zip |
| 89 fi | 89 fi |
| 90 unzip vg250_${TS}.utm32s.shape.ebenen.zip "*VG250_GEM*" | 90 unzip vg250_${TS}.utm32s.shape.ebenen.zip "*VG250_GEM*" |
| 91 cd vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/ | 91 cd vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/ |
| 92 shp2pgsql VG250_GEM geo.gem_utm | psql $DB_CONNECT_STRING -d $DB_NAME | 92 shp2pgsql VG250_GEM geo.gem_utm | psql -q $DB_CONNECT_STRING -d $DB_NAME |
| 93 cd /tmp | 93 cd /tmp |
| 94 rm -rf vg250_${TS}.utm32s.shape.ebenen | 94 rm -rf vg250_${TS}.utm32s.shape.ebenen |
| 95 fi | 95 fi |