Project

General

Profile

« Previous | Next » 

Revision 4511

Added by daigle over 15 years ago

Change the db query to only pull public allowed documents when creating the sitemap file.

View differences:

src/edu/ucsb/nceas/metacat/Sitemap.java
100 100 
            // Query xml_documents to get list of documents
101 101 
            StringBuffer query = new StringBuffer();
102 102 
            // TODO: make the doctype configurable in the query
103 
            query.append("select docid, rev from xml_documents "
104 
                    + "where doctype LIKE 'eml:%' " + "order by docid, rev");
103 
            String sql =
104 
            	"SELECT xml_documents.docid, xml_documents.rev " +
105 
            	"FROM xml_documents, xml_access " +
106 
                "WHERE xml_documents.doctype LIKE 'eml:%' " +
107 
                "AND xml_documents.docid = xml_access.docid " +
108 
                "AND xml_access.principal_name = 'public' " +
109 
                "AND xml_access.perm_type = 'allow' " +
110 
                "order by docid, rev";
111 
            query.append(sql);
105 112 

  		




  106
  113
  
    
            DBConnection dbConn = null;


  		




  107
  114
  
    
            int serialNumber = -1;


  		












Also available in:  Unified diff