Project

General

Profile

« Previous | Next » 

Revision 6744

Added by ben leinfelder over 12 years ago

refactor Metacat access handling to be on a per-revision basis so that it more closely aligns with the DataONE approach
http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5560

View differences:

SpatialHarvester.java
71 71 
  }
72 72 

  		




  73
  73
  
    
  /**


  		




  74
  
  
    
   * Returns a Vector of all the docids in the xml_path_index tables


  		




  
  74
  
    
   * Returns a Vector of all the current versions of public docids


  		




  75
  75
  
    
   */


  		




  76
  76
  
    
  protected Vector<String> queryAllDocids() {


  		




  77
  77
  
    
    Vector<String> _docs = new Vector<String>();


  		




  ......




  83
  83
  
    
     * to be considered for the spatial cache


  		




  84
  84
  
    
     */


  		




  85
  85
  
    
    //String query = "select distinct docid from xml_path_index";


  		




  86
  
  
    
    String query = "select distinct docid from xml_access where principal_name = 'public' and perm_type = 'allow'";


  		




  
  86
  
    
    String query = "select distinct id.docid " +


  		




  
  87
  
    
    		"from xml_access xa, identifier id, xml_documents xd " +


  		




  
  88
  
    
    		"where xa.guid = id.guid " +


  		




  
  89
  
    
    		"and id.docid = xd.docid " +


  		




  
  90
  
    
    		"and id.rev = xd.rev " +


  		




  
  91
  
    
    		"and xa.principal_name = 'public' " +


  		




  
  92
  
    
    		"and xa.perm_type = 'allow'";


  		




  87
  93
  
    

  		




  88
  94
  
    
    try {


  		




  89
  95
  
    
      pstmt = dbconn.prepareStatement(query);


  		












Also available in:  Unified diff