Examples of SQLSelectQuery

com.alibaba.druid.sql.ast.statement.SQLSelectQuery

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

   */
  private void getSelectPlan(ParseContext context,
      SQLSelectStatement sqlSelectStatement,
      MetaEventOperation metaEventOperation) throws IOException {
    SQLSelect select = sqlSelectStatement.getSelect();
    SQLSelectQuery sqlSelectQuery = select.getQuery();
    if (sqlSelectQuery instanceof MySqlSelectQueryBlock) {
      MySqlSelectQueryBlock sqlSelectQueryBlock = (MySqlSelectQueryBlock) sqlSelectQuery;
      // SELECT
      // FROM
      // WHERE

View Full Code Here

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

              reader);


          SQLSelectStatement sqlSelectStatement = (SQLSelectStatement) stmt;
          // this is SELECT clause
          SQLSelect select = sqlSelectStatement.getSelect();
          SQLSelectQuery sqlSelectQuery = select.getQuery();
          if (sqlSelectQuery instanceof SQLSelectQueryBlock) {
            SQLSelectQueryBlock sqlSelectQueryBlock = (SQLSelectQueryBlock) sqlSelectQuery;
            // Parse The WHERE clause
            SQLExpr where = sqlSelectQueryBlock.getWhere();
            LOG.debug("SELECT SQL:where " + where);

View Full Code Here

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


        return isSimpleCountTableSource(subQuery.getSelect());
    }


    public static boolean isSimpleCountTableSource(SQLSelect select) {
        SQLSelectQuery query = select.getQuery();


        if (query instanceof SQLSelectQueryBlock) {
            SQLSelectQueryBlock queryBlock = (SQLSelectQueryBlock) query;


            boolean allawTrueWhere = false;

View Full Code Here

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

            }


            if (queryBlock.getSelectList().size() == 1
                && queryBlock.getSelectList().get(0).getExpr() instanceof SQLAllColumnExpr) {
                if (from instanceof SQLSubqueryTableSource) {
                    SQLSelectQuery subQuery = ((SQLSubqueryTableSource) from).getSelect().getQuery();
                    if (queryBlockFromIsNull(subQuery)) {
                        return true;
                    }
                }
            }

View Full Code Here

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


    public SQLSelectQuery query() {
        if (lexer.token() == (Token.LPAREN)) {
            lexer.nextToken();


            SQLSelectQuery select = query();
            accept(Token.RPAREN);


            return queryRest(select);
        }

View Full Code Here

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

            if (lexer.token() == (Token.ALL)) {
                union.setOperator(SQLUnionOperator.UNION_ALL);
                lexer.nextToken();
            }


            SQLSelectQuery right = query();


            union.setRight(right);


            return queryRest(union);
        }


        if (lexer.token() == Token.INTERSECT) {
            lexer.nextToken();


            SQLUnionQuery union = new SQLUnionQuery();
            union.setLeft(selectQuery);


            union.setOperator(SQLUnionOperator.INTERSECT);


            SQLSelectQuery right = this.query();
            union.setRight(right);


            return union;
        }


        if (lexer.token() == Token.MINUS) {
            lexer.nextToken();


            SQLUnionQuery union = new SQLUnionQuery();
            union.setLeft(selectQuery);


            union.setOperator(SQLUnionOperator.MINUS);


            SQLSelectQuery right = this.query();
            union.setRight(right);


            return union;
        }

View Full Code Here

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

        if (!(stmt instanceof SQLSelectStatement)) {
            throw new SQLException("executeQueryError : " + sql);
        }


        SQLSelect select = ((SQLSelectStatement) stmt).getSelect();
        SQLSelectQuery query = select.getQuery();


        if (query instanceof SQLSelectQueryBlock) {
            return executeQuery(statement, (SQLSelectQueryBlock) query);
        }

View Full Code Here

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


    protected SQLSelectQuery query() {
        if (lexer.token() == (Token.LPAREN)) {
            lexer.nextToken();


            SQLSelectQuery select = query();
            accept(Token.RPAREN);


            return queryRest(select);
        }

View Full Code Here

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

            if (lexer.token() == (Token.ALL)) {
                union.setOperator(SQLUnionOperator.UNION_ALL);
                lexer.nextToken();
            }


            SQLSelectQuery right = query();


            union.setRight(right);


            return queryRest(union);
        }


        if (lexer.token() == Token.INTERSECT) {
            lexer.nextToken();


            SQLUnionQuery union = new SQLUnionQuery();
            union.setLeft(selectQuery);


            union.setOperator(SQLUnionOperator.INTERSECT);


            SQLSelectQuery right = this.query();
            union.setRight(right);


            return union;
        }


        if (lexer.token() == Token.MINUS) {
            lexer.nextToken();


            SQLUnionQuery union = new SQLUnionQuery();
            union.setLeft(selectQuery);


            union.setOperator(SQLUnionOperator.MINUS);


            SQLSelectQuery right = this.query();
            union.setRight(right);


            return union;
        }

View Full Code Here

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

    @Override
    protected SQLSelectQuery query() throws ParserException {
        if (lexer.token() == (Token.LPAREN)) {
            lexer.nextToken();


            SQLSelectQuery select = query();
            accept(Token.RPAREN);


            return queryRest(select);
        }

View Full Code Here

0 1 2 3 4 5

TOP

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.