/ - Diff - Metacat - Ecoinformatics Redmine

« Previous | Next »

Revision 622

Added by berkley over 23 years ago

changed accession number schema to <sitecode>.<serialnumber>.<revisionnumber>. DocumentIdentifier.java parses docids into parts for easy manipulation. You can now specifiy a specific revision by asking for document <sitecode>.<serialnumber>.<revisionnumber> or you can get the newest revision by asking for <sitecode>.<serialnumber> or by asking for <sitecode>.<serialnumber>.newest.

         try {
           this.conn = conn;
           this.docid = docid;
           DocumentIdentifier id = new DocumentIdentifier(docid);
           // Look up the document information
           getDocumentInfo(docid);
-...
         out.print("</" + currentElement.nodename + ">" );
         out.flush();
+      }
       private boolean isRevisionOnly(DocumentIdentifier docid) throws Exception
+      {
         //System.out.println("inRevisionOnly");
         PreparedStatement pstmt;
         String rev = docid.getRev();
         String newid = docid.getIdentifier();
         pstmt = conn.prepareStatement("select rev from xml_documents " +
                                       "where docid like '" + newid + "'");
         pstmt.execute();
         ResultSet rs = pstmt.getResultSet();
         boolean tablehasrows = rs.next();
         if(rev.equals("newest") || rev.equals("all"))
+        {
           return false;
+        }
         if(tablehasrows)
+        {
           int r = rs.getInt(1);
           if(new Integer(rev).intValue() == r)
           { //the current revision in in xml_documents
             //System.out.println("returning false");
             return false;
+          }
           else if(new Integer(rev).intValue() < r)
           { //the current revision is in xml_revisions.
             //System.out.println("returning true");
             return true;
+          }
           else if(new Integer(rev).intValue() > r)
           { //error, rev cannot be greater than r
             throw new Exception("requested revision cannot be greater than " +
                                 "the latest revision number.");
+          }
+        }
         throw new Exception("the requested docid '" + docid.toString() +
                             "' does not exist");
+      }
       private void getDocumentInfo(String docid) throws McdbException,
                                                         AccessionNumberException
+      {
         getDocumentInfo(new DocumentIdentifier(docid));
+      }
       /**
        * Look up the document type information from the database
+       *
        * @param docid the id of the document to look up
        */
       private void getDocumentInfo(String docid) throws McdbException
       private void getDocumentInfo(DocumentIdentifier docid) throws McdbException
+      {
         PreparedStatement pstmt;
         String table = "xml_documents";
         try
+        {
           if(isRevisionOnly(docid))
           { //pull the document from xml_revisions instead of from xml_documents;
             table = "xml_revisions";
+          }
+        }
         catch(Exception e)
+        {
           System.out.println("error in getDocumentInfo: " + e.getMessage());
+        }
         //deal with the key words here.
         if(docid.getRev().equals("all"))
+        {
+        }
         try {
           StringBuffer sql = new StringBuffer();
           sql.append("SELECT docname, doctype, rootnodeid,doctitle, ");
           sql.append("date_created, date_updated, ");
           sql.append("user_owner, user_updated, server_location, ");
           sql.append("rev FROM ").append(table);
           sql.append(" WHERE docid LIKE '").append(docid.getIdentifier());
           sql.append("' and rev like '").append(docid.getRev()).append("'");
           //System.out.println(sql.toString());
           pstmt =
             conn.prepareStatement("SELECT docname, doctype, rootnodeid,doctitle, " +
                                   "date_created, date_updated, " +
                                   "user_owner, user_updated, server_location, " +
                                   "public_access, rev " +
                                    "FROM xml_documents " +
                                    "WHERE docid LIKE ?");
             conn.prepareStatement(sql.toString());
           // Bind the values to the query
           pstmt.setString(1, docid);
           //pstmt.setString(1, docid.getIdentifier());
           //pstmt.setString(2, docid.getRev());
           pstmt.execute();
           ResultSet rs = pstmt.getResultSet();
-...
             this.userowner      = rs.getString(7);
             this.userupdated    = rs.getString(8);
             this.serverlocation = rs.getInt(9);
             this.publicaccess   = rs.getInt(10);
             this.rev            = rs.getInt(11);
             //this.publicaccess   = rs.getInt(10);
             this.rev            = rs.getInt(10);
+          }
           pstmt.close();
-...
             pstmt.close();
+          }
         } catch (SQLException e) {
           System.out.println("error in getDocumentInfo: " + e.getMessage());
           e.printStackTrace(System.out);
           throw new McdbException("Error accessing database connection.", e);
+        }

     package edu.ucsb.nceas.metacat;
     import java.io.*;
     import java.util.*;
     import java.lang.*;
     import java.sql.*;
     /**
      * A class to parse document ids
      * The docid is of the form siteCode.uniqueId.rev
      */
     public class DocumentIdentifier
+    {
       private String docid = null;
       private String rev = null;
       private String uniqueId = null;
       private String siteCode = null;
       private String separator = null;
       private MetaCatUtil util = new MetaCatUtil();
       /**
        * Constructor to build a docid object and parse an incoming string.
        */
       public DocumentIdentifier(String docid) throws AccessionNumberException
+      {
         this.docid = docid;
         //int numSeps = countSeparator();
         //if(numSeps > 2 || numSeps < 1)
         //{
         //  throw new AccessionNumberException("Accession number can contain " +
         //            "no more than 2 and no fewer than 1 separators.");
         //}
         if(docid.endsWith("."))
+        {
           throw new AccessionNumberException("Accession number cannot end with " +
                     "a seperator.");
+        }
         if(docid.startsWith("."))
+        {
           throw new AccessionNumberException("Accession number cannot begin with " +
                     "a seperator.");
+        }
         parseDocid();
+      }
       /**
        * parses the docid into its parts
        */
       private void parseDocid()
+      {
         separator = util.getOption("accNumSeparator");
         int firstIndex = docid.indexOf(separator);
         int lastIndex = docid.lastIndexOf(separator);
         if(firstIndex != lastIndex)
         { //this docid contains a revision number
           rev = docid.substring(lastIndex + 1);
           uniqueId = docid.substring(firstIndex + 1, lastIndex);
           siteCode = docid.substring(0, firstIndex);
+        }
         else
+        {
           uniqueId = docid.substring(firstIndex + 1);
           siteCode = docid.substring(0, firstIndex);
           rev = getNewestRev();
+        }
         if(rev.equals("newest"))
+        {
           rev = getNewestRev();
+        }
+      }
       /**
        * returns the newest revision number for a document
        */
       private String getNewestRev()
+      {
         PreparedStatement pstmt;
         Connection conn = null;
         try
+        {
           conn = util.openDBConnection();
           pstmt = conn.prepareStatement("select rev from xml_documents where " +
                                         "docid like '" + docid + "'");
           pstmt.execute();
           ResultSet rs = pstmt.getResultSet();
           boolean tablehasrows = rs.next();
           if(tablehasrows)
+          {
             String retStr = rs.getString(1);
             conn.close();
             return retStr;
+          }
+        }
         catch(Exception e)
+        {
           try
+          {
             conn.close();
+          }
           catch(Exception e2)
           {}
           System.out.println("error in DocumentIdentifier.getNewestRev " +
                               e.getMessage());
+        }
         return "1";
+      }
       private int countSeparator()
+      {
         int count = 0;
         for(int i=0; i<docid.length(); i++)
+        {
           if(docid.charAt(i) == '.')
+          {
             count++;
+          }
+        }
         return count;
+      }
       /**
        * returns the revision number encoded in this docid
        */
       public String getRev()
+      {
         return rev;
+      }
       /**
        * returns the uniqueId encoded in this docid
        */
       public String getUniqueId()
+      {
         return uniqueId;
+      }
       /**
        * returns the siteCode encoded in this docid
        */
       public String getSiteCode()
+      {
         return siteCode;
+      }
       /**
        * returns the separator used in the accession number
        */
       public String getSeparator()
+      {
         return separator;
+      }
       /**
        * returns <siteCode><sepatator><uniqueId>
        */
       public String getIdentifier()
+      {
         return siteCode + separator + uniqueId;
+      }
       /**
        * returns the whole docid as a string
        */
       public String toString()
+      {
         return docid;
+      }
       /**
        * Test driver.  The first command line argument is the docid you want to
        * create an object for.  For instance ">java DocumentIdentifer nceas.1.2"
        * will return "rev: 2 \n uniqueId: 1 \n siteCode: nceas \n"
        */
       public static void main(String args[])
+      {
         try
+        {
           DocumentIdentifier d = new DocumentIdentifier(args[0]);
           System.out.println("rev: " + d.getRev());
           System.out.println("uniqueId: " + d.getUniqueId());
           System.out.println("siteCode: " + d.getSiteCode());
+        }
         catch(Exception e)
+        {
           System.out.println("error: " + e.getMessage());
+        }
+      }
+    }

Also available in: Unified diff

Project

General

Profile

Metacat

Revision 622

Added by berkley over 23 years ago