Project

General

Profile

« Previous | Next » 

Revision 6465

Added by Aaron Marcuse-Kubitza about 12 years ago

make_analytical_db: mk_analytical_table(): Factored table references in different schemas out into vars

View differences:

make_analytical_db
13 13 
mk_analytical_table ()
14 14 
{
15 15 
    local table="$1"
16 
    local public_table="\"$public\".$table" analyt_table="analytical_db.$table"
16 17 
    cat <<EOF
17 18 
-- Create $table
18 19 
TRUNCATE $table;
19 20 
INSERT INTO $table SELECT * FROM ${table}_view;
20 21 

  		




  21
  
  
    
-- Create analytical_db.$table view pointing to table in $public


  		




  22
  
  
    
DROP VIEW IF EXISTS analytical_db.$table;


  		




  23
  
  
    
CREATE VIEW analytical_db.$table AS


  		




  24
  
  
    
SELECT * FROM "$public".$table;


  		




  25
  
  
    
GRANT SELECT ON TABLE analytical_db.$table TO bien_read;


  		




  
  22
  
    
-- Create $analyt_table view pointing to table in $public


  		




  
  23
  
    
DROP VIEW IF EXISTS $analyt_table;


  		




  
  24
  
    
CREATE VIEW $analyt_table AS


  		




  
  25
  
    
SELECT * FROM $public_table;


  		




  
  26
  
    
GRANT SELECT ON TABLE $analyt_table TO bien_read;


  		




  26
  27
  
    
EOF


  		




  27
  28
  
    
}


  		




  28
  29
  
    

  		












Also available in:  Unified diff