Method list

jnode-core/src/jnode/robot/ScriptFix.java:178–221

()

	}

	private String list() throws SQLException {

		StringBuilder sb = new StringBuilder();
		sb.append("==============  List of all jscripts ===============\n");
		sb.append("| id  |                   content                  |\n");
		sb.append("|-----|--------------------------------------------|\n");
		for (Jscript js : ORMManager.get(Jscript.class).getOrderAnd("id", true)) {
			String code = js.getContent();
			boolean first = true;
			for (int i = 0; i < code.length(); i += 42) {
				int endIndex = (code.length() > i + 42) ? i + 42 : code
						.length();
				String sub = code.substring(i, endIndex);
				String id = (first) ? String.format("%05d", js.getId())
						: "     ";
				for (int j = 42; j > sub.length(); j--) {
					sub += " ";
				}
				sb.append("|" + id + "| " + sub + " |\n");
				first = false;
			}
			sb.append("|-----|--------------scheduled-at------------------|\n");
			for (Schedule s : ORMManager.get(Schedule.class).getAnd(
					"jscript_id", "=", js)) {
				String fmt = String.format(
						"|%05d|      %s AT %02d LAST %s",
						s.getId(),
						s.getType().name(),
						s.getDetails(),
						(s.getLastRunDate() != null) ? format.format(s
								.getLastRunDate()) : "NEVER");
				for (int j = 53; j > fmt.length(); j--) {
					fmt += " ";
				}
				fmt += "|\n";
				sb.append(fmt);
			}
			sb.append("|-----|--------------------------------------------|\n");

		}
		sb.append("============== List of all jscripts ================\n");
		return sb.toString();

	}
}