@Override public final String toString() { StringBuilder buf = new StringBuilder(); toSQL(null, buf); return buf.toString(); }
public void toSQL(ColumnResolver resolver, StringBuilder buf) { child.toSQL(resolver, buf); if (!orderAscending) buf.append(" DESC"); if (nullsLast) buf.append(" NULLS LAST "); } }
public void toSQL(ColumnResolver resolver, StringBuilder buf) { node.toSQL(resolver, buf); if (alias != null) { buf.append(' '); if (isCaseSensitve) buf.append('"'); buf.append(alias); if (isCaseSensitve) buf.append('"'); } }
@Override public void toSQL(ColumnResolver resolver, StringBuilder buf) { List<ParseNode> children = getChildren(); children.get(0).toSQL(resolver, buf); if (negate) buf.append(" NOT"); buf.append(" BETWEEN "); children.get(1).toSQL(resolver, buf); buf.append(" AND "); children.get(2).toSQL(resolver, buf); } }
@Override public void toSQL(ColumnResolver resolver, StringBuilder buf) { List<ParseNode> children = getChildren(); children.get(0).toSQL(resolver, buf); if (negate) buf.append(" NOT"); buf.append(" " + (likeType == LikeType.CASE_SENSITIVE ? "LIKE" : "ILIKE") + " "); children.get(1).toSQL(resolver, buf); } }
@Override public void toSQL(ColumnResolver resolver, StringBuilder buf) { buf.append('('); List<ParseNode> children = getChildren(); children.get(0).toSQL(resolver, buf); for (int i = 1 ; i < children.size(); i++) { buf.append(" " + NAME + " "); children.get(i).toSQL(resolver, buf); } buf.append(')'); } }
@Override public void toSQL(ColumnResolver resolver, StringBuilder buf) { buf.append('('); List<ParseNode> children = getChildren(); children.get(0).toSQL(resolver, buf); for (int i = 1 ; i < children.size(); i++) { buf.append(" " + NAME + " "); children.get(i).toSQL(resolver, buf); } buf.append(')'); } }
@Override public void toSQL(ColumnResolver resolver, StringBuilder buf) { buf.append(' '); buf.append(PArrayDataType.ARRAY_TYPE_SUFFIX); buf.append('['); List<ParseNode> children = getChildren(); children.get(0).toSQL(resolver, buf); for (int i = 1 ; i < children.size(); i++) { buf.append(','); children.get(i).toSQL(resolver, buf); } buf.append(']'); } }
@Override public void toSQL(ColumnResolver resolver, StringBuilder buf) { List<ParseNode> children = getChildren(); buf.append(" NOT "); children.get(0).toSQL(resolver, buf); } }
@Override public void toSQL(ColumnResolver resolver, StringBuilder buf) { if (negate) buf.append(" NOT"); buf.append(" EXISTS "); getChildren().get(0).toSQL(resolver, buf); } }
@Override public void toSQL(ColumnResolver resolver, StringBuilder buf) { getChildren().get(0).toSQL(resolver, buf); buf.append(" IS"); if (negate) buf.append(" NOT"); buf.append(" NULL "); } }
@Override public void toSQL(ColumnResolver resolver, StringBuilder buf) { buf.append('('); List<ParseNode> children = getChildren(); children.get(0).toSQL(resolver, buf); for (int i = 1 ; i < children.size(); i++) { buf.append(" " + getOperator() + " "); children.get(i).toSQL(resolver, buf); } buf.append(')'); } }
@Override public void toSQL(ColumnResolver resolver, StringBuilder buf) { List<ParseNode> children = getChildren(); buf.append(' '); buf.append('('); if (!children.isEmpty()) { for (ParseNode child : children) { child.toSQL(resolver, buf); buf.append(','); } buf.setLength(buf.length()-1); } buf.append(')'); } }
@Override public void toSQL(ColumnResolver resolver, StringBuilder buf) { buf.append(' '); buf.append("COUNT(DISTINCT "); List<ParseNode> children = getChildren(); if (!children.isEmpty()) { for (ParseNode child : children) { child.toSQL(resolver, buf); buf.append(','); } buf.setLength(buf.length()-1); } buf.append(')'); } }
@Override public void toSQL(ColumnResolver resolver, StringBuilder buf) { buf.append(' '); buf.append(name); buf.append('('); List<ParseNode> children = getChildren(); if (!children.isEmpty()) { for (ParseNode child : children) { child.toSQL(resolver, buf); buf.append(','); } buf.setLength(buf.length()-1); } buf.append(')'); } }
@Override public void toSQL(ColumnResolver resolver, StringBuilder buf) { List<ParseNode> children = getChildren(); ParseNode rhs = children.get(0); ComparisonParseNode comp = (ComparisonParseNode)children.get(1); ParseNode lhs = comp.getLHS(); CompareOp op = comp.getFilterOp(); buf.append(' '); lhs.toSQL(resolver, buf); buf.append(" " + QueryUtil.toSQL(op) + " "); buf.append(getType()); buf.append('('); rhs.toSQL(resolver, buf); buf.append(')'); } }