Metacat

/**

 *  '$RCSfile$'

 *    Purpose: A class to asyncronously build the package relation index

 *             in the database table xml_relation.

 *  Copyright: 2000 Regents of the University of California and the

 *             National Center for Ecological Analysis and Synthesis

 *    Authors: Chad Berkley

 *    Release: @release@

 *

 *   '$Author: bojilova $'

 *     '$Date: 2001-01-08 17:11:26 -0800 (Mon, 08 Jan 2001) $'

 * '$Revision: 645 $'

 */

package edu.ucsb.nceas.metacat;

import java.sql.*;

import java.util.*;

import java.lang.Thread; 

public class RelationHandler implements Runnable

{

  private Thread btThread = null;

  private Connection conn = null;

  private DocumentImpl xmldoc = null;

  MetaCatUtil util = new MetaCatUtil();

  /** 

   * Constructor for this class.  finds all of the relations to a single xml

   * document and writes them to the database.  This includes transitive

   * relations.

   * @param xmldoc the xml document to index.

   */

  public RelationHandler(DocumentImpl xmldoc, Connection conn)

  {

    //this.conn = conn;

    try

    {

      this.conn = util.openDBConnection();

    }

    catch(Exception e)

    {

      System.out.println("error opening connection in relationHandler");

    }

    this.xmldoc = xmldoc;

    if(xmldoc.getDoctype().equals(util.getOption("packagedoctype")))

    { //make sure this doctype is a package document then run the thread

      btThread = new Thread(this);

      btThread.setPriority(Thread.MIN_PRIORITY);

      btThread.start();

    }

  }

  /**

   * The thread handler

   */

  public void run()

  {

    String docid = xmldoc.getDocID();

    // deletes all of the relations with a docid of @docid.

    deleteRelations(docid);

    //pseudo-code algorithm

    //for each new relation r in xml_nodes

    //  put r into xml_relation

    //  compare r to each relation already in xml_relation

    //  if r isrelatedto a row in xml_relation

    //    add a new row to xml_relation that represents this new relation

    try

    {

      PreparedStatement pstmt = conn.prepareStatement(

                                QuerySpecification.printPackageSQL(docid));

      pstmt.execute();

      //get the new relations out of xml_nodes

      ResultSet rs = pstmt.getResultSet();

      boolean hasmorerows = rs.next();

      while(hasmorerows)

      {

        String subject = rs.getString(1);

        MetacatURL subjectMurl = new MetacatURL(subject);

        String subjectDoctype = null;

        if(subjectMurl.getProtocol().equals("metacat"))

        {

          DocumentImpl subDoc = new DocumentImpl(conn, 

                                                 subjectMurl.getParam(0)[1]);

          subjectDoctype = subDoc.getDoctype();

        }

        String relationship = rs.getString(2);

        String object = rs.getString(3);

        //compare r to each relation in xml_relation

        pstmt = conn.prepareStatement("select subject, subdoctype, " +

                                      "relationship, object, objdoctype " +

                                      "from xml_relation");

        pstmt.execute();

        //get each relation in xml_relation for comparison

        ResultSet relations = pstmt.getResultSet();

        boolean hasmorerelations = relations.next();

        while(hasmorerelations)

        {

          String currentSub = relations.getString(1);

          String currentSubDoctype = relations.getString(2);

          String currentRelationship = relations.getString(3);

          String currentObj = relations.getString(4);

          String currentObjDoctype = relations.getString(5);

          if(object.equals(currentObj))

          {//there is a transitive relation so add a new relation to the table

            StringBuffer insertTransRelation = new StringBuffer();

            insertTransRelation.append("insert into xml_relation (docid, ");

            insertTransRelation.append(" subject, ");

            insertTransRelation.append("subdoctype, relationship, object, ");

            insertTransRelation.append("objdoctype) values ('");

            insertTransRelation.append(docid).append("', '");

            insertTransRelation.append(currentSub).append("', '");

            insertTransRelation.append(currentSubDoctype).append("', ");

            insertTransRelation.append("'hasTransitiveRelationTo', '");

            insertTransRelation.append(subject).append("', '");

            insertTransRelation.append(subjectDoctype).append("')");

            //System.out.println("sql1: " + insertTransRelation.toString());

            pstmt = conn.prepareStatement(insertTransRelation.toString());

            pstmt.execute(); 

            insertTransRelation = new StringBuffer();

            //put the same relation in with the subject and object switched

            insertTransRelation.append("insert into xml_relation (docid, ");

            insertTransRelation.append(" subject, ");

            insertTransRelation.append("subdoctype, relationship, object, ");

            insertTransRelation.append("objdoctype) values ('");

            insertTransRelation.append(docid).append("', '");

            insertTransRelation.append(subject).append("', '");

            insertTransRelation.append(subjectDoctype).append("', ");

            insertTransRelation.append("'hasTransitiveRelationTo', '");

            insertTransRelation.append(currentSub).append("', '");

            insertTransRelation.append(currentSubDoctype).append("')");

            //System.out.println("sql2: " + insertTransRelation.toString());

            pstmt = conn.prepareStatement(insertTransRelation.toString());

            pstmt.execute();

          }

          hasmorerelations = relations.next();

        }

        //get the current relations information

        MetacatURL subMurl = new MetacatURL(subject);

        MetacatURL objMurl = new MetacatURL(object);

        String subDoctype = null;

        String objDoctype = null;

        if(subMurl.getProtocol().equals("metacat"))

        {

          DocumentImpl subDoc = new DocumentImpl(conn, subMurl.getParam(0)[1]);

          subDoctype = subDoc.getDoctype();

        }

        if(objMurl.getProtocol().equals("metacat"))

        {

          DocumentImpl objDoc = new DocumentImpl(conn, objMurl.getParam(0)[1]);

          objDoc.getDoctype();

        }

        //now that the comparisons are done, the new relation can be put

        //into xml_relation

        StringBuffer insertStmt = new StringBuffer();

        insertStmt.append("insert into xml_relation (docid, subject, ");

        insertStmt.append("subdoctype, ");

        insertStmt.append("relationship, object, objdoctype) values ('");

        insertStmt.append(docid).append("', '");

        insertStmt.append(subject).append("', '");

        insertStmt.append(subDoctype).append("', '");

        insertStmt.append(relationship).append("', '");

        insertStmt.append(object).append("', '");

        insertStmt.append(objDoctype).append("')");

        pstmt = conn.prepareStatement(insertStmt.toString());

        pstmt.execute(); 

        hasmorerows = rs.next();

      }

      conn.commit();

      conn.close();

      btThread = null;

    } 

    catch(Exception e) 

    { 

      try 

      { 

        conn.rollback();

      } 

      catch (SQLException sqle) {}

      System.out.println("Error in relationHandler: " + e.getMessage());

      util.debugMessage("Error in relationHandler: " + e.getMessage());

      e.printStackTrace(System.out);

      btThread = null;

    }

  }

  /**

   * Deletes all of the relations with a docid of 'docid'.

   * @param docid the docid to delete.

   */

  public void deleteRelations(String docid)

  {

    try

    {

      PreparedStatement pstmt = conn.prepareStatement("delete from " +

                             "xml_relation where docid like '" + docid + "'");

      pstmt.execute();

      pstmt.close();

    }

    catch(Exception e)

    {

      try 

      { 

        conn.rollback();

      } 

      catch (SQLException sqle) {}

      System.out.println("error in deleteRelations(): " + e.getMessage());

      e.printStackTrace(System.out);

    }

  }

}