Examples of SQLOrderBy

com.alibaba.druid.sql.ast.SQLOrderBy

Examples of com.alibaba.druid.sql.ast.SQLOrderBy

            SQLExpr where = this.exprParser.expr();
            deleteStatement.setWhere(where);
        }


        if (lexer.token() == (Token.ORDER)) {
            SQLOrderBy orderBy = exprParser.parseOrderBy();
            deleteStatement.setOrderBy(orderBy);
        }


        deleteStatement.setLimit(parseLimit());

View Full Code Here

Examples of com.alibaba.druid.sql.ast.SQLOrderBy

        return aggregateExpr;
    }


    public SQLOrderBy parseOrderBy() {
        if (lexer.token() == Token.ORDER) {
            SQLOrderBy orderBy = new SQLOrderBy();


            lexer.nextToken();


            accept(Token.BY);


            orderBy.addItem(parseSelectOrderByItem());


            while (lexer.token() == Token.COMMA) {
                lexer.nextToken();
                orderBy.addItem(parseSelectOrderByItem());
            }


            return orderBy;
        }

View Full Code Here

Examples of com.alibaba.druid.sql.ast.SQLOrderBy


    }


    protected void visitAggreateRest(SQLAggregateExpr aggregateExpr) {
        {
            SQLOrderBy value = (SQLOrderBy) aggregateExpr.getAttribute("ORDER BY");
            if (value != null) {
                print(" ");
                ((SQLObject) value).accept(this);
            }
        }

View Full Code Here

Examples of com.alibaba.druid.sql.ast.SQLOrderBy

        return aggregateExpr;
    }


    public SQLOrderBy parseOrderBy() {
        if (lexer.token() == Token.ORDER) {
            SQLOrderBy orderBy = new SQLOrderBy();


            lexer.nextToken();


            accept(Token.BY);


            orderBy.getItems().add(parseSelectOrderByItem());


            while (lexer.token() == Token.COMMA) {
                lexer.nextToken();
                orderBy.getItems().add(parseSelectOrderByItem());
            }


            return orderBy;
        }

View Full Code Here

Examples of com.alibaba.druid.sql.ast.SQLOrderBy

        return new SQLUnionQuery();
    }


    public SQLUnionQuery unionRest(SQLUnionQuery union) {
        if (lexer.token() == Token.ORDER) {
            SQLOrderBy orderBy = this.exprParser.parseOrderBy();
            union.setOrderBy(orderBy);
            return unionRest(union);
        }
        return union;
    }

View Full Code Here

Examples of com.alibaba.druid.sql.ast.SQLOrderBy

        return aggregateExpr;
    }


    public SQLOrderBy parseOrderBy() {
        if (lexer.token() == Token.ORDER) {
            SQLOrderBy orderBy = new SQLOrderBy();


            lexer.nextToken();


            accept(Token.BY);


            orderBy.addItem(parseSelectOrderByItem());


            while (lexer.token() == Token.COMMA) {
                lexer.nextToken();
                orderBy.addItem(parseSelectOrderByItem());
            }


            return orderBy;
        }

View Full Code Here

Examples of com.alibaba.druid.sql.ast.SQLOrderBy

        return new SQLUnionQuery();
    }


    public SQLUnionQuery unionRest(SQLUnionQuery union) {
        if (lexer.token() == Token.ORDER) {
            SQLOrderBy orderBy = this.exprParser.parseOrderBy();
            union.setOrderBy(orderBy);
            return unionRest(union);
        }
        return union;
    }

View Full Code Here

Examples of com.alibaba.druid.sql.ast.SQLOrderBy

                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.SQLOrderBy

                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();

View Full Code Here

Examples of com.alibaba.druid.sql.ast.SQLOrderBy


    }


    protected void visitAggreateRest(SQLAggregateExpr aggregateExpr) {
        {
            SQLOrderBy value = (SQLOrderBy) aggregateExpr.getAttribute("ORDER BY");
            if (value != null) {
                print(" ");
                ((SQLObject) value).accept(this);
            }
        }

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.