@Override public void visit(SubSelect subSelect) { if (subSelect.isUseBrackets()) { buffer.append("("); } if (selectVisitor != null) { if (subSelect.getWithItemsList() != null) { buffer.append("WITH "); for (Iterator<WithItem> iter = subSelect.getWithItemsList().iterator(); iter. hasNext();) { iter.next().accept(selectVisitor); if (iter.hasNext()) { buffer.append(", "); } buffer.append(" "); } buffer.append(" "); } subSelect.getSelectBody().accept(selectVisitor); } if (subSelect.isUseBrackets()) { buffer.append(")"); } }
@Override public void visit(SubSelect subSelect) { buffer.append("("); if (subSelect.getWithItemsList() != null && !subSelect.getWithItemsList().isEmpty()) { buffer.append("WITH "); for (Iterator<WithItem> iter = subSelect.getWithItemsList().iterator(); iter.hasNext();) { WithItem withItem = iter.next(); withItem.accept(this); if (iter.hasNext()) { buffer.append(","); } buffer.append(" "); } } subSelect.getSelectBody().accept(this); buffer.append(")"); Alias alias = subSelect.getAlias(); if (alias != null) { buffer.append(alias.toString()); } Pivot pivot = subSelect.getPivot(); if (pivot != null) { pivot.accept(this); } }
@Override public void visit(Select select) { selectDeParser.setBuffer(buffer); expressionDeParser.setSelectVisitor(selectDeParser); expressionDeParser.setBuffer(buffer); selectDeParser.setExpressionVisitor(expressionDeParser); if (select.getWithItemsList() != null && !select.getWithItemsList().isEmpty()) { buffer.append("WITH "); for (Iterator<WithItem> iter = select.getWithItemsList().iterator(); iter.hasNext();) { WithItem withItem = iter.next(); withItem.accept(selectDeParser); if (iter.hasNext()) { buffer.append(","); } buffer.append(" "); } } select.getSelectBody().accept(selectDeParser); }
@Override public void visit(SubSelect subSelect) { if (subSelect.getWithItemsList() != null) { for (WithItem withItem : subSelect.getWithItemsList()) { withItem.accept(this); } } subSelect.getSelectBody().accept(this); }
@Override public void visit(Select select) { if (select.getWithItemsList() != null) { for (WithItem withItem : select.getWithItemsList()) { withItem.accept(this); } } select.getSelectBody().accept(this); }
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(")"); } }
item.accept(selectVisitor);
buffer.append("WITH "); for (WithItem with : insert.getSelect().getWithItemsList()) { with.accept(selectVisitor);
@Override public void visit(SubSelect subSelect) { if (selectVisitor != null) { if (subSelect.getWithItemsList() != null) { for (WithItem item : subSelect.getWithItemsList()) { item.accept(selectVisitor); } } subSelect.getSelectBody().accept(selectVisitor); } if (subSelect.getPivot() != null) { subSelect.getPivot().accept(this); } }
@Override public void visit(SubSelect subSelect) { if (subSelect.getSelectBody() != null) { subSelect.getSelectBody().accept(this); } if (subSelect.getWithItemsList() != null) { subSelect.getWithItemsList().forEach(e -> e.accept(this)); } }
@Override public void visit(Select select) { if (select.getWithItemsList() != null) { for (WithItem withItem : select.getWithItemsList()) { withItem.accept(this); } } select.getSelectBody().accept(this); }
@Override public void visit(SubSelect subSelect) { if (subSelect.getWithItemsList() != null) { for (WithItem withItem : subSelect.getWithItemsList()) { withItem.accept(this); } } subSelect.getSelectBody().accept(this); }
@Override public void visit(Select select) { if (select.getSelectBody() != null) { select.getSelectBody().accept(this); } if (select.getWithItemsList() != null) { select.getWithItemsList().forEach( i -> { if (i != null) { i.accept(this); } } ); } }
/** * Main entry for this Tool class. A list of found tables is returned. * * @param select */ public TableNameVisitor(Select select, QuotedIDFactory idfac) throws JSQLParserException { this.idfac = idfac; if (select.getWithItemsList() != null) { for (WithItem withItem : select.getWithItemsList()) withItem.accept(selectVisitor); } select.getSelectBody().accept(selectVisitor); }
/** * Main entry for this Tool class. A list of found tables is returned. * * @param select */ public TableNameVisitor(Select select, QuotedIDFactory idfac) throws JSQLParserException { this.idfac = idfac; if (select.getWithItemsList() != null) { for (WithItem withItem : select.getWithItemsList()) withItem.accept(selectVisitor); } select.getSelectBody().accept(selectVisitor); }
/** * Return a {@link AggregationJSQL} containing GROUP BY statement * @param select * @return */ public AggregationJSQL getAggregation(Select select, boolean deepParsing){ if (select.getWithItemsList() != null) { for (WithItem withItem : select.getWithItemsList()) { withItem.accept(this); } } select.getSelectBody().accept(this); return aggregation; }
/** * NORMALISES EXPRESSION ALIAS NAMES in SELECT clauses (including subqueries) * * @param select * @param idfac */ public AliasMapVisitor(Select select, QuotedIDFactory idfac) { this.idfac = idfac; if (select.getWithItemsList() != null) { for (WithItem withItem : select.getWithItemsList()) { withItem.accept(selectVisitor); } } select.getSelectBody().accept(selectVisitor); }
/** * Return the list of columns with the expressions between SELECT and FROM, * considering also the case of UNION * * @param select parsed statement * @return */ public ColumnsVisitor(Select select) { if (select.getWithItemsList() != null) { for (WithItem withItem : select.getWithItemsList()) { withItem.accept(this); } } select.getSelectBody().accept(this); }
@Override public void visit(SubSelect subSelect) { if (selectVisitor != null) { if (subSelect.getWithItemsList() != null) { for (WithItem item : subSelect.getWithItemsList()) { item.accept(selectVisitor); } } subSelect.getSelectBody().accept(selectVisitor); } if (subSelect.getPivot() != null) { subSelect.getPivot().accept(this); } }
/** * Method to substitute * from the select query. It add the columns name that are used in the mapping * @param select the query with or without * * @param variables the variables used in the mapping, this are the needed columns for our select query * @return the query with columns or functions in the projection part */ public String getMappingQuery(Select select, Set<Variable> variables) { VariableSet variableNames = new VariableSet(variables); if (select.getWithItemsList() != null) { for (WithItem withItem : select.getWithItemsList()) withItem.accept(new ReplaceStarSelectVisitor(false, null, variableNames)); } select.getSelectBody().accept(new ReplaceStarSelectVisitor(false, null, variableNames)); return select.toString(); }