/ - Diff - Metacat - Ecoinformatics Redmine

« Previous | Next »

Revision 1354

Added by Jing Tao almost 22 years ago

Support returnfields has attributes.

     import edu.ucsb.nceas.dbadapter.*;
     import java.io.*;
     import java.util.Hashtable;
     import java.util.Stack;
     import java.util.Vector;
     import java.util.Enumeration;
-...
       private String [] group = null;
       public static final String ATTRIBUTESYMBOL = "@";
       private boolean hasAttributeReturnField = false;
       private Hashtable attributeReturnList = new Hashtable();
       private int countAttributeReturnField = 0;
       /**
        * construct an instance of the QuerySpecification class
+       *
-...
+      }
       /**
        * A method to get if the query has an attribute return field
        */
       public boolean containAttributeReturnField()
+      {
         return hasAttributeReturnField;
+      }
       /**
        * Accessor method to return the identifier of this Query
        */
       public String getIdentifier()
-...
         } else if (currentTag.equals("filterdoctype")) {
           filterDocList.add(inputString);
         } else if (currentTag.equals("returnfield")) {
           returnFieldList.add(inputString);
           containsExtendedSQL = true;
           // make sure if return fields has an attribute or not
           if (inputString.indexOf(ATTRIBUTESYMBOL) ==-1)
+          {
             // no attribute value will be returned
             returnFieldList.add(inputString);
             containsExtendedSQL = true;
+          }
           else
+          {
             // has a attribute return field
             // divied the return filed into two parts, one is path and the
             // other is attribue name
             String returnPath = newPathExpressionWithOutAttribute(inputString);
             String attributeName = getAttributeName(inputString);
             Vector pathInfo = new Vector();
             // the vector has the information about return path and attributename
             pathInfo.addElement(returnPath);
             pathInfo.addElement(attributeName);
             // put the vector into a hash table. The reseaon why don't put
             // return path or attributename as a key is because they are not unique
             attributeReturnList.put
                                 (new Integer(countAttributeReturnField), pathInfo);
             countAttributeReturnField++;
             hasAttributeReturnField = true;
             containsExtendedSQL = true;
+          }
         } else if (currentTag.equals("filterdoctype")) {
           filterDocList.add(inputString);
         } else if (currentTag.equals("owner")) {
-...
         return self.toString();
+      }
       /**
        * This method prints sql based upon the returnfield tag in the
        * pathquery document has an attribute.  This allows for customization of the
        * returned fields
        * @param doclist the list of document ids to search by
        */
       public String printAttributeQuery(String doclist)
+      {
         StringBuffer self = new StringBuffer();
         self.append("select xml_nodes.docid, xml_index.path, ");
         self.append("xml_nodes.nodedata, xml_nodes.nodename ");
         self.append("from xml_index, xml_nodes where xml_index.nodeid=");
         self.append("xml_nodes.parentnodeid and (");
         boolean firstfield = true;
         //put the returnfields attributes into the query
         //the for loop allows for multiple fields and attributes
         Enumeration returnAttributes = attributeReturnList.elements();
         while (returnAttributes.hasMoreElements())
+        {
           Vector currentVector = (Vector)returnAttributes.nextElement();
           String returnPath = (String)currentVector.elementAt(0);
           String attributeName = (String)currentVector.elementAt(1);
           if(firstfield)
+          {
             firstfield = false;
             self.append("( xml_index.path like '");
             self.append(returnPath);
             self.append("' AND xml_nodes.nodename like '");
             self.append(attributeName);
             self.append("') ");
+          }
           else
+          {
             self.append(" or ( xml_index.path like '");
             self.append(returnPath);
             self.append("' AND xml_nodes.nodename like '");
             self.append(attributeName);
             self.append("') ");
+          }
+        }
         self.append(") AND xml_nodes.docid in (");
         //self.append(query.printSQL());
         self.append(doclist);
         self.append(")");
         self.append(" AND xml_nodes.nodetype = 'ATTRIBUTE'");
         MetaCatUtil.debugMessage("Attribute query: "+self.toString(), 30);
         return self.toString();
+      }
       public static String printRelationSQL(String docid)
+      {
         StringBuffer self = new StringBuffer();
-...
     //    return "meta_file_id=" + meta_file_id + "\n" +
     //           "querytitle=" + querytitle + "\n" + query;
+      }
       /* A method to get rid of attribute part in path expression*/
       public static String newPathExpressionWithOutAttribute(String pathExpression)
+      {
           if (pathExpression == null)
+          {
             return null;
+          }
           int index = pathExpression.lastIndexOf(ATTRIBUTESYMBOL);
           String newExpression = null;
           if (index != 1)
+          {
             newExpression=pathExpression.substring(0, index-1);
+          }
           MetaCatUtil.debugMessage("The path expression without attributes: )" +
                                    newExpression, 30);
           return newExpression;
+      }
       /* A method to get attribute name from path */
       public static String getAttributeName(String path)
+      {
           if (path == null)
+          {
             return null;
+          }
           int index = path.lastIndexOf(ATTRIBUTESYMBOL);
           int size = path.length();
           String attributeName = null;
            if (index != 1)
+          {
             attributeName = path.substring(index+1, size);
+          }
           MetaCatUtil.debugMessage("The attirbute name from path: )" +
                                    attributeName, 30);
           return attributeName;
+      }
       /** a utility class that represents a group of terms in a query */
       private class QueryGroup {
-...
+          }
+        }
         /* A method to get rid of attribute part in path expression*/
         private String newPathExpressionWithOutAttribute(String pathExpression)
+        {
           if (pathExpression == null)
+          {
             return null;
+          }
           int index = pathExpression.lastIndexOf(ATTRIBUTESYMBOL);
           String newExpression = null;
           if (index != 1)
+          {
             newExpression=pathExpression.substring(0, index-1);
+          }
           MetaCatUtil.debugMessage("The path expression without attributes: )" +
                                    newExpression, 30);
           return newExpression;
+        }
         /* A method to get attribute name from path */
         private String getAttributeName(String path)
+        {
           if (path == null)
+          {
             return null;
+          }
           int index = path.lastIndexOf(ATTRIBUTESYMBOL);
           int size = path.length();
           String attributeName = null;
            if (index != 1)
+          {
             attributeName = path.substring(index+1, size);
+          }
           MetaCatUtil.debugMessage("The attirbute name from path: )" +
                                    attributeName, 30);
           return attributeName;
+        }
         /*
          * Constraint the query with @pathexp without using the XML Index,
          * but nested SQL statements instead. The query migth be slower.

Also available in: Unified diff

Project

General

Profile

Metacat

Revision 1354

Added by Jing Tao almost 22 years ago