Metacat

<?xml version="1.0"?>

<pathquery version="1.2">

  <querytitle>Untitled-Search-1</querytitle>

  <returndoctype>-//ecoinformatics.org//eml-dataset-2.0.0beta4//EN</returndoctype>

  <returndoctype>-//ecoinformatics.org//eml-dataset-2.0.0beta6//EN</returndoctype>

  <returndoctype>-//NCEAS//eml-dataset-2.0//EN</returndoctype>

  <returnfield>dataset/title</returnfield>

  <returnfield>originator/individualName/surName</returnfield>

  <returnfield>keyword</returnfield>

  <querygroup operator="INTERSECT">

    <querygroup operator="UNION">

      <querygroup operator="UNION">

        TestSuite suite = new TestSuite();

        suite.addTest(new QuerySpecificationTest("testPrintSQL"));

        suite.addTest(new QuerySpecificationTest("testPrintExtendedSQL"));

        return suite;

    }

    public void testPrintSQL()

    {

        try {

            QuerySpecification qspec = new QuerySpecification(xml, 

                    MetaCatUtil.getOption("saxparser"), 

                    MetaCatUtil.getOption("accNumberSeparator"));

    public void testPrintExtendedSQL()

    {

        try {

            Hashtable controlPairs = new Hashtable();

            QuerySpecification qspec = new QuerySpecification(xml, 

                    MetaCatUtil.getOption("saxparser"), 

                    MetaCatUtil.getOption("accNumberSeparator"));

            System.out.println(

                            controlPairs, false));

        } catch (IOException e) {

            fail(e.getMessage());

        }

    }

}

datafilesizelimit=1000

defaultcontenttype=@defaultcontenttype@

query.ignored.params=enableediting,foo

            countAttributeReturnField++;

            hasAttributeReturnField = true;

            containsExtendedSQL = true;

        }

    }

            self.append(")");

        }

    }

    /**

     * 

     */

    public String printAttributeQuery(String doclist)

    {

        StringBuffer self = new StringBuffer();

        }

        self.append(") AND xml_nodes.docid in (");

        self.append(doclist);

        MetaCatUtil.debugMessage("Attribute query: " + self.toString(), 30);

        return self.toString();

package edu.ucsb.nceas.metacat;

import java.util.StringTokenizer;

import java.util.Vector;

import javax.servlet.ServletOutputStream;

/**

 * A Class that searches a relational DB for elements and

 * attributes that have free text matches a query string,

          double connTime = System.currentTimeMillis();

          // Execute the query

          FileReader xml = new FileReader(new File(xmlfile));

          Hashtable nodelist = null;

          nodelist = queryobj.findDocuments(xml, null, null, useXMLIndex);

        // Get the XML query and covert it into a SQL statment

        QuerySpecification qspec = new QuerySpecification(xmlquery,

                                   parserName,

        result = findDocuments(qspec, user, groups, useXMLIndex);

      }

      catch (IOException ioe)

              && !qspec.isPercentageSearch())

          {

            MetaCatUtil.debugMessage("Back tracing now...", 20);

            StringBuffer btBuf = new StringBuffer();

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

            { //there was a backtrackable document found

              DocumentImpl xmldoc = null;

              String packageDocid = btrs.getString(1);

              try

              {

                //  THIS CONSTRUCTOR BUILDS THE WHOLE XML doc not needed here

                //  xmldoc = new DocumentImpl(dbconn);

                xmldoc = new DocumentImpl(packageDocid, false);

                if (xmldoc == null) {

                }

              }

              catch(Exception e)

              String docid_org = xmldoc.getDocID();

              if (docid_org == null) {

              }

              docid   = docid_org.trim();

              docname = xmldoc.getDocname();

              document = new StringBuffer();

              completeDocid += rev;

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

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

            document = new StringBuffer();

            completeDocid += rev;

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

            if (docname != null) {

            MetaCatUtil.debugMessage("Time for execute access extended query: "

                              +(extendedAccessQueryEnd-extendedQueryStart), 30);

            MetaCatUtil.debugMessage("Extended query: "+ extendedQuery, 30);

            pstmt = dbconn.prepareStatement(extendedQuery);

            //increase dbconnection usage count

            // get attribures return

          }//if doclist lenght is great than zero

        }//if has extended query

          //String connstring = "metacat://"+util.getOption("server")+"?docid=";

          String connstring = "%docid=";

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

          pstmt.execute();

          rs = pstmt.getResultSet();

          tableHasRows = rs.next();

   * A method to return search result after running a query which return

   * field have attribue

   */

  {

    StringBuffer XML = null;

    String sql = null;

    // if has attribute as return field

    if (squery.containAttributeReturnField())

    {

      try

      {

        dbconn=DBConnectionPool.getDBConnection("DBQuery.getAttributeValue");

    }//try

    catch (SQLException e)

    {

                            +e.getMessage(), 30);

    }

    finally

        }

        String docidPlusVersion=((String)docIdList.elementAt(i))

        //create new documentImpl object

    byte[] byteString = null;

    ZipEntry zEntry = null;

    // this is data file; add file to zip

    if (!filePath.endsWith("/"))

    {

      filePath += "/";

    }//try

    catch (IOException ioe)

    {

    }//catch

  }//addDataFileToZipOutputStream()

      docImpls=new DocumentImpl(docId);

      //checking if the user has the permission to read the documents

      {

        zOut = new ZipOutputStream(out);

        //if the docImpls is metadata

        version=currentVersion;

        //get package zip entry name

        //it should be docId.revsion.package

        //get the whole id list for data packadge

        docIdList=getCurrentDocidListForDataPackage(packageId);

        //get the whole documentImple object

      else  //for an old version

      {

        //get the whole id list for data packadge

        docIdList=getOldVersionDocidListForDataPackage(docIdString);

          //create a docmentImpls object (represent xml doc) base on the docId

          docImpls=(DocumentImpl)documentImplList.elementAt(i);

          //checking if the user has the permission to read the documents

          {

            //if the docImpls is metadata

            if ((docImpls.getDoctype()).compareTo("BIN")!=0)

      return xmlFieldValue;

    }

  }

}