@Test
public void shouldGetVdbConditions() throws Exception {
loadVdbs();
// get
Properties settings =
_uriBuilder.createSettings(
SettingNames.VDB_NAME, TestUtilities.ALL_ELEMENTS_EXAMPLE_VDB_NAME);
_uriBuilder.addSetting(settings, SettingNames.DATA_ROLE_ID, "roleOne");
_uriBuilder.addSetting(settings, SettingNames.PERMISSION_ID, "myTable.T2");
URI uri = _uriBuilder.buildVdbPermissionUri(LinkType.CONDITIONS, settings);
this.response = request(uri).get();
final String entity = this.response.readEntity(String.class);
assertThat(entity, is(notNullValue()));
// System.out.println("Response:\n" + entity);
RestVdbCondition[] conditions =
KomodoJsonMarshaller.unmarshallArray(entity, RestVdbCondition[].class);
assertNotNull(conditions);
assertEquals(1, conditions.length);
RestVdbCondition condition = conditions[0];
assertEquals("col1 = user()", condition.getName());
assertFalse(condition.isConstraint());
Collection<RestLink> links = condition.getLinks();
assertEquals(3, links.size());
}
@Test
public void shouldGetVdbs() throws Exception {
loadVdbs();
// get
URI uri = _uriBuilder.generateVdbsUri();
this.response = request(uri).get();
assertTrue(response.hasEntity());
final String entities = response.readEntity(String.class);
assertThat(entities, is(notNullValue()));
// System.out.println("Response:\n" + entities);
// make sure the VDB JSON document is returned for each vdb
RestVdb[] vdbs = KomodoJsonMarshaller.unmarshallArray(entities, RestVdb[].class);
assertEquals(4, vdbs.length);
boolean foundPortfolio = false;
for (RestVdb vdb : vdbs) {
assertNotNull(vdb.getId());
assertNotNull(vdb.getDataPath());
assertNotNull(vdb.getkType());
if (TestUtilities.PORTFOLIO_VDB_NAME.equals(vdb.getId())) {
foundPortfolio = true;
assertPortfolio(vdb);
}
}
assertTrue(foundPortfolio);
}
@Test
public void shouldGetVdbMask() throws Exception {
loadVdbs();
// get
Properties settings =
_uriBuilder.createSettings(
SettingNames.VDB_NAME, TestUtilities.ALL_ELEMENTS_EXAMPLE_VDB_NAME);
_uriBuilder.addSetting(settings, SettingNames.DATA_ROLE_ID, "roleOne");
_uriBuilder.addSetting(settings, SettingNames.PERMISSION_ID, "myTable.T2.col1");
_uriBuilder.addSetting(settings, SettingNames.PERMISSION_CHILD_TYPE, LinkType.MASKS.uriName());
_uriBuilder.addSetting(settings, SettingNames.PERMISSION_CHILD_ID, "col2");
URI uri = _uriBuilder.buildVdbPermissionChildUri(LinkType.SELF, settings);
this.response = request(uri).get();
final String entity = this.response.readEntity(String.class);
assertThat(entity, is(notNullValue()));
// System.out.println("Response:\n" + entity);
RestVdbMask mask = KomodoJsonMarshaller.unmarshall(entity, RestVdbMask.class);
assertNotNull(mask);
assertEquals("col2", mask.getName());
assertEquals("1", mask.getOrder());
Collection<RestLink> links = mask.getLinks();
assertEquals(3, links.size());
}
@Test
public void shouldGetVdbPermission() throws Exception {
loadVdbs();
// get
Properties settings =
_uriBuilder.createSettings(
SettingNames.VDB_NAME, TestUtilities.ALL_ELEMENTS_EXAMPLE_VDB_NAME);
_uriBuilder.addSetting(settings, SettingNames.DATA_ROLE_ID, "roleOne");
_uriBuilder.addSetting(settings, SettingNames.PERMISSION_ID, "myTable.T1");
URI uri = _uriBuilder.buildVdbPermissionUri(LinkType.SELF, settings);
this.response = request(uri).get();
final String entity = this.response.readEntity(String.class);
assertThat(entity, is(notNullValue()));
// System.out.println("Response from uri " + uri + ":\n" + entity);
RestVdbPermission permission = KomodoJsonMarshaller.unmarshall(entity, RestVdbPermission.class);
assertNotNull(permission);
assertEquals(KomodoType.VDB_PERMISSION, permission.getkType());
assertEquals("myTable.T1", permission.getId());
assertFalse(permission.hasChildren());
assertFalse(permission.isAllowAlter());
assertFalse(permission.isAllowCreate());
assertFalse(permission.isAllowDelete());
assertFalse(permission.isAllowExecute());
assertFalse(permission.isAllowLanguage());
assertTrue(permission.isAllowRead());
assertFalse(permission.isAllowUpdate());
Collection<RestLink> links = permission.getLinks();
assertEquals(5, links.size());
}
@Test
public void shouldGetVdbTranslator() throws Exception {
loadVdbs();
// get
Properties settings =
_uriBuilder.createSettings(SettingNames.VDB_NAME, TestUtilities.TWEET_EXAMPLE_VDB_NAME);
_uriBuilder.addSetting(settings, SettingNames.TRANSLATOR_NAME, "rest");
URI uri = _uriBuilder.buildVdbTranslatorUri(LinkType.SELF, settings);
this.response = request(uri).get();
final String entity = this.response.readEntity(String.class);
assertThat(entity, is(notNullValue()));
// System.out.println("Response from uri " + uri + ":\n" + entity);
RestVdbTranslator translator = KomodoJsonMarshaller.unmarshall(entity, RestVdbTranslator.class);
assertNotNull(translator);
assertEquals(KomodoType.VDB_TRANSLATOR, translator.getkType());
assertEquals("ws", translator.getType());
assertEquals("Rest Web Service translator", translator.getDescription());
Collection<RestLink> links = translator.getLinks();
assertEquals(3, links.size());
}
@Test
public void shouldGetVdbImport() throws Exception {
loadVdbs();
// get
Properties settings =
_uriBuilder.createSettings(
SettingNames.VDB_NAME, TestUtilities.ALL_ELEMENTS_EXAMPLE_VDB_NAME);
_uriBuilder.addSetting(settings, SettingNames.IMPORT_NAME, "x");
URI uri = _uriBuilder.buildVdbImportUri(LinkType.SELF, settings);
this.response = request(uri).get();
final String entity = this.response.readEntity(String.class);
assertThat(entity, is(notNullValue()));
// System.out.println("Response from uri " + uri + ":\n" + entity);
RestVdbImport vdbImport = KomodoJsonMarshaller.unmarshall(entity, RestVdbImport.class);
assertNotNull(vdbImport);
assertEquals(KomodoType.VDB_IMPORT, vdbImport.getkType());
assertEquals("x", vdbImport.getName());
assertEquals(2, vdbImport.getVersion());
assertEquals(false, vdbImport.isImportDataPolicies());
Collection<RestLink> links = vdbImport.getLinks();
assertEquals(3, links.size());
}
@Test
public void shouldGetVdbImports() throws Exception {
loadVdbs();
// get
URI uri =
_uriBuilder.generateVdbChildGroupUri(
TestUtilities.ALL_ELEMENTS_EXAMPLE_VDB_NAME, LinkType.IMPORTS);
this.response = request(uri).get();
final String entity = this.response.readEntity(String.class);
assertThat(entity, is(notNullValue()));
// System.out.println("Response:\n" + entity);
RestVdbImport[] imports = KomodoJsonMarshaller.unmarshallArray(entity, RestVdbImport[].class);
assertNotNull(imports);
assertEquals(1, imports.length);
RestVdbImport vdbImport = imports[0];
assertEquals(KomodoType.VDB_IMPORT, vdbImport.getkType());
assertEquals("x", vdbImport.getName());
assertEquals(2, vdbImport.getVersion());
assertEquals(false, vdbImport.isImportDataPolicies());
Collection<RestLink> links = vdbImport.getLinks();
assertEquals(3, links.size());
}
@Test
public void shouldGetVdbTranslators() throws Exception {
loadVdbs();
// get
URI uri =
_uriBuilder.generateVdbChildGroupUri(
TestUtilities.TWEET_EXAMPLE_VDB_NAME, LinkType.TRANSLATORS);
this.response = request(uri).get();
final String entity = this.response.readEntity(String.class);
assertThat(entity, is(notNullValue()));
// System.out.println("Response:\n" + entity);
RestVdbTranslator[] translators =
KomodoJsonMarshaller.unmarshallArray(entity, RestVdbTranslator[].class);
assertNotNull(translators);
assertEquals(1, translators.length);
RestVdbTranslator translator = translators[0];
assertEquals(KomodoType.VDB_TRANSLATOR, translator.getkType());
assertEquals("ws", translator.getType());
assertEquals("Rest Web Service translator", translator.getDescription());
Collection<RestLink> links = translator.getLinks();
assertEquals(3, links.size());
}
@Test
public void shouldGetVdbWhenPatternMatches() throws Exception {
loadVdbs();
final String pattern = STAR + "P" + STAR;
this.response =
request(
UriBuilder.fromUri(_uriBuilder.generateVdbsUri())
.queryParam(KomodoVdbService.QueryParamKeys.PATTERN, pattern)
.build())
.get();
final String entities = response.readEntity(String.class);
assertThat(entities, is(notNullValue()));
// System.out.println("Response:\n" + entities);
// make sure the VDB JSON document is returned for each vdb
RestVdb[] vdbs = KomodoJsonMarshaller.unmarshallArray(entities, RestVdb[].class);
assertEquals(2, vdbs.length);
// Should return both MyPartsVDB_Dynamic and Portfoliio
for (RestVdb vdb : vdbs) {
if (TestUtilities.PARTS_VDB_NAME.equals(vdb.getName())) {
// Not checking this one
} else if (TestUtilities.PORTFOLIO_VDB_NAME.equals(vdb.getName())) assertPortfolio(vdb);
else fail("Invalid VDB returned from search pattern " + pattern);
}
}
@Test
public void shouldGetVdbModelSource() throws Exception {
loadVdbs();
// get
Properties settings =
_uriBuilder.createSettings(SettingNames.VDB_NAME, TestUtilities.PORTFOLIO_VDB_NAME);
_uriBuilder.addSetting(settings, SettingNames.MODEL_NAME, "PersonalValuations");
_uriBuilder.addSetting(settings, SettingNames.SOURCE_NAME, "excelconnector");
URI uri = _uriBuilder.buildVdbModelSourceUri(LinkType.SELF, settings);
this.response = request(uri).get();
final String entity = this.response.readEntity(String.class);
assertThat(entity, is(notNullValue()));
// System.out.println("Response from uri " + uri + ":\n" + entity);
RestVdbModelSource source = KomodoJsonMarshaller.unmarshall(entity, RestVdbModelSource.class);
assertNotNull(source);
assertEquals("excelconnector", source.getId());
assertEquals(KomodoType.VDB_MODEL_SOURCE, source.getkType());
assertEquals("java:/excel-file", source.getJndiName());
assertEquals("excel", source.getTranslator());
Collection<RestLink> links = source.getLinks();
assertEquals(3, links.size());
}
@Test
public void shouldGetVdbModel() throws Exception {
loadVdbs();
// get
Properties settings =
_uriBuilder.createSettings(SettingNames.VDB_NAME, TestUtilities.PORTFOLIO_VDB_NAME);
_uriBuilder.addSetting(settings, SettingNames.MODEL_NAME, "PersonalValuations");
URI uri = _uriBuilder.buildVdbModelUri(LinkType.SELF, settings);
this.response = request(uri).get();
final String entity = this.response.readEntity(String.class);
assertThat(entity, is(notNullValue()));
// System.out.println("Response from uri " + uri + ":\n" + entity);
RestVdbModel model = KomodoJsonMarshaller.unmarshall(entity, RestVdbModel.class);
assertNotNull(model);
assertEquals("PersonalValuations", model.getId());
assertEquals(KomodoType.MODEL, model.getkType());
assertEquals(true, model.isVisible());
assertEquals(Type.PHYSICAL, model.getModelType());
Collection<RestLink> links = model.getLinks();
assertEquals(4, links.size());
}
@Test
public void shouldReturnEmptyListWhenNoVdbsInWorkspace() {
this.response = request(_uriBuilder.generateVdbsUri()).get();
final String entity = this.response.readEntity(String.class);
assertThat(entity, is(notNullValue()));
// System.out.println("Response:\n" + entity);
RestVdb[] vdbs = KomodoJsonMarshaller.unmarshallArray(entity, RestVdb[].class);
assertNotNull(vdbs);
assertEquals(0, vdbs.length);
}
@Test
public void shouldGetVdbImportsEmptyList() throws Exception {
loadVdbs();
// get
URI uri =
_uriBuilder.generateVdbChildGroupUri(TestUtilities.PORTFOLIO_VDB_NAME, LinkType.IMPORTS);
this.response = request(uri).get();
final String entity = this.response.readEntity(String.class);
assertThat(entity, is(notNullValue()));
// System.out.println("Response:\n" + entity);
RestVdbImport[] imports = KomodoJsonMarshaller.unmarshallArray(entity, RestVdbImport[].class);
assertNotNull(imports);
assertEquals(0, imports.length);
}
@Test
public void shouldGetVdb() throws Exception {
loadVdbs();
// get
Properties settings =
_uriBuilder.createSettings(SettingNames.VDB_NAME, TestUtilities.PORTFOLIO_VDB_NAME);
this.response = request(_uriBuilder.buildVdbUri(LinkType.SELF, settings)).get();
final String entity = this.response.readEntity(String.class);
assertThat(entity, is(notNullValue()));
// System.out.println("Response:\n" + entity);
RestVdb vdb = KomodoJsonMarshaller.unmarshall(entity, RestVdb.class);
assertNotNull(vdb);
assertPortfolio(vdb);
}
@Test
public void shouldLimitNumberOfVdbsReturnedWhenUsingStartQueryParameter() throws Exception {
loadVdbs();
final int start = 3;
this.response =
request(
UriBuilder.fromUri(_uriBuilder.generateVdbsUri())
.queryParam(KomodoVdbService.QueryParamKeys.START, start)
.build())
.get();
final String entities = response.readEntity(String.class);
assertThat(entities, is(notNullValue()));
// System.out.println("Response:\n" + entities);
// make sure the VDB JSON document is returned for each vdb
RestVdb[] vdbs = KomodoJsonMarshaller.unmarshallArray(entities, RestVdb[].class);
assertEquals(1, vdbs.length);
}
@Test
public void shouldGetVdbDataRoles() throws Exception {
loadVdbs();
// get
URI uri =
_uriBuilder.generateVdbChildGroupUri(
TestUtilities.ALL_ELEMENTS_EXAMPLE_VDB_NAME, LinkType.DATA_ROLES);
this.response = request(uri).get();
final String entity = this.response.readEntity(String.class);
assertThat(entity, is(notNullValue()));
// System.out.println("Response:\n" + entity);
RestVdbDataRole[] dataRoles =
KomodoJsonMarshaller.unmarshallArray(entity, RestVdbDataRole[].class);
assertNotNull(dataRoles);
assertEquals(1, dataRoles.length);
RestVdbDataRole dataRole = dataRoles[0];
assertEquals(KomodoType.VDB_DATA_ROLE, dataRole.getkType());
assertEquals("roleOne", dataRole.getName());
assertEquals("roleOne described", dataRole.getDescription());
assertEquals(true, dataRole.isAllowCreateTempTables());
assertEquals(false, dataRole.isAnyAuthenticated());
assertEquals(true, dataRole.isGrantAll());
assertEquals(2, dataRole.getMappedRoles().length);
assertTrue(
dataRole.getMappedRoles()[0].equals("ROLE1")
|| dataRole.getMappedRoles()[0].equals("ROLE2"));
assertTrue(
dataRole.getMappedRoles()[1].equals("ROLE1")
|| dataRole.getMappedRoles()[1].equals("ROLE2"));
Collection<RestLink> links = dataRole.getLinks();
assertEquals(4, links.size());
}
@Test
public void shouldGetVdbModelSourcesIncludeReferenceForTranslator() throws Exception {
loadVdbs();
// get
Properties settings =
_uriBuilder.createSettings(SettingNames.VDB_NAME, TestUtilities.TWEET_EXAMPLE_VDB_NAME);
_uriBuilder.addSetting(settings, SettingNames.MODEL_NAME, "twitter");
URI uri = _uriBuilder.buildVdbModelUri(LinkType.SOURCES, settings);
this.response = request(uri).get();
final String entities = this.response.readEntity(String.class);
assertThat(entities, is(notNullValue()));
// System.out.println("Response from uri " + uri + ":\n" + entities);
RestVdbModelSource[] sources =
KomodoJsonMarshaller.unmarshallArray(entities, RestVdbModelSource[].class);
assertEquals(1, sources.length);
RestVdbModelSource source = sources[0];
assertEquals("twitter", source.getId());
assertEquals(KomodoType.VDB_MODEL_SOURCE, source.getkType());
assertEquals("java:/twitterDS", source.getJndiName());
assertEquals("rest", source.getTranslator());
Collection<RestLink> links = source.getLinks();
assertEquals(4, links.size());
RestLink refLink = null;
for (RestLink link : links) {
if (LinkType.REFERENCE.equals(link.getRel())) refLink = link;
}
assertNotNull(refLink);
URI href = refLink.getHref();
assertTrue(href.toString().endsWith("/v1/workspace/vdbs/twitter/VdbTranslators/rest"));
}
@Test
public void shouldGetVdbDataRole() throws Exception {
loadVdbs();
// get
Properties settings =
_uriBuilder.createSettings(
SettingNames.VDB_NAME, TestUtilities.ALL_ELEMENTS_EXAMPLE_VDB_NAME);
_uriBuilder.addSetting(settings, SettingNames.DATA_ROLE_ID, "roleOne");
URI uri = _uriBuilder.buildVdbDataRoleUri(LinkType.SELF, settings);
this.response = request(uri).get();
final String entity = this.response.readEntity(String.class);
assertThat(entity, is(notNullValue()));
// System.out.println("Response from uri " + uri + ":\n" + entity);
RestVdbDataRole dataRole = KomodoJsonMarshaller.unmarshall(entity, RestVdbDataRole.class);
assertNotNull(dataRole);
assertEquals(KomodoType.VDB_DATA_ROLE, dataRole.getkType());
assertEquals("roleOne", dataRole.getName());
assertEquals("roleOne described", dataRole.getDescription());
assertEquals(true, dataRole.isAllowCreateTempTables());
assertEquals(false, dataRole.isAnyAuthenticated());
assertEquals(true, dataRole.isGrantAll());
assertEquals(2, dataRole.getMappedRoles().length);
assertTrue(
dataRole.getMappedRoles()[0].equals("ROLE1")
|| dataRole.getMappedRoles()[0].equals("ROLE2"));
assertTrue(
dataRole.getMappedRoles()[1].equals("ROLE1")
|| dataRole.getMappedRoles()[1].equals("ROLE2"));
Collection<RestLink> links = dataRole.getLinks();
assertEquals(4, links.size());
}
@Test
public void shouldGetVdbModels() throws Exception {
loadVdbs();
// get
URI uri =
_uriBuilder.generateVdbChildGroupUri(TestUtilities.PORTFOLIO_VDB_NAME, LinkType.MODELS);
this.response = request(uri).get();
final String entity = this.response.readEntity(String.class);
assertThat(entity, is(notNullValue()));
// System.out.println("Response:\n" + entity);
RestVdbModel[] models = KomodoJsonMarshaller.unmarshallArray(entity, RestVdbModel[].class);
assertNotNull(models);
assertEquals(5, models.length);
for (RestVdbModel model : models) {
assertEquals(KomodoType.MODEL, model.getkType());
assertEquals(true, model.isVisible());
if ("MarketData".equals(model.getId())) {
assertEquals(Type.PHYSICAL, model.getModelType());
} else if ("Accounts".equals(model.getId())) {
assertEquals(Type.PHYSICAL, model.getModelType());
} else if ("PersonalValuations".equals(model.getId())) {
assertEquals(Type.PHYSICAL, model.getModelType());
} else if ("Stocks".equals(model.getId())) {
assertEquals(Type.VIRTUAL, model.getModelType());
} else if ("StocksMatModel".equals(model.getId())) {
assertEquals(Type.VIRTUAL, model.getModelType());
} else fail("Model has invalid id");
Collection<RestLink> links = model.getLinks();
assertEquals(4, links.size());
}
}