public void testBackwardCompatibility() throws RegistryException {
Registry rootRegistry = embeddedRegistryService.getSystemRegistry();
Resource r1 = rootRegistry.newResource();
r1.setContent("r1 content");
rootRegistry.put("/test/comments/r1", r1);
rootRegistry.addComment(
"/test/comments/r1", new Comment("backward-compatibility1 on this resource :)"));
rootRegistry.addComment(
"/test/comments/r1", new Comment("backward-compatibility2 on this resource :)"));
String sql =
"SELECT REG_COMMENT_ID FROM REG_COMMENT C, REG_RESOURCE_COMMENT RC "
+ "WHERE C.REG_COMMENT_TEXT LIKE ? AND C.REG_ID=RC.REG_COMMENT_ID";
Resource queryR = rootRegistry.newResource();
queryR.setMediaType(RegistryConstants.SQL_QUERY_MEDIA_TYPE);
queryR.addProperty(
RegistryConstants.RESULT_TYPE_PROPERTY_NAME, RegistryConstants.COMMENTS_RESULT_TYPE);
rootRegistry.put("/beep/x", queryR);
Map<String, String> params = new HashMap<String, String>();
params.put("query", sql);
params.put(RegistryConstants.RESULT_TYPE_PROPERTY_NAME, RegistryConstants.COMMENTS_RESULT_TYPE);
params.put("1", "backward-compatibility1%");
Collection qResults = rootRegistry.executeQuery("/beep/x", params);
String[] qPaths = (String[]) qResults.getContent();
assertEquals("Query result count should be 1", qPaths.length, 1);
}
/**
* Method to obtain a list of paths having resources of the given media type.
*
* @param registry the registry instance to run query on.
* @param mediaType the media type.
* @return an array of resource paths.
* @throws RegistryException if the operation failed.
*/
public static String[] getResultPaths(Registry registry, String mediaType)
throws RegistryException {
String[] result;
String[] paginatedResult;
try {
Map<String, String> parameter = new HashMap<String, String>();
parameter.put("1", mediaType);
parameter.put(
"query",
"SELECT DISTINCT REG_PATH_ID, REG_NAME FROM REG_RESOURCE WHERE REG_MEDIA_TYPE=?");
result = (String[]) registry.executeQuery(null, parameter).getContent();
if (result == null || result.length == 0) {
return new String[0];
}
result = removeMountPaths(result, registry);
MessageContext messageContext = MessageContext.getCurrentMessageContext();
if (PaginationUtils.isPaginationAnnotationFound("getPaginatedGovernanceArtifacts")
&& ((messageContext != null && PaginationUtils.isPaginationHeadersExist(messageContext))
|| PaginationContext.getInstance() != null)) {
int rowCount = result.length;
PaginationContext paginationContext;
try {
if (messageContext != null) {
PaginationUtils.setRowCount(messageContext, Integer.toString(rowCount));
paginationContext = PaginationUtils.initPaginationContext(messageContext);
} else {
paginationContext = PaginationContext.getInstance();
}
int start = paginationContext.getStart();
int count = paginationContext.getCount();
int startIndex;
if (start == 1) {
startIndex = 0;
} else {
startIndex = start;
}
if (rowCount < start + count) {
paginatedResult = new String[rowCount - startIndex];
System.arraycopy(result, startIndex, paginatedResult, 0, (rowCount - startIndex));
} else {
paginatedResult = new String[count];
System.arraycopy(result, startIndex, paginatedResult, 0, count);
}
return paginatedResult;
} finally {
PaginationContext.destroy();
}
}
} catch (RegistryException e) {
String msg = "Error in getting the result for media type: " + mediaType + ".";
log.error(msg, e);
throw new RegistryException(msg, e);
}
return result;
}
public void testDefaultQuery() throws Exception {
Resource r1 = registry.newResource();
String r1Content = "this is r1 content";
r1.setContent(r1Content.getBytes());
r1.setDescription("production ready.");
String r1Path = "/c3/r1";
registry.put(r1Path, r1);
Resource r2 = registry.newResource();
String r2Content = "content for r2 :)";
r2.setContent(r2Content);
r2.setDescription("ready for production use.");
String r2Path = "/c3/r2";
registry.put(r2Path, r2);
Resource r3 = registry.newResource();
String r3Content = "content for r3 :)";
r3.setContent(r3Content);
r3.setDescription("only for government use.");
String r3Path = "/c3/r3";
registry.put(r3Path, r3);
registry.applyTag("/c3/r1", "java");
registry.applyTag("/c3/r2", "jsp");
registry.applyTag("/c3/r3", "ajax");
String sql1 =
"SELECT RT.REG_TAG_ID FROM REG_RESOURCE_TAG RT, REG_RESOURCE R "
+ "WHERE (R.REG_VERSION=RT.REG_VERSION OR "
+ "(R.REG_PATH_ID=RT.REG_PATH_ID AND R.REG_NAME=RT.REG_RESOURCE_NAME)) "
+ "AND R.REG_DESCRIPTION LIKE ? ORDER BY RT.REG_TAG_ID";
Resource q1 = systemRegistry.newResource();
q1.setContent(sql1);
q1.setMediaType(RegistryConstants.SQL_QUERY_MEDIA_TYPE);
q1.addProperty(RegistryConstants.RESULT_TYPE_PROPERTY_NAME, RegistryConstants.TAGS_RESULT_TYPE);
systemRegistry.put("/qs/q3", q1);
Map<String, String> parameters = new HashMap<String, String>();
parameters.put("1", "%production%");
Collection result = registry.executeQuery("/qs/q3", parameters);
String[] tagPaths = result.getChildren();
assertEquals("There should be two matching tags.", tagPaths.length, 2);
Resource tag2 = registry.get(tagPaths[0]);
assertEquals("First matching tag should be 'java'", (String) tag2.getContent(), "java");
Resource tag1 = registry.get(tagPaths[1]);
assertEquals("Second matching tag should be 'jsp'", (String) tag1.getContent(), "jsp");
}
public void testWithoutTableParamsQuery() throws Exception {
Resource r1 = registry.newResource();
String r1Content = "this is r1 content";
r1.setContent(r1Content.getBytes());
r1.setDescription("production ready.");
String r1Path = "/c1/r1";
registry.put(r1Path, r1);
Resource r2 = registry.newResource();
String r2Content = "content for r2 :)";
r2.setContent(r2Content);
r2.setDescription("ready for production use.");
String r2Path = "/c2/r2";
registry.put(r2Path, r2);
Resource r3 = registry.newResource();
String r3Content = "content for r3 :)";
r3.setContent(r3Content);
r3.setDescription("only for government use.");
String r3Path = "/c2/r3";
registry.put(r3Path, r3);
String sql1 =
"SELECT REG_PATH_ID, REG_NAME FROM REG_RESOURCE, " + "REG_TAG WHERE REG_DESCRIPTION LIKE ?";
Resource q1 = systemRegistry.newResource();
q1.setContent(sql1);
q1.setMediaType(RegistryConstants.SQL_QUERY_MEDIA_TYPE);
q1.addProperty(
RegistryConstants.RESULT_TYPE_PROPERTY_NAME, RegistryConstants.RESOURCES_RESULT_TYPE);
systemRegistry.put("/qs/q1", q1);
Map<String, String> parameters = new HashMap<String, String>();
parameters.put("1", "%production%");
Resource result = registry.executeQuery("/qs/q1", parameters);
assertTrue(
"Search with result type Resource should return a directory.",
result instanceof org.wso2.carbon.registry.core.Collection);
List<String> matchingPaths = new ArrayList<String>();
String[] paths = (String[]) result.getContent();
matchingPaths.addAll(Arrays.asList(paths));
assertTrue("Path /c1/r1 should be in the results.", matchingPaths.contains("/c1/r1"));
assertTrue("Path /c2/r2 should be in the results.", matchingPaths.contains("/c2/r2"));
}
public void testWithoutWhereQuery() throws Exception {
Resource r1 = registry.newResource();
String r1Content = "this is r1 content";
r1.setContent(r1Content.getBytes());
r1.setDescription("production ready.");
String r1Path = "/c1/r1";
registry.put(r1Path, r1);
Resource r2 = registry.newResource();
String r2Content = "content for r2 :)";
r2.setContent(r2Content);
r2.setDescription("ready for production use.");
String r2Path = "/c2/r2";
registry.put(r2Path, r2);
Resource r3 = registry.newResource();
String r3Content = "content for r3 :)";
r3.setContent(r3Content);
r3.setDescription("only for government use.");
String r3Path = "/c2/r3";
registry.put(r3Path, r3);
String sql1 = "SELECT REG_PATH_ID, REG_NAME FROM REG_RESOURCE, REG_TAG";
Resource q1 = systemRegistry.newResource();
q1.setContent(sql1);
q1.setMediaType(RegistryConstants.SQL_QUERY_MEDIA_TYPE);
q1.addProperty(
RegistryConstants.RESULT_TYPE_PROPERTY_NAME, RegistryConstants.RESOURCES_RESULT_TYPE);
systemRegistry.put("/qs/q1", q1);
Map parameters = new HashMap();
Resource result = registry.executeQuery("/qs/q1", parameters);
assertTrue(
"Search with result type Resource should return a directory.",
result instanceof org.wso2.carbon.registry.core.Collection);
String[] paths = (String[]) result.getContent();
assertTrue("Should return all the resources", paths.length >= 3);
}
/**
* Simulates a configSystemRegistry operation.
*
* <p>Operation criteria: get - path put - path, resourcePath (existing resource), optional :
* mediaType resourceExists - path delete - path importResource - path, param1 (URL: source URL),
* optional : mediaType copy - path, param1 (target path) move - path, param1 (target path) rename
* - path, param1 (target path) removeLink - path createLink - path, param1 (target path),
* optional : param2 (target sub-path) invokeAspect - path, param1 (aspect name), param2 (action)
* addAssociation - path, param1 (target path), param2 (association type) removeAssociation -
* path, param1 (target path), param2 (association type) getAssociations - path, param1
* (association type) getAllAssociations - path createVersion - path restoreVersion - path
* getVersions - path applyTag - path, param1 (tag) removeTag - path, param1 (tag) getTags - path
* getResourcePathsWithTag - param1 (tag) rateResource - path, param1 (Number: rating) getRating -
* path, param1 (username) getAverageRating - path addComment - path, param1 (comment)
* removeComment - path editComment - path, param1 (comment) getComments - path searchContent -
* param1 (keywords) executeQuery - param1 (Map: parameters, ex:- key1:val1,key2:val2,...),
* optional: path
*
* <p>Operations not-supported dump restore
*
* @param simulationRequest the simulation request.
* @throws Exception if an exception occurs while executing any operation, or if an invalid
* parameter was entered.
*/
public static void simulateRegistryOperation(
Registry rootRegistry, SimulationRequest simulationRequest) throws Exception {
String operation = simulationRequest.getOperation();
if (operation == null) {
return;
}
if (operation.toLowerCase().equals("get")) {
String path = simulationRequest.getPath();
if (isInvalidateValue(path)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.get(path);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("resourceexists")) {
String path = simulationRequest.getPath();
if (isInvalidateValue(path)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.resourceExists(path);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("put")) {
String path = simulationRequest.getPath();
String resourcePath = simulationRequest.getResourcePath();
String type = null;
String[] params = simulationRequest.getParameters();
if (params != null && params.length >= 1) {
type = params[0];
}
if (isInvalidateValue(path) || isInvalidateValue(type)) {
return;
}
Resource resource;
if (!isInvalidateValue(resourcePath) && rootRegistry.resourceExists(resourcePath)) {
resource = rootRegistry.get(resourcePath);
} else if (type.toLowerCase().equals("collection")) {
resource = rootRegistry.newCollection();
} else {
resource = rootRegistry.newResource();
}
simulationService.setSimulation(true);
resource.setMediaType(simulationRequest.getMediaType());
rootRegistry.put(path, resource);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("delete")) {
String path = simulationRequest.getPath();
if (isInvalidateValue(path)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.delete(path);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("importresource")) {
String path = simulationRequest.getPath();
String sourceURL = null;
String[] params = simulationRequest.getParameters();
if (params != null && params.length >= 1) {
sourceURL = params[0];
}
if (isInvalidateValue(path) || isInvalidateValue(sourceURL)) {
return;
}
simulationService.setSimulation(true);
Resource resource = rootRegistry.newResource();
resource.setMediaType(simulationRequest.getMediaType());
rootRegistry.importResource(path, sourceURL, resource);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("rename")) {
String path = simulationRequest.getPath();
String target = null;
String[] params = simulationRequest.getParameters();
if (params != null && params.length >= 1) {
target = params[0];
}
if (isInvalidateValue(path) || isInvalidateValue(target)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.rename(path, target);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("move")) {
String path = simulationRequest.getPath();
String target = null;
String[] params = simulationRequest.getParameters();
if (params != null && params.length >= 1) {
target = params[0];
}
if (isInvalidateValue(path) || isInvalidateValue(target)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.move(path, target);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("copy")) {
String path = simulationRequest.getPath();
String target = null;
String[] params = simulationRequest.getParameters();
if (params != null && params.length >= 1) {
target = params[0];
}
if (isInvalidateValue(path) || isInvalidateValue(target)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.copy(path, target);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("removelink")) {
String path = simulationRequest.getPath();
if (isInvalidateValue(path)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.removeLink(path);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("createlink")) {
String path = simulationRequest.getPath();
String target = null;
String targetSubPath = null;
String[] params = simulationRequest.getParameters();
if (params != null && params.length > 0) {
target = params[0];
if (params.length > 1) {
targetSubPath = params[1];
}
}
if (isInvalidateValue(path) || isInvalidateValue(target)) {
return;
}
simulationService.setSimulation(true);
if (isInvalidateValue(targetSubPath)) {
rootRegistry.createLink(path, target);
} else {
rootRegistry.createLink(path, target, targetSubPath);
}
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("invokeaspect")) {
String path = simulationRequest.getPath();
String aspectName = null;
String action = null;
String[] params = simulationRequest.getParameters();
if (params != null && params.length >= 2) {
aspectName = params[0];
action = params[1];
}
if (isInvalidateValue(path) || isInvalidateValue(aspectName) || isInvalidateValue(action)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.invokeAspect(path, aspectName, action);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("addassociation")) {
String path = simulationRequest.getPath();
String target = null;
String associationType = null;
String[] params = simulationRequest.getParameters();
if (params != null && params.length >= 2) {
target = params[0];
associationType = params[1];
}
if (isInvalidateValue(path)
|| isInvalidateValue(target)
|| isInvalidateValue(associationType)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.addAssociation(path, target, associationType);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("removeassociation")) {
String path = simulationRequest.getPath();
String target = null;
String associationType = null;
String[] params = simulationRequest.getParameters();
if (params != null && params.length >= 2) {
target = params[0];
associationType = params[1];
}
if (isInvalidateValue(path)
|| isInvalidateValue(target)
|| isInvalidateValue(associationType)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.removeAssociation(path, target, associationType);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("getassociations")) {
String path = simulationRequest.getPath();
String associationType = null;
String[] params = simulationRequest.getParameters();
if (params != null && params.length >= 1) {
associationType = params[0];
}
if (isInvalidateValue(path) || isInvalidateValue(associationType)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.getAssociations(path, associationType);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("getallassociations")) {
String path = simulationRequest.getPath();
if (isInvalidateValue(path)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.getAllAssociations(path);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("createversion")) {
String path = simulationRequest.getPath();
if (isInvalidateValue(path)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.createVersion(path);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("restoreversion")) {
String path = simulationRequest.getPath();
if (isInvalidateValue(path)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.restoreVersion(path);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("getversions")) {
String path = simulationRequest.getPath();
if (isInvalidateValue(path)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.getVersions(path);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("applytag")) {
String path = simulationRequest.getPath();
String tag = null;
String[] params = simulationRequest.getParameters();
if (params != null && params.length >= 1) {
tag = params[0];
}
if (isInvalidateValue(path) || isInvalidateValue(tag)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.applyTag(path, tag);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("removetag")) {
String path = simulationRequest.getPath();
String tag = null;
String[] params = simulationRequest.getParameters();
if (params != null && params.length >= 1) {
tag = params[0];
}
if (isInvalidateValue(path) || isInvalidateValue(tag)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.removeTag(path, tag);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("gettags")) {
String path = simulationRequest.getPath();
if (isInvalidateValue(path)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.getTags(path);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("getresourcepathswithtag")) {
String tag = null;
String[] params = simulationRequest.getParameters();
if (params != null && params.length >= 1) {
tag = params[0];
}
if (isInvalidateValue(tag)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.getResourcePathsWithTag(tag);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("rateresource")) {
String path = simulationRequest.getPath();
int rating = -1;
String[] params = simulationRequest.getParameters();
if (params != null && params.length >= 1) {
try {
rating = Integer.parseInt(params[0]);
} catch (NumberFormatException ignored) {
return;
}
}
if (isInvalidateValue(path) || rating == -1) {
return;
}
simulationService.setSimulation(true);
rootRegistry.rateResource(path, rating);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("getrating")) {
String path = simulationRequest.getPath();
String username = null;
String[] params = simulationRequest.getParameters();
if (params != null && params.length >= 1) {
username = params[0];
}
if (isInvalidateValue(path) || isInvalidateValue(username)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.getRating(path, username);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("getaveragerating")) {
String path = simulationRequest.getPath();
if (isInvalidateValue(path)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.getAverageRating(path);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("addcomment")) {
String path = simulationRequest.getPath();
String comment = null;
String[] params = simulationRequest.getParameters();
if (params != null && params.length >= 1) {
comment = params[0];
}
if (isInvalidateValue(path) || isInvalidateValue(comment)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.addComment(path, new Comment(comment));
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("editcomment")) {
String path = simulationRequest.getPath();
String comment = null;
String[] params = simulationRequest.getParameters();
if (params != null && params.length >= 1) {
comment = params[0];
}
if (isInvalidateValue(path) || isInvalidateValue(comment)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.editComment(path, comment);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("removeComment")) {
String path = simulationRequest.getPath();
if (isInvalidateValue(path)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.removeComment(path);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("getcomments")) {
String path = simulationRequest.getPath();
if (isInvalidateValue(path)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.getComments(path);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("searchcontent")) {
String keywords = null;
String[] params = simulationRequest.getParameters();
if (params != null && params.length >= 1) {
keywords = params[0];
}
if (isInvalidateValue(keywords)) {
return;
}
simulationService.setSimulation(true);
rootRegistry.searchContent(keywords);
simulationService.setSimulation(false);
} else if (operation.toLowerCase().equals("executequery")) {
String path = simulationRequest.getPath();
String queryParams = null;
String[] params = simulationRequest.getParameters();
if (params != null && params.length >= 1) {
queryParams = params[0];
}
Map<String, String> paramMap = new LinkedHashMap<String, String>();
if (isInvalidateValue(queryParams)) {
return;
}
String[] entries = queryParams.split(",");
if (entries != null) {
for (String entry : entries) {
String[] keyValPair = entry.split(":");
if (keyValPair != null && keyValPair.length == 2) {
paramMap.put(keyValPair[0], keyValPair[1]);
}
}
}
simulationService.setSimulation(true);
rootRegistry.executeQuery(path, paramMap);
simulationService.setSimulation(false);
} else {
throw new Exception("Unsupported Registry Operation: " + operation);
}
}