use of javax.jcr.query.RowIterator in project jackrabbit by apache.
the class IndexingRuleTest method testUseInExcerptWithAggregate.
public void testUseInExcerptWithAggregate() throws RepositoryException {
Node node = testRootNode.addNode(nodeName1, NT_UNSTRUCTURED);
node.setProperty("rule", "excerpt");
node.setProperty("title", "Apache Jackrabbit");
node.setProperty("text", "Jackrabbit is a JCR implementation");
Node aggregated = node.addNode("aggregated-node", NT_UNSTRUCTURED);
aggregated.setProperty("rule", "excerpt");
aggregated.setProperty("title", "Apache Jackrabbit");
aggregated.setProperty("text", "Jackrabbit is a JCR implementation");
testRootNode.save();
String stmt = "/jcr:root" + testRootNode.getPath() + "/*[jcr:contains(., 'jackrabbit')]/rep:excerpt(.)";
RowIterator rows = executeQuery(stmt).getRows();
assertTrue("No results returned", rows.hasNext());
Value excerpt;
while (rows.hasNext()) {
excerpt = rows.nextRow().getValue("rep:excerpt(.)");
assertNotNull("No excerpt created", excerpt);
assertTrue("Title must not be present in excerpt", excerpt.getString().indexOf("Apache") == -1);
int idx = 0;
int numHighlights = 0;
for (; ; ) {
idx = excerpt.getString().indexOf("<strong>", idx);
if (idx == -1) {
break;
}
numHighlights++;
int endIdx = excerpt.getString().indexOf("</strong>", idx);
assertEquals("wrong highlight", "Jackrabbit", excerpt.getString().substring(idx + "<strong>".length(), endIdx));
idx = endIdx;
}
assertTrue("Missing highlight", numHighlights > 0);
}
stmt = "/jcr:root" + testRootNode.getPath() + "/*[jcr:contains(., 'apache')]/rep:excerpt(.)";
rows = executeQuery(stmt).getRows();
assertTrue("No results returned", rows.hasNext());
excerpt = rows.nextRow().getValue("rep:excerpt(.)");
assertNotNull("No excerpt created", excerpt);
assertTrue("Title must not be present in excerpt", excerpt.getString().indexOf("Apache") == -1);
}
use of javax.jcr.query.RowIterator in project jackrabbit by apache.
the class LargeResultSetTest method readResult.
private void readResult(QueryResult result, int count) throws RepositoryException {
for (RowIterator rows = result.getRows(); rows.hasNext(); ) {
rows.nextRow();
count--;
}
assertEquals(0, count);
}
use of javax.jcr.query.RowIterator in project jackrabbit by apache.
the class GQL method executeJcrQuery.
private RowIterator executeJcrQuery(String jcrQuery, String jcrQueryLanguage) {
try {
QueryManager qm = session.getWorkspace().getQueryManager();
RowIterator nodes = qm.createQuery(jcrQuery, jcrQueryLanguage).execute().getRows();
if (filter != null) {
nodes = new FilteredRowIterator(nodes);
}
if (offset > 0) {
try {
nodes.skip(offset);
} catch (NoSuchElementException e) {
return RowIteratorAdapter.EMPTY;
}
}
if (numResults == Integer.MAX_VALUE) {
return new RowIterAdapter(nodes, nodes.getSize());
}
List<Row> resultRows = new ArrayList<Row>();
while (numResults-- > 0 && nodes.hasNext()) {
resultRows.add(nodes.nextRow());
}
return new RowIterAdapter(resultRows, resultRows.size());
} catch (RepositoryException e) {
// in case of error return empty result
return RowIteratorAdapter.EMPTY;
}
}
use of javax.jcr.query.RowIterator in project jackrabbit by apache.
the class QueryEngine method execute.
protected QueryResult execute(JoinMerger merger, ConstraintSplitInfo csInfo, boolean isOuterJoin, int printIndentation) throws RepositoryException {
Comparator<Row> leftCo = new RowPathComparator(merger.getLeftSelectors());
long timeJoinLeftSide = System.currentTimeMillis();
if (csInfo.isMultiple()) {
log.debug("{} SQL2 JOIN execute: there are multiple inner splits.", genString(printIndentation));
// first branch
long bTime = System.currentTimeMillis();
QueryResult branch1 = execute(merger, csInfo.getLeftInnerConstraints(), isOuterJoin, printIndentation + printIndentStep);
Set<Row> allRows = new TreeSet<Row>(new RowPathComparator(Arrays.asList(merger.getSelectorNames())));
RowIterator ri1 = branch1.getRows();
while (ri1.hasNext()) {
Row r = ri1.nextRow();
allRows.add(r);
}
log.debug("{} SQL2 JOIN executed first branch, took {} ms.", genString(printIndentation), System.currentTimeMillis() - bTime);
// second branch
bTime = System.currentTimeMillis();
QueryResult branch2 = execute(merger, csInfo.getRightInnerConstraints(), isOuterJoin, printIndentation + printIndentStep);
RowIterator ri2 = branch2.getRows();
while (ri2.hasNext()) {
Row r = ri2.nextRow();
allRows.add(r);
}
log.debug("{} SQL2 JOIN executed second branch, took {} ms.", genString(printIndentation), System.currentTimeMillis() - bTime);
return new SimpleQueryResult(merger.getColumnNames(), merger.getSelectorNames(), new RowIteratorAdapter(allRows));
}
Set<Row> leftRows = buildLeftRowsJoin(csInfo, leftCo, printIndentation + printIndentStep);
if (log.isDebugEnabled()) {
timeJoinLeftSide = System.currentTimeMillis() - timeJoinLeftSide;
log.debug(genString(printIndentation) + "SQL2 JOIN LEFT SIDE took " + timeJoinLeftSide + " ms. fetched " + leftRows.size() + " rows.");
}
// The join constraint information is split into:
// - rightConstraints selects just the 'ON' constraints
// - csInfo has the 'WHERE' constraints
//
// So, in the case of an OUTER JOIN we'll run 2 queries, one with
// 'ON'
// and one with 'ON' + 'WHERE' conditions
// this way, at merge time in case of an outer join we can tell if
// it's a 'null' row, or a bad row -> one that must not be returned.
// This way at the end we'll have:
// - rightRowsSet containing the 'ON' dataset
// - excludingOuterJoinRowsSet: the 'ON' + 'WHERE' condition
// dataset, or
// NULL if there is no 'WHERE' condition
long timeJoinRightSide = System.currentTimeMillis();
List<Constraint> rightConstraints = merger.getRightJoinConstraints(leftRows);
Comparator<Row> rightCo = new RowPathComparator(merger.getRightSelectors());
if (leftRows == null || leftRows.isEmpty()) {
return merger.merge(new RowIteratorAdapter((leftRows == null) ? Collections.emptySet() : leftRows), new RowIteratorAdapter(new TreeSet<Row>()), null, rightCo);
}
Set<Row> rightRows = buildRightRowsJoin(csInfo, rightConstraints, isOuterJoin, rightCo, printIndentation + printIndentStep);
// this has to be initialized as null
Set<Row> excludingOuterJoinRowsSet = null;
if (isOuterJoin && csInfo.getRightConstraint() != null) {
excludingOuterJoinRowsSet = buildRightRowsJoin(csInfo, rightConstraints, false, rightCo, printIndentation + printIndentStep);
}
if (log.isDebugEnabled()) {
timeJoinRightSide = System.currentTimeMillis() - timeJoinRightSide;
log.debug(genString(printIndentation) + "SQL2 JOIN RIGHT SIDE took " + timeJoinRightSide + " ms. fetched " + rightRows.size() + " rows.");
}
// merge left with right datasets
return merger.merge(new RowIteratorAdapter(leftRows), new RowIteratorAdapter(rightRows), excludingOuterJoinRowsSet, rightCo);
}
use of javax.jcr.query.RowIterator in project jackrabbit by apache.
the class QueryEngine method sort.
/**
* Sorts the given query results according to the given QOM orderings. If
* one or more orderings have been specified, this method will iterate
* through the entire original result set, order the collected rows, and
* return a new result set based on the sorted collection of rows.
*
* @param result
* original query results
* @param orderings
* QOM orderings
* @param offset
* result offset
* @param limit
* result limit
* @return sorted query results
* @throws RepositoryException
* if the results can not be sorted
*/
protected static QueryResult sort(QueryResult result, final Ordering[] orderings, OperandEvaluator evaluator, long offset, long limit) throws RepositoryException {
if ((orderings != null && orderings.length > 0) || offset != 0 || limit >= 0) {
List<Row> rows = new ArrayList<Row>();
RowIterator iterator = result.getRows();
while (iterator.hasNext()) {
rows.add(iterator.nextRow());
}
if (orderings != null && orderings.length > 0) {
Collections.sort(rows, new RowComparator(orderings, evaluator));
}
if (offset > 0) {
int size = rows.size();
rows = rows.subList((int) Math.min(offset, size), size);
}
if (limit >= 0) {
int size = rows.size();
rows = rows.subList(0, (int) Math.min(limit, size));
}
return new SimpleQueryResult(result.getColumnNames(), result.getSelectorNames(), new RowIteratorAdapter(rows));
} else {
return result;
}
}
Aggregations