Examples with RowIterator javax.jcr.query.RowIterator used on opensource projects

Example 41 with RowIterator

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);
}

Example 42 with RowIterator

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;
    }
}

Example 43 with RowIterator

use of javax.jcr.query.RowIterator in project jackrabbit by apache.

the class GQLTest method testPrefixedValue.

public void testPrefixedValue() throws RepositoryException {
    Node n1 = testRootNode.addNode("node1");
    n1.setProperty("jcr:title", "a");
    Node n2 = testRootNode.addNode("node2");
    n2.setProperty("jcr:title", "b");
    Node n3 = testRootNode.addNode("node3");
    n3.setProperty("jcr:title", "c");
    superuser.save();
    String stmt = createStatement("order:jcr:title");
    RowIterator rows = GQL.execute(stmt, superuser);
    checkResultSequence(rows, new Node[] { n1, n2, n3 });
}

Example 44 with RowIterator

use of javax.jcr.query.RowIterator in project jackrabbit by apache.

the class GQLTest method testOrder.

public void testOrder() throws RepositoryException {
    Node n1 = testRootNode.addNode("node1");
    n1.setProperty("p", 1);
    Node n2 = testRootNode.addNode("node2");
    n2.setProperty("p", 2);
    Node n3 = testRootNode.addNode("node3");
    n3.setProperty("p", 3);
    superuser.save();
    // default: ascending
    String stmt = createStatement("order:p");
    RowIterator rows = GQL.execute(stmt, superuser);
    checkResultSequence(rows, new Node[] { n1, n2, n3 });
    // explicit ascending
    stmt = createStatement("order:+p");
    rows = GQL.execute(stmt, superuser);
    checkResultSequence(rows, new Node[] { n1, n2, n3 });
    // explicit descending
    stmt = createStatement("order:-p");
    rows = GQL.execute(stmt, superuser);
    checkResultSequence(rows, new Node[] { n3, n2, n1 });
}

Example 45 with RowIterator

use of javax.jcr.query.RowIterator in project jackrabbit by apache.

the class GQLTest method testOptionalTerm.

public void testOptionalTerm() throws RepositoryException {
    Node n1 = testRootNode.addNode("node1");
    n1.setProperty("text", "apache jackrabbit");
    Node n2 = testRootNode.addNode("node2");
    n2.setProperty("text", "apache jcr");
    Node n3 = testRootNode.addNode("node3");
    n3.setProperty("text", "jackrabbit jcr");
    superuser.save();
    String stmt = createStatement("apache jackrabbit OR jcr");
    RowIterator rows = GQL.execute(stmt, superuser);
    checkResult(rows, new Node[] { n1, n2 });
}