Project

General

Profile

« Previous | Next » 

Revision 13069

Added by Aaron Marcuse-Kubitza about 10 years ago

schemas/vegbien.sql: public_validations: schema comment: documented how to run the validations. this information is also in the usage comment for public_validations.remake_diff_table(), but is copied here for easy reference.

View differences:

vegbien.sql
23 23 
COMMENT ON SCHEMA public_validations IS '
24 24 
aggregating validations queries
25 25 

  		




  
  26
  
    
to run the validations on all datasources:


  		




  
  27
  
    
SELECT public_validations.remake_diff_tables();


  		




  
  28
  
    

  		




  
  29
  
    
to run the validations on a particular datasource:


  		




  
  30
  
    
SELECT public_validations.remake_diff_tables(''datasource'');


  		




  
  31
  
    

  		




  
  32
  
    
to run a particular validations query for a datasource:


  		




  
  33
  
    
SELECT public_validations.remake_diff_table(''"datasource"._view_name'');


  		




  
  34
  
    

  		




  26
  35
  
    
to reset the queries to what''s in schemas/vegbien.sql:


  		




  27
  36
  
    
SELECT public_validations.rm_output_queries();


  		




  28
  37
  
    
run the portion of schemas/vegbien.sql from


  		












Also available in:  Unified diff