Examples of SQLAggregateExpr

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

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

            if (offset <= 0) {
                queryBlock.setFirst(new SQLNumberExpr(count));
                return SQLUtils.toSQLString(select, dbType);
            }


            SQLAggregateExpr aggregateExpr = new SQLAggregateExpr("ROW_NUMBER");
            SQLOrderBy orderBy = select.getOrderBy();
            aggregateExpr.setOver(new SQLOver(orderBy));
            select.setOrderBy(null);


            queryBlock.getSelectList().add(new SQLSelectItem(aggregateExpr, "ROWNUM"));


            DB2SelectQueryBlock countQueryBlock = new DB2SelectQueryBlock();
            countQueryBlock.getSelectList().add(new SQLSelectItem(new SQLAllColumnExpr()));


            countQueryBlock.setFrom(new SQLSubqueryTableSource(select, "XX"));


            countQueryBlock.setWhere(pageCondition);


            return SQLUtils.toSQLString(countQueryBlock, dbType);
        }


        DB2SelectQueryBlock countQueryBlock = new DB2SelectQueryBlock();
        countQueryBlock.getSelectList().add(new SQLSelectItem(new SQLPropertyExpr(new SQLIdentifierExpr("XX"), "*")));
        SQLAggregateExpr aggregateExpr = new SQLAggregateExpr("ROW_NUMBER");
        SQLOrderBy orderBy = select.getOrderBy();
        aggregateExpr.setOver(new SQLOver(orderBy));
        select.setOrderBy(null);
        countQueryBlock.getSelectList().add(new SQLSelectItem(aggregateExpr, "ROWNUM"));


        countQueryBlock.setFrom(new SQLSubqueryTableSource(select, "XX"));

View Full Code Here

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

            if (offset <= 0) {
                queryBlock.setTop(new SQLServerTop(new SQLNumberExpr(count)));
                return SQLUtils.toSQLString(select, dbType);
            }


            SQLAggregateExpr aggregateExpr = new SQLAggregateExpr("ROW_NUMBER");
            SQLOrderBy orderBy = select.getOrderBy();
            aggregateExpr.setOver(new SQLOver(orderBy));
            select.setOrderBy(null);


            queryBlock.getSelectList().add(new SQLSelectItem(aggregateExpr, "ROWNUM"));


            SQLServerSelectQueryBlock countQueryBlock = new SQLServerSelectQueryBlock();
            countQueryBlock.getSelectList().add(new SQLSelectItem(new SQLAllColumnExpr()));


            countQueryBlock.setFrom(new SQLSubqueryTableSource(select, "XX"));


            countQueryBlock.setWhere(pageCondition);


            return SQLUtils.toSQLString(countQueryBlock, dbType);
        }
        


        SQLServerSelectQueryBlock countQueryBlock = new SQLServerSelectQueryBlock();
        countQueryBlock.getSelectList().add(new SQLSelectItem(new SQLPropertyExpr(new SQLIdentifierExpr("XX"), "*")));


        countQueryBlock.setFrom(new SQLSubqueryTableSource(select, "XX"));
        
        if (offset <= 0) {
            countQueryBlock.setTop(new SQLServerTop(new SQLNumberExpr(count)));
            return SQLUtils.toSQLString(countQueryBlock, dbType);
        }
        
        SQLAggregateExpr aggregateExpr = new SQLAggregateExpr("ROW_NUMBER");
        SQLOrderBy orderBy = select.getOrderBy();
        aggregateExpr.setOver(new SQLOver(orderBy));
        select.setOrderBy(null);
        countQueryBlock.getSelectList().add(new SQLSelectItem(aggregateExpr, "ROWNUM"));


        SQLServerSelectQueryBlock offsetQueryBlock = new SQLServerSelectQueryBlock();
        offsetQueryBlock.getSelectList().add(new SQLSelectItem(new SQLAllColumnExpr()));

View Full Code Here

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


        return new SQLSelectQueryBlock();
    }


    private static SQLSelectItem createCountItem(String dbType) {
        SQLAggregateExpr countExpr = new SQLAggregateExpr("COUNT");


        countExpr.getArguments().add(new SQLAllColumnExpr());


        SQLSelectItem countItem = new SQLSelectItem(countExpr);
        return countItem;
    }

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

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

                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

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.