@Override public String toString() { String allDistinct = ""; if (isAll()) { allDistinct = " ALL"; } else if (isDistinct()) { allDistinct = " DISTINCT"; } return super.toString() + allDistinct; } }
@Override public void visit( SetOperationList setOpList ) { List<SelectBody> selects; int index; for ( SetOperation ops : setOpList.getOperations() ) { if ( "union all".equalsIgnoreCase( ops.getASTNode().jjtGetValue().toString() ) ) { selects = setOpList.getSelects(); for ( index = ops.getASTNode().jjtGetNumChildren() - 1; index >= 0; index -= 1 ) { ( ( PlainSelect ) selects.get( index ) ).setUseBrackets( true ); } } } setOpList.setLimit( limit ); pagingSql = setOpList.toString(); logger.debug( "Build paging sql: {}", pagingSql ); PlainSelect plainSelect; for ( SelectBody select : setOpList.getSelects() ) { plainSelect = ( PlainSelect ) select; plainSelect.setLimit( null ); plainSelect.setUseBrackets( false ); plainSelect.getSelectItems().clear(); plainSelect.setSelectItems( createCountFunction() ); countingSql.add( plainSelect.toString() ); } logger.debug( "Build counting sql: {}", countingSql ); }
@Override public String toString() { StringBuilder buffer = new StringBuilder(); for (int i = 0; i < selects.size(); i++) { if (i != 0) { buffer.append(" ").append(operations.get(i - 1).toString()).append(" "); } if (brackets == null || brackets.get(i)) { buffer.append("(").append(selects.get(i).toString()).append(")"); } else { buffer.append(selects.get(i).toString()); } } if (orderByElements != null) { buffer.append(PlainSelect.orderByToString(orderByElements)); } if (limit != null) { buffer.append(limit.toString()); } if (offset != null) { buffer.append(offset.toString()); } if (fetch != null) { buffer.append(fetch.toString()); } return buffer.toString(); }
@Override public String toString() { String allDistinct = ""; if (isAll()) { allDistinct = " ALL"; } else if (isDistinct()) { allDistinct = " DISTINCT"; } return super.toString() + allDistinct; } }
@Override public String toString() { StringBuilder buffer = new StringBuilder(); for (int i = 0; i < selects.size(); i++) { if (i != 0) { buffer.append(" ").append(operations.get(i - 1).toString()).append(" "); } if (brackets == null || brackets.get(i)) { buffer.append("(").append(selects.get(i).toString()).append(")"); } else { buffer.append(selects.get(i).toString()); } } if (orderByElements != null) { buffer.append(PlainSelect.orderByToString(orderByElements)); } if (limit != null) { buffer.append(limit.toString()); } if (offset != null) { buffer.append(offset.toString()); } if (fetch != null) { buffer.append(fetch.toString()); } return buffer.toString(); }
@Override public String toString() { StringBuilder buf = new StringBuilder(); for (int i = 0; i < getPlainSelects().size(); i++) { if (i != 0) { buf.append(" ") .append(getOperations().get(i - 1).toString()) .append(" "); } buf.append(getPlainSelects().get(i).toString()); } if (getOrderByElements() != null) { buf.append(PlainSelect.orderByToString(getOrderByElements())); } if (getLimit() != null) { buf.append(getLimit().toString()); } return buf.toString(); }
@Override public void visit(SetOperationList setOpList) { if (transformEXCEPT && setOpList.getOperations().size()>0 && setOpList.getOperations().get(0).toString().equals(SetOperationList.SetOperationType.EXCEPT.name())) { assert setOpList.getPlainSelects().size() == 2 : setOpList; PlainSelect left = setOpList.getPlainSelects().get(0);