Metacat

 *  '$RCSfile$'

 *    Purpose: A Class that writes an XML document main data

 *  Copyright: 2000 Regents of the University of California and the

 *             National Center for Ecological Analysis and Synthesis

 *    Authors: Jivka Bojilova, Matt Jones

 *   '$Author$'

 *     '$Date$'

 * '$Revision$'

                          String doctype, String docid, String action)

                          throws AccessionNumberException {

      this.docid = docid;

      writeDocumentToDB(action);

    /** 

     * Construct a new document instance, used for deleting documents

     *

     * @param conn the JDBC Connection to which all information is written

     */

    public DBSAXDocument (Connection conn) {

      this.conn = conn;

    }

    private void writeDocumentToDB(String action) 

                          throws AccessionNumberException {

          PreparedStatement pstmt = null;

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

            this.docid = AccessionNumber.generate(docid, "INSERT");

            pstmt = conn.prepareStatement(

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

                "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);

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

            // Determine if the docid is OK for an UPDATE

            this.docid = AccessionNumber.generate(docid, "UPDATE");

            // Save the old document entry in a backup table

            saveDocument(docid);

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

            pstmt = conn.prepareStatement(

                "UPDATE xml_documents " +

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

                "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, this.docid);

          } else {

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

          }

        } catch (AccessionNumberException ane) {

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

          MetaCatUtil.debugMessage(ane.getMessage());

          throw ane;

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

  public void saveDocument(String docid) throws SQLException {

    // First get all of the values we need

    long rnodeid = -1;

    String docname = null;

    String doctype = null;

    String doctitle = null;

    Date date_created = null;

    PreparedStatement pstmt = conn.prepareStatement(

       "SELECT rootnodeid, docname, doctype, doctitle, date_created " +

       "FROM xml_documents " +

       "WHERE docid = ?");

    // Bind the values to the query and execute it

    pstmt.setString(1, docid);

    pstmt.execute();

    ResultSet rs = pstmt.getResultSet();

    boolean tableHasRows = rs.next();

    if (tableHasRows) {

      rnodeid      = rs.getLong(1);

      docname      = rs.getString(2);

      doctype      = rs.getString(3);

      doctitle     = rs.getString(4);

      date_created = rs.getDate(5);

    }

    pstmt.close();

    MetaCatUtil.debugMessage(new Long(rnodeid).toString());

    MetaCatUtil.debugMessage(docname);

    MetaCatUtil.debugMessage(doctitle);

    //MetaCatUtil.debugMessage(date_created.toString());

    // Next create the new record in the other table using the values selected

    pstmt = conn.prepareStatement(

       "INSERT INTO xml_revisions " +

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

       "date_created, date_updated) " +

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

    // Bind the values to the query and execute it

    pstmt.setString(1, docid);

    pstmt.setLong(2, rnodeid);

    pstmt.setString(3, docname);

    pstmt.setString(4, doctype);

    pstmt.setString(5, doctitle);

    //pstmt.setDate(6, date_created);

    pstmt.execute();

    pstmt.close();

  }

/**

 * '$Log$

 * 'Revision 1.13.2.8  2000/06/26 08:38:02  jones

 * 'Added DELETE feature to DBWriter.  Now takes an action "DELETE" and a

 * 'docid and will move the record from the xml_documents table to the

 * 'xml_revisions table.

 * 'Modified option parsing to support option symbols on command line.

 * '

 * 'Revision 1.13.2.7  2000/06/26 03:04:31  jones

 * 'Completed UPDATE function.  Included new table "xml_revisions" to store a

 * 'single document record for each revision to a document.  It is identical

 * 'to "xml_documents" with the addition of a "revisionid" column to

 * 'allow more than one revision per docid.

 * '

 * 'Revision 1.13.2.6  2000/06/26 02:02:20  jones

 * 'Continued fixing problems with exception handling that deals

 * 'with INSERT and UPDATE actions and the docid passed to DBWriter

 * '

 * 'Revision 1.13.2.5  2000/06/25 23:38:16  jones

 * 'Added RCSfile keyword

 * '

 * 'Revision 1.13.2.4  2000/06/25 23:34:17  jones

 * 'Changed documentation formatting, added log entries at bottom of source files

 * ''

 */