/**
* Create some instances for a given BO and validate if they can be queried:
*
* <ul>
* <li>where the qualified business object id is set
* <li>the primary key is passed to findForBusinessObject()
* <li>the qualified business object id is passed to findForBusinessObject and the primary key
* is set as a data filter
* <li>the qualified business object id is passed to findForBusinessObject and an attribute of
* the BO is set as a data filter
* </ul>
*/
@Test
public void CheckFiltering() throws Exception {
DeployedModelDescription model =
sf.getQueryService().getModels(DeployedModelQuery.findActiveForId(MODEL_NAME3)).get(0);
String businessObjectQualifiedId = new QName(model.getId(), "Fund").toString();
for (int i = 1; i <= 9; i++) {
final Map<String, Object> fund = CollectionUtils.newMap();
fund.put("AccountNumber", "100100" + i);
fund.put("AccountName", "Fund" + i);
sf.getWorkflowService()
.createBusinessObjectInstance(businessObjectQualifiedId, (Serializable) fund);
}
BusinessObjectQuery query =
BusinessObjectQuery.findForBusinessObject(businessObjectQualifiedId);
query.setPolicy(new BusinessObjectQuery.Policy(BusinessObjectQuery.Option.WITH_VALUES));
BusinessObjects bos = sf.getQueryService().getAllBusinessObjects(query);
Assert.assertEquals("Objects", 1, bos.getSize());
BusinessObject bo = bos.get(0);
List<BusinessObject.Value> values = bo.getValues();
Assert.assertEquals("Values", 9, values.size());
query = BusinessObjectQuery.findWithPrimaryKey(businessObjectQualifiedId, "1001003");
query.setPolicy(new BusinessObjectQuery.Policy(BusinessObjectQuery.Option.WITH_VALUES));
bos = sf.getQueryService().getAllBusinessObjects(query);
Assert.assertEquals("Objects", 1, bos.getSize());
bo = bos.get(0);
values = bo.getValues();
Assert.assertEquals("Values", 1, values.size());
checkValue(values, true, "AccountNumber", "1001003");
query = BusinessObjectQuery.findForBusinessObject(businessObjectQualifiedId);
query.where(DataFilter.isEqual("Fund", "AccountNumber", "1001005"));
query.setPolicy(new BusinessObjectQuery.Policy(BusinessObjectQuery.Option.WITH_VALUES));
bos = sf.getQueryService().getAllBusinessObjects(query);
Assert.assertEquals("Objects", 1, bos.getSize());
bo = bos.get(0);
values = bo.getValues();
Assert.assertEquals("Values", 1, values.size());
checkValue(values, true, "AccountNumber", "1001005");
query = BusinessObjectQuery.findForBusinessObject(businessObjectQualifiedId);
query.where(DataFilter.isEqual("Fund", "AccountName", "Fund7"));
query.setPolicy(new BusinessObjectQuery.Policy(BusinessObjectQuery.Option.WITH_VALUES));
bos = sf.getQueryService().getAllBusinessObjects(query);
Assert.assertEquals("Objects", 1, bos.getSize());
bo = bos.get(0);
values = bo.getValues();
Assert.assertEquals("Values", 1, values.size());
checkValue(values, true, "AccountName", "Fund7");
}
/**
* Create some instances for a given BO and validate if they can be queried where:
*
* <ul>
* <li>the qualified business object id is set
* <li>the primary key is passed to findForBusinessObject()
* <li>the qualified business object id is passed to findForBusinessObject and an attribute of
* the BO is set as a data filter
* <li>the qualified business object id is passed to findForBusinessObject and the query is
* restricted to the currently active model
* <li>the qualified business object id is passed to findForBusinessObject and across all
* deployed model versions
* <li>the qualified business object id is passed to findForBusinessObject and the query is
* restricted to a given modelOid
* </ul>
*/
@Test
public void CheckFiltering2() throws Exception {
DeployedModelDescription model =
sf.getQueryService().getModels(DeployedModelQuery.findActiveForId(MODEL_NAME3)).get(0);
String businessObjectQualifiedId = new QName(model.getId(), "Employee").toString();
createEmployee(businessObjectQualifiedId, "1", "Florin");
createEmployee(businessObjectQualifiedId, "Sid", "2");
BusinessObjectQuery query =
BusinessObjectQuery.findForBusinessObject(businessObjectQualifiedId);
query.setPolicy(new BusinessObjectQuery.Policy(BusinessObjectQuery.Option.WITH_VALUES));
BusinessObjects bos = sf.getQueryService().getAllBusinessObjects(query);
Assert.assertEquals("Objects", 1, bos.getSize());
BusinessObject bo = bos.get(0);
List<BusinessObject.Value> values = bo.getValues();
Assert.assertEquals("Values", 2, values.size());
query = BusinessObjectQuery.findWithPrimaryKey(businessObjectQualifiedId, "1");
query.setPolicy(new BusinessObjectQuery.Policy(BusinessObjectQuery.Option.WITH_VALUES));
bos = sf.getQueryService().getAllBusinessObjects(query);
Assert.assertEquals("Objects", 1, bos.getSize());
bo = bos.get(0);
values = bo.getValues();
Assert.assertEquals("Values", 1, values.size());
checkValue(values, true, "EmpID", "1");
query = BusinessObjectQuery.findWithPrimaryKey(businessObjectQualifiedId, "Sid");
query.setPolicy(new BusinessObjectQuery.Policy(BusinessObjectQuery.Option.WITH_VALUES));
bos = sf.getQueryService().getAllBusinessObjects(query);
Assert.assertEquals("Objects", 1, bos.getSize());
bo = bos.get(0);
values = bo.getValues();
Assert.assertEquals("Values", 1, values.size());
checkValue(values, true, "EmpID", "Sid");
query = BusinessObjectQuery.findForBusinessObject(businessObjectQualifiedId);
query.where(DataFilter.isEqual("Employee", "EmpName", "2"));
query.setPolicy(new BusinessObjectQuery.Policy(BusinessObjectQuery.Option.WITH_VALUES));
bos = sf.getQueryService().getAllBusinessObjects(query);
Assert.assertEquals("Objects", 1, bos.getSize());
bo = bos.get(0);
values = bo.getValues();
Assert.assertEquals("Values", 1, values.size());
checkValue(values, true, "EmpName", "2");
query = BusinessObjectQuery.findForBusinessObject(businessObjectQualifiedId);
query.where(DataFilter.isEqual("Employee", "EmpName", "Florin"));
query.setPolicy(new BusinessObjectQuery.Policy(BusinessObjectQuery.Option.WITH_VALUES));
bos = sf.getQueryService().getAllBusinessObjects(query);
Assert.assertEquals("Objects", 1, bos.getSize());
bo = bos.get(0);
values = bo.getValues();
Assert.assertEquals("Values", 1, values.size());
checkValue(values, true, "EmpName", "Florin");
RtEnvHome.deployModel(sf.getAdministrationService(), null, MODEL_NAME3);
createEmployee(businessObjectQualifiedId, "3", "Meyer");
query =
BusinessObjectQuery.findForBusinessObject(
PredefinedConstants.ACTIVE_MODEL, businessObjectQualifiedId);
query.setPolicy(new BusinessObjectQuery.Policy(BusinessObjectQuery.Option.WITH_VALUES));
bos = sf.getQueryService().getAllBusinessObjects(query);
Assert.assertEquals("Objects", 1, bos.getSize());
bo = bos.get(0);
values = bo.getValues();
Assert.assertEquals("Values", 1, values.size());
query = BusinessObjectQuery.findForBusinessObject(businessObjectQualifiedId);
query.setPolicy(new BusinessObjectQuery.Policy(BusinessObjectQuery.Option.WITH_VALUES));
bos = sf.getQueryService().getAllBusinessObjects(query);
Assert.assertEquals("Objects", 2, bos.getSize());
Assert.assertEquals("Values", 3, getTotalSize(bos));
query =
BusinessObjectQuery.findForBusinessObject(model.getModelOID(), businessObjectQualifiedId);
query.setPolicy(new BusinessObjectQuery.Policy(BusinessObjectQuery.Option.WITH_VALUES));
bos = sf.getQueryService().getAllBusinessObjects(query);
Assert.assertEquals("Objects", 1, bos.getSize());
bo = bos.get(0);
values = bo.getValues();
Assert.assertEquals("Values", 2, values.size());
}
