Examples of SQLAggregateExpr

com.alibaba.druid.sql.ast.expr.SQLAggregateExpr

Examples of com.alibaba.druid.sql.ast.expr.SQLAggregateExpr


  private AggregateInfo parseAggregateClause(List<SQLSelectItem> select, FTable table) throws UnsupportedException {
    for (SQLSelectItem item : select) {
      SQLExpr expr = item.getExpr();
      if(expr instanceof SQLAggregateExpr) {
        SQLAggregateExpr aggregateExpr = (SQLAggregateExpr) expr;
        String method = aggregateExpr.getMethodName();
        String columnName = parseColumn(aggregateExpr.getArguments().get(0));
        LOG.debug(" SQLAggregatetItem column: " + columnName + " method: " + method);
        Field field = table.getColumns().get(columnName);
        if(method.equalsIgnoreCase("count")
            //&& (columnName.equals("*") || columnName.equals("1"))
            ) {

View Full Code Here

Examples of com.alibaba.druid.sql.ast.expr.SQLAggregateExpr

                method_name = expr.toString();
                methodInvokeExpr = new SQLMethodInvokeExpr(method_name);
            }


            if (isAggreateFunction(method_name)) {
                SQLAggregateExpr aggregateExpr = parseAggregateExpr(method_name);


                return aggregateExpr;
            }


            if (lexer.token() != Token.RPAREN) {

View Full Code Here

Examples of com.alibaba.druid.sql.ast.expr.SQLAggregateExpr


        return false;
    }


    protected SQLAggregateExpr parseAggregateExpr(String method_name) throws ParserException {
        SQLAggregateExpr aggregateExpr;
        if (lexer.token() == Token.ALL) {
            aggregateExpr = new SQLAggregateExpr(method_name, 1);
            lexer.nextToken();
        } else if (lexer.token() == Token.DISTINCT) {
            aggregateExpr = new SQLAggregateExpr(method_name, 0);
            lexer.nextToken();
        } else {
            aggregateExpr = new SQLAggregateExpr(method_name, 1);
        }


        exprList(aggregateExpr.getArguments());


        accept(Token.RPAREN);


        return aggregateExpr;
    }

View Full Code Here

Examples of com.alibaba.druid.sql.ast.expr.SQLAggregateExpr

                    SQLIdentifierExpr identExpr = (SQLIdentifierExpr) expr;
                    String method_name = identExpr.getName();
                    lexer.nextToken();


                    if (isAggreateFunction(method_name)) {
                        SQLAggregateExpr aggregateExpr = parseAggregateExpr(method_name);


                        return aggregateExpr;
                    }


                    SQLMethodInvokeExpr methodInvokeExpr = new SQLMethodInvokeExpr(method_name);

View Full Code Here

Examples of com.alibaba.druid.sql.ast.expr.SQLAggregateExpr


        return false;
    }


    protected SQLAggregateExpr parseAggregateExpr(String method_name) throws ParserException {
        SQLAggregateExpr aggregateExpr;
        if (lexer.token() == Token.ALL) {
            aggregateExpr = new SQLAggregateExpr(method_name, 1);
            lexer.nextToken();
        } else if (lexer.token() == Token.DISTINCT) {
            aggregateExpr = new SQLAggregateExpr(method_name, 0);
            lexer.nextToken();
        } else {
            aggregateExpr = new SQLAggregateExpr(method_name, 1);
        }
        exprList(aggregateExpr.getArguments());


        accept(Token.RPAREN);


        return aggregateExpr;
    }

View Full Code Here

Examples of com.alibaba.druid.sql.ast.expr.SQLAggregateExpr

    }


    protected SQLAggregateExpr parseAggregateExpr(String methodName) {
        methodName = methodName.toUpperCase();
        
        SQLAggregateExpr aggregateExpr;
        if (lexer.token() == Token.UNIQUE) {
            aggregateExpr = new SQLAggregateExpr(methodName, SQLAggregateExpr.Option.UNIQUE);
            lexer.nextToken();
        } else if (lexer.token() == (Token.ALL)) {
            aggregateExpr = new SQLAggregateExpr(methodName, SQLAggregateExpr.Option.ALL);
            lexer.nextToken();
        } else if (lexer.token() == (Token.DISTINCT)) {
            aggregateExpr = new SQLAggregateExpr(methodName, SQLAggregateExpr.Option.DISTINCT);
            lexer.nextToken();
        } else {
            aggregateExpr = new SQLAggregateExpr(methodName);
        }
        exprList(aggregateExpr.getArguments(), aggregateExpr);


        if (lexer.stringVal().equalsIgnoreCase("IGNORE")) {
            lexer.nextToken();
            identifierEquals("NULLS");
            aggregateExpr.setIgnoreNulls(true);
        }


        accept(Token.RPAREN);
        
        if (identifierEquals("WITHIN")) {
            lexer.nextToken();
            accept(Token.GROUP);
            accept(Token.LPAREN);
            SQLOrderBy withinGroup = this.parseOrderBy();
            aggregateExpr.setWithinGroup(withinGroup);
            accept(Token.RPAREN);
        }


        if (lexer.token() == Token.OVER) {
            OracleAnalytic over = new OracleAnalytic();


            lexer.nextToken();
            accept(Token.LPAREN);


            if (identifierEquals("PARTITION")) {
                lexer.nextToken();
                accept(Token.BY);


                if (lexer.token() == (Token.LPAREN)) {
                    lexer.nextToken();
                    exprList(over.getPartitionBy(), over);
                    accept(Token.RPAREN);
                } else {
                    exprList(over.getPartitionBy(), over);
                }
            }


            over.setOrderBy(parseOrderBy());
            if (over.getOrderBy() != null) {
                OracleAnalyticWindowing windowing = null;
                if (lexer.stringVal().equalsIgnoreCase("ROWS")) {
                    lexer.nextToken();
                    windowing = new OracleAnalyticWindowing();
                    windowing.setType(OracleAnalyticWindowing.Type.ROWS);
                } else if (lexer.stringVal().equalsIgnoreCase("RANGE")) {
                    lexer.nextToken();
                    windowing = new OracleAnalyticWindowing();
                    windowing.setType(OracleAnalyticWindowing.Type.RANGE);
                }


                if (windowing != null) {
                    if (lexer.stringVal().equalsIgnoreCase("CURRENT")) {
                        lexer.nextToken();
                        if (lexer.stringVal().equalsIgnoreCase("ROW")) {
                            lexer.nextToken();
                            windowing.setExpr(new SQLIdentifierExpr("CURRENT ROW"));
                            over.setWindowing(windowing);
                        }
                        throw new ParserException("syntax error");
                    }
                    if (lexer.stringVal().equalsIgnoreCase("UNBOUNDED")) {
                        lexer.nextToken();
                        if (lexer.stringVal().equalsIgnoreCase("PRECEDING")) {
                            lexer.nextToken();
                            windowing.setExpr(new SQLIdentifierExpr("UNBOUNDED PRECEDING"));
                        } else {
                            throw new ParserException("syntax error");
                        }
                    }


                    over.setWindowing(windowing);
                }
            }


            accept(Token.RPAREN);


            aggregateExpr.setOver(over);
        }
        return aggregateExpr;
    }

View Full Code Here

Examples of com.alibaba.druid.sql.ast.expr.SQLAggregateExpr

                methodName = expr.toString();
                methodInvokeExpr = new SQLMethodInvokeExpr(methodName);
            }


            if (isAggreateFunction(methodName)) {
                SQLAggregateExpr aggregateExpr = parseAggregateExpr(methodName);


                return aggregateExpr;
            }


            if (lexer.token() != Token.RPAREN) {

View Full Code Here

Examples of com.alibaba.druid.sql.ast.expr.SQLAggregateExpr

    }


    protected SQLAggregateExpr parseAggregateExpr(String methodName) {
        methodName = methodName.toUpperCase();


        SQLAggregateExpr aggregateExpr;
        if (lexer.token() == Token.ALL) {
            aggregateExpr = new SQLAggregateExpr(methodName, SQLAggregateExpr.Option.ALL);
            lexer.nextToken();
        } else if (lexer.token() == Token.DISTINCT) {
            aggregateExpr = new SQLAggregateExpr(methodName, SQLAggregateExpr.Option.DISTINCT);
            lexer.nextToken();
        } else {
            aggregateExpr = new SQLAggregateExpr(methodName);
        }


        exprList(aggregateExpr.getArguments(), aggregateExpr);


        parseAggregateExprRest(aggregateExpr);


        accept(Token.RPAREN);


        if (lexer.token() == Token.OVER) {
            lexer.nextToken();
            SQLOver over = new SQLOver();
            accept(Token.LPAREN);


            if (lexer.token() == Token.PARTITION || identifierEquals("PARTITION")) {
                lexer.nextToken();
                accept(Token.BY);


                if (lexer.token() == (Token.LPAREN)) {
                    lexer.nextToken();
                    exprList(over.getPartitionBy(), over);
                    accept(Token.RPAREN);
                } else {
                    exprList(over.getPartitionBy(), over);
                }
            }


            over.setOrderBy(parseOrderBy());


            accept(Token.RPAREN);
            aggregateExpr.setOver(over);


        }


        return aggregateExpr;
    }

View Full Code Here

Examples of com.alibaba.druid.sql.ast.expr.SQLAggregateExpr

                methodName = expr.toString();
                methodInvokeExpr = new SQLMethodInvokeExpr(methodName);
            }


            if (isAggreateFunction(methodName)) {
                SQLAggregateExpr aggregateExpr = parseAggregateExpr(methodName);


                return aggregateExpr;
            }


            if (lexer.token() != Token.RPAREN) {

View Full Code Here

Examples of com.alibaba.druid.sql.ast.expr.SQLAggregateExpr

    }


    protected SQLAggregateExpr parseAggregateExpr(String methodName) {
        methodName = methodName.toUpperCase();


        SQLAggregateExpr aggregateExpr;
        if (lexer.token() == Token.ALL) {
            aggregateExpr = new SQLAggregateExpr(methodName, SQLAggregateExpr.Option.ALL);
            lexer.nextToken();
        } else if (lexer.token() == Token.DISTINCT) {
            aggregateExpr = new SQLAggregateExpr(methodName, SQLAggregateExpr.Option.DISTINCT);
            lexer.nextToken();
        } else {
            aggregateExpr = new SQLAggregateExpr(methodName);
        }


        exprList(aggregateExpr.getArguments(), aggregateExpr);


        parseAggregateExprRest(aggregateExpr);


        accept(Token.RPAREN);


        if (lexer.token() == Token.OVER) {
            lexer.nextToken();
            SQLOver over = new SQLOver();
            accept(Token.LPAREN);


            if (identifierEquals("PARTITION")) {
                lexer.nextToken();
                accept(Token.BY);


                if (lexer.token() == (Token.LPAREN)) {
                    lexer.nextToken();
                    exprList(over.getPartitionBy());
                    accept(Token.RPAREN);
                } else {
                    exprList(over.getPartitionBy());
                }
            }


            over.setOrderBy(parseOrderBy());


            accept(Token.RPAREN);
            aggregateExpr.setOver(over);


        }


        return aggregateExpr;
    }

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.