Project

General

Profile

« Previous | Next » 

Revision 14093

Added by Aaron Marcuse-Kubitza over 10 years ago

bin/make_analytical_db: merged mk_table and mk_analytical_table since they now do the same thing

View differences:

trunk/bin/make_analytical_db
27 27 
EOF
28 28 
}
29 29 

  		




  30
  
  
    
mk_analytical_table()


  		




  31
  
  
    
{


  		




  32
  
  
    
    local table="$1"


  		




  33
  
  
    
    local public_table="\"$public\".$table"


  		




  34
  
  
    
    cat <<EOF


  		




  35
  
  
    
$(mk_table "$@")


  		




  36
  
  
    
EOF


  		




  37
  
  
    
}


  		




  38
  
  
    

  		




  39
  30
  
    
((set -x; "$selfDir/psql_verbose_vegbien") <<EOF


  		




  40
  31
  
    
GRANT USAGE ON SCHEMA analytical_db TO bien_read;


  		




  41
  32
  
    
GRANT USAGE ON SCHEMA analytical_db TO public_;


  		




  ......




  44
  35
  
    

  		




  45
  36
  
    
$(mk_table threatened_taxonlabel)


  		




  46
  37
  
    

  		




  47
  
  
    
$(mk_analytical_table taxon_trait)


  		




  48
  
  
    
$(mk_analytical_table analytical_stem)


  		




  49
  
  
    
$(mk_analytical_table provider_count)


  		




  
  38
  
    
$(mk_table taxon_trait)


  		




  
  39
  
    
$(mk_table analytical_stem)


  		




  
  40
  
    
$(mk_table provider_count)


  		




  50
  41
  
    
GRANT SELECT ON TABLE analytical_db.provider_count TO public_;


  		




  51
  42
  
    
EOF


  		




  52
  43
  
    
) || exit


  		












Also available in:  Unified diff