@Override
    public ProjectMap getProjectsByIdList(List<Integer> projIdList) {
      if (projIdList.isEmpty()) {
        return ProjectMap.empty();
      }

      List<StoredProject> projs =
          autoCommit(
              (handle, dao) ->
                  handle
                      .createQuery(
                          "select * from projects"
                              + " where site_id = :siteId"
                              + " and id "
                              + inLargeIdListExpression(projIdList))
                      .bind("siteId", siteId)
                      .map(new StoredProjectMapper(cfm))
                      .list());

      ImmutableMap.Builder<Integer, StoredProject> builder = ImmutableMap.builder();
      for (StoredProject proj : projs) {
        builder.put(proj.getId(), proj);
      }
      return new ProjectMap(builder.build());
    }
예제 #2
0
  @GET
  @Path("/api/sessions/{id}")
  public RestSession getSession(@PathParam("id") long id) throws ResourceNotFoundException {
    StoredSessionWithLastAttempt session = sm.getSessionStore(getSiteId()).getSessionById(id);

    StoredProject proj = rm.getProjectStore(getSiteId()).getProjectById(session.getProjectId());

    return RestModels.session(session, proj.getName());
  }
    @Override
    public <T> T deleteProject(int projId, ProjectObsoleteAction<T> func)
        throws ResourceNotFoundException {
      return transaction(
          (handle, dao) -> {
            StoredProject proj =
                requiredResource(
                    dao.getProjectByIdWithLockForDelete(siteId, projId), "project id=%d", projId);

            T res = func.call(new DatabaseProjectControlStore(handle, siteId), proj);

            dao.deleteProject(proj.getId());

            return res;
          },
          ResourceNotFoundException.class);
    }
예제 #4
0
  @GET
  @Path("/api/sessions/{id}/attempts")
  public RestSessionAttemptCollection getSessionAttempts(
      @PathParam("id") long id, @QueryParam("last_id") Long lastId)
      throws ResourceNotFoundException {

    ProjectStore rs = rm.getProjectStore(getSiteId());
    SessionStore ss = sm.getSessionStore(getSiteId());

    StoredSession session = ss.getSessionById(id);
    StoredProject project = rs.getProjectById(session.getProjectId());
    List<StoredSessionAttempt> attempts =
        ss.getAttemptsOfSession(id, 100, Optional.fromNullable(lastId));

    List<RestSessionAttempt> collection =
        attempts
            .stream()
            .map(attempt -> RestModels.attempt(session, attempt, project.getName()))
            .collect(Collectors.toList());

    return RestModels.attemptCollection(collection);
  }