Metacat

/**

 *    Purpose: A class that gets Accession Number, check for uniqueness

 *             and register it into db

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

 *             National Center for Ecological Analysis and Synthesis

 *    Authors: Jivka Bojilova, Matt Jones

 *     '$Date$'

 * '$Revision$'

 * This program is free software; you can redistribute it and/or modify

 * it under the terms of the GNU General Public License as published by

 * the Free Software Foundation; either version 2 of the License, or

 * (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

package edu.ucsb.nceas.metacat;

import java.net.*;

import java.sql.*;

 * Generates a unique Accession Number or if provided check it

 * for uniqueness and register it into the db connection

 * (on update or delete of XML document)

 * Check for existance of provided Accession Number

 *

  private Connection conn = null;

   * Construct an AccessionNumber

   */

  public AccessionNumber ()

         throws SQLException, ClassNotFoundException  {

    this.sep = util.getOption("accNumSeparator");

    // Open a connection to the database

    this.conn = util.openDBConnection();

  }

  /**

   * Construct an AccessionNumber

   *

   * @param conn the db connection to read from and write Accession# to

   */

  public AccessionNumber (Connection conn) {

    this.sep = util.getOption("accNumSeparator");

   */

  public String generate(String accNumber, String action)

                throws AccessionNumberException, SQLException

  {

    try {

      // INSERT

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

        // get a new Accession#

        if ( accNumber == null ) {

          String uniqueid = getUniqueID();

        } else if ( !accNumberUsed(accNumber) ) {

          return accNumber;

        // Accession# is used; throw an exception to prevent the insertion

        } else {

          throw new AccessionNumberException

                    ("Accession number " + accNumber + " is already in use.");

        }

      // UPDATE or DELETE

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

        // Accession# is not provided; throw an exception to prevent the action

        if ( accNumber == null ) {

          throw new AccessionNumberException("Accession number is required.");

        // Accession# is not current (not in xml_documents); throw an exception

        } else if ( !accNumberIsCurrent(accNumber) ) {

          throw new AccessionNumberException

          ("Document not found for Accession number " + accNumber);

        // Accession# is current (present in xml_documents); return it

        } else {

          return accNumber;

        }

      }

    } catch (SQLException e) {

      throw new SQLException

      ("Error on AccessionNumber.generate(accNumber, action): "+e.getMessage());

    }

    // never comes here

    throw new

    AccessionNumberException("Fatal Error in accession number generation.");

  }

  private String getSitecode()

  private String getUniqueID () throws SQLException

    try {

      PreparedStatement pstmt;

      pstmt = conn.prepareStatement

      ResultSet rs = pstmt.getResultSet();

      boolean hasRow = rs.next();

    } catch (SQLException e) {

      throw new

      PreparedStatement pstmt;

      pstmt = conn.prepareStatement(

                "WHERE docid LIKE ? " +

                "UNION " +

                "SELECT 'x' FROM xml_revisions " +

                "WHERE docid LIKE ?");

      pstmt.setString(1,accNumber);

      pstmt.setString(2,accNumber);

      ResultSet rs = pstmt.getResultSet();

      hasAccNumber = rs.next();

      pstmt.close();

      ("Error on AccessionNumber.accNumberUsed(accNumber): " + e.getMessage());

  }

  private boolean accNumberIsCurrent(String accNumber) throws SQLException {

      PreparedStatement pstmt;

      pstmt = conn.prepareStatement(

                "WHERE docid LIKE ?");

      pstmt.execute();

      ResultSet rs = pstmt.getResultSet();

      hasCurrentAccNumber = rs.next();

      pstmt.close();

      throw new SQLException(

          "Error on AccessionNumber.accNumberIsCurrent(String accNumber): " +

          e.getMessage());

    return hasCurrentAccNumber;

  }

}