Examples with WithItem net.sf.jsqlparser.statement.select.WithItem used on opensource projects

Example 6 with WithItem

use of net.sf.jsqlparser.statement.select.WithItem in project JSqlParser by JSQLParser.

the class UpsertDeParser method appendSelect.

private void appendSelect(Upsert upsert) {
    buffer.append(" ");
    if (upsert.isUseSelectBrackets()) {
        buffer.append("(");
    }
    if (upsert.getSelect().getWithItemsList() != null) {
        buffer.append("WITH ");
        for (WithItem with : upsert.getSelect().getWithItemsList()) {
            with.accept(selectVisitor);
        }
        buffer.append(" ");
    }
    upsert.getSelect().getSelectBody().accept(selectVisitor);
    if (upsert.isUseSelectBrackets()) {
        buffer.append(")");
    }
}