queryMgr.values(queryDef, valuesHandle); AggregateResult[] agg = valuesHandle.getAggregates(); System.out.println(agg.length); assertEquals("Invalid length", 4, agg.length);
@Test public void testValuesAggregatesFiveOccurences() throws KeyManagementException, NoSuchAlgorithmException, IOException, ParserConfigurationException, SAXException, XpathException, TransformerException { System.out.println("Running testValuesAggregatesThreeOccurences"); String[] filenames = { "aggr1.xml", "aggr2.xml", "aggr3.xml", "aggr4.xml" }; String queryOptionName = "aggregatesOpt5Occ.xml"; DatabaseClient client = getDatabaseClient("rest-admin", "x", getConnType()); // write docs for (String filename : filenames) { writeDocumentUsingInputStreamHandle(client, filename, "/values-aggr/", "XML"); } setQueryOption(client, queryOptionName); QueryManager queryMgr = client.newQueryManager(); // create query def ValuesDefinition queryDef = queryMgr.newValuesDefinition("title", "aggregatesOpt5Occ.xml"); queryDef.setAggregate("count"); queryDef.setName("title-val"); // create handle ValuesHandle valuesHandle = new ValuesHandle(); queryMgr.values(queryDef, valuesHandle); AggregateResult[] agg = valuesHandle.getAggregates(); System.out.println(agg.length); System.out.println(agg[0].getValue()); // release client client.release(); }
queryMgr.values(queryDef, valuesHandle); AggregateResult[] agg = valuesHandle.getAggregates(); assertEquals("Wrong counting", "4", agg[0].getValue());
queryMgr.values(queryDef, valuesHandle); AggregateResult[] agg = valuesHandle.getAggregates(); System.out.println(agg.length); assertEquals("Invalid length", 4, agg.length); queryMgr.values(queryDef1, valuesHandle1); AggregateResult[] agg1 = valuesHandle1.getAggregates();
@Test public void testAggregates() throws IOException, ParserConfigurationException, SAXException, ResourceNotFoundException, ForbiddenUserException, FailedRequestException, ResourceNotResendableException { String optionsName = makeValuesOptions(); QueryManager queryMgr = Common.client.newQueryManager(); ValuesDefinition vdef = queryMgr.newValuesDefinition("double", optionsName); vdef.setAggregate("sum", "avg"); vdef.setName("double"); //ValuesListDefinition vldef = queryMgr.newValuesListDefinition("valuesoptions"); //ValuesListHandle vlh = queryMgr.valuesList(vldef, new ValuesListHandle()); ValuesHandle v = queryMgr.values(vdef, new ValuesHandle()); AggregateResult[] agg = v.getAggregates(); assertEquals("There should be 2 aggregates", 2, agg.length); double first = agg[0].get("xs:double", Double.class); assertTrue("Aggregate 1 should be between 11.4 and 12", 11.4 < first && first < 12.0); double second = agg[1].get("xs:double", Double.class); logger.debug("" + second); assertTrue("Aggregate 2 should be between 1.43 and 1.44", 1.43 < second && second < 1.44); Common.adminClient.newServerConfigManager().newQueryOptionsManager().deleteOptions(optionsName); }