Examples with OracleOutputVisitor com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor used on opensource projects

Example 16 with OracleOutputVisitor

use of com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor in project druid by alibaba.

the class OracleSelectGroupingTest method output.

private void output(List<SQLStatement> stmtList) {
    StringBuilder out = new StringBuilder();
    OracleOutputVisitor visitor = new OracleOutputVisitor(out);
    for (SQLStatement stmt : stmtList) {
        stmt.accept(visitor);
        visitor.println();
    }
    System.out.println(out.toString());
}

Example 17 with OracleOutputVisitor

use of com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor in project druid by alibaba.

the class SQLMergeTest method merge.

private String merge() {
    StringBuilder out = new StringBuilder();
    OracleOutputVisitor visitor = new OracleOutputVisitor(out) {

        public boolean visit(SQLInListExpr x) {
            x.getExpr().accept(this);
            if (x.isNot()) {
                print(" NOT IN (##)");
            } else {
                print(" IN (##)");
            }
            return false;
        }
    };
    OracleStatementParser parser = new OracleStatementParser(sql);
    List<SQLStatement> statementList = parser.parseStatementList();
    for (SQLStatement statement : statementList) {
        statement.accept(visitor);
        visitor.println();
    }
    return out.toString();
}

Example 18 with OracleOutputVisitor

use of com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor in project druid by alibaba.

the class Demo0 method test_demo_0.

public void test_demo_0() throws Exception {
    String sql = "SELECT SYSDATE FROM DUAL";
    // parser得到AST
    SQLStatementParser parser = new OracleStatementParser(sql);
    // 
    List<SQLStatement> stmtList = parser.parseStatementList();
    // 将AST通过visitor输出
    StringBuilder out = new StringBuilder();
    OracleOutputVisitor visitor = new OracleOutputVisitor(out);
    for (SQLStatement stmt : stmtList) {
        stmt.accept(visitor);
        out.append(";");
    }
    System.out.println(out.toString());
}

Example 19 with OracleOutputVisitor

use of com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor in project druid by alibaba.

the class OracleTest method output.

protected String output(List<SQLStatement> stmtList) {
    StringBuilder out = new StringBuilder();
    OracleOutputVisitor visitor = new OracleOutputVisitor(out);
    for (SQLStatement stmt : stmtList) {
        stmt.accept(visitor);
    }
    return out.toString();
}

Example 20 with OracleOutputVisitor

use of com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor in project druid by alibaba.

the class CallTest method output.

private void output(List<SQLStatement> stmtList) {
    StringBuilder out = new StringBuilder();
    OracleOutputVisitor visitor = new OracleOutputVisitor(out);
    for (SQLStatement stmt : stmtList) {
        stmt.accept(visitor);
        visitor.println();
    }
    System.out.println(out.toString());
}