Project

General

Profile

« Previous | Next » 

Revision 11723

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/CVS/plantConcept_/: translated multi-column filters to postprocessing derived columns, using the steps at http://wiki.vegpath.org/Adding_new-style_import_to_a_datasource#1-Translate-filters-to-postprocessing-derived-columns

View differences:

postprocess.sql
1 1 
SELECT util.search_path_append('util');
2 2 

  		




  
  3
  
    
SELECT util.rename_cols(:table_str, $$


  		




  
  4
  
    
genus => *genus,


  		




  
  5
  
    
$$::hstore);


  		




  
  6
  
    

  		




  3
  7
  
    
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY ("PLANTCONCEPT_ID")$$); -- runtime: ~0 @starscream


  		




  
  8
  
    

  		




  
  9
  
    

  		




  
  10
  
    
SELECT mk_derived_col((:table_str, 'division'),


  		




  
  11
  
    
$$_alt(denorm_division, "Division")$$)


  		




  
  12
  
    
; -- runtime: 0.2 s ("212.478 ms") @starscream


  		




  
  13
  
    

  		




  
  14
  
    
SELECT mk_derived_col((:table_str, 'genus'),


  		




  
  15
  
    
$$_alt(denorm_genus, "*genus")$$)


  		




  
  16
  
    
; -- runtime: 0.1 s ("127.546 ms") @starscream


  		












Also available in:  Unified diff