Project

General

Profile

« Previous | Next » 

Revision 5999

Added by Aaron Marcuse-Kubitza over 11 years ago

mappings/verify.plots.sql: Added "top-level" to # locations, # location events names because these queries do not include all locations

View differences:

inputs/SALVIAS/verify/plots.ref.sql
14 14 
ORDER BY projectname
15 15 
;
16 16 

  		




  17
  
  
    
SELECT '# locations' AS ___;


  		




  
  17
  
    
SELECT '# top-level locations' AS ___;


  		




  18
  18
  
    
SELECT count(*) AS count FROM "plotMetadata";


  		




  19
  19
  
    
;


  		




  20
  20
  
    

  		




  21
  
  
    
SELECT '# location events' AS ___;


  		




  
  21
  
    
SELECT '# top-level location events' AS ___;


  		




  22
  22
  
    
SELECT count(*) AS count FROM "plotMetadata";


  		




  23
  23
  
    

  		




  24
  24
  
    
SELECT '1st methods' AS ___;


  		












  

    
      mappings/verify.plots.sql
    
  





  23
  23
  
    
ORDER BY projectname


  		




  24
  24
  
    
;


  		




  25
  25
  
    

  		




  26
  
  
    
SELECT '# locations' AS ___;


  		




  
  26
  
    
SELECT '# top-level locations' AS ___;


  		




  27
  27
  
    
SELECT count(DISTINCT location_id) AS count


  		




  28
  28
  
    
FROM location


  		




  29
  29
  
    
WHERE reference_id =


  		




  ......




  31
  31
  
    
AND parent_id IS NULL -- no subplots


  		




  32
  32
  
    
;


  		




  33
  33
  
    

  		




  34
  
  
    
SELECT '# location events' AS ___;


  		




  
  34
  
    
SELECT '# top-level location events' AS ___;


  		




  35
  35
  
    
SELECT count(*) AS count


  		




  36
  36
  
    
FROM locationevent


  		




  37
  37
  
    
WHERE reference_id =


  		












Also available in:  Unified diff