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
|
/*******************************************************************************
* Copyright (c) 2014 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.orcs.db.internal.callable;
import org.eclipse.osee.framework.core.data.IOseeBranch;
import org.eclipse.osee.framework.core.enums.BranchArchivedState;
import org.eclipse.osee.framework.jdk.core.type.OseeCoreException;
import org.eclipse.osee.jdbc.JdbcClient;
import org.eclipse.osee.jdbc.JdbcConnection;
import org.eclipse.osee.logger.Log;
import org.eclipse.osee.orcs.OrcsSession;
import org.eclipse.osee.orcs.data.ArchiveOperation;
/**
* @author Ryan D. Brooks
*/
public class ArchiveUnarchiveBranchCallable extends AbstractDatastoreTxCallable<Void> {
private static final String INSERT_ADDRESSING =
"insert into %s (transaction_id, gamma_id, tx_current, mod_type, branch_id) select transaction_id, gamma_id, tx_current, mod_type, branch_id from %s where branch_id = ?";
private static final String DELETE_ADDRESSING = "delete from %s where branch_id = ?";
private static final String UPDATE_BRANCH = "UPDATE osee_branch SET archived = ? WHERE branch_id = ?";
private final IOseeBranch branch;
private final ArchiveOperation op;
public ArchiveUnarchiveBranchCallable(Log logger, OrcsSession session, JdbcClient jdbcClient, IOseeBranch branch, ArchiveOperation op) {
super(logger, session, jdbcClient);
this.branch = branch;
this.op = op;
}
@Override
protected Void handleTxWork(JdbcConnection connection) throws OseeCoreException {
boolean archive = op == ArchiveOperation.ARCHIVE;
JdbcClient jdbcClient = getJdbcClient();
String sourceTableName = archive ? "osee_txs" : "osee_txs_archived";
String destinationTableName = archive ? "osee_txs_archived" : "osee_txs";
String sql = String.format(INSERT_ADDRESSING, destinationTableName, sourceTableName);
jdbcClient.runPreparedUpdate(connection, sql, branch.getUuid());
sql = String.format(DELETE_ADDRESSING, sourceTableName);
jdbcClient.runPreparedUpdate(connection, sql, branch.getUuid());
BranchArchivedState newState = archive ? BranchArchivedState.ARCHIVED : BranchArchivedState.UNARCHIVED;
Object[] params = new Object[] {newState.getValue(), branch.getUuid()};
jdbcClient.runPreparedUpdate(connection, UPDATE_BRANCH, params);
return null;
}
}
|
