Method query

jnode-core/src/jnode/robot/AreaFix.java:248–270

Отправляем %QUERY @param link @return @throws SQLException

(Link link)

	 * @throws SQLException
	 */
	private String query(Link link) throws SQLException {
		StringBuilder sb = new StringBuilder();
		sb.append("========== List of subscribed areas ==========\n");
		GenericRawResults<String[]> echoes = ORMManager
				.get(Echoarea.class)
				.getRaw(String
						.format("SELECT a.name, a.description from echoarea a"
								+ " LEFT JOIN subscription s on (a.id=s.echoarea_id)"
								+ " WHERE s.link_id=%d ORDER BY a.name",
								link.getId()));
		for (String[] echo : echoes.getResults()) {
			sb.append("* ");
			sb.append(echo[0]);
			if (echo[1].length() > 0) {
				sb.append(" - ");
				sb.append(echo[1]);
			}
			sb.append('\n');
		}
		sb.append("========== List of subscribed areas ==========\n");
		return sb.toString();

	}

	private String add(Link link, String area) throws SQLException {
		StringBuilder sb = new StringBuilder();