Revision 6054
Added by Aaron Marcuse-Kubitza about 12 years ago
bin/make_analytical_db | ||
---|---|---|
5 | 5 |
|
6 | 6 |
exec &>"$selfDir/../inputs/analytical_db/logs/make_analytical_db.log.sql" |
7 | 7 |
|
8 |
set -x |
|
9 |
date |
|
8 |
(set -x; date) |
|
10 | 9 |
|
11 |
"$selfDir/psql_verbose_vegbien" & <<EOF |
|
10 |
# geoscrub_input |
|
11 |
(set -x; "$selfDir/psql_verbose_vegbien" <<EOF |
|
12 | 12 |
TRUNCATE geoscrub_input; |
13 | 13 |
INSERT INTO geoscrub_input SELECT * FROM geoscrub_input_view; |
14 | 14 |
EOF |
15 |
) & |
|
16 |
sleep 1 |
|
15 | 17 |
|
16 |
"$selfDir/psql_verbose_vegbien" & <<EOF |
|
18 |
# analytical_* |
|
19 |
(set -x; "$selfDir/psql_verbose_vegbien" <<EOF |
|
17 | 20 |
SELECT make_family_higher_plant_group(); |
18 | 21 |
|
19 | 22 |
TRUNCATE analytical_stem; |
20 | 23 |
INSERT INTO analytical_stem SELECT * FROM analytical_stem_view; |
21 | 24 |
TRUNCATE analytical_aggregate; |
22 | 25 |
INSERT INTO analytical_aggregate SELECT * FROM analytical_aggregate_view; |
23 |
TRUNCATE geoscrub_input; |
|
24 |
INSERT INTO geoscrub_input SELECT * FROM geoscrub_input_view; |
|
25 | 26 |
EOF |
27 |
) & |
|
26 | 28 |
|
27 | 29 |
wait |
Also available in: Unified diff
make_analytical_db: Wrap each individual command in `set -x` to avoid echoing low-level commands such as sleep, wait