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
|
/*******************************************************************************
* Copyright (c) 2013 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.loader.executors;
import java.util.Collection;
import org.eclipse.osee.executor.admin.HasCancellation;
import org.eclipse.osee.framework.core.data.IOseeBranch;
import org.eclipse.osee.framework.core.exception.OseeCoreException;
import org.eclipse.osee.framework.core.model.cache.BranchCache;
import org.eclipse.osee.framework.database.IOseeDatabaseService;
import org.eclipse.osee.framework.database.core.ArtifactJoinQuery;
import org.eclipse.osee.framework.database.core.CharJoinQuery;
import org.eclipse.osee.framework.database.core.IOseeStatement;
import org.eclipse.osee.framework.database.core.JoinUtility;
import org.eclipse.osee.orcs.OrcsSession;
import org.eclipse.osee.orcs.core.ds.LoadDataHandler;
import org.eclipse.osee.orcs.core.ds.Options;
import org.eclipse.osee.orcs.core.ds.OptionsUtil;
import org.eclipse.osee.orcs.db.internal.loader.LoadSqlContext;
import org.eclipse.osee.orcs.db.internal.loader.LoadUtil;
import org.eclipse.osee.orcs.db.internal.loader.SqlObjectLoader;
import org.eclipse.osee.orcs.db.internal.loader.criteria.CriteriaOrcsLoad;
/**
* @author Roberto E. Escobar
*/
public class UuidsLoadExecutor extends AbstractLoadExecutor {
private static final String GUIDS_TO_IDS =
"SELECT art.art_id FROM osee_join_char_id jid, osee_artifact art WHERE jid.query_id = ? AND jid.id = art.guid";
private final BranchCache branchCache;
private final OrcsSession session;
private final IOseeBranch branch;
private final Collection<String> artifactIds;
public UuidsLoadExecutor(SqlObjectLoader loader, IOseeDatabaseService dbService, BranchCache branchCache, OrcsSession session, IOseeBranch branch, Collection<String> artifactIds) {
super(loader, dbService);
this.branchCache = branchCache;
this.session = session;
this.branch = branch;
this.artifactIds = artifactIds;
}
@Override
public void load(HasCancellation cancellation, LoadDataHandler handler, CriteriaOrcsLoad criteria, Options options) throws OseeCoreException {
checkCancelled(cancellation);
ArtifactJoinQuery join = createIdJoin(options);
LoadSqlContext loadContext = new LoadSqlContext(session, options, branch);
int fetchSize = LoadUtil.computeFetchSize(artifactIds.size());
getLoader().loadArtifacts(cancellation, handler, join, criteria, loadContext, fetchSize);
}
private ArtifactJoinQuery createIdJoin(Options options) throws OseeCoreException {
ArtifactJoinQuery toReturn = JoinUtility.createArtifactJoinQuery(getDatabaseService());
if (!artifactIds.isEmpty()) {
int branchId = branchCache.getLocalId(branch);
Integer transactionId = OptionsUtil.getFromTransaction(options);
CharJoinQuery guidJoin = JoinUtility.createCharJoinQuery(getDatabaseService(), session.getGuid());
for (String id : artifactIds) {
guidJoin.add(id);
}
try {
guidJoin.store();
IOseeStatement chStmt = getDatabaseService().getStatement();
chStmt.runPreparedQuery(artifactIds.size(), GUIDS_TO_IDS, guidJoin.getQueryId());
while (chStmt.next()) {
Integer artId = chStmt.getInt("art_id");
toReturn.add(artId, branchId, transactionId);
}
} finally {
guidJoin.delete();
}
}
return toReturn;
}
}
|
