Metacat

  private MetaCatUtil util = new MetaCatUtil();

  public Hashtable findDocuments(Reader xmlquery, String user, String group)

  {

    return findDocuments(xmlquery, user, group, null);

  }

   * @param user the username of the user

   * @param group the group of the user

   * @param returndoc an array of document types to backtrack against.

  public Hashtable findDocuments(Reader xmlquery, String user, String group,

                                 String[] returndoc)

      Vector returndocVec = new Vector();

      if(returndoc != null)

      {//add the returndoc elements to a vector for easier manipulation

        for(int i=0; i<returndoc.length; i++)

        {

          returndocVec.add(new String((String)returndoc[i]));

        }

      }

          if(returndocVec.size() != 0 && !returndocVec.contains(doctype))

          { //there are returndocs to match (backtracking can now be performed). 

            //System.out.println("olddoctype: " + doctype);

            StringBuffer btBuf = new StringBuffer();

            btBuf.append("select object from xml_relation where ");

            btBuf.append("objdoctype in (");

            //build the doctype list for the backtracking sql statement

            for(int i=0; i<returndocVec.size(); i++)

            {

              btBuf.append("'").append((String)returndocVec.get(i)).append("'");

              if(i != (returndocVec.size() - 1))

              {

                btBuf.append(", ");

              }

            }

            btBuf.append(") ");

            btBuf.append("and subject like '");

            btBuf.append("metacat://docid#").append(docid).append("'");

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

            pstmt.execute();

            ResultSet btrs = pstmt.getResultSet();

            boolean hasBtRows = btrs.next();

            if(hasBtRows)

            { //there was a backtrackable document found

              DocumentImpl xmldoc = null;

              //System.out.println("document found is: " + btrs.getString(1));

              metacatURL objURL = new metacatURL(btrs.getString(1));

              try

              {

                xmldoc = new DocumentImpl(conn, objURL.getParam(0)[1]);

              }

              catch(Exception e)

              {

                System.out.println("Error getting document: " + e.getMessage());

              }

              docid   = xmldoc.getDocID();

              docname = xmldoc.getDocname();

              doctype = xmldoc.getDoctype();

              doctitle = xmldoc.getDocTitle();

              createDate = xmldoc.getCreateDate();

              updateDate = xmldoc.getUpdateDate();

              //System.out.println("docname: " + docname + " doctype: " + doctype + 

              //                   " doctitle: " + doctitle + " createdate: " +

              //                   createDate + " updatedate: " + updateDate);

            }

            btrs.close();

          }

          //System.out.println("packagdoctype: " + util.getOption("packagedoctype"));

          if(!doctype.equals(util.getOption("packagedoctype")))

          {

            document.append("<docid>").append(docid).append("</docid>");

            if (docname != null) {

              document.append("<docname>" + docname + "</docname>");

            }

            if (doctype != null) {

              document.append("<doctype>" + doctype + "</doctype>");

            }

            if (doctitle != null) {

              document.append("<doctitle>" + doctitle + "</doctitle>");

            }

            if(createDate != null) {

              document.append("<createdate>" + createDate + "</createdate>");

            }

            if(updateDate != null) {

              document.append("<updatedate>" + updateDate + "</updatedate>");

            }

            // Store the document id and the root node id

            docListResult.put(docid,(String)document.toString());

          Enumeration keylist = docListResult.keys();

          StringBuffer doclist = new StringBuffer();

          while(keylist.hasMoreElements())

          {

            doclist.append("'");

            doclist.append((String)keylist.nextElement());

            doclist.append("',");

          }

          doclist.deleteCharAt(doclist.length()-1); //remove the last comma

          pstmt = conn.prepareStatement(qspec.printExtendedSQL(

                                        doclist.toString()));

        //this loop adds the relation data to the resultdoc

        //this code might be able to be added to the backtracking code above

        Enumeration docidkeys = docListResult.keys();

        while(docidkeys.hasMoreElements())

          String docidkey = (String)docidkeys.nextElement();

          pstmt = conn.prepareStatement(

                  qspec.printRelationSQL("metacat://docid#" + docidkey));

          pstmt.execute();

          rs = pstmt.getResultSet();

          tableHasRows = rs.next();

          while(tableHasRows)

          {

            String sub = rs.getString(1);

            String rel = rs.getString(2);

            String obj = rs.getString(3);

            metacatURL murl = new metacatURL(sub);

            if(murl.getURLType().equals("metacat"))

            {//we only want to process metacat urls here.

              String[] tempparam = murl.getParam(0);

              if(tempparam[0].equals("docid") && tempparam[1].equals(docidkey))

                document = new StringBuffer();

                document.append("<relation>");

                document.append("<relationtype>").append(rel);

                document.append("</relationtype>");

                document.append("<relationdoc>").append(obj);

                document.append("</relationdoc>");

                document.append("</relation>");

                String removedelement = (String)docListResult.remove(docidkey);

                docListResult.put(docidkey, removedelement + document.toString());

            tableHasRows = rs.next();

 * 'Revision 1.20  2000/09/15 19:52:11  berkley

 * 'Added functionality for package specifications.  metacatservlet now contains a new action called getrelateddocument that handles retrieving related documents using the metacatURL specification (metacatURL.java).  DBQuery contains new code in runQuery that embeds relation tags in the returned hashtable describing the documents related to each docid.  querySpecification contains a new method which prints the sql that does the relation query.

 * '