public boolean visit(SQLSubqueryTableSource x) { x.getSelect().accept(this); return false; }
@Override public boolean visit(OracleWithSubqueryEntry x) { x.getSubQuery().accept(this); return false; }
public boolean visit(SQLAlterViewStatement x) { if (repository != null && x.getParent() == null) { repository.resolve(x); } x.getSubQuery().accept(this); return false; }
@Override public boolean visit(OracleCreateTableStatement x) { this.visit((SQLCreateTableStatement) x); if (x.getSelect() != null) { x.getSelect().accept(this); } return false; }
public boolean visit(SQLCreateViewStatement x) { if (repository != null && x.getParent() == null) { repository.resolve(x); } x.getSubQuery().accept(this); return false; }
@Override protected void accept0(SQLASTVisitor visitor) { if (visitor.visit(this)) { if (into != null) { into.accept(visitor); } if (select != null) { select.accept(visitor); } } visitor.endVisit(this); } }
@Override public boolean visit(MySqlSelectIntoStatement x) { x.getSelect().accept(this); print0(ucase ? " INTO " : " into "); for (int i = 0; i < x.getVarList().size(); i++) { x.getVarList().get(i).accept(this); if (i != x.getVarList().size() - 1) print0(", "); } return false; }
public void output(StringBuffer buf) { String dbType = null; SQLObject parent = this.getParent(); if (parent instanceof SQLStatement) { dbType = ((SQLStatement) parent).getDbType(); } if (dbType == null && parent instanceof OracleSQLObject) { dbType = JdbcConstants.ORACLE; } if (dbType == null && query instanceof SQLSelectQueryBlock) { dbType = ((SQLSelectQueryBlock) query).dbType; } SQLASTOutputVisitor visitor = SQLUtils.createOutputVisitor(buf, dbType); this.accept(visitor); }
public boolean visit(OracleCursorExpr x) { print0(ucase ? "CURSOR(" : "cursor("); this.indentCount++; println(); x.getQuery().accept(this); this.indentCount--; println(); print(')'); return false; }
@Override public boolean visit(SQLAllExpr x) { print0(ucase ? "ALL (" : "all ("); this.indentCount++; println(); x.getSubQuery().accept(this); this.indentCount--; println(); print(')'); return false; }
@Override public boolean visit(SQLSomeExpr x) { print0(ucase ? "SOME (" : "some ("); this.indentCount++; println(); x.getSubQuery().accept(this); this.indentCount--; println(); print(')'); return false; }
@Override public boolean visit(SQLAnyExpr x) { print0(ucase ? "ANY (" : "any ("); this.indentCount++; println(); x.getSubQuery().accept(this); this.indentCount--; println(); print(')'); return false; }
@Override public boolean visit(SQLWithSubqueryClause.Entry x) { String alias = x.getAlias(); SQLWithSubqueryClause with = (SQLWithSubqueryClause) x.getParent(); if (Boolean.TRUE == with.getRecursive()) { SQLSelect select = x.getSubQuery(); if (select != null) { select.accept(this); } else { x.getReturningStatement().accept(this); } } else { SQLSelect select = x.getSubQuery(); if (select != null) { select.accept(this); } else { x.getReturningStatement().accept(this); } } return false; }
public boolean visit(SQLDumpStatement x) { if (repository != null && x.getParent() == null) { repository.resolve(x); } final SQLExprTableSource into = x.getInto(); if (into != null) { into.accept(this); } final SQLSelect select = x.getSelect(); if (select != null) { select.accept(this); } return false; } }
@Override public boolean visit(MySqlCursorDeclareStatement x) { print0(ucase ? "DECLARE " : "declare "); printExpr(x.getCursorName()); print0(ucase ? " CURSOR FOR" : " cursor for"); this.indentCount++; println(); x.getSelect().accept(this); this.indentCount--; return false; }
@Override public boolean visit(SQLInSubQueryExpr x) { x.getExpr().accept(this); if (x.isNot()) { print0(ucase ? " NOT IN (" : " not in ("); } else { print0(ucase ? " IN (" : " in ("); } this.indentCount++; println(); x.getSubQuery().accept(this); this.indentCount--; println(); print(')'); return false; }
@Override public boolean visit(SQLSubqueryTableSource x) { print('('); this.indentCount++; println(); x.getSelect().accept(this); this.indentCount--; println(); print(')'); if (x.getAlias() != null) { print(' '); print0(x.getAlias()); } return false; }
@Override public boolean visit(SQLDumpStatement x) { List<SQLCommentHint> headHints = x.getHeadHintsDirect(); if (headHints != null) { for (SQLCommentHint hint : headHints) { hint.accept(this); println(); } } print0(ucase ? "DUMP DATA " : "dump data "); if (x.isOverwrite()) { print0(ucase ? "OVERWRITE " : "overwrite "); } SQLExprTableSource into = x.getInto(); if (into != null) { into.accept(this); } x.getSelect().accept(this); return false; }
public boolean visit(OracleSelectSubqueryTableSource x) { print('('); this.indentCount++; println(); x.getSelect().accept(this); this.indentCount--; println(); print(')'); if (x.getPivot() != null) { println(); x.getPivot().accept(this); } printFlashback(x.getFlashback()); if ((x.getAlias() != null) && (x.getAlias().length() != 0)) { print(' '); print0(x.getAlias()); } return false; }
public boolean visit(SQLCreateTableStatement x) { if (repository != null && x.getParent() == null) { repository.resolve(x); } for (SQLTableElement e : x.getTableElementList()) { e.setParent(x); } TableStat stat = getTableStat(x.getName()); stat.incrementCreateCount(); accept(x.getTableElementList()); if (x.getInherits() != null) { x.getInherits().accept(this); } if (x.getSelect() != null) { x.getSelect().accept(this); } return false; }