@Override public String toString() { return (recursive ? "RECURSIVE " : "") + name + ((withItemList != null) ? " " + PlainSelect. getStringList(withItemList, true, true) : "") + " AS (" + selectBody + ")"; }
@Override public String toString() { return "CASE " + ((switchExpression != null) ? switchExpression + " " : "") + PlainSelect.getStringList(whenClauses, false, false) + " " + ((elseExpression != null) ? "ELSE " + elseExpression + " " : "") + "END"; } }
@Override public String toString() { return PlainSelect.getStringList(expressions, true, true); } }
@Override public String toString() { return columnName + " " + colDataType + (columnSpecStrings != null ? " " + PlainSelect. getStringList(columnSpecStrings, false, false) : ""); } }
public String toString() { String sql = ""; sql = "INSERT INTO "; sql += table+" "; sql += ((columns!=null)?PlainSelect.getStringList(columns, true, true)+" ":""); if(useValues) { sql += "VALUES "+itemsList+""; } else { sql += ""+itemsList+""; } return sql; }
public String toString() { return "CASE "+((switchExpression!=null)?switchExpression+" ":"")+ PlainSelect.getStringList(whenClauses,false, false)+" "+ ((elseExpression!=null)?"ELSE "+elseExpression+" ":"")+ "END"; } }
@Override public String toString() { return " WHEN NOT MATCHED THEN INSERT " + (columns.isEmpty() ? "" : PlainSelect.getStringList(columns, true, true)) + " VALUES " + PlainSelect.getStringList(values, true, true); } }
@Override public String toString() { String idxSpecText = PlainSelect.getStringList(idxSpec, false, false); return type + (name != null ? " " + name : "") + " " + PlainSelect. getStringList(columnsNames, true, true) + (!"".equals(idxSpecText) ? " " + idxSpecText : ""); } }
public String toString() { String sql = "DROP "+type+" "+name; if( parameters != null && parameters.size() > 0) { sql += " "+PlainSelect.getStringList(parameters); } return sql; } }
private String parametersToString() { if (columnSpecs == null || columnSpecs.isEmpty()) { return ""; } return " " + PlainSelect.getStringList(columnSpecs, false, false); } }
@Override public String toString() { String sql = useUnique ? "UNIQUE" : "DISTINCT"; if (onSelectItems != null && !onSelectItems.isEmpty()) { sql += " ON (" + PlainSelect.getStringList(onSelectItems) + ")"; } return sql; } }
public static String getFormatedList(List<?> list, String expression, boolean useComma, boolean useBrackets) { String sql = getStringList(list, useComma, useBrackets); if (sql.length() > 0) { if (expression.length() > 0) { sql = " " + expression + " " + sql; } else { sql = " " + sql; } } return sql; }
@Override public String toString() { StringBuilder sql = new StringBuilder(); sql.append("VALUES "); sql.append(PlainSelect.getStringList(expressions, true, true)); return sql.toString(); }
@Override public String toString() { return "PIVOT (" + PlainSelect.getStringList(functionItems) + " FOR " + PlainSelect. getStringList(forColumns, true, forColumns != null && forColumns.size() > 1) + " IN " + PlainSelect.getStringList(getInItems(), true, true) + ")" + (alias!=null?alias.toString():""); } }
@Override public String toString() { String sql = "DROP " + type + " " + (ifExists ? "IF EXISTS " : "") + name.toString(); if (parameters != null && !parameters.isEmpty()) { sql += " " + PlainSelect.getStringList(parameters); } return sql; } }
@Override public String toString() { List<Column> forColumns = getForColumns(); String in = inAny ? "ANY" : inSelect == null ? PlainSelect.getStringList(getInItems()) : inSelect. toString(); return "PIVOT XML (" + PlainSelect.getStringList(getFunctionItems()) + " FOR " + PlainSelect. getStringList(forColumns, true, forColumns != null && forColumns.size() > 1) + " IN (" + in + "))"; }
void toStringPartitionBy(StringBuilder b) { if (partitionExpressionList != null && !partitionExpressionList.getExpressions().isEmpty()) { b.append("PARTITION BY "); b.append(PlainSelect. getStringList(partitionExpressionList.getExpressions(), true, false)); b.append(" "); } } }
public void deParse(Drop drop) { buffer.append("DROP "); buffer.append(drop.getType()); if (drop.isIfExists()) { buffer.append(" IF EXISTS"); } buffer.append(" ").append(drop.getName()); if (drop.getParameters() != null && !drop.getParameters().isEmpty()) { buffer.append(" ").append(PlainSelect.getStringList(drop.getParameters())); } }
@Override public String toString() { String idxSpecText = PlainSelect.getStringList(getIndexSpec(), false, false); return (getName() != null ? "CONSTRAINT " + getName() + " " : "") + getType() + " " + PlainSelect.getStringList(getColumnsNames(), true, true) + (!"". equals(idxSpecText) ? " " + idxSpecText : ""); } }
@Override public String toString() { return execType.name() + " " + name + (exprList != null && exprList.getExpressions() != null ? " " + PlainSelect.getStringList(exprList.getExpressions(), true, parenthesis) : ""); }