Metacat

  // The run method of xmlIndex thread. It writes XML Index for the document.

      //if this is a package file then write the package info to 

      //the xml_relation table. RelationHandler checks to see

      //if it is a package file so you don't have to do it here.

        //DocumentImpl xmldoc = new DocumentImpl(dbconn, docid);

      } 

      else if ( doctype.equals(util.getOption("accessdoctype")) ) 

      {

        DocumentImpl xmldoc = new DocumentImpl(dbconn, docid);

        String xml = xmldoc.toString();

        try {

          AccessControlList aclobj = 

          new AccessControlList(dbconn, docid, new StringReader(xml),

                                user, groups, serverCode);

          dbconn.commit();

        } catch (SAXException e) {

          try {

            dbconn.rollback();

            dbconn.close();

          } catch (SQLException sqle) {}

          System.out.println("Error writing ACL in DBSaxHandler.run " + 

                             e.getMessage()); 

      System.out.println("Error writing XML Index in DBSaxHandler.run " + 

                         e.getMessage()); 

  public void putRelations() {

    // deletes all of the relations with a docid of @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 {

      DocumentImpl xmldoc = new DocumentImpl(conn,docid,false);

      //DocumentImpl xmldoc = new DocumentImpl(conn);

      //xmldoc.getDocumentInfo(docid);

      String packagetype = xmldoc.getDoctype();

      // first delete the relations for this package document if any

      deleteRelations(docid);

      // put the new relations

      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);

        String relationship = rs.getString(2);

        String object = rs.getString(3);

        String subjectDoctype = null;

        String paramDocid = null;

        URL subjectMurl = null;

        //get the current relations information

        String subDocid = null;

        String objDocid = null;

        String subDoctype = null;

        String objDoctype = null;

        try {

          URL subMurl = new URL(subject);

          if(subMurl.getQuery() != null) {

            Hashtable subMurlParams = util.parseQuery(subMurl.getQuery());

            subDocid = (String)subMurlParams.get("docid");

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

              DocumentImpl subDoc = new DocumentImpl(conn, subDocid);

              subDoctype = subDoc.getDoctype();

            }

          } else {

            subDocid = subject;

          }

        } catch(MalformedURLException murle) { 

          //assume this is just a docid not a url

          subDocid = subject;

        }

        try {

          URL objMurl = new URL(object); 

          if(objMurl.getQuery() != null) {

            Hashtable objMurlParams = util.parseQuery(objMurl.getQuery());

            objDocid = (String)objMurlParams.get("docid");

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

              DocumentImpl objDoc = new DocumentImpl(conn, objDocid);

              objDoctype = objDoc.getDoctype();

            }

          } else {

            objDocid = object;

          }

        } catch(MalformedURLException murle) {

          //assume this is just a docid

          objDocid = object;

        }

        //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, packagetype, ");

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

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

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

        insertStmt.append(packagetype).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();

      }

      pstmt.close();

      conn.commit();

    } catch(Exception e) { 

      MetaCatUtil.debugMessage("Error in RelationHandler.run(): " + 

                               e.getMessage());

      System.out.println("Error in RelationHandler.run(): " + 

                               e.getMessage());

      try { 

        conn.rollback();

      } catch (SQLException sqle) {

        System.out.println("Error in RelationHandler.run(): " + 

                           sqle.getMessage());

      }

   * @param docid the docid to delete.

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

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

//import edu.ucsb.nceas.dbadapter.AbstractDatabase;

  public AccessControlList(Connection conn, String aclid, Reader acl,

                  throws SAXException, IOException, ClassNotFoundException,

                         Exception

    DocumentImpl aclinfo = new DocumentImpl(conn,aclid,false);

    this.rev = aclinfo.getRev();

    // Initialize the parser and read the queryspec

    parser.parse(new InputSource(acl));

  /**

   * Construct an instance of the AccessControlList class.

   * It parses eml-access file and loads acl data into db connection.

   * It is used from command line execution.

   *

   * @param conn the JDBC connection where acl data are loaded

   * @param docid the Accession# of the document with the acl data

   * @param aclfilename the name of acl file containing acl data

   * @param user the user connected to MetaCat servlet and owns the document

   * @param groups the groups to which user belongs

   */

  public AccessControlList( Connection conn, String aclid, String aclfilename,

                           String user, String[] groups )

                  throws SAXException, IOException, ClassNotFoundException,

                         Exception

  {

    this(conn, aclid, new FileReader(new File(aclfilename).toString()), 

         user, groups, 1);

  }

      this.aclObjects = getACLObjects(aclid + sep + rev);

        //delete all permissions for resources related to @aclid if any

      //  //then delete all relations with docid of @aclid if any

      //  deleteRelations(aclid);