Project

General

Profile

« Previous | Next » 

Revision 6056

Added by Aaron Marcuse-Kubitza over 11 years ago

make_analytical_db: Run all commands synchronously so the log file output doesn't become jumbled

View differences:

bin/make_analytical_db
7 7 

  		




  8
  8
  
    
(set -x; date)


  		




  9
  9
  
    

  		




  10
  
  
    
# geoscrub_input


  		




  11
  10
  
    
(set -x; "$selfDir/psql_verbose_vegbien" <<EOF


  		




  12
  11
  
    
TRUNCATE geoscrub_input;


  		




  13
  12
  
    
INSERT INTO geoscrub_input SELECT * FROM geoscrub_input_view;


  		




  14
  
  
    
EOF


  		




  15
  
  
    
) &


  		




  16
  
  
    
sleep 1


  		




  17
  13
  
    

  		




  18
  
  
    
# analytical_*


  		




  19
  
  
    
(set -x; "$selfDir/psql_verbose_vegbien" <<EOF


  		




  20
  14
  
    
SELECT make_family_higher_plant_group();


  		




  21
  15
  
    

  		




  22
  16
  
    
TRUNCATE analytical_stem;


  		




  ......




  24
  18
  
    
TRUNCATE analytical_aggregate;


  		




  25
  19
  
    
INSERT INTO analytical_aggregate SELECT * FROM analytical_aggregate_view;


  		




  26
  20
  
    
EOF


  		




  27
  
  
    
) &


  		




  28
  
  
    

  		




  29
  
  
    
wait


  		




  
  21
  
    
)


  		












Also available in:  Unified diff