Package com.alibaba.druid.sql.dialect.oracle.visitor

Examples of com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor

46
47
48
49
50
51
52
53
54
55
        Assert.assertEquals(2, visitor.getColumns().size());
        Assert.assertEquals(true, visitor.getColumns().contains(new Column("emp", "salary")));
        Assert.assertEquals(true, visitor.getColumns().contains(new Column("emp", "F1")));

        StringBuilder buf = new StringBuilder();
        OracleOutputVisitor outputVisitor = new OracleOutputVisitor(buf);
        stmt.accept(outputVisitor);
        Assert.assertEquals("SELECT MAX(salary)\nFROM emp\nWHERE F1 = DATE '2011-10-01';\n", buf.toString());

    }
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
54
55
56
        output(statementList);
    }

    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());
    }
View Full Code Here
46
47
48
49
50
51
52
53
54
55
        Assert.assertEquals(2, visitor.getColumns().size());
        Assert.assertEquals(true, visitor.getColumns().contains(new Column("employee", "salary")));
        Assert.assertEquals(true, visitor.getColumns().contains(new Column("employee", "name")));

        StringBuilder buf = new StringBuilder();
        OracleOutputVisitor outputVisitor = new OracleOutputVisitor(buf);
        stmt.accept(outputVisitor);
        Assert.assertEquals("SELECT salary\nFROM employee\nORDER BY name;\n", buf.toString());

    }
View Full Code Here
21
22
23
24
25
26
27
28
29
30
31
       OracleStatementParser parser = new OracleStatementParser(sql);
       List<SQLStatement> statementList = parser.parseStatementList();
       SQLStatement stmt = statementList.get(0);
      
       StringBuilder out = new StringBuilder();
       stmt.accept(new OracleOutputVisitor(out, true));

       String newSQL = out.toString();      
       Assert.assertEquals("SELECT /*+leading(e) index(e ORD_ORDER_ITEM_GS_BS_DI_IND)*/ DISTINCT e.id\nFROM ord_order_item e\nWHERE e.F1 = DATE '2011-10-01';\n", newSQL);
      
  }
View Full Code Here
93
94
95
96
97
98
99
100
101
102
        return format(sql, JdbcUtils.ORACLE);
    }

    public static String toOracleString(SQLObject sqlObject) {
        StringBuilder out = new StringBuilder();
        sqlObject.accept(new OracleOutputVisitor(out));

        String sql = out.toString();
        return sql;
    }
View Full Code Here
164
165
166
167
168
169
170
171
172
173
174
175
176
    public static SQLASTOutputVisitor createFormatOutputVisitor(Appendable out, List<SQLStatement> statementList,
                                                                String dbType) {
        if (JdbcUtils.ORACLE.equals(dbType) || JdbcUtils.ALI_ORACLE.equals(dbType)) {
            if (statementList.size() == 1) {
                return new OracleOutputVisitor(out, false);
            } else {
                return new OracleOutputVisitor(out, true);
            }
        }

        if (JdbcUtils.MYSQL.equals(dbType)) {
            return new MySqlOutputVisitor(out);
View Full Code Here
44
45
46
47
48
49
50
        return new OracleMappingVisitor(engine, context);
    }

    @Override
    public SQLASTOutputVisitor createOutputVisitor(MappingEngine engine, Appendable out) {
        return new OracleOutputVisitor(out, false);
    }
View Full Code Here
99
100
101
102
103
104
105
106
107
108
        return format(sql, JdbcUtils.ORACLE);
    }

    public static String toOracleString(SQLObject sqlObject) {
        StringBuilder out = new StringBuilder();
        sqlObject.accept(new OracleOutputVisitor(out, false));

        String sql = out.toString();
        return sql;
    }
View Full Code Here
190
191
192
193
194
195
196
197
198
199
200
201
202
    public static SQLASTOutputVisitor createFormatOutputVisitor(Appendable out, List<SQLStatement> statementList,
                                                                String dbType) {
        if (JdbcUtils.ORACLE.equals(dbType) || JdbcUtils.ALI_ORACLE.equals(dbType)) {
            if (statementList.size() == 1) {
                return new OracleOutputVisitor(out, false);
            } else {
                return new OracleOutputVisitor(out, true);
            }
        }

        if (JdbcUtils.MYSQL.equals(dbType) || //
            JdbcUtils.MARIADB.equals(dbType) || //
View Full Code Here
100
101
102
103
104
105
106
107
108
109
        return format(sql, JdbcUtils.ORACLE);
    }

    public static String toOracleString(SQLObject sqlObject) {
        StringBuilder out = new StringBuilder();
        sqlObject.accept(new OracleOutputVisitor(out, false));

        String sql = out.toString();
        return sql;
    }
View Full Code Here
TOP

Related Classes of com.alibaba.druid.sql.dialect.oracle.visitor.OracleOutputVisitor

  • com.alibaba.druid.bvt.sql.oracle.CallTest
  • com.alibaba.druid.bvt.sql.oracle.OracleHintTest
  • com.alibaba.druid.bvt.sql.oracle.OracleSelectGroupingTest
  • com.alibaba.druid.bvt.sql.oracle.OracleSelectParserTest
  • com.alibaba.druid.bvt.sql.oracle.OracleSQLParserTest
  • com.alibaba.druid.bvt.sql.oracle.visitor.OracleOutputVisitorTest_Aggregate
  • com.alibaba.druid.bvt.sql.oracle.visitor.OracleOutputVisitorTest_dblink
  • com.alibaba.druid.bvt.sql.oracle.visitor.OracleOutputVisitorTest_delete
  • com.alibaba.druid.bvt.sql.oracle.visitor.OracleOutputVisitorTest_forupdate
  • com.alibaba.druid.bvt.sql.oracle.visitor.OracleOutputVisitorTest_orderBy
    • 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.