org.modeshape.jcr.api.query.Query类的使用及代码示例

x33g5p2x  于2022-01-29 转载在 其他  
字(17.1k)|赞(0)|评价(0)|浏览(286)

本文整理了Java中org.modeshape.jcr.api.query.Query类的一些代码示例，展示了Query类的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Query类的具体详情如下：
包路径：org.modeshape.jcr.api.query.Query
类名称：Query

Query介绍

[英]A specialization of the standard JCR javax.jcr.query.Query interface that adds the ModeShape-specific constant for the #FULL_TEXT_SEARCH query language.
[中]标准JCR javax的专门化。jcr。查询为#全文_TEXT_搜索查询语言添加特定于ModeShape的常量的查询接口。

代码示例

代码示例来源：origin: com.thinkbiganalytics.kylo/kylo-metadata-modeshape

  1. public static String explainPlain(Session session, String queryExpression) throws RepositoryException {
  2.   Query query = session.getWorkspace().getQueryManager().createQuery(queryExpression, "JCR-SQL2");
  3.   org.modeshape.jcr.api.query.Query msQuery = (org.modeshape.jcr.api.query.Query)query;
  4.   // Get the query plan without executing it ...
  5.   org.modeshape.jcr.api.query.QueryResult result = msQuery.explain();
  6.   String plan = result.getPlan();
  7.   return plan;
  8. }

代码示例来源：origin: ModeShape/modeshape

  1. @Override
  2.   public void run() {
  3.     JcrSession session = null;
  4.     try {
  5.       session = repository().login();
  6.       Query query = jcrSql2Query(session, "SELECT * FROM [mix:title]");
  7.       startLatch.await();
  8.       for (int i = 0; i != numQueriesEachThread; ++i) {
  9.         // Compute a query plan that should use this index, UNLESS the index is currently undergoing rebuilding...
  10.         validateQuery()./*rowCount(2L).useIndex("titleNodes")*/validate(query, query.execute());
  11.       }
  12.     } catch (Exception e) {
  13.       e.printStackTrace();
  14.       fail(e.getMessage());
  15.     } finally {
  16.       printMessage("Completing thread");
  17.       if (session != null) session.logout();
  18.       stopLatch.countDown();
  19.     }
  20.   }
  21. };

代码示例来源：origin: ModeShape/modeshape

  1. @FixFor( "MODE-2312" )
  2. @Test
  3. public void shouldUseImplicitPathIndex() throws Exception {
  4.   Node root = session().getRootNode();
  5.   Node newNode1 = root.addNode("nodeA");
  6.   newNode1.setProperty("foo", "X");
  7.   newNode1.addMixin("mix:referenceable");
  8.   Node newNode2 = root.addNode("nodeB");
  9.   newNode2.setProperty("foo", "Y");
  10.   session().save();
  11.   // print = true;
  12.   // Compute a query plan that should use this index ...
  13.   final String pathValue = newNode1.getPath();
  14.   Query query = jcrSql2Query("SELECT [jcr:path] FROM [nt:unstructured] WHERE [jcr:path] = '" + pathValue + "'");
  15.   validateQuery().rowCount(1L).useIndex(IndexPlanners.NODE_BY_PATH_INDEX_NAME).validate(query, query.execute());
  16.   query = jcrSql2Query("SELECT A.* FROM [nt:unstructured] AS A WHERE A.[jcr:path] = $pathValue");
  17.   query.bindValue("pathValue", valueFactory().createValue(pathValue));
  18.   validateQuery().rowCount(1L).useIndex(IndexPlanners.NODE_BY_PATH_INDEX_NAME).validate(query, query.execute());
  19. }

代码示例来源：origin: ModeShape/modeshape

  1. bindExtraVariables(uriInfo, session.getValueFactory(), query);
  2. org.modeshape.jcr.api.query.QueryResult result = query.explain();
  3. String plan = result.getPlan();
  4. return new RestQueryPlanResult(plan, statement, language, query.getAbstractQueryModelRepresentation());

代码示例来源：origin: ModeShape/modeshape

  1. @Test
  2. @FixFor( "MODE-2515" )
  3. public void shouldSupportQueryLimitWithMoreThan100Nodes() throws Exception {
  4.   registerValueIndex("title", "mix:title", null, "*", "jcr:title", PropertyType.STRING);
  5.   // Add a node that uses this type ...
  6.   Node root = session().getRootNode();
  7.   int nodeCount = 102;
  8.   for (int i = 0; i < nodeCount; i++) {
  9.     Node book = root.addNode("book_" + (i+1));
  10.     book.addMixin("mix:title");
  11.     book.setProperty("jcr:title", "Title");
  12.   }
  13.   session.save();
  14.   // Compute a query plan that should use this index ...
  15.   Query query = jcrSql2Query("SELECT * FROM [mix:title] as book where book.[jcr:title] = 'Title'");
  16.   int limit = nodeCount - 1;
  17.   query.setLimit(limit);
  18.   validateQuery().rowCount(limit).useIndex("title").validate(query, query.execute());
  19.   limit = nodeCount / 2;
  20.   query.setLimit(limit);
  21.   validateQuery().rowCount(limit).useIndex("title").validate(query, query.execute());
  22. }

代码示例来源：origin: ModeShape/modeshape

  1. @Test
  2. public void shouldUseSingleColumnStringIndexForQueryWithNoCriteriaOtherThanMixinViaFromClause() throws Exception {
  3.   registerValueIndex("titleNodes", "mix:title", null, "*", "jcr:mixinTypes", PropertyType.NAME);
  4.   // print = true;
  5.   // Add a node that uses this type ...
  6.   Node root = session().getRootNode();
  7.   Node book1 = root.addNode("myFirstBook");
  8.   book1.addMixin("mix:title");
  9.   book1.setProperty("jcr:title", "The Title");
  10.   Node book2 = root.addNode("mySecondBook");
  11.   book2.addMixin("mix:title");
  12.   book2.setProperty("jcr:title", "A Different Title");
  13.   // Create a node that is not a 'mix:title' and therefore won't be included in the SELECT clauses ...
  14.   Node other = root.addNode("somethingElse");
  15.   other.setProperty("propA", "a value for property A");
  16.   other.setProperty("jcr:title", "The Title");
  17.   session.save();
  18.   // Compute a query plan that should use this index ...
  19.   Query query = jcrSql2Query("SELECT * FROM [mix:title]");
  20.   validateQuery().rowCount(2L).useIndex("titleNodes").validate(query, query.execute());
  21. }

代码示例来源：origin: com.thinkbiganalytics.kylo/kylo-metadata-modeshape

  1. public List<T> findWithExplainPlan(String queryExpression) {
  2.   try {
  3.     org.modeshape.jcr.api.query.Query query = (org.modeshape.jcr.api.query.Query) getSession().getWorkspace().getQueryManager().createQuery(queryExpression, "JCR-SQL2");
  4.     org.modeshape.jcr.api.query.QueryResult result = query.explain();
  5.     String plan = result.getPlan();
  6.     log.info(plan);
  7.     return find(queryExpression);
  8.   } catch (RepositoryException e) {
  9.     throw new MetadataRepositoryException("Failure while finding entity ", e);
  10.   }
  11. }

代码示例来源：origin: ModeShape/modeshape

  1. @FixFor( "MODE-2312" )
  2. @Test
  3. public void shouldUseImplicitIdIndex() throws Exception {
  4.   Node root = session().getRootNode();
  5.   Node newNode1 = root.addNode("nodeA");
  6.   newNode1.setProperty("foo", "X");
  7.   newNode1.addMixin("mix:referenceable");
  8.   Node newNode2 = root.addNode("nodeB");
  9.   newNode2.setProperty("foo", "Y");
  10.   session().save();
  11.   // print = true;
  12.   // Compute a query plan that should use this index ...
  13.   final String uuid = newNode1.getIdentifier();
  14.   Query query = jcrSql2Query("SELECT [jcr:path] FROM [nt:unstructured] WHERE [jcr:uuid] = '" + uuid + "'");
  15.   validateQuery().rowCount(1L).useIndex(IndexPlanners.NODE_BY_ID_INDEX_NAME).validate(query, query.execute());
  16.   query = jcrSql2Query("SELECT A.* FROM [nt:unstructured] AS A WHERE A.[jcr:uuid] = $uuidValue");
  17.   query.bindValue("uuidValue", valueFactory().createValue(uuid));
  18.   validateQuery().rowCount(1L).useIndex(IndexPlanners.NODE_BY_ID_INDEX_NAME).validate(query, query.execute());
  19. }

代码示例来源：origin: ModeShape/modeshape

  1. @Test
  2. public void shouldUseSingleColumnStringIndexForQueryWithNoCriteriaOtherThanPrimaryTypeViaFromClause() throws Exception {
  3.   registerValueIndex("unstructuredNodes", "nt:unstructured", null, "*", "jcr:primaryType", PropertyType.NAME);
  4.   // print = true;
  5.   // Add a node that uses this type ...
  6.   Node root = session().getRootNode();
  7.   Node book1 = root.addNode("myFirstBook");
  8.   book1.addMixin("mix:title");
  9.   book1.setProperty("jcr:title", "The Title");
  10.   Node book2 = root.addNode("mySecondBook");
  11.   book2.addMixin("mix:title");
  12.   book2.setProperty("jcr:title", "A Different Title");
  13.   // Create a node that is not a 'mix:title' and therefore won't be included in the SELECT clauses ...
  14.   Node other = root.addNode("somethingElse");
  15.   other.setProperty("propA", "a value for property A");
  16.   other.setProperty("jcr:title", "The Title");
  17.   session.save();
  18.   // Compute a query plan that should use this index ...
  19.   Query query = jcrSql2Query("SELECT * FROM [nt:unstructured]");
  20.   validateQuery().rowCount(3L).useIndex("unstructuredNodes").validate(query, query.execute());
  21. }

代码示例来源：origin: ModeShape/modeshape

  1. @Override
  2. public String explain( String query,
  3.             String language ) throws RepositoryException {
  4.   logger.trace("Explaining query: {0}", query);
  5.   // Create the query ...
  6.   final org.modeshape.jcr.api.query.Query jcrQuery = (org.modeshape.jcr.api.query.Query)getLocalSession().getSession().getWorkspace().getQueryManager().createQuery(query,
  7.                                                                                    language);
  8.   return jcrQuery.explain().getPlan();
  9. }

代码示例来源：origin: ModeShape/modeshape

  1. query.bindValue("author", session.getValueFactory().createValue("author1"));
  2. validateQuery()
  3.     .useNoIndexes()
  4.     .rowCount(1)
  5.     .hasNodesAtPaths("/book1")
  6.     .validate(query, query.execute());
  7. query.bindValue("author", session.getValueFactory().createValue("author2"));
  8. final List<String> expectedPaths = new ArrayList<>(Arrays.asList("/book1", "/book2"));
  9. validateQuery()
  10.     .validate(query, query.execute());
  11. assertTrue("Not all paths found: " + expectedPaths, expectedPaths.isEmpty());

代码示例来源：origin: ModeShape/modeshape

  1. @Test
  2. public void shouldNotUseSingleColumnStringIndexInQueryAgainstSuperType() throws Exception {
  3.   registerValueIndex("descriptionIndex", "mix:title", "Index for the 'jcr:title' property on mix:title", "*", "jcr:title",
  4.             PropertyType.STRING);
  5.   // print = true;
  6.   // Add a node that uses this type ...
  7.   Node root = session().getRootNode();
  8.   Node book1 = root.addNode("myFirstBook");
  9.   book1.addMixin("mix:title");
  10.   book1.setProperty("jcr:title", "The Title");
  11.   Node book2 = root.addNode("mySecondBook");
  12.   book2.addMixin("mix:title");
  13.   book2.setProperty("jcr:title", "A Different Title");
  14.   // Create a node that is not a 'mix:title' and therefore won't be included in the query ...
  15.   Node other = root.addNode("somethingElse");
  16.   other.setProperty("propA", "a value for property A");
  17.   other.setProperty("jcr:title", "The Title");
  18.   session.save();
  19.   // Compute a query plan that will NOT use this index, since the selector doesn't match the index's node type.
  20.   // If we would use this index, the index doesn't know about non-mix:title nodes like the 'other' node ...
  21.   Query query = jcrSql2Query("SELECT * FROM [nt:base] WHERE [jcr:title] = 'The Title'");
  22.   validateQuery().rowCount(2L).validate(query, query.execute());
  23.   // Compute a query plan that will NOT use this index, since the selector doesn't match the index's node type.
  24.   // If we would use this index, the index doesn't know about non-mix:title nodes like the 'other' node ...
  25.   query = jcrSql2Query("SELECT * FROM [nt:base] WHERE [jcr:title] LIKE '% Title'");
  26.   validateQuery().rowCount(3L).validate(query, query.execute());
  27. }

代码示例来源：origin: org.modeshape/modeshape-jdbc-local

  1. @Override
  2. public String explain( String query,
  3.             String language ) throws RepositoryException {
  4.   logger.trace("Explaining query: {0}", query);
  5.   // Create the query ...
  6.   final org.modeshape.jcr.api.query.Query jcrQuery = (org.modeshape.jcr.api.query.Query)getLocalSession().getSession().getWorkspace().getQueryManager().createQuery(query,
  7.                                                                                    language);
  8.   return jcrQuery.explain().getPlan();
  9. }

代码示例来源：origin: ModeShape/modeshape

  1. query.bindValue("sysName", valueFactory().createValue(newNode1.getIdentifier()));
  2. validateQuery().rowCount(1L).useIndex("refIndex").validate(query, query.execute());
  3. query.bindValue("sysName", valueFactory().createValue(newNode1.getIdentifier()));
  4. validateQuery().rowCount(1L).useIndex("refIndex").validate(query, query.execute());
  5. query.bindValue("sysName", valueFactory().createValue("X"));
  6. validateQuery().rowCount(1L).useIndex("sysIndex").validate(query, query.execute());
  7. query.bindValue("sysName", valueFactory().createValue("X"));
  8. validateQuery().rowCount(1L).considerIndexes("refIndex", "sysIndex").validate(query, query.execute());

代码示例来源：origin: ModeShape/modeshape

  1. @Test
  2. public void shouldUseSingleColumnDateIndexInQueryAgainstSameNodeType() throws Exception {
  3.   registerValueIndex("dateIndex", "mix:lastModified", "Date value index", "*", "jcr:lastModified", PropertyType.DATE);
  4.   // print = true;
  5.   // Add a node that uses this type ...
  6.   Node root = session().getRootNode();
  7.   Node obj1 = root.addNode("notionalObjectA");
  8.   obj1.addMixin("mix:lastModified");
  9.   Node obj2 = root.addNode("notionalObjectB");
  10.   obj2.addMixin("mix:lastModified");
  11.   // Create a node that is not a 'notion:typed' and therefore won't be included in the query ...
  12.   Node other = root.addNode("somethingElse");
  13.   other.setProperty("jcr:lastModified", Calendar.getInstance());
  14.   session.save();
  15.   // Issues some queries that should use this index ...
  16.   Query query = jcrSql2Query("SELECT * FROM [mix:lastModified] WHERE [jcr:lastModified] > CAST('2012-10-21T00:00:00.000' AS DATE)");
  17.   validateQuery().rowCount(2L).validate(query, query.execute());
  18.   query = jcrSql2Query("SELECT * FROM [mix:lastModified] WHERE [jcr:lastModified] < CAST('2999-10-21T00:00:00.000' AS DATE)");
  19.   validateQuery().rowCount(2L).validate(query, query.execute());
  20.   // Issue a query that does not use this index ...
  21.   query = jcrSql2Query("SELECT * FROM [nt:unstructured] WHERE [jcr:lastModified] > CAST('2012-10-21T00:00:00.000' AS DATE)");
  22.   validateQuery().rowCount(3L).validate(query, query.execute());
  23. }

代码示例来源：origin: ModeShape/modeshape

  1. @FixFor( "MODE-1901" )
  2. @Test
  3. public void shouldExplainQueryWithoutExecutingQuery() throws RepositoryException {
  4.   String sql = "SELECT * FROM [nt:file]";
  5.   org.modeshape.jcr.api.query.Query query = session.getWorkspace().getQueryManager().createQuery(sql, Query.JCR_SQL2);
  6.   org.modeshape.jcr.api.query.QueryResult result = query.explain();
  7.   validateQuery().rowCount(0).warnings(0).onlyQueryPlan().validate(query, result);
  8. }

代码示例来源：origin: ModeShape/modeshape

  1. @FixFor( "MODE-2307" )
  2. @Test
  3. public void shouldUseSingleColumnStringIndexForQueryWithJoin() throws Exception {
  4.   registerNodeType("nt:typeWithReference");
  5.   registerNodeType("nt:typeWithSysName");
  6.   registerValueIndex("refIndex", "nt:typeWithReference", null, "*", "referenceId", PropertyType.STRING);
  7.   registerValueIndex("sysIndex", "nt:typeWithSysName", null, "*", "sysName", PropertyType.STRING);
  8.   registerNodeTypeIndex("typesIndex", "nt:base", null, "*", "jcr:primaryType", PropertyType.STRING);
  9.   // print = true;
  10.   Node root = session().getRootNode();
  11.   Node newNode1 = root.addNode("nodeWithSysName", "nt:typeWithSysName");
  12.   newNode1.setProperty("sysName", "X");
  13.   newNode1.addMixin("mix:referenceable");
  14.   Node newNode2 = root.addNode("nodeWithReference", "nt:typeWithReference");
  15.   newNode2.setProperty("referenceId", newNode1.getIdentifier());
  16.   session.save();
  17.   // Compute a query plan that should use this index ...
  18.   Query query = jcrSql2Query("SELECT A.* FROM [nt:typeWithReference] AS A "
  19.                 + "JOIN [nt:typeWithSysName] AS B ON A.referenceId  = B.[jcr:uuid] " //
  20.                 + "WHERE B.sysName = $sysName");
  21.   query.bindValue("sysName", valueFactory().createValue("X"));
  22.   validateQuery().rowCount(1L).considerIndexes("sysIndex", "refIndex", "typesIndex").validate(query, query.execute());
  23. }

代码示例来源：origin: ModeShape/modeshape

  1. @Test
  2. public void shouldUseSingleColumnDateAsLongIndexInQueryAgainstSameNodeType() throws Exception {
  3.   registerValueIndex("dateIndex", "mix:lastModified", "Date value index", "*", "jcr:lastModified", PropertyType.LONG);
  4.   // print = true;
  5.   // Add a node that uses this type ...
  6.   Node root = session().getRootNode();
  7.   Node obj1 = root.addNode("notionalObjectA");
  8.   obj1.addMixin("mix:lastModified");
  9.   Node obj2 = root.addNode("notionalObjectB");
  10.   obj2.addMixin("mix:lastModified");
  11.   // Create a node that is not a 'notion:typed' and therefore won't be included in the query ...
  12.   Node other = root.addNode("somethingElse");
  13.   other.setProperty("jcr:lastModified", Calendar.getInstance());
  14.   session.save();
  15.   // Issues some queries that should use this index ...
  16.   Query query = jcrSql2Query("SELECT * FROM [mix:lastModified] WHERE [jcr:lastModified] > CAST('2012-10-21T00:00:00.000' AS DATE)");
  17.   validateQuery().rowCount(2L).validate(query, query.execute());
  18.   query = jcrSql2Query("SELECT * FROM [mix:lastModified] WHERE [jcr:lastModified] < CAST('2999-10-21T00:00:00.000' AS DATE)");
  19.   validateQuery().rowCount(2L).validate(query, query.execute());
  20.   // Issue a query that does not use this index ...
  21.   query = jcrSql2Query("SELECT * FROM [nt:unstructured] WHERE [jcr:lastModified] > CAST('2012-10-21T00:00:00.000' AS DATE)");
  22.   validateQuery().rowCount(3L).validate(query, query.execute());
  23. }

代码示例来源：origin: ModeShape/modeshape

  1. validateQuery().rowCount(2L).useIndex("pathIndex").validate(query, query.execute());
  2. query.bindValue("value", session().getValueFactory().createValue("value1"));
  3. validateQuery().rowCount(2L).useIndex("pathIndex").validate(query, query.execute());
  4. validateQuery().rowCount(2L).useIndex("pathIndex").validate(query, query.execute());
  5. query.bindValue("value", session().getValueFactory().createValue("value1"));
  6. validateQuery().rowCount(2L).useIndex("pathIndex").validate(query, query.execute());
  7. validateQuery().rowCount(1L).useIndex("titleIndex").validate(query, query.execute());
  8. validateQuery().rowCount(1L).useIndex("titleIndex").validate(query, query.execute());

代码示例来源：origin: ModeShape/modeshape

  1. final QueryManager queryManager = session.getWorkspace().getQueryManager();
  2. final Query query = queryManager.createQuery(sql, Query.JCR_SQL2);
  3. final QueryResult result = query.execute();

内容来源于网络，如有侵权，请联系作者删除！

query

相关文章

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多

    Query类方法

    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com