/ - Diff - Metacat - Ecoinformatics Redmine

« Previous | Next »

Revision 176

Added by Matt Jones over 24 years ago

added code to build an index of the paths through the DOM tree to each node in the tree as the node is being inserted

src/xmltables.sql
21	21	DROP SEQUENCE xml_nodes_id_seq;
22	22	DROP SEQUENCE xml_catalog_id_seq;
23	23
24		DROP TRIGGER xml_nodes_before_insert;
25	24	DROP TRIGGER xml_catalog_before_insert;
26	25
27	26	DROP TABLE xml_index;

          public_id, system_id)
          VALUES ('XSL', '-//NCEAS//eml-dataset//EN', '-//W3C//HTML//EN',
          '-//NCEAS//eml-dataset-display.xsl',
          'file:///home/httpd/html/xmltodb/xsqltest/eml-dataset-display.xsl');
          'http://24.237.19.164/xmltodb/xsqltest/eml-dataset-display.xsl');
     INSERT INTO xml_catalog (entry_type, source_doctype, target_doctype,
          public_id, system_id)
          VALUES ('XSL', '-//NCEAS//eml-variable//EN', '-//W3C//HTML//EN',
          '-//NCEAS//eml-variable-display.xsl',
          'file:///home/httpd/html/xmltodb/xsqltest/eml-variable-display.xsl');
          'http://24.237.19.164/xmltodb/xsqltest/eml-variable-display.xsl');
     INSERT INTO xml_catalog (entry_type, source_doctype, target_doctype,
          public_id, system_id)
          VALUES ('XSL', '-//NCEAS//eml-file//EN', '-//W3C//HTML//EN',
          '-//NCEAS//eml-file-display.xsl',
          'file:///home/httpd/html/xmltodb/xsqltest/eml-file-display.xsl');
          'http://24.237.19.164/xmltodb/xsqltest/eml-file-display.xsl');

      */
     public class DBSAXNode extends BasicNode {
       private Connection		conn;
       private Connection	conn;
       private DBSAXNode	parentNode;
       /**
        * Construct a new node instance for DOCUMENT nodes
-...
       public DBSAXNode (Connection conn, String tagname) {
         super(tagname);
         this.conn = conn;
         this.parentNode = null;
         writeChildNodeToDB("DOCUMENT", tagname, null);
         //setNodeID(getAssignedNodeID());
         setRootNodeID(getNodeID());
+      }
-...
        * @param tagname the name of the node
        * @param parentNode the parent node for this node being created
        */
       public DBSAXNode (Connection conn, String tagname,
                         DBSAXNode parentNode, DBSAXNode rootNode, DBSAXDocument currentDocument) {
       public DBSAXNode (Connection conn, String tagname, DBSAXNode parentNode,
                         DBSAXNode rootNode, DBSAXDocument currentDocument) {
         super(tagname);
         setParentID(parentNode.getNodeID());
-...
         setDocID(currentDocument.getDocID());
         setNodeIndex(parentNode.incChildNum());
         this.conn = conn;
         this.parentNode = parentNode;
         writeChildNodeToDB("ELEMENT", getTagName(), null);
         //setNodeID(getAssignedNodeID());
         updateNodeIndex();
+      }
       /** creates SQL code and inserts new node into DB connection */
-...
+          }
           // Bind the values to the query
           long nid = genNodeID();
           long nid = generateNodeID();
           pstmt.setLong(1, nid);
           pstmt.setString(2, nodetype);
           pstmt.setString(3, nodename);
-...
           pstmt.execute();
           pstmt.close();
           if (nodetype == "DOCUMENT" || nodetype == "ELEMENT")
             setNodeID(nid);
           // Record the node id that was generated fromthe database
           setNodeID(nid);
           // Record the node type that was passed in via the constructor
           setNodeType(nodetype);
         } catch (SQLException e) {
           System.err.println("Error inserting node: (" + nodetype + ", " +
                                                          nodename + ", " +
-...
+          }
+      }
       /**
        * creates SQL code to put doc ID for the document node and for comment/PI nodes under document node
        * into DB connection
        * creates SQL code to put doc ID for the document node and for
        * comment/PI nodes under document node into DB connection
        */
       public void writeDocID(String doc_id) {
           try {
-...
+      }
       /** get next node id from DB connection */
       private long genNodeID() {
       private long generateNodeID() {
           long nid=0;
           Statement stmt;
           try {
-...
           System.err.println("Attribute name must not be null!");
+        }
+      }
       /**
        * Update the node index (xml_index) for this node by generating
        * test strings that represent all of the relative and absolute
        * paths through the XML tree from document root to this node
        */
       private void updateNodeIndex() {
         Hashtable pathlist = new Hashtable();
         boolean atStartingNode = true;
         boolean atRootDocumentNode = false;
         DBSAXNode nodePointer = this;
         StringBuffer currentPath = new StringBuffer();
         // Create a Hashtable of all of the paths to reach this node
         // including absolute paths and relative paths
         while (!atRootDocumentNode) {
           if (atStartingNode) {
             currentPath.insert(0, nodePointer.getTagName());
             pathlist.put(currentPath.toString(), new Long(getNodeID()));
             atStartingNode = false;
           } else {
             currentPath.insert(0, "/");
             currentPath.insert(0, nodePointer.getTagName());
             pathlist.put(currentPath.toString(), new Long(getNodeID()));
+          }
           // advance to the next parent node
           nodePointer = nodePointer.getParentNode();
           // If we're at the DOCUMENT node (root of DOM tree), add
           // the root "/" to make the absolute path
           if (nodePointer.getNodeType().equals("DOCUMENT")) {
             currentPath.insert(0, "/");
             pathlist.put(currentPath.toString(), new Long(getNodeID()));
             atRootDocumentNode = true;
+          }
+        }
         try {
           // Create an insert statement to reuse for all of the path insertions
           PreparedStatement pstmt = conn.prepareStatement(
                   "INSERT INTO xml_index (nodeid, path) VALUES (?, ?)");
           // Step through the hashtable and insert each of the path values
           Enumeration en = pathlist.keys();
           while (en.hasMoreElements()) {
             String path = (String)en.nextElement();
             Long nodeid = (Long)pathlist.get(path);
             pstmt.setLong(1, nodeid.longValue());
             pstmt.setString(2, path);
             pstmt.execute();
             //System.out.println(nodeid + " ==> " + path);
+          }
           // Close the database statement
           pstmt.close();
         } catch (SQLException sqe) {
           System.err.println("SQL Exception while inserting path to index.");
           System.err.println(sqe.getMessage());
+        }
+      }
       /** get the parent of this node */
       public DBSAXNode getParentNode() {
         return parentNode;
+      }
+    }

Also available in: Unified diff

Project

General

Profile

Metacat

Revision 176

Added by Matt Jones over 24 years ago