Project

General

Profile

« Previous | Next » 

Revision 6053

Added by Aaron Marcuse-Kubitza about 12 years ago

make_analytical_db: Moved log file to inputs/analytical_db/logs/make_analytical_db.log.sql so it would be synced along with the other import logs

View differences:

make_analytical_db
3 3 

  		




  4
  4
  
    
selfDir="$(dirname -- "$0")"


  		




  5
  5
  
    

  		




  6
  
  
    
exec &>"$selfDir/../inputs/analytical_db/logs/make_analytical_db.log"


  		




  
  6
  
    
exec &>"$selfDir/../inputs/analytical_db/logs/make_analytical_db.log.sql"


  		




  7
  7
  
    

  		




  8
  8
  
    
set -x


  		




  9
  9
  
    
date


  		




  10
  10
  
    

  		




  11
  
  
    
"$selfDir/psql_verbose_vegbien" <<EOF


  		




  
  11
  
    
"$selfDir/psql_verbose_vegbien" & <<EOF


  		




  
  12
  
    
TRUNCATE geoscrub_input;


  		




  
  13
  
    
INSERT INTO geoscrub_input SELECT * FROM geoscrub_input_view;


  		




  
  14
  
    
EOF


  		




  
  15
  
    

  		




  
  16
  
    
"$selfDir/psql_verbose_vegbien" & <<EOF


  		




  12
  17
  
    
SELECT make_family_higher_plant_group();


  		




  13
  18
  
    

  		




  14
  19
  
    
TRUNCATE analytical_stem;


  		




  ......




  18
  23
  
    
TRUNCATE geoscrub_input;


  		




  19
  24
  
    
INSERT INTO geoscrub_input SELECT * FROM geoscrub_input_view;


  		




  20
  25
  
    
EOF


  		




  
  26
  
    

  		




  
  27
  
    
wait


  		












Also available in:  Unified diff