예제 #1
0
 // helper method
 protected void doUpdate(Database db, Tuple request)
     throws DatabaseException, IOException, ParseException {
   Entity entity = getModel().create();
   ScreenMessage msg = null;
   try {
     entity.set(request, false);
     int updatedRows = db.update(entity);
     msg = new ScreenMessage("UPDATE SUCCESS: affected " + updatedRows, null, true);
   } catch (Exception e) {
     logger.error("doUpdate(): " + e);
     e.printStackTrace();
     msg = new ScreenMessage("UPDATE FAILED: " + e.getMessage(), null, false);
   }
   getModel().getMessages().add(msg);
   if (msg.isSuccess()) {
     pager.setDirty(true);
     // resetChildren();
   }
 }
예제 #2
0
  /**
   * Helper function to add a record from UI
   *
   * @param request
   * @return true if add was successfull, false if it wassen't
   * @throws ParseException
   * @throws DatabaseException
   * @throws IOException
   */
  public boolean doAdd(Database db, Tuple request)
      throws ParseException, DatabaseException, IOException {
    ScreenMessage msg = null;
    Entity entity = getModel().create();
    boolean result = false;

    try {
      db.beginTx();
      entity.set(request, false);
      int updatedRows = 0;
      if (request.getObject(FormModel.INPUT_BATCHADD) != null
          && request.getInt(FormModel.INPUT_BATCHADD) > 1) {
        // batch
        int i;
        for (i = 0; i < request.getInt(FormModel.INPUT_BATCHADD); i++) {
          updatedRows += db.add(entity);
        }
      } else {
        updatedRows = db.add(entity);
      }
      db.commitTx();
      msg = new ScreenMessage("ADD SUCCESS: affected " + updatedRows, null, true);
      result = true;
      // navigate to newly added record
      pager.last(db);

    } catch (Exception e) {
      db.rollbackTx();
      msg = new ScreenMessage("ADD FAILED: " + e.getMessage(), null, false);
      result = false;
    }
    getModel().getMessages().add(msg);

    /* make sure the user sees the newly added record(s) */
    // view.setMode(FormScreen.Mode.RECORD_VIEW);
    // pager.setLimit(1);
    pager.resetOrderBy();
    pager.last(db);
    // should reset to an order that shows the record on the end

    return result;
  }
  private static void showSelectFilterDialogForEntity(Entity entity, PrintWriter out, Database db) {
    logger.debug("show 'set filters' dialogue");
    out.println("<html><body>");
    out.println(
        "<head><script src=\"../../../res/scripts/rest.js\" language=\"javascript\"></script></head>");
    out.println("<h1>REST url wizard:</h1>");
    out.println("Step 2: choose filters<br>");
    out.println("<form>");
    out.println(
        "You choose to use the REST interface for retrieval of '"
            + entity.getClass().getName()
            + "' data. (<a href=\"../find\">back</a>)<br><br> Here you can add filters:<br>");

    SelectInput fieldInput = new SelectInput("field", null);
    fieldInput.setOptions(entity.getFields().toArray(new String[entity.getFields().size()]));

    SelectInput operatorInput = new SelectInput("operator", null);
    List<String> operators = new ArrayList<String>();
    operators.add(QueryRule.Operator.EQUALS.toString());
    operators.add(QueryRule.Operator.GREATER_EQUAL.toString());
    operators.add(QueryRule.Operator.NOT.toString());
    operators.add(QueryRule.Operator.LESS.toString());
    operators.add(QueryRule.Operator.LESS_EQUAL.toString());
    operators.add(QueryRule.Operator.LIKE.toString());
    operatorInput.setOptions(operators.toArray(new String[operators.size()]));

    StringInput valueInput = new StringInput("value", null);

    out.println(fieldInput.getHtml() + operatorInput.getHtml() + valueInput.getHtml());
    out.println("<br>");

    out.println(fieldInput.getHtml() + operatorInput.getHtml() + valueInput.getHtml());
    out.println("<br>");

    out.println(
        "<input type=\"submit\" value=\"generate url\" onclick=\"generateRestUrl(this.form.elements); return false\">");

    out.println("TIP: notice how the url is bookmarkeable for future downloads!");
    out.println("TIP: click 'save as...' and name it as '.txt' file.");
    out.println("</form></body></html>");
  }
예제 #4
0
  // helper method
  protected void doRemove(Database db, Tuple request)
      throws DatabaseException, ParseException, IOException {
    Entity entity = getModel().create();
    ScreenMessage msg = null;
    try {
      entity.set(request);
      int updatedRows = db.remove(entity);
      if (updatedRows > 0)
        msg = new ScreenMessage("REMOVE SUCCESS: affected " + updatedRows, null, true);
      else msg = new ScreenMessage("REMOVE FAILED: call system administrator", null, false);
    } catch (Exception e) {
      msg = new ScreenMessage("REMOVE FAILED: " + e.getMessage(), null, false);
    }
    getModel().getMessages().add(msg);

    // **make sure the user sees a record**/
    if (msg.isSuccess()) {
      pager.prev(db);
      // resetChildren();
    }
  }