Skip to main content
summaryrefslogtreecommitdiffstats
blob: 93f6970a30831e506e5529616d552aae74ed9e80 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
/*******************************************************************************
 * 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.client.integration.tests.integration.skynet.core;

import static org.eclipse.osee.client.demo.DemoChoice.OSEE_CLIENT_DEMO;
import static org.eclipse.osee.client.integration.tests.integration.skynet.core.utils.Asserts.assertThatEquals;
import static org.junit.Assert.assertEquals;
import java.util.Collection;
import java.util.Map;
import org.eclipse.core.runtime.IStatus;
import org.eclipse.osee.client.demo.DemoBranches;
import org.eclipse.osee.client.integration.tests.integration.skynet.core.utils.Asserts;
import org.eclipse.osee.client.integration.tests.integration.skynet.core.utils.TestUtil;
import org.eclipse.osee.client.test.framework.OseeClientIntegrationRule;
import org.eclipse.osee.client.test.framework.OseeLogMonitorRule;
import org.eclipse.osee.framework.core.data.IOseeBranch;
import org.eclipse.osee.framework.core.enums.CoreArtifactTypes;
import org.eclipse.osee.framework.core.enums.CoreAttributeTypes;
import org.eclipse.osee.framework.core.operation.IOperation;
import org.eclipse.osee.framework.core.operation.NullOperationLogger;
import org.eclipse.osee.framework.core.operation.Operations;
import org.eclipse.osee.framework.database.core.ConnectionHandler;
import org.eclipse.osee.framework.database.operation.PurgeUnusedBackingDataAndTransactions;
import org.eclipse.osee.framework.jdk.core.type.OseeCoreException;
import org.eclipse.osee.framework.skynet.core.artifact.Artifact;
import org.eclipse.osee.framework.skynet.core.transaction.SkynetTransaction;
import org.eclipse.osee.framework.skynet.core.transaction.TransactionManager;
import org.eclipse.osee.framework.skynet.core.utility.PurgeTransactionOperationWithListener;
import org.junit.After;
import org.junit.Before;
import org.junit.Rule;
import org.junit.Test;

/**
 * @author Ryan Schmitt
 */
public class PurgeTransactionTest {

   @Rule
   public OseeClientIntegrationRule integration = new OseeClientIntegrationRule(OSEE_CLIENT_DEMO);

   @Rule
   public OseeLogMonitorRule monitorRule = new OseeLogMonitorRule();

   private static final IOseeBranch BRANCH = DemoBranches.SAW_Bld_2;

   private static final String[] TABLES = new String[] {
      "osee_attribute",
      "osee_artifact",
      "osee_relation_link",
      "osee_tx_details",
      "osee_txs"};

   private Collection<Artifact> softArts;

   @Before
   @After
   public void cleanup() throws OseeCoreException {
      Operations.executeWorkAndCheckStatus(new PurgeUnusedBackingDataAndTransactions(NullOperationLogger.getSingleton()));
   }

   @Test
   public void testPurgeTransaction() throws Exception {
      Map<String, Integer> initialRowCount = TestUtil.getTableRowCounts(TABLES);
      int createTxId = createArtifacts();

      Map<String, Integer> preModifyCount = TestUtil.getTableRowCounts(TABLES);
      int initialTxCurrents = getCurrentRows(createTxId);

      int modifyTxId = modifyArtifacts();
      purge(modifyTxId);
      assertThatEquals(preModifyCount, TestUtil.getTableRowCounts(TABLES));
      assertEquals("Purge Transaction did not correctly update tx_current.", initialTxCurrents,
         getCurrentRows(createTxId));

      purge(createTxId);
      assertThatEquals(initialRowCount, TestUtil.getTableRowCounts(TABLES));
   }

   private int createArtifacts() throws Exception {
      SkynetTransaction createTransaction = TransactionManager.createTransaction(BRANCH, "Purge Transaction Test");
      softArts =
         TestUtil.createSimpleArtifacts(CoreArtifactTypes.SoftwareRequirement, 10, getClass().getSimpleName(), BRANCH);
      for (Artifact softArt : softArts) {
         softArt.persist(createTransaction);
      }
      createTransaction.execute();
      return createTransaction.getTransactionId();
   }

   private int modifyArtifacts() throws Exception {
      SkynetTransaction modifyTransaction = TransactionManager.createTransaction(BRANCH, "Purge Transaction Test");
      for (Artifact softArt : softArts) {
         softArt.addAttribute(CoreAttributeTypes.StaticId, getClass().getSimpleName());
         softArt.persist(modifyTransaction);
      }
      modifyTransaction.execute();
      return modifyTransaction.getTransactionId();
   }

   private void purge(int transactionId) throws Exception {
      IOperation operation = PurgeTransactionOperationWithListener.getPurgeTransactionOperation(transactionId);
      Asserts.assertOperation(operation, IStatus.OK);
      Operations.executeWorkAndCheckStatus(new PurgeUnusedBackingDataAndTransactions(NullOperationLogger.getSingleton()));
   }

   private int getCurrentRows(int createTxId) throws OseeCoreException {
      final String query = "select count(*) from osee_txs where transaction_id=? and tx_current=1";
      return ConnectionHandler.runPreparedQueryFetchInt(-1, query, createTxId);
   }
}

Back to the top