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.sql.ResultSet;

import java.sql.SQLException;

import edu.ucsb.nceas.utilities.PropertyNotFoundException;

 * for uniqueness and register it into the db connection

 * Check for existance of provided Accession Number

  private String rev = null;

	 * Construct an AccessionNumber

	 */

	private AccessionNumber() throws AccessionNumberException {

		try {

			this.sep = PropertyService.getProperty("document.accNumSeparator");

			throw new AccessionNumberException("Could not retrieve property "

					+ "in constructor: " + pnfe.getMessage());

		}

	}

	 * Construct an AccessionNumber

	 *

	 * @param conn

	 *            the db connection to read Accession number from

	 * @param accnum

	 *            the accession number to be checked for validness

	 */

 {

    this.rev = null;

    this.docid = accnum;

    if ( accnum != null ) {

      int firstIndex = accnum.indexOf(this.sep);

      int lastIndex = accnum.lastIndexOf(this.sep);

      if ( firstIndex != lastIndex ) {

        //this docid contains a revision number

        this.rev = accnum.substring(lastIndex + 1);

        this.docid = accnum.substring(0, lastIndex);

      }

    }

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

            try {

                Integer.parseInt(rev);

            }

            catch (java.lang.NumberFormatException e) {

                throw new AccessionNumberException(

                    "Revision number is required");

            }

        }

      if ( docid == null ) {

      // rev is not provided; throw an exception to prevent the insertion

      } else if ( rev == null ) {

        throw new AccessionNumberException

      // docid is used; throw an exception to prevent the insertion

      } else if ( accNumberUsed(docid) ) {

        throw new AccessionNumberException

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

      String l_rev = "";

      if(rev != null){

              reversionNumber = Integer.parseInt(rev);

          } catch (java.lang.NumberFormatException e){

              throw new AccessionNumberException(

                      "Revision number is required");

          }

      if ( docid == null ) {

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

      } else if ( rev == null ) {

        throw new AccessionNumberException

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

      } else if ( !accNumberIsCurrent(docid) ) {

        throw new AccessionNumberException

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

                                              + getLastRevisionNumber(docid));

      // Revision number is not the recent one; throw an exception

        throw new AccessionNumberException

                  ("Last revision number is "+ l_rev);

      }

    }

  }

    int serialNumber = -1;

      //check out DBConnection

      conn=DBConnectionPool.getDBConnection("AccessionNumber.accNumberUsed");

      serialNumber=conn.getCheckOutSerialNumber();

                "SELECT 'x' FROM xml_revisions " +

      pstmt.setString(2,accNumber);

      ResultSet rs = pstmt.getResultSet();

      hasAccNumber = rs.next();

      pstmt.close();

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

    finally

    {

      DBConnectionPool.returnDBConnection(conn, serialNumber);

    }

    int serialNumber = -1;

      //check out DBConnection

      conn=DBConnectionPool.getDBConnection("AccessionNumber.accNumberIsCurre");

      serialNumber=conn.getCheckOutSerialNumber();

      pstmt.execute();

      ResultSet rs = pstmt.getResultSet();

      hasCurrentAccNumber = rs.next();

      pstmt.close();

      throw new SQLException(

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

          e.getMessage());

    finally

    {

      DBConnectionPool.returnDBConnection(conn, serialNumber);

    }

  private String getLastRevision(String docid) throws SQLException

  {

    String rev = "";

    int serialNumber = -1;

      //check out DBConnection

      conn=DBConnectionPool.getDBConnection("AccessionNumber.getLastRevision");

      serialNumber=conn.getCheckOutSerialNumber();

              ("SELECT rev FROM xml_documents WHERE docid='" + docid + "'");

      pstmt.execute();

      ResultSet rs = pstmt.getResultSet();

      boolean hasRow = rs.next();

      rev = rs.getString(1);

      pstmt.close();

      throw new SQLException(

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

    }

    {

      DBConnectionPool.returnDBConnection(conn,serialNumber);

    }

    return rev;

  }

    * Get last revision number from database for a docid

    * The return value is integer because we want compare it to there new one

    * @param docid <sitecode>.<uniqueid> part of Accession Number

    */

  private int getLastRevisionNumber(String docId) throws SQLException

  {

    int rev = 1;

    int serialNumber = -1;

      //check out DBConnection

      conn=DBConnectionPool.getDBConnection("AccessionNumber.getLastRevisionN");

      serialNumber=conn.getCheckOutSerialNumber();

              ("SELECT rev FROM xml_documents WHERE docid='" + docId + "'");

      pStmt.execute();

      boolean hasRow = rs.next();

      rev = rs.getInt(1);

      pStmt.close();

      throw new SQLException(

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

    }

    {

      DBConnectionPool.returnDBConnection(conn,serialNumber);

    }

  }

   * returns the docid encoded in this accession number

   */

  public String getDocid() {

    return this.docid;

  }

  /**

   * returns the revision number encoded in this accession number

   */

  public String getRev()

  {

    return this.rev;

  }