Project

General

Profile

« Previous | Next » 

Revision 14361

Added by Aaron Marcuse-Kubitza over 10 years ago

fix: inputs/.TNRS/schema.sql: taxon_match: to remove columns or add columns: also need to run util.recreate_view()

View differences:

trunk/inputs/.TNRS/schema.sql
575 575 
to port derived column changes to vegbiendev:
576 576 
SELECT util.derived_cols_export(''"TNRS".taxon_match'');
577 577 
# run the returned SQL on vegbiendev
578 
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
578 579 

  		




  579
  580
  
    
to remove columns or add columns at the end:


  		




  
  581
  
    
SELECT util.recreate_view(''"TNRS".taxon_best_match'');


  		




  580
  582
  
    
$ make schemas/remake


  		




  581
  583
  
    

  		




  582
  584
  
    
to add columns in the middle:


  		




  ......




  584
  586
  
    
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS


  		




  585
  587
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match'');


  		




  586
  588
  
    
SELECT util.derived_cols_repopulate(''"TNRS".taxon_match'');


  		




  
  589
  
    
SELECT util.recreate_view(''"TNRS".taxon_best_match'');


  		




  587
  590
  
    
$ make schemas/remake


  		




  588
  591
  
    

  		




  589
  592
  
    
to populate a new column:


  		












  

    
      trunk/schemas/vegbien.sql
    
  





  20236
  20236
  
    
to port derived column changes to vegbiendev:


  		




  20237
  20237
  
    
SELECT util.derived_cols_export(''"TNRS".taxon_match'');


  		




  20238
  20238
  
    
# run the returned SQL on vegbiendev


  		




  
  20239
  
    
SELECT util.recreate_view(''"TNRS".taxon_best_match'');


  		




  20239
  20240
  
    

  		




  20240
  20241
  
    
to remove columns or add columns at the end:


  		




  
  20242
  
    
SELECT util.recreate_view(''"TNRS".taxon_best_match'');


  		




  20241
  20243
  
    
$ make schemas/remake


  		




  20242
  20244
  
    

  		




  20243
  20245
  
    
to add columns in the middle:


  		




  ......




  20245
  20247
  
    
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS


  		




  20246
  20248
  
    
SELECT util.derived_cols_update(''"TNRS".taxon_match'');


  		




  20247
  20249
  
    
SELECT util.derived_cols_repopulate(''"TNRS".taxon_match'');


  		




  
  20250
  
    
SELECT util.recreate_view(''"TNRS".taxon_best_match'');


  		




  20248
  20251
  
    
$ make schemas/remake


  		




  20249
  20252
  
    

  		




  20250
  20253
  
    
to populate a new column:


  		












Also available in:  Unified diff