Package com.alibaba.druid.sql.ast.statement

Examples of com.alibaba.druid.sql.ast.statement.SQLSelectStatement

1364
1365
1366
1367
1368
1369
1370
    }

    public SQLSelectStatement parseSelect() {
        SQLSelectParser selectParser = createSQLSelectParser();
        SQLSelect select = selectParser.select();
        return new SQLSelectStatement(select);
    }
View Full Code Here
1737
1738
1739
1740
1741
1742
1743
1744
1745
        if (!(select.getParent() instanceof SQLSelectStatement)) {
            return false;
        }

        SQLSelectStatement stmt = (SQLSelectStatement) select.getParent();

        return stmt.getParent() == null;
    }
View Full Code Here
1761
1762
1763
1764
1765
1766
1767
1768
1769
1770
1771
1772
                        parent = parent.getParent();
                    }

                    boolean sameToTopSelectSchema = false;
                    if (parent instanceof SQLSelectStatement) {
                        SQLSelectStatement selectStmt = (SQLSelectStatement) parent;
                        SQLSelectQuery query = selectStmt.getSelect().getQuery();
                        if (query instanceof SQLSelectQueryBlock) {
                            SQLSelectQueryBlock queryBlock = (SQLSelectQueryBlock) query;
                            SQLTableSource from = queryBlock.getFrom();

                            while (from instanceof SQLJoinTableSource) {
View Full Code Here
1878
1879
1880
1881
1882
1883
1884
1885
        SQLSelect select = (SQLSelect) queryBlock.getParent();
        if (!(select.getParent() instanceof SQLSelectStatement)) {
            return false;
        }

        SQLSelectStatement stmt = (SQLSelectStatement) select.getParent();
        return stmt.getParent() == null;
    }
View Full Code Here
2039
2040
2041
2042
2043
2044
2045
2046
        SQLSelect select = (SQLSelect) queryBlock.getParent();
        if (!(select.getParent() instanceof SQLSelectStatement)) {
            return false;
        }

        SQLSelectStatement stmt = (SQLSelectStatement) select.getParent();
        return stmt.getParent() == null;
    }
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
        String expect = "SELECT salary\n" + "FROM employees\n" + "AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '1' DAY)\n"
                        + "WHERE last_name = 'Chung';\n";

        OracleStatementParser parser = new OracleStatementParser(sql);
        SQLSelectStatement stmt = (SQLSelectStatement) parser.parseStatementList().get(0);

        String text = TestUtils.outputOracle(stmt);

        Assert.assertEquals(expect, text);
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
    public void test_cursor() throws Exception {
        String sql = "SELECT department_name, CURSOR(SELECT salary, commission_pct FROM employees e WHERE e.department_id = d.department_id) "
                     + "FROM departments d;";

        OracleStatementParser parser = new OracleStatementParser(sql);
        SQLSelectStatement stmt = (SQLSelectStatement) parser.parseStatementList().get(0);

        String text = TestUtils.outputOracle(stmt);

        Assert.assertEquals("SELECT department_name, CURSOR(\n\t\tSELECT salary, commission_pct\n" + "\t\tFROM employees e\n"
                            + "\t\tWHERE e.department_id = d.department_id\n\t)\n" + "FROM departments d;\n", text);
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
        String sql = "SELECT TOP ? * FROM T";

        String expect = "SELECT TOP ? *\nFROM T";

        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        SQLSelectStatement stmt = (SQLSelectStatement) parser.parseStatementList().get(0);

        String text = TestUtils.outputSqlServer(stmt);

        Assert.assertEquals(expect, text);

View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
        for (int i = 0; i < 10000; ++i) {
            buf.append(" OR ID = ?");
        }
        String sql = buf.toString();
        OracleStatementParser parser = new OracleStatementParser(sql);
        SQLSelectStatement stmt = (SQLSelectStatement) parser.parseStatementList().get(0);
        SQLSelectQueryBlock select = (SQLSelectQueryBlock) stmt.getSelect().getQuery();
        SQLBinaryOpExpr where = (SQLBinaryOpExpr) select.getWhere();
        SQLBinaryOpExpr last = (SQLBinaryOpExpr) where.getRight();
        Assert.assertEquals(SQLBinaryOperator.Equality, last.getOperator());
    }
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
        for (int i = 0; i < 10000; ++i) {
            buf.append(" AND ID = ?");
        }
        String sql = buf.toString();
        OracleStatementParser parser = new OracleStatementParser(sql);
        SQLSelectStatement stmt = (SQLSelectStatement) parser.parseStatementList().get(0);
        SQLSelectQueryBlock select = (SQLSelectQueryBlock) stmt.getSelect().getQuery();
        SQLBinaryOpExpr where = (SQLBinaryOpExpr) select.getWhere();
        SQLBinaryOpExpr last = (SQLBinaryOpExpr) where.getRight();
        Assert.assertEquals(SQLBinaryOperator.Equality, last.getOperator());
    }
View Full Code Here
TOP

Related Classes of com.alibaba.druid.sql.ast.statement.SQLSelectStatement

  • com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_10
  • com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_11
  • com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_12
  • com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_13
  • com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_14
  • com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_15
  • com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_16
  • com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_7
  • com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_8
  • com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_9
    • 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.