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

Example 36 with QueryManager

use of javax.jcr.query.QueryManager in project jackrabbit-oak by apache.

the class QueryFulltextTest method testFulltext.

public void testFulltext() throws Exception {
    Session session = superuser;
    QueryManager qm = session.getWorkspace().getQueryManager();
    Node n1 = testRootNode.addNode("node1");
    n1.setProperty("text", "hello");
    Node n2 = testRootNode.addNode("node2");
    n2.setProperty("text", "hallo");
    Node n3 = testRootNode.addNode("node3");
    n3.setProperty("text", "hello hallo");
    session.save();
    // lowercase "or" mean search for the term "or"
    String sql2 = "select [jcr:path] as [path] from [nt:base] " + "where contains([text], 'hello or hallo') order by [jcr:path]";
    Query q = qm.createQuery(sql2, Query.JCR_SQL2);
    assertEquals("", getResult(q.execute(), "path"));
}

Example 37 with QueryManager

use of javax.jcr.query.QueryManager in project jackrabbit-oak by apache.

the class FacetTest method testFacetRetrieval.

public void testFacetRetrieval() throws Exception {
    Session session = superuser;
    Node n1 = testRootNode.addNode("node1");
    n1.setProperty("text", "hello");
    Node n2 = testRootNode.addNode("node2");
    n2.setProperty("text", "hallo");
    Node n3 = testRootNode.addNode("node3");
    n3.setProperty("text", "oh hallo");
    session.save();
    QueryManager qm = session.getWorkspace().getQueryManager();
    String sql2 = "select [jcr:path], [rep:facet(text)] from [nt:base] " + "where contains([text], 'hello OR hallo') order by [jcr:path]";
    Query q = qm.createQuery(sql2, Query.JCR_SQL2);
    QueryResult result = q.execute();
    FacetResult facetResult = new FacetResult(result);
    assertNotNull(facetResult);
    assertNotNull(facetResult.getDimensions());
    assertEquals(1, facetResult.getDimensions().size());
    assertTrue(facetResult.getDimensions().contains("text"));
    List<FacetResult.Facet> facets = facetResult.getFacets("text");
    assertNotNull(facets);
    assertEquals("hallo", facets.get(0).getLabel());
    assertEquals(1, facets.get(0).getCount(), 0);
    assertEquals("hello", facets.get(1).getLabel());
    assertEquals(1, facets.get(1).getCount(), 0);
    assertEquals("oh hallo", facets.get(2).getLabel());
    assertEquals(1, facets.get(2).getCount(), 0);
    NodeIterator nodes = result.getNodes();
    assertTrue(nodes.hasNext());
    assertNotNull(nodes.nextNode());
    assertTrue(nodes.hasNext());
    assertNotNull(nodes.nextNode());
    assertTrue(nodes.hasNext());
    assertNotNull(nodes.nextNode());
    assertFalse(nodes.hasNext());
}

Example 38 with QueryManager

use of javax.jcr.query.QueryManager in project jackrabbit-oak by apache.

the class FacetTest method testFacetRetrievalMV.

public void testFacetRetrievalMV() throws Exception {
    Session session = superuser;
    Node n1 = testRootNode.addNode("node1");
    n1.setProperty("jcr:title", "apache jackrabbit oak");
    n1.setProperty("tags", new String[] { "software", "repository", "apache" });
    Node n2 = testRootNode.addNode("node2");
    n2.setProperty("jcr:title", "oak furniture");
    n2.setProperty("tags", "furniture");
    Node n3 = testRootNode.addNode("node3");
    n3.setProperty("jcr:title", "oak cosmetics");
    n3.setProperty("tags", "cosmetics");
    Node n4 = testRootNode.addNode("node4");
    n4.setProperty("jcr:title", "oak and aem");
    n4.setProperty("tags", new String[] { "software", "repository", "aem" });
    session.save();
    QueryManager qm = session.getWorkspace().getQueryManager();
    String sql2 = "select [jcr:path], [rep:facet(tags)] from [nt:base] " + "where contains([jcr:title], 'oak') order by [jcr:path]";
    Query q = qm.createQuery(sql2, Query.JCR_SQL2);
    QueryResult result = q.execute();
    FacetResult facetResult = new FacetResult(result);
    assertNotNull(facetResult);
    assertNotNull(facetResult.getDimensions());
    assertEquals(1, facetResult.getDimensions().size());
    assertTrue(facetResult.getDimensions().contains("tags"));
    List<FacetResult.Facet> facets = facetResult.getFacets("tags");
    assertNotNull(facets);
    assertEquals("repository", facets.get(0).getLabel());
    assertEquals(2, facets.get(0).getCount(), 0);
    assertEquals("software", facets.get(1).getLabel());
    assertEquals(2, facets.get(1).getCount(), 0);
    assertEquals("aem", facets.get(2).getLabel());
    assertEquals(1, facets.get(2).getCount(), 0);
    assertEquals("apache", facets.get(3).getLabel());
    assertEquals(1, facets.get(3).getCount(), 0);
    assertEquals("cosmetics", facets.get(4).getLabel());
    assertEquals(1, facets.get(4).getCount(), 0);
    assertEquals("furniture", facets.get(5).getLabel());
    assertEquals(1, facets.get(5).getCount(), 0);
    NodeIterator nodes = result.getNodes();
    assertTrue(nodes.hasNext());
    assertNotNull(nodes.nextNode());
    assertTrue(nodes.hasNext());
    assertNotNull(nodes.nextNode());
    assertTrue(nodes.hasNext());
    assertNotNull(nodes.nextNode());
    assertTrue(nodes.hasNext());
    assertNotNull(nodes.nextNode());
    assertFalse(nodes.hasNext());
}

Example 39 with QueryManager

use of javax.jcr.query.QueryManager in project jackrabbit-oak by apache.

the class QomTest method before.

@Before
public void before() throws RepositoryException {
    Session session = getAdminSession();
    vf = session.getValueFactory();
    QueryManager qm = session.getWorkspace().getQueryManager();
    f = qm.getQOMFactory();
}

Example 40 with QueryManager

use of javax.jcr.query.QueryManager in project jackrabbit-oak by apache.

the class LuceneIndexDescendantSpellcheckTest method getSpellchecks.

private Set<String> getSpellchecks(String query) throws Exception {
    QueryManager queryManager = session.getWorkspace().getQueryManager();
    QueryResult result = queryManager.createQuery(query, Query.JCR_SQL2).execute();
    RowIterator rows = result.getRows();
    Set<String> suggestions = newHashSet();
    while (rows.hasNext()) {
        suggestions.add(rows.nextRow().getValue("spellcheck").getString());
    }
    return suggestions;
}