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 |