Java Query类代码示例

import io.ebean.Query; //导入依赖的package包/类
@SubjectNotPresent
public Result getActiveExams(Optional<String> date) {
    PathProperties pp = PathProperties.parse("(course(name, code, credits, " +
            "gradeScale(description, externalRef, displayName), organisation(code, name, nameAbbreviation)) " +
            "name, examActiveStartDate, examActiveEndDate, duration, enrollInstruction, examLanguages(code, name) " +
            "gradeScale(description, externalRef, displayName), examOwners(firstName, lastName, email), " +
            "examType(type)" +
            ")");
    DateTime dateTime = date.isPresent() ?
            ISODateTimeFormat.dateTimeParser().parseDateTime(date.get()) :
            DateTime.now();
    Query<Exam> query = Ebean.find(Exam.class);
    query.apply(pp);
    List<Exam> exams = query.where()
            .eq("state", Exam.State.PUBLISHED)
            .lt("examActiveStartDate", dateTime)
            .ge("examActiveEndDate", dateTime)
            .eq("executionType.type", ExamExecutionType.Type.PUBLIC.toString())
            .findList();

    return ok(exams, pp);
}
 

import io.ebean.Query; //导入依赖的package包/类
@SubjectNotPresent
public Result getReservations(Optional<String> start, Optional<String> end, Optional<Long> roomId) {
    PathProperties pp = PathProperties.parse("(startAt, endAt, noShow, " +
            "user(firstName, lastName, email, userIdentifier), " +
            "enrolment(exam(name, examOwners(firstName, lastName, email), parent(examOwners(firstName, lastName, email)))), " +
            "machine(name, ipAddress, otherIdentifier, room(name, roomCode)))");
    Query<Reservation> query = Ebean.find(Reservation.class);
    pp.apply(query);
    ExpressionList<Reservation> el = query.where()
            .isNotNull("enrolment")
            .ne("enrolment.exam.state", Exam.State.DELETED);
    if (start.isPresent()) {
        DateTime startDate = ISODateTimeFormat.dateTimeParser().parseDateTime(start.get());
        el = el.ge("startAt", startDate.toDate());
    }

    if (end.isPresent()) {
        DateTime endDate = ISODateTimeFormat.dateTimeParser().parseDateTime(end.get());
        el = el.lt("endAt", endDate.toDate());
    }
    if (roomId.isPresent()) {
        el = el.eq("machine.room.id", roomId.get());
    }
    Set<Reservation> reservations = el.orderBy("startAt").findSet();
    return ok(reservations, pp);
}
 

import io.ebean.Query; //导入依赖的package包/类
@SubjectNotPresent
public Result getRoomOpeningHours(Long roomId, Optional<String> date) {
    if (!date.isPresent()) {
        return badRequest("no search date given");
    }
    LocalDate searchDate = ISODateTimeFormat.dateParser().parseLocalDate(date.get());
    PathProperties pp = PathProperties.parse("(*, defaultWorkingHours(*), calendarExceptionEvents(*))");
    Query<ExamRoom> query = Ebean.find(ExamRoom.class);
    pp.apply(query);
    ExamRoom room = query.where().idEq(roomId).findUnique();
    if (room == null) {
        return notFound("room not found");
    }
    room.setCalendarExceptionEvents(room.getCalendarExceptionEvents().stream().filter(ee -> {
        LocalDate start = new LocalDate(ee.getStartDate()).withDayOfMonth(1);
        LocalDate end = new LocalDate(ee.getEndDate()).dayOfMonth().withMaximumValue();
        return !start.isAfter(searchDate) && !end.isBefore(searchDate);

    }).collect(Collectors.toList()));
    return ok(room, pp);
}
 

import io.ebean.Query; //导入依赖的package包/类
@Restrict({@Group("ADMIN")})
public Result findUsers(Optional<String> filter) {
    Query<User> query = Ebean.find(User.class).fetch("roles").fetch("permissions");
    List<User> results;
    if (filter.isPresent()) {
        ExpressionList<User> el = query.where().disjunction();
        el = applyUserFilter(null, el, filter.get());
        String condition = String.format("%%%s%%", filter.get());
        results = el.ilike("email", condition)
                .ilike("userIdentifier", condition)
                .ilike("employeeNumber", condition)
                .endJunction()
                .orderBy("lastName, firstName")
                .findList();
    } else {
        results = query.orderBy("lastName, firstName").findList();
    }
    return ok(Json.toJson(results));
}
 

import io.ebean.Query; //导入依赖的package包/类
@Restrict({@Group("TEACHER"), @Group("ADMIN")})
public Result listExams(Optional<List<Long>> courseIds, Optional<List<Long>> sectionIds, Optional<List<Long>> tagIds) {
    User user = getLoggedUser();
    List<Long> courses = courseIds.orElse(Collections.emptyList());
    List<Long> sections = sectionIds.orElse(Collections.emptyList());
    List<Long> tags = tagIds.orElse(Collections.emptyList());
    PathProperties pp = PathProperties.parse("(id, name, course(id, code), examSections(id, name))");
    Query<Exam> query = Ebean.find(Exam.class);
    pp.apply(query);
    ExpressionList<Exam> el = query.where().isNotNull("name").isNotNull("course");
    if (!user.hasRole("ADMIN", getSession())) {
        el = el.eq("examOwners", user);
    }
    if (!courses.isEmpty()) {
        el = el.in("course.id", courses);
    }
    if (!sections.isEmpty()) {
        el = el.in("examSections.id", sections);
    }
    if (!tags.isEmpty()) {
        el = el.in("examSections.sectionQuestions.question.parent.tags.id", tags);
    }
    return ok(el.findList(), pp);
}
 

import io.ebean.Query; //导入依赖的package包/类
@Restrict(@Group("TEACHER"))
public Result getTeachersExams() {
    // Get list of exams that user is assigned to inspect or is creator of
    PathProperties props = PathProperties.parse("(*, course(id, code), " +
            "children(id, state, examInspections(user(id, firstName, lastName))), " +
            "examinationDates(*), " +
            "examOwners(id, firstName, lastName), executionType(type), " +
            "examInspections(id, user(id, firstName, lastName)), " +
            "examEnrolments(id, user(id), reservation(id, endAt)))");
    Query<Exam> query = Ebean.createQuery(Exam.class);
    props.apply(query);
    User user = getLoggedUser();
    List<Exam> exams = query
            .where()
            .in("state", Exam.State.PUBLISHED, Exam.State.SAVED, Exam.State.DRAFT)
            .disjunction()
            .eq("examInspections.user", user)
            .eq("examOwners", user)
            .endJunction()
            .isNull("parent")
            .orderBy("created").findList();
    return ok(exams, props);
}
 

import io.ebean.Query; //导入依赖的package包/类
@Restrict({@Group("ADMIN"), @Group("TEACHER")})
public Result getExams() {
    User user = getLoggedUser();
    PathProperties props = PathProperties.parse("(id, name)");
    Query<Exam> q = Ebean.createQuery(Exam.class);
    props.apply(q);
    ExpressionList<Exam> el = q.where()
            .isNull("parent") // only Exam prototypes
            .eq("state", Exam.State.PUBLISHED);
    if (user.hasRole("TEACHER", getSession())) {
        el = el.gt("examActiveEndDate", new Date())
                .disjunction()
                .eq("creator", user)
                .eq("examOwners", user)
                .eq("examInspections.user", user)
                .eq("shared", true)
                .endJunction();
    }
    return ok(el.findList(), props);
}
 

import io.ebean.Query; //导入依赖的package包/类
@Restrict({@Group("TEACHER"), @Group("ADMIN")})
public Result getQuestion(Long id) {
    User user = getLoggedUser();
    Query<Question> query = Ebean.find(Question.class);
    PathProperties pp = PathProperties.parse("(*, questionOwners(id, firstName, lastName, userIdentifier, email), " +
            "attachment(id, fileName), options(id, correctOption, defaultScore, option), tags(id, name), " +
            "examSectionQuestions(id, examSection(name, exam(name, state))))");
    pp.apply(query);
    ExpressionList<Question> expr = query.where().idEq(id);
    if (user.hasRole("TEACHER", getSession())) {
        expr = expr.disjunction()
                .eq("shared", true)
                .eq("questionOwners", user)
                .eq("examSectionQuestions.examSection.exam.examOwners", user)
                .endJunction();
    }
    Question question = expr.findUnique();
    if (question == null) {
        return forbidden("sitnet_error_access_forbidden");
    }
    Collections.sort(question.getOptions());
    return ok(question, pp);
}
 

import io.ebean.Query; //导入依赖的package包/类
/**
 * Restricts the max results of the given {@link Query} if the current {@code tree} marks this {@code query} as
 * limited.
 *
 * @param query
 * @return
 */
private Query restrictMaxResultsIfNecessary(Query query) {
  if (tree.isLimiting()) {

    if (query.getMaxRows() != Integer.MAX_VALUE) {
                /*
                 * In order to return the correct results, we have to adjust the first result offset to be returned if:
	 * - a Pageable parameter is present
	 * - AND the requested page number > 0
	 * - AND the requested page size was bigger than the derived result limitation via the First/Top keyword.
	 */
      if (query.getMaxRows() > tree.getMaxResults() && query.getFirstRow() > 0) {
        query.setFirstRow(query.getFirstRow() - (query.getMaxRows() - tree.getMaxResults()));
      }
    }

    query.setMaxRows(tree.getMaxResults());
  }

  if (tree.isExistsProjection()) {
    query.setMaxRows(1);
  }

  return query;
}
 

import io.ebean.Query; //导入依赖的package包/类
@Override
@SuppressWarnings("unchecked")
protected Object doExecute(final AbstractEbeanQuery repositoryQuery, final Object[] values) {
  ParameterAccessor accessor = new ParametersParameterAccessor(parameters, values);
  Object createQuery = repositoryQuery.createQuery(values);

  if (createQuery instanceof Query) {
    Query ormQuery = (Query) createQuery;
    PagedList pagedList = ormQuery.findPagedList();
    return PageableExecutionUtils.getPage(pagedList.getList(), accessor.getPageable(), () -> pagedList.getTotalCount());
  } else if (createQuery instanceof SqlQuery) {
    SqlQuery sqlQuery = (SqlQuery) createQuery;
    // TODO page
    return sqlQuery.findList();
  } else {
    throw new InvalidEbeanQueryMethodException("query must be Query or SqlQuery");
  }
}
 

import io.ebean.Query; //导入依赖的package包/类
private Object bindAndPrepare(Object query, Parameters<?, ?> parameters) {

        Object result = bind(query);

        if (!parameters.hasPageableParameter()) {
            return result;
        }
        if (query instanceof Query) {
            Query ormQuery = (Query) query;
            ormQuery.setFirstRow((int) getPageable().getOffset());
            ormQuery.setMaxRows(getPageable().getPageSize());
        } else if (query instanceof SqlQuery) {
            SqlQuery sqlQuery = (SqlQuery) query;
            sqlQuery.setFirstRow((int) getPageable().getOffset());
            sqlQuery.setMaxRows(getPageable().getPageSize());
        }

        return result;
    }
 

import io.ebean.Query; //导入依赖的package包/类
/**
 * Return a query using native SQL and column mapping.
 *
 * @param sql           native SQL
 * @param columnMapping column mapping,key is dbColumn, value is propertyName.
 * @return the created Query using native SQL and column mapping config.
 */
public <T> Query<T> createSqlQueryMappingColumns(Class<T> entityType,
                                                 String sql,
                                                 Map<String, String> columnMapping) {
  Assert.notNull(entityType, "entityType must not null");
  Assert.hasText(sql, "sql must has text");
  Assert.notEmpty(columnMapping, "columnMapping must not empty");
  RawSqlBuilder rawSqlBuilder = RawSqlBuilder.parse(sql);
  columnMapping.entrySet().forEach(entry -> {
    rawSqlBuilder.columnMapping(entry.getKey(), entry.getValue());
  });
  return ebeanServer.find(entityType).setRawSql(rawSqlBuilder.create());
}
 

import io.ebean.Query; //导入依赖的package包/类
private long processGroup() throws IOException {

    List<Object> deleteIds = group.getDeleteIds();
    for (Object id : deleteIds) {
      txn.send(new DocStoreDeleteEvent(desc, id));
    }

    count += deleteIds.size();

    List<Object> indexIds = group.getIndexIds();
    if (!indexIds.isEmpty()) {
      Query<T> query = server.find(desc.getBeanType());
      query.where().idIn(indexIds);
      indexUsingQuery(query, txn);
    }

    Collection<UpdateNested> values = group.getNestedPathIds().values();
    for (UpdateNested nested : values) {
      ProcessNested<T> nestedDocUpdate = new ProcessNested<>(server, desc, txn, nested);
      count += nestedDocUpdate.process();
    }

    return count;
  }
 

import io.ebean.Query; //导入依赖的package包/类
/**
 * Load the json map given the embedded document has cardinality many (ElasticSearch nested).
 */
private void fetchEmbeddedAssocMany(List<Object> nestedIds) {

  Query<T> query = server.createQuery(desc.getBeanType());
  query.apply(manyRootDoc);
  query.where().in(fullNestedPath, nestedIds);

  // hit the database and build the embedded JSON documents
  List<T> list = query.findList();
  for (T bean : list) {
    Object manyList = nestedProperty.getVal(bean);
    String embedJson = server.json().toJson(manyList, nestedDoc);
    Object beanId = desc.beanId(bean);
    jsonMap.put(beanId, embedJson);
  }
}
 

import io.ebean.Query; //导入依赖的package包/类
@Test
public void allOptions() {

  TextSimple options = new TextSimple()
      .analyzer("whitespace")
      .analyzeWildcard(true)
      .fields("name")
      .lenient(true)
      .locale("EN")
      .lowercaseExpandedTerms(false)
      .minShouldMatch("1")
      .opAnd();

  Query<Customer> query = server.find(Customer.class)
      .text()
      .textSimple("quick brown", options)
      .query();

  List<Customer> list = query.findList();
  assertThat(list).hasSize(0);
  assertEquals(query.getGeneratedSql(), "{\"query\":{\"simple_query_string\":{\"query\":\"quick brown\",\"analyzer\":\"whitespace\",\"fields\":[\"name\"],\"default_operator\":\"and\",\"lowercase_expanded_terms\":false,\"analyze_wildcard\":true,\"locale\":\"EN\",\"lenient\":true,\"minimum_should_match\":\"1\"}}}");
}