Metacat

 /** creates SQL code and inserts new document into DB connection */

  private void writeDocumentToDB(String action, String user) 

               throws SQLException, Exception {

    try {

      PreparedStatement pstmt = null;

      if (action.equals("INSERT")) {

        //AccessionNumber ac = new AccessionNumber();

        //this.docid = ac.generate(docid, "INSERT");

        pstmt = conn.prepareStatement(

            "INSERT INTO xml_documents " +

            "(docid, rootnodeid, docname, doctype, " +

            "user_owner, user_updated, date_created, date_updated) " +

            "VALUES (?, ?, ?, ?, ?, ?, sysdate, sysdate)");

        // Bind the values to the query

        pstmt.setString(1, this.docid);

        pstmt.setLong(2, rootnodeid);

        pstmt.setString(3, docname);

        pstmt.setString(4, doctype);

        pstmt.setString(5, user);

        pstmt.setString(6, user);

      } else if (action.equals("UPDATE")) {

        // Save the old document entry in a backup table

        DocumentImpl.archiveDocRevision( conn, docid, user );

        // Delete index for the old version of docid

        // The new index is inserting on the next calls to DBSAXNode

        pstmt = conn.prepareStatement(

                "DELETE FROM xml_index WHERE docid='" + this.docid + "'");

        pstmt.execute();

        pstmt.close();

        // Update the new document to reflect the new node tree

        pstmt = conn.prepareStatement(

            "UPDATE xml_documents " +

            "SET rootnodeid = ?, docname = ?, doctype = ?, " +

            "user_updated = ?, date_updated = sysdate WHERE docid LIKE ?");

        // Bind the values to the query

        pstmt.setLong(1, rootnodeid);

        pstmt.setString(2, docname);

        pstmt.setString(3, doctype);

        pstmt.setString(4, user);

        pstmt.setString(5, this.docid);

      } else {

        System.err.println("Action not supported: " + action);

      }

      // Do the insertion

      pstmt.execute();

      pstmt.close();

    } catch (SQLException sqle) {

      throw sqle;

//    } catch (AccessionNumberException ane) {

//      MetaCatUtil.debugMessage("Invalid accession number.");

//      MetaCatUtil.debugMessage(ane.getMessage());

//      throw ane;

    } catch (Exception e) {

      throw e;

    }

  }

   * Get the document title

   */

  public String getTitle() {

    return doctitle;

  }

  /**

   * Set the document title

   *

   * @param title the new title for the document

   */

  public void setTitle( String title ) {

    this.doctitle = title;

    try {

      PreparedStatement pstmt;

      pstmt = conn.prepareStatement(

            "UPDATE xml_documents " +

            " SET doctitle = ? " +

            "WHERE docid = ?");

      // Bind the values to the query

      pstmt.setString(1, doctitle);

      pstmt.setString(2, docid);

      // Do the insertion

      pstmt.execute();

      pstmt.close();

    } catch (SQLException e) {

      System.out.println(e.getMessage());

    }

  }

  /**

   * Look up the title of the first child element named "title"

   * and record it as the document title

   */

/*   NOT NEEDED ANY MORE

  public void setTitleFromChildElement() {

    String title = null;

    long assigned_id=0;

    PreparedStatement pstmt;

    try {

      pstmt = conn.prepareStatement(

              "SELECT nodedata FROM xml_nodes " +

              "WHERE nodetype = 'TEXT' " +

              "AND rootnodeid = ? " +

              "AND parentnodeid IN " +

              "  (SELECT nodeid FROM xml_nodes " +

              "  WHERE nodename = 'title' " +

              "  AND nodetype =  'ELEMENT' " +

              "  AND rootnodeid = ? ) " +

              "ORDER BY nodeid");

*/

      // The above query might be slow, and probably will be because

      // it gets ALL of the title elements while searching for one

      // title in a small subtree but it avoids the problem of using

      // Oracle's Hierarchical Query syntax which is not portable --

      // the commented out SQL that follows shows an equivalent query

      // using Oracle-specific hierarchical query

      /*

      pstmt = conn.prepareStatement(

              "SELECT nodedata FROM xml_nodes " +

              "WHERE nodetype = 'TEXT' " +

              "AND parentnodeid IN " +

              "(SELECT nodeid FROM xml_nodes " +

              "WHERE nodename = 'title' " +

              "START WITH nodeid = ? " +

              "CONNECT BY PRIOR nodeid = parentnodeid)");

      */

/*

      // Bind the values to the query

      pstmt.setLong(1, rootnodeid);

      pstmt.setLong(2, rootnodeid);

      pstmt.execute();

      ResultSet rs = pstmt.getResultSet();

      boolean tableHasRows = rs.next();

      if (tableHasRows) {

        title = rs.getString(1);

      }

      pstmt.close();

    } catch (SQLException e) {

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

    }

    // assign the new title

    this.setTitle(title);

  }

*/

  /**

    AccessionNumber ac = new AccessionNumber(conn);

    AccessionNumber ac = new AccessionNumber(conn);

  /** Save a document entry in the xml_revisions table */

  private static void archiveDocRevision(Connection conn, String docid,

                                         String user) throws SQLException {

    // create a record in xml_revisions table 

    // for that document as selected from xml_documents

    PreparedStatement pstmt = conn.prepareStatement(

      "INSERT INTO xml_revisions " +

        "(revisionid, docid, rootnodeid, docname, doctype, doctitle, " +

        "user_owner, user_updated, date_created, date_updated) " +

      "SELECT null, ?, rootnodeid, docname, doctype, doctitle," + 

        "user_owner, ?, sysdate, sysdate "+

      "FROM xml_documents " +

      "WHERE docid = ?");

    // Bind the values to the query and execute it

    pstmt.setString(1, docid);

    pstmt.setString(2, user);

    pstmt.setString(3, docid);

    pstmt.execute();

    pstmt.close();

  }