public QuerySet whereNotIn(String column, String value, String type) throws SQLException { hasRan(); if (whereSet == null) { whereSet = "\nWHERE "; } else { whereSet += "\n" + type + " "; } checkSqlInValue(value); whereSet += column + " " + LogicOperands.NOT_IN + " (" + value + ")"; return this; }
private String renderArrayListWithIds(ArrayList<String> values) throws SQLException { hasRan(); String result = ""; StringBuilder sb = new StringBuilder(); for (String value : values) { sb.append(value).append(","); } if (sb.length() > 0) { sb.setLength(sb.length() - 1); } result = sb.toString(); // Additional check to verify that String in list are integers throws exception if not checkSqlInValue(result); return result; }