Project

General

Profile

« Previous | Next » 

Revision 6054

Added by Aaron Marcuse-Kubitza over 11 years ago

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

View differences:

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