Metacat

package edu.ucsb.nceas.metacat;

/**

 * Before Metacat 1.8.1 release, Metacat uses the eml201 schema with the tag

 * RELEASE_EML_2_0_1_UPDATE_5. Unfortunately, this tag points at wrong version

 * of eml-resource.xsd. In this schema, the element "references" has an attribute named

 * "system" and the attribute has a default value "document". Metacat will add 

 * the attribute system="document" to "references" element even the orginal eml didn't have it

 * (this is another bug and see bug 1601), so this causes metacat generated some invalid eml201

 * documents. This class provides a path to fix the existed invalid eml201 documents. It will

 * remove the attribute system="document" of the element "references" in xml_nodes and xml_index

 * tables. 

 * @author tao

 *

 */

public class EML201DocumentCorrector  implements Runnable

{

	/**

	 * Default constructor

	 *

	 */

     public EML201DocumentCorrector()

     {

     }

     /**

      *  It will remove the records - attribute system="document" of element "refrence"

      *  in both xml_nodes and xml_index table

      */

     public void run()

     {

     }

     /*

      * Generate the sql command to delete the records in xml_node table 

      */

     private String generateXML_NodeDeletingSQL()

     {

    	 String sql ="delete from xml_nodes where nodetype='ATTRIBUTE' and nodename='system' and nodevalue='document' "+

    	                     "and parentnodeid in (select nodeid from xml_nodes where  nodetype='ELEMENT' and nodename='references') and docid in "+

    	                     "(select docid from xml_documents where doctype ='eml://ecoinformatics.org/eml-2.0.1'";

    	 return sql;

     }

     /*

      * Generate the sql command to delete the records in xml_nidex table;

      */

     private String generateXML_IndexDeletingSQL()

     {

    	 String sql ="delete from xml_index where path ='references/@system' AND docid in "+ 

    	 "(select docid from xml_documents where doctype ='eml://ecoinformatics.org/eml-2.0.1'";

    	 return sql;

     }

}