Project

General

Profile

« Previous | Next » 

Revision 6054

make_analytical_db: Wrap each individual command in `set -x` to avoid echoing low-level commands such as sleep, wait

View differences:

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