org.eclipse.osee.framework.ui.skynet/src/org/eclipse/osee/framework/ui/skynet/dbHealth/CommitTransactions.java

/*******************************************************************************
 * Copyright (c) 2004, 2007 Boeing.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v10.html
 *
 * Contributors:
 *     Boeing - initial API and implementation
 *******************************************************************************/
package org.eclipse.osee.framework.ui.skynet.dbHealth;

import org.eclipse.core.runtime.IProgressMonitor;
import org.eclipse.osee.framework.db.connection.ConnectionHandler;
import org.eclipse.osee.framework.db.connection.ConnectionHandlerStatement;
import org.eclipse.osee.framework.jdk.core.util.Strings;

/**
 * Updates commit transactions so new and then modified objects will be committed with a mod type of new. This BLAM
 * operation also removes attribute from deleted artifacts from committed transactions.
 * 
 * @author Jeff C. Phillips
 */
public class CommitTransactions extends DatabaseHealthOperation {
   private static final String GET_COMMIT_TRANSACTIONS =
         "select transaction_id from osee_tx_details where osee_comment like '%Commit%'";
   private static final String UPDATE_NEW_TRANSACTIONS_TO_CURRENT =
         "update osee_txs set mod_type = 1 where transaction_id = ? AND mod_type <> 1 AND gamma_id in( select tx1.gamma_id from osee_tx_details td1, osee_txs tx1, osee_artifact_version av1 where td1.transaction_id = ? AND td1.transaction_id = tx1.transaction_id AND tx1.gamma_id = av1.gamma_id AND av1.art_id NOT IN (SELECT av2.art_id FROM osee_tx_details td2, osee_txs tx2, osee_artifact_version av2 where td2.osee_comment like '%Commit%' AND td2.transaction_id < td1.transaction_id AND td2.transaction_id = tx2.transaction_id AND tx2.gamma_id = av2.gamma_id) AND av1.art_id NOT IN (SELECT av3.art_id FROM osee_txs tx3, osee_tx_details td3, osee_artifact_version av3 WHERE td3.branch_id = td1.branch_id AND td3.transaction_id < td1.transaction_id AND td3.transaction_id = tx3.transaction_id AND tx3.mod_type = 1 AND tx3.gamma_id = av3.gamma_id))";
   private static final String DELETE_ORPHAN_ATTRIBUTES =
         "delete FROM osee_attribute where gamma_id in (select t3.gamma_id from osee_txs t2, osee_attribute t3 where t2.transaction_id = ? AND t2.gamma_id = t3.gamma_id AND t3.art_id NOT in(SELECT art_id from osee_txs t4, osee_artifact_version t5 WHERE t4.transaction_id = t2.transaction_id AND t4.gamma_id = t5.gamma_id))";

   public CommitTransactions() {
      super(
            "commit transactions by deleting orphan attributes and setting new artifacts that have been modified to a mod type of 1");
   }

   @Override
   public String getVerifyTaskName() {
      return Strings.emptyString();
   }

   /* (non-Javadoc)
    * @see org.eclipse.osee.framework.ui.skynet.dbHealth.DatabaseHealthOperation#doHealthCheck(org.eclipse.core.runtime.IProgressMonitor)
    */
   @Override
   protected void doHealthCheck(IProgressMonitor monitor) throws Exception {
      if (isFixOperationEnabled()) {
         checkForCancelledStatus(monitor);

         ConnectionHandlerStatement chStmt = new ConnectionHandlerStatement();
         try {
            chStmt.runPreparedQuery(GET_COMMIT_TRANSACTIONS, new Object[0]);

            checkForCancelledStatus(monitor);
            monitor.worked(calculateWork(0.50));

            while (chStmt.next()) {
               int transactionNumber = chStmt.getInt("transaction_id");
               int updateCount =
                     ConnectionHandler.runPreparedUpdate(UPDATE_NEW_TRANSACTIONS_TO_CURRENT, transactionNumber,
                           transactionNumber);
               int deleteAttrCount = ConnectionHandler.runPreparedUpdate(DELETE_ORPHAN_ATTRIBUTES, transactionNumber);

               getSummary().append(
                     "For transaction: " + transactionNumber + " Number of update modTypes to 1:" + updateCount + " Number of deleted attrs: " + deleteAttrCount);
            }
         } finally {
            chStmt.close();
         }
      } else {
         monitor.worked(calculateWork(0.50));
      }
      monitor.worked(calculateWork(0.50));
   }
}