public org.iucn.sis.shared.api.models.WorkflowStatus getWorkflowRow(Integer workingSetID)
      throws WorkflowManagerException {
    final SelectQuery query = new SelectQuery();
    query.select(WorkflowConstants.WORKFLOW_TABLE, "*");
    query.constrain(
        new CanonicalColumnName(WorkflowConstants.WORKFLOW_TABLE, "workingsetid"),
        QConstraint.CT_EQUALS,
        workingSetID.toString());

    final Row.Loader rl = new Row.Loader();

    try {
      ec.doQuery(query, rl);
    } catch (DBException e) {
      throw new WorkflowManagerException("Unexpected server error, please try again later.", e);
    }

    org.iucn.sis.shared.api.models.WorkflowStatus model =
        new org.iucn.sis.shared.api.models.WorkflowStatus();
    model.setId(rl.getRow().get("id").getInteger());
    model.setStatus(rl.getRow().get("status").toString());

    return model;
  }
  public void ensureEvaluated(WorkingSet workingSet) throws WorkflowManagerException {
    final Collection<Assessment> assessments =
        WorkflowManager.getAllAssessments(session, workingSet);
    Debug.println("Ensuring evaluation on " + assessments.size() + " assessments...");

    final String table = "RedListEvaluated";
    final Collection<String> failedSpecies = new ArrayList<String>();
    for (Assessment data : assessments) {
      // final String uid = data.getAssessmentID() + "_" + AssessmentType.DRAFT_ASSESSMENT_TYPE;
      final String uid = "" + data.getId();

      final SelectQuery query = new SelectQuery();
      query.select(table, "asm_id");
      query.constrain(
          new CanonicalColumnName(table, "is_evaluated"), QConstraint.CT_EQUALS, "true");
      query.constrain(
          QConstraint.CG_AND,
          new CanonicalColumnName(table, "approval_status"),
          QConstraint.CT_EQUALS,
          Integer.valueOf(1));
      query.constrain(
          QConstraint.CG_AND, new CanonicalColumnName(table, "uid"), QConstraint.CT_EQUALS, uid);

      final Row.Loader rl = new Row.Loader();

      try {
        ec.doQuery(query, rl);
      } catch (DBException e) {
        failedSpecies.add(data.getSpeciesName());
        continue;
      }

      if (rl.getRow() == null) failedSpecies.add(data.getSpeciesName());
    }

    if (!failedSpecies.isEmpty()) {
      final StringBuilder builder = new StringBuilder();
      builder.append("The following species have not yet been marked as evaluted: ");
      for (Iterator<String> iter = failedSpecies.iterator(); iter.hasNext(); )
        builder.append(iter.next() + (iter.hasNext() ? ", " : ""));
      throw new WorkflowManagerException(builder.toString());
    }
  }