/ - Diff - Metacat - Ecoinformatics Redmine

« Previous | Next »

Revision 965

Added by Jing Tao almost 23 years ago

In order to increase data file docid, method registerDocument was revised. Now it not only insert a new data file record to xml_documents table, but also can update the data file documents. Moreover, it can archieve the old version to xml_revisions table. Two other private methods were added to handl these futures: deleteXMLDocuments and getLatestRevisionNumber.

     import java.io.StringWriter;
     import java.io.Writer;
     import java.io.InputStreamReader;
     import java.text.SimpleDateFormat;
     import java.util.Date;
-...
+      {
         Connection dbconn = null;
         MetaCatUtil util = new MetaCatUtil();
         AccessionNumber ac;
         try {
           dbconn = util.openDBConnection();
           AccessionNumber ac = new AccessionNumber(dbconn, accnum, "insert");
           String docIdWithoutRev=MetaCatUtil.getDocIdFromString(accnum);
           int userSpecifyRev=MetaCatUtil.getVersionFromString(accnum);
           int revInDataBase=getLatestRevisionNumber(dbconn, docIdWithoutRev);
           //revIndataBase=-1, there is no record in xml_documents table
           //the data file is a new one, inert it into table
           //user specified rev should be great than 0
           if (revInDataBase==-1 && userSpecifyRev>0 )
+          {
             ac = new AccessionNumber(dbconn, accnum, "insert");
+          }
           //rev is greater the last revsion number and revInDataBase isn't -1
           // it is a updated data file
           else if (userSpecifyRev>revInDataBase && revInDataBase>0)
+          {
             //archive the old entry
             archiveDocRevision(dbconn, docIdWithoutRev, user);
             //delete the old entry in xml_documents
             deleteXMLDocuments(dbconn, docIdWithoutRev);
             ac = new AccessionNumber(dbconn, accnum, "update");
+          }
           //other situation
           else
+          {
             throw new Exception("Revision number couldn't be "
                         +userSpecifyRev);
+          }
           String docid = ac.getDocid();
           String rev = ac.getRev();
           SimpleDateFormat formatter = new SimpleDateFormat ("yy-MM-dd HH:mm:ss");
           Date localtime = new Date();
           String dateString = formatter.format(localtime);
-...
           sql.append(sqlDateString).append(",");
           sql.append(sqlDateString).append(",");
           sql.append("'0')");
           //System.out.println("sql: " + sql.toString());
           PreparedStatement pstmt = dbconn.prepareStatement(sql.toString());
           pstmt.execute();
           pstmt.close();
-...
         pstmt.close();
+      }
       /**
         * delete a entry in xml_table for given docid
         * @param docId, the id of the document need to be delete
         */
       private static void deleteXMLDocuments(Connection conn, String docId)
                                              throws SQLException
+      {
         //delete a record
         PreparedStatement pStmt =
                  conn.prepareStatement("DELETE FROM xml_documents WHERE docid = '"
                                                   + docId + "'");
         pStmt.execute();
         pStmt.close();
       }//deleteXMLDocuments
       /**
         * Get last revision number from database for a docid
         * If couldn't find an entry,  -1 will return
         * The return value is integer because we want compare it to there new one
         * @param docid <sitecode>.<uniqueid> part of Accession Number
         */
       private static int getLatestRevisionNumber(Connection conn, String docId)
                                           throws SQLException
+      {
         int rev = 1;
         PreparedStatement pStmt;
         pStmt = conn.prepareStatement
                   ("SELECT rev FROM xml_documents WHERE docid='" + docId + "'");
         pStmt.execute();
         ResultSet rs = pStmt.getResultSet();
         boolean hasRow = rs.next();
         if (hasRow)
+        {
           rev = rs.getInt(1);
           pStmt.close();
+        }
         else
+        {
           rev=-1;
           pStmt.close();
+        }
         return rev;
       }//getLatestRevisionNumber
       /**
        * the main routine used to test the DBWriter utility.
        * <p>
        * Usage: java DocumentImpl <-f filename -a action -d docid>

Also available in: Unified diff

Project

General

Profile

Metacat

Revision 965

Added by Jing Tao almost 23 years ago