private StoryList retrieveStoriesByQuery(QueryFilter filter)
throws IOException, ConnectorException, TransformerException, URISyntaxException {
RallyRestApi restApi = new RallyRestApi(new URI(RALLY_SERVER_URL), username, password);
QueryRequest storyQuery = new QueryRequest("HierarchicalRequirement");
QueryRequest defectQuery = new QueryRequest("Defect");
StoryList stories = objFactory.createStoryList();
try {
defectQuery.setQueryFilter(filter);
storyQuery.setQueryFilter(filter);
QueryResponse storyResp = restApi.query(storyQuery);
QueryResponse defectResp = restApi.query(defectQuery);
if (storyResp.wasSuccessful()) {
List<StoryType> storyList = getStoryList(storyResp.getResults());
stories.getStory().addAll(storyList);
}
if (defectResp.wasSuccessful()) {
List<StoryType> defectList = getStoryList(defectResp.getResults());
stories.getStory().addAll(defectList);
}
} finally {
restApi.close();
}
return stories;
}
public static void main(String[] args) throws URISyntaxException, IOException {
String host = "https://rally1.rallydev.com";
String apiKey = "_abc123"; // use your ApiKey
String applicationName = "Nick:PiTypes";
RallyRestApi restApi = new RallyRestApi(new URI(host), apiKey);
restApi.setApplicationName(applicationName);
String workspaceRef = "/workspace/12345";
try {
QueryRequest typedefRequest = new QueryRequest("TypeDefinition");
typedefRequest.setFetch(new Fetch("ElementName", "Ordinal"));
typedefRequest.setOrder("Ordinal DESC");
typedefRequest.setQueryFilter(new QueryFilter("Parent.Name", "=", "Portfolio Item"));
typedefRequest.setWorkspace(workspaceRef);
QueryResponse typedefResponse = restApi.query(typedefRequest);
for (int i = 0; i < typedefResponse.getTotalResultCount(); i++) {
JsonObject typedefObj = typedefResponse.getResults().get(i).getAsJsonObject();
if (typedefObj.get("Ordinal").getAsInt() > -1) {
System.out.println(
"ElementName: "
+ typedefObj.get("ElementName")
+ ", "
+ "Ordinal: "
+ typedefObj.get("Ordinal"));
}
}
} finally {
restApi.close();
}
}
@Override
public TaskList retrieveTasks(StoryList stories)
throws IOException, ClientProtocolException, ConnectorException, TransformerException,
URISyntaxException {
RallyRestApi restApi = new RallyRestApi(new URI(RALLY_SERVER_URL), username, password);
QueryRequest taskQuery = new QueryRequest("Task");
TaskList taskList = objFactory.createTaskList();
try {
for (StoryType story : stories.getStory()) {
String storyID = story.getIdentifier();
Link storyLink = findLinkByRel(story, RALLY_OBJECT_URL_REL);
if (storyLink != null) {
storyLink.setRel(RALLY_PARENT_URL_REL);
}
NDC.push("retrieving tasks for " + storyID);
logger.debug(NDC.peek());
QueryFilter filter = new QueryFilter("WorkProduct.FormattedID", "=", storyID);
taskQuery.setQueryFilter(filter);
QueryResponse query = restApi.query(taskQuery);
if (query.wasSuccessful()) {
for (JsonElement e : query.getResults()) {
if (e == null) continue;
TaskType task = objFactory.createTaskType();
JsonObject jsonTask = e.getAsJsonObject();
String taskName = jsonTask.get("Name").getAsString();
task.setParentIdentifier(storyID);
task.setDescription(fixDescription(getValueOrDefault(jsonTask.get("Description"), "")));
if (!jsonTask.get("Owner").isJsonNull()) {
task.setOwner(
getValueOrDefault(
jsonTask.get("Owner").getAsJsonObject().get("_refObjectName"), ""));
}
task.setFullName(taskName);
task.setShortName((taskName.length() > 30) ? taskName.substring(0, 30) : taskName);
task.setIdentifier(jsonTask.get("FormattedID").getAsString());
task.setDetailedEstimate(getValueOrDefault(jsonTask.get("Estimate"), new Double(0.0)));
task.setTodoRemaining(getValueOrDefault(jsonTask.get("Estimate"), new Double(0.0)));
task.setEffortApplied(getValueOrDefault(jsonTask.get("Actuals"), new Double(0.0)));
task.setDescription(fixDescription(getValueOrDefault(jsonTask.get("Description"), "")));
addLink(story, jsonTask.get("_ref").getAsString(), RALLY_OBJECT_URL_REL);
addLink(task, jsonTask.get("_ref").getAsString(), RALLY_OBJECT_URL_REL);
addLink(task, storyLink);
taskList.getTask().add(task);
}
}
}
} finally {
NDC.pop();
restApi.close();
}
return taskList;
}
public static void test1() throws URISyntaxException, IOException {
User user = User.getInstance();
// Create and configure a new instance of RallyRestApi
RallyRestApi restApi =
new RallyRestApi(
new URI("https://rally1.rallydev.com"), user.getUser(), user.getPassword());
restApi.setApplicationName("QueryExample");
try {
System.out.println("Querying for unaccepted stories for current user...");
QueryRequest defects = new QueryRequest("HierarchicalRequirement");
defects.setFetch(new Fetch("FormattedID", "Name", "ScheduleState"));
QueryFilter qf1 = new QueryFilter("Owner.Name", "=", user.getUser());
QueryFilter qf2 = new QueryFilter("ScheduleState", "<", "Accepted");
defects.setQueryFilter(qf1.and(qf2));
defects.setOrder("FormattedID DESC");
// Return up to 20, 1 per page
defects.setPageSize(1);
defects.setLimit(20);
QueryResponse queryResponse = restApi.query(defects);
if (queryResponse.wasSuccessful()) {
System.out.println(
String.format("\nTotal results: %d", queryResponse.getTotalResultCount()));
System.out.println("unaccept stories:");
for (JsonElement result : queryResponse.getResults()) {
JsonObject defect = result.getAsJsonObject();
System.out.println(
String.format(
"\t%s - %s - ScheduleState:%s",
defect.get("FormattedID").getAsString(),
defect.get("Name").getAsString(),
defect.get("ScheduleState").getAsString()));
}
} else {
System.err.println("The following errors occurred: ");
for (String err : queryResponse.getErrors()) {
System.err.println("\t" + err);
}
}
} finally {
// Release resources
restApi.close();
}
}
@Override
public List<IterationStatus> listIterationsForProject(String projectName)
throws IOException, ConnectorException, URISyntaxException {
List<IterationStatus> iterationList = new ArrayList<IterationStatus>();
RallyRestApi restApi = new RallyRestApi(new URI(RALLY_SERVER_URL), username, password);
QueryRequest query = new QueryRequest("Iterations");
query.setFetch(new Fetch("Name"));
query.setQueryFilter(new QueryFilter("Project.Name", "=", "Adrenalin SeaDAC Renderer"));
QueryResponse resp = restApi.query(query);
for (JsonElement r : resp.getResults()) {
JsonObject result = r.getAsJsonObject();
iterationList.add(
new IterationStatus(
result.get("Name").getAsString(), new URI(result.get("_ref").getAsString())));
}
restApi.close();
return iterationList;
}
public static void main(String[] args) throws URISyntaxException, IOException {
String host = "https://rally1.rallydev.com";
String apiKey = "_abc123";
String workspaceRef = "/workspace/12352608129";
String applicationName = "bulkUpdateTagsOnDefects";
RallyRestApi restApi = new RallyRestApi(new URI(host), apiKey);
restApi.setApplicationName(applicationName);
try {
String tagToRemove = "tag1";
String tagToAdd = "new tag";
// find all defects with "tag1" with ScheduleState < Completed
QueryRequest defectRequest = new QueryRequest("Defect");
defectRequest.setWorkspace(workspaceRef);
defectRequest.setFetch(new Fetch(new String[] {"Name", "FormattedID", "Tags"}));
defectRequest.setLimit(1000);
defectRequest.setQueryFilter(
(new QueryFilter("Tags.Name", "contains", tagToRemove))
.and(new QueryFilter("ScheduleState", "<", "Completed")));
QueryResponse defectQueryResponse = restApi.query(defectRequest);
System.out.println("Size: " + defectQueryResponse.getTotalResultCount());
/*
QueryRequest oldTagRequest = new QueryRequest("Tag");
oldTagRequest.setWorkspace(workspaceRef);
oldTagRequest.setQueryFilter(new QueryFilter("Name", "=", tagToRemove));
QueryResponse oldTagQueryResponse = restApi.query(oldTagRequest);
if(oldTagQueryResponse.getTotalResultCount() == 0){
System.out.println("Cannot find tag: " + tagToRemove);
return;
}
JsonObject oldTagJsonObject = oldTagQueryResponse.getResults().get(0).getAsJsonObject();
String oldTagRef = oldTagJsonObject.get("_ref").getAsString();
System.out.println(oldTagRef);
*/
QueryRequest newTagRequest = new QueryRequest("Tag");
newTagRequest.setWorkspace(workspaceRef);
newTagRequest.setQueryFilter(new QueryFilter("Name", "=", tagToAdd));
QueryResponse newTagQueryResponse = restApi.query(newTagRequest);
if (newTagQueryResponse.getTotalResultCount() == 0) {
System.out.println("Cannot find tag: " + tagToAdd);
return;
}
JsonObject newTagJsonObject = newTagQueryResponse.getResults().get(0).getAsJsonObject();
String newTagRef = newTagJsonObject.get("_ref").getAsString();
System.out.println(newTagRef);
if (defectQueryResponse.getTotalResultCount() == 0) {
System.out.println("Cannot find defects tagged : " + tagToRemove);
return;
} else {
for (int i = 0; i < defectQueryResponse.getResults().size(); i++) {
JsonObject defectJsonObject = defectQueryResponse.getResults().get(i).getAsJsonObject();
String defectRef = defectJsonObject.get("_ref").getAsString();
System.out.println(
"Name: "
+ defectJsonObject.get("Name")
+ " FormattedID: "
+ defectJsonObject.get("FormattedID"));
int numberOfTags = defectJsonObject.getAsJsonObject("Tags").get("Count").getAsInt();
QueryRequest tagCollectionRequest =
new QueryRequest(defectJsonObject.getAsJsonObject("Tags"));
tagCollectionRequest.setFetch(new Fetch("Name", "ObjectID"));
JsonArray tags = restApi.query(tagCollectionRequest).getResults();
for (int j = 0; j < numberOfTags; j++) {
System.out.println("Tag Name: " + tags.get(j).getAsJsonObject().get("Name"));
}
tags.add(newTagJsonObject);
JsonObject defectUpdate = new JsonObject();
defectUpdate.add("Tags", tags);
UpdateRequest updateDefectRequest = new UpdateRequest(defectRef, defectUpdate);
UpdateResponse updateDefectResponse = restApi.update(updateDefectRequest);
if (updateDefectResponse.wasSuccessful()) {
System.out.println(
"Successfully updated : "
+ defectJsonObject.get("FormattedID")
+ " Tags after update: ");
QueryRequest tagCollectionRequest2 =
new QueryRequest(defectJsonObject.getAsJsonObject("Tags"));
tagCollectionRequest2.setFetch(new Fetch("Name", "ObjectID"));
JsonArray tagsAfterUpdate = restApi.query(tagCollectionRequest2).getResults();
int numberOfTagsAfterUpdate = restApi.query(tagCollectionRequest2).getResults().size();
for (int j = 0; j < numberOfTagsAfterUpdate; j++) {
System.out.println(
"Tag Name: " + tagsAfterUpdate.get(j).getAsJsonObject().get("Name"));
}
}
}
}
} finally {
restApi.close();
}
}
private static void getRally(String oid) throws Exception {
try {
// start sub threads
String host = "https://rally1.rallydev.com";
String apiKey = "_56bw2obMSvaC3T6d4E0UTYdxFJqEpkNQoaFeesI7l94";
String applicationName = "Nick multi thread example " + oid;
RallyRestApi restApi = new RallyRestApi(new URI(host), apiKey);
restApi.setApplicationName(applicationName);
String workspaceRef = "/workspace/" + oid;
QueryRequest releaseRequest = new QueryRequest("Release");
releaseRequest.setFetch(
new Fetch(
"Name",
"ObjectID",
"ReleaseStartDate",
"ReleaseDate",
"Project",
"RevisionHistory",
"Revisions"));
String date = getDate();
releaseRequest.setQueryFilter(new QueryFilter("ReleaseDate", ">", date));
releaseRequest.setWorkspace(workspaceRef);
QueryResponse releaseQueryResponse = restApi.query(releaseRequest);
int numberOfReleases = releaseQueryResponse.getTotalResultCount();
System.out.println(
"number of releases in workspace : "
+ oid
+ " with ReleaseDate > "
+ date
+ ":"
+ numberOfReleases);
if (numberOfReleases > 0) {
for (int i = 0; i < numberOfReleases; i++) {
JsonObject releaseJsonObject = releaseQueryResponse.getResults().get(i).getAsJsonObject();
System.out.println(
releaseJsonObject.get("Name")
+ " : "
+ releaseJsonObject.get("ObjectID")
+ " in project "
+ releaseJsonObject.get("Project").getAsJsonObject().get("Name"));
String rsd = releaseJsonObject.get("ReleaseStartDate").getAsString();
String rd = releaseJsonObject.get("ReleaseDate").getAsString();
JsonObject revisionHistory = releaseJsonObject.get("RevisionHistory").getAsJsonObject();
QueryRequest revisionsRequest =
new QueryRequest(revisionHistory.getAsJsonObject("Revisions"));
revisionsRequest.setFetch(new Fetch("Description", "User", "UserName"));
revisionsRequest.setQueryFilter(
new QueryFilter("Description", "contains", "Unscheduled"));
QueryResponse revisionsResponse = restApi.query(revisionsRequest);
int numberOfRevisions = revisionsResponse.getTotalResultCount();
if (numberOfRevisions > 0) {
System.out.println(
"number of revisions when work items were removed from release: "
+ numberOfRevisions);
for (int x = 0; x < numberOfRevisions; x++) {
JsonObject revisionJsonObject =
revisionsResponse.getResults().get(x).getAsJsonObject();
System.out.println(
revisionJsonObject.get("Description")
+ "\n by:"
+ revisionJsonObject.get("User").getAsJsonObject().get("UserName"));
}
} else {
System.out.println("no work items were removed from release");
}
}
}
} finally {
System.out.println(
"done with thread " + oid + "\n--------------------------------------------------------");
}
}
public static void main(String[] args)
throws URISyntaxException, IOException, InterruptedException {
// start main thread
String host = "https://rally1.rallydev.com";
String apiKey = "_abc123";
String applicationName = "Nick multi thread example";
RallyRestApi restApi = new RallyRestApi(new URI(host), apiKey);
restApi.setApplicationName(applicationName);
// get current user
GetRequest getRequest = new GetRequest("/user");
GetResponse getResponse = restApi.get(getRequest);
JsonObject currentUser = getResponse.getObject();
String currentUserRef = currentUser.get("_ref").getAsString();
System.out.println("current user " + currentUserRef);
// get workspaces where the current user has permission
List<String> workspaces = new ArrayList<String>();
QueryRequest workspacePermissionsRequest = new QueryRequest("WorkspacePermissions");
workspacePermissionsRequest.setQueryFilter(new QueryFilter("User", "=", currentUserRef));
workspacePermissionsRequest.setFetch(new Fetch("Workspace", "ObjectID"));
QueryResponse workspacePermissionsResponse = restApi.query(workspacePermissionsRequest);
int numberOfPermissoins = workspacePermissionsResponse.getTotalResultCount();
System.out.println(numberOfPermissoins);
if (numberOfPermissoins > 0) {
for (int i = 0; i < numberOfPermissoins; i++) {
JsonObject workspacePermissionObject =
workspacePermissionsResponse.getResults().get(i).getAsJsonObject();
String workspaceRef =
workspacePermissionObject
.get("Workspace")
.getAsJsonObject()
.get("ObjectID")
.getAsString();
workspaces.add(workspaceRef);
}
}
System.out.println("workspaces " + workspaces);
class MyRunnable implements Runnable {
private String oid;
public MyRunnable(String oid) {
this.oid = oid;
}
public void run() {
try {
getRally(this.oid);
} catch (Exception e) {
e.printStackTrace();
}
}
}
Thread[] threads = new Thread[numberOfPermissoins];
for (int i = 0; i < threads.length; i++) {
threads[i] = new Thread(new MyRunnable(workspaces.get(i)));
threads[i].start();
threads[i].join();
}
if (restApi != null) {
restApi.close();
}
}
public static void main(String[] args) throws URISyntaxException, IOException {
String host = "https://rally1.rallydev.com";
String apiKey = "_abc123";
String workspaceRef = "/workspace/12352608129";
String applicationName = "Nick: updateMilestoneCollection";
RallyRestApi restApi = new RallyRestApi(new URI(host), apiKey);
restApi.setApplicationName(applicationName);
try {
String milestoneName = "Mid January";
String storyId = "US30015";
QueryRequest milestoneRequest = new QueryRequest("Milestone");
milestoneRequest.setWorkspace(workspaceRef);
milestoneRequest.setQueryFilter(new QueryFilter("Name", "=", milestoneName));
QueryResponse milestoneQueryResponse = restApi.query(milestoneRequest);
if (milestoneQueryResponse.getTotalResultCount() == 0) {
System.out.println("Cannot find milestone: " + milestoneName);
return;
}
JsonObject milestoneJsonObject = milestoneQueryResponse.getResults().get(0).getAsJsonObject();
String milestoneRef = milestoneJsonObject.get("_ref").getAsString();
System.out.println(milestoneRef);
QueryRequest storyRequest = new QueryRequest("HierarchicalRequirement");
storyRequest.setWorkspace(workspaceRef);
storyRequest.setFetch(new Fetch("FormattedID", "Name", "Milestones"));
storyRequest.setQueryFilter(new QueryFilter("FormattedID", "=", storyId));
QueryResponse storyQueryResponse = restApi.query(storyRequest);
;
if (storyQueryResponse.getTotalResultCount() == 0) {
System.out.println("Cannot find story : " + storyId);
return;
}
JsonObject storyJsonObject = storyQueryResponse.getResults().get(0).getAsJsonObject();
String storyRef = storyJsonObject.get("_ref").getAsString();
System.out.println(storyRef);
int numberOfMilestones =
storyJsonObject.getAsJsonObject("Milestones").get("Count").getAsInt();
System.out.println(numberOfMilestones + " milestone(s) on " + storyId);
QueryRequest milestoneCollectionRequest =
new QueryRequest(storyJsonObject.getAsJsonObject("Milestones"));
milestoneCollectionRequest.setFetch(new Fetch("Name"));
JsonArray milestones = restApi.query(milestoneCollectionRequest).getResults();
for (int j = 0; j < numberOfMilestones; j++) {
System.out.println("Milestone Name: " + milestones.get(j).getAsJsonObject().get("Name"));
}
milestones.add(milestoneJsonObject);
JsonObject storyUpdate = new JsonObject();
storyUpdate.add("Milestones", milestones);
UpdateRequest updateStoryRequest = new UpdateRequest(storyRef, storyUpdate);
UpdateResponse updateStoryResponse = restApi.update(updateStoryRequest);
if (updateStoryResponse.wasSuccessful()) {
System.out.println("Successfully updated : " + storyId + " Milestones after update: ");
QueryRequest milestoneCollectionRequest2 =
new QueryRequest(storyJsonObject.getAsJsonObject("Milestones"));
milestoneCollectionRequest2.setFetch(new Fetch("Name"));
JsonArray milestonesAfterUpdate = restApi.query(milestoneCollectionRequest2).getResults();
int numberOfMilestonesAfterUpdate =
restApi.query(milestoneCollectionRequest2).getResults().size();
for (int j = 0; j < numberOfMilestonesAfterUpdate; j++) {
System.out.println(
"Milestone Name: " + milestonesAfterUpdate.get(j).getAsJsonObject().get("Name"));
}
}
} finally {
restApi.close();
}
}
