Package com.alibaba.druid.sql.visitor

Examples of com.alibaba.druid.sql.visitor.SQLASTOutputVisitor

155
156
157
158
159
160
161
162
163
164
165
        }
    }

    public static String toSQLString(List<SQLStatement> statementList, String dbType) {
        StringBuilder out = new StringBuilder();
        SQLASTOutputVisitor visitor = createFormatOutputVisitor(out, statementList, dbType);

        for (SQLStatement stmt : statementList) {
            stmt.accept(visitor);
        }
View Full Code Here
194
195
196
197
198
199
200
        if (JdbcUtils.H2.equals(dbType)) {
            return new MySqlOutputVisitor(out);
        }

        return new SQLASTOutputVisitor(out);
    }
View Full Code Here
65
66
67
68
69
70
71
72
73
74
        return toSQLServerString(sqlObject);
    }

    public static String toSQLString(SQLObject sqlObject) {
        StringBuilder out = new StringBuilder();
        sqlObject.accept(new SQLASTOutputVisitor(out));

        String sql = out.toString();
        return sql;
    }
View Full Code Here
160
161
162
163
164
165
166
167
168
169
170
171
172
        return toSQLString(statementList, dbType, null);
    }

    public static String toSQLString(List<SQLStatement> statementList, String dbType, List<Object> parameters) {
        StringBuilder out = new StringBuilder();
        SQLASTOutputVisitor visitor = createFormatOutputVisitor(out, statementList, dbType);
        if (parameters != null) {
            visitor.setParameters(parameters);
        }

        for (SQLStatement stmt : statementList) {
            stmt.accept(visitor);
        }
View Full Code Here
200
201
202
203
204
205
206
        if (JdbcUtils.JTDS.equals(dbType)) {
            return new SQLServerOutputVisitor(out);
        }

        return new SQLASTOutputVisitor(out);
    }
View Full Code Here
65
66
67
68
69
70
71
72
73
74
        return toSQLServerString(sqlObject);
    }

    public static String toSQLString(SQLObject sqlObject) {
        StringBuilder out = new StringBuilder();
        sqlObject.accept(new SQLASTOutputVisitor(out));

        String sql = out.toString();
        return sql;
    }
View Full Code Here
163
164
165
166
167
168
169
170
171
172
173
174
175
        return toSQLString(statementList, dbType, null);
    }
   
    public static String toSQLString(List<SQLStatement> statementList, String dbType, List<Object> parameters) {
        StringBuilder out = new StringBuilder();
        SQLASTOutputVisitor visitor = createFormatOutputVisitor(out, statementList, dbType);
        if (parameters != null) {
            visitor.setParameters(parameters);
        }

        for (SQLStatement stmt : statementList) {
            stmt.accept(visitor);
        }
View Full Code Here
205
206
207
208
209
210
211
        if (JdbcUtils.H2.equals(dbType)) {
            return new MySqlOutputVisitor(out);
        }

        return new SQLASTOutputVisitor(out);
    }
View Full Code Here
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
        String sql = "select * from ge_rms_company start with comcode = '00' connect by nocycle prior comcode = uppercomcode";
        SQLStatementParser parser = SQLParserUtils.createSQLStatementParser(sql, JdbcUtils.ORACLE);
        List<SQLStatement> stmtList = parser.parseStatementList();
        StringBuilder out = new StringBuilder();
        // PrettyFormat use default : true
        SQLASTOutputVisitor visitor = new OracleOutputVisitor(out);
        for(SQLStatement statement : stmtList) {
            statement.accept(visitor);
        }

        String expectResult = "SELECT *\nFROM ge_rms_company\nSTART WITH comcode = '00'\nCONNECT BY NOCYCLE PRIOR comcode = uppercomcode;\n";
        Assert.assertEquals(expectResult, out.toString());

        out.setLength(0);
        visitor = new OracleOutputVisitor(out);
        // setPrettyFormat : false
        visitor.setPrettyFormat(false);
        for(SQLStatement statement : stmtList) {
            statement.accept(visitor);
        }
        expectResult = "SELECT * FROM ge_rms_company START WITH comcode = '00' CONNECT BY NOCYCLE PRIOR comcode = uppercomcode";
        Assert.assertEquals(expectResult, out.toString());
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
        return output(Arrays.asList(stmtList));
    }

    public static String output(List<SQLStatement> stmtList) {
        StringBuilder out = new StringBuilder();
        SQLASTOutputVisitor visitor = new SQLASTOutputVisitor(out);

        for (SQLStatement stmt : stmtList) {
            stmt.accept(visitor);
        }
View Full Code Here
TOP

Related Classes of com.alibaba.druid.sql.visitor.SQLASTOutputVisitor

  • com.alibaba.druid.bvt.sql.oracle.visitor.OracleOutputVisitorTest_PrettyFormat
  • com.alibaba.druid.mapping.MappingEngine
  • com.alibaba.druid.sql.ast.expr.SQLBinaryOpExpr
  • com.alibaba.druid.sql.ast.expr.SQLCharExpr
  • com.alibaba.druid.sql.ast.SQLExpr
  • com.alibaba.druid.sql.ast.SQLObject
  • com.alibaba.druid.sql.ast.statement.SQLAlterTableItem
  • com.alibaba.druid.sql.ast.statement.SQLExprTableSource
  • com.alibaba.druid.sql.ast.statement.SQLSelect
  • com.alibaba.druid.sql.SQLUtils
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.