com.oberasoftware.jasdb.api.session.query.QueryBuilder.sortBy()方法的使用及代码示例

x33g5p2x  于2022-01-28 转载在 其他  
字(5.9k)|赞(0)|评价(0)|浏览(59)

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

QueryBuilder.sortBy介绍

暂无

代码示例

代码示例来源:origin: oberasoftware/jasdb

private void setSortParams(QueryBuilder builder, SortParameter... params) {
  for(SortParameter sortParam: params) {
    builder.sortBy(sortParam);
  }
}

代码示例来源:origin: oberasoftware/jasdb

private void setSortParams(QueryBuilder builder, SortParameter... params) {
  for(SortParameter sortParam: params) {
    builder.sortBy(sortParam);
  }
}

代码示例来源:origin: oberasoftware/jasdb

public QueryBuilder sortBy(String field) {
  sortBy(field, Order.ASCENDING);
  return this;
}

代码示例来源:origin: oberasoftware/jasdb

private void setOrderingParams(QueryBuilder queryBuilder, List<OrderParam> orderParams) {
  if(!orderParams.isEmpty()) {
    for(OrderParam orderParam : orderParams) {
      Order order = orderParam.getSortDirection() == OrderParam.DIRECTION.ASC ? Order.ASCENDING : Order.DESCENDING;
      queryBuilder.sortBy(orderParam.getField(), order);
    }
  }
}

代码示例来源:origin: oberasoftware/jasdb

@Test
public void testRangeQuerySortByOtherFieldNaturalOrdering() throws Exception {
  DBSession pojoDb = sessionFactory.createSession();
  EntityBag bag = pojoDb.createOrGetBag("inverted");
  try {
    QueryExecutor executor = bag.find(QueryBuilder.createBuilder().field("field5").greaterThan(10).field("field5").smallerThan(30).sortBy("field1"));
    try (QueryResult result = executor.execute()) {
      assertNotNull(result);
      assertTrue("There should be a result", result.hasNext());
      int start = 11;
      int amount = 18;
      List<String> keysInOrder = assertResult(start, amount, result);
      List<String> expectedOrder = new ArrayList<>();
      for (int i = start; i < amount + start; i++) {
        String id = valueToId.get("value" + i);
        expectedOrder.add(id);
        LOG.info("Expected key: {} with value: {}", id, "value" + i);
      }
      assertListOrder(keysInOrder, expectedOrder);
    }
  } finally {
    pojoDb.closeSession();
    JasDBMain.shutdown();
  }
}

代码示例来源:origin: oberasoftware/jasdb

@Test
public void testRangeQuerySortByOtherField() throws Exception {
  DBSession pojoDb = sessionFactory.createSession();
  EntityBag bag = pojoDb.createOrGetBag("inverted");
  try {
    QueryBuilder query = QueryBuilder.createBuilder().field("field5").greaterThan(10).field("field5").smallerThan(30).sortBy("field6", Order.ASCENDING);
    List<Entity> entities = getEntities(bag, query);
    List<String> field6Values = getEntityValue(entities, "field6");
    long previous = 0;
    for(String stringValue : field6Values) {
      long value = Long.parseLong(stringValue);
      assertThat(value >= previous, is(true));
      previous = value;
    }
  } finally {
    pojoDb.closeSession();
    JasDBMain.shutdown();
  }
}

代码示例来源:origin: oberasoftware/jasdb

@Test
public void testSortByNonExistingField() throws Exception {
  DBSession session = sessionFactory.createSession();
  try{
    EntityBag bag = session.createOrGetBag("Bag");
    SimpleEntity entity = new SimpleEntity();
    entity.addProperty("name", "xxx");
    entity.addProperty("v", "1");
    bag.addEntity(entity);
    entity = new SimpleEntity();
    entity.addProperty("name", "xxx");
    entity.addProperty("v", "2");
    bag.addEntity(entity);
    QueryBuilder innerQuery = QueryBuilder.createBuilder();
    innerQuery.field("name").value("xxx").sortBy("_id",Order.DESCENDING).sortBy("id", Order.DESCENDING);
    QueryExecutor executor = bag.find(innerQuery);
    QueryResult result = executor.execute();
    assertThat(result.size(), is(2l));
  } finally {
    JasDBMain.shutdown();
  }
}

代码示例来源:origin: oberasoftware/jasdb

@Test
public void testEqualsOrQuery() throws Exception {
  DBSession pojoDb = sessionFactory.createSession();
  EntityBag bag = pojoDb.createOrGetBag("inverted");
  try {
    String queryKey1 = "value1";
    String queryKey2 = "value50";
    String expectedId1 = valueToId.get(queryKey1);
    String expectedId2 = valueToId.get(queryKey2);
    QueryExecutor executor = bag.find(QueryBuilder.createBuilder().field("field1").value(queryKey1)
        .or(QueryBuilder.createBuilder().field("field1").value(queryKey2)).sortBy("field1"));
    long start = System.nanoTime();
    QueryResult result = executor.execute();
    long end = System.nanoTime();
    long passed = end - start;
    LOG.info("Query execution took: {}", passed);
    assertNotNull(result);
    assertTrue("There should be a result", result.hasNext());
    Entity entity1 = result.next();
    assertTrue("There should be a result", result.hasNext());
    Entity entity2 = result.next();
    assertNotNull("There should be a returned entity", entity1);
    assertEquals("The id's should match", expectedId1, entity1.getInternalId());
    assertNotNull("There should be a returned entity", entity2);
    assertEquals("The id's should match", expectedId2, entity2.getInternalId());
  } finally {
    pojoDb.closeSession();
    JasDBMain.shutdown();
  }
}

代码示例来源:origin: oberasoftware/jasdb

@Test
public void testSortDescendingInvalidType() throws Exception {
  DBSession session = sessionFactory.createSession();
  try{
    EntityBag bag = session.createOrGetBag("Bag");
    SimpleEntity entity = new SimpleEntity();
    entity.addProperty("name", "xxx");
    entity.addProperty("v", "3");
    bag.addEntity(entity);
    entity = new SimpleEntity();
    entity.addProperty("name", 1);
    entity.addProperty("v", "1");
    bag.addEntity(entity);
    entity = new SimpleEntity();
    entity.addProperty("name", "xxx");
    entity.addProperty("v", "2");
    bag.addEntity(entity);
    QueryBuilder innerQuery = QueryBuilder.createBuilder();
    innerQuery.field("name").value("xxx").sortBy("v", Order.DESCENDING);
    QueryExecutor executor = bag.find(innerQuery);
    QueryResult result = executor.execute();
    assertThat(result.size(), is(2l));
    assertThat(result.next().getValue("v"), is("3"));
    assertThat(result.next().getValue("v"), is("2"));
  } finally {
    JasDBMain.shutdown();
  }
}

相关文章