Examples of SQLSelectItem

com.alibaba.druid.sql.ast.statement.SQLSelectItem

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

                return SQLUtils.toSQLString(select, dbType);
            }
        }


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


        countQueryBlock.setFrom(new SQLSubqueryTableSource(select, "XX"));
        countQueryBlock.setWhere(new SQLBinaryOpExpr(new SQLIdentifierExpr("ROWNUM"), //
                                                     SQLBinaryOperator.LessThanOrEqual, //
                                                     new SQLNumberExpr(count + offset)));
        if (offset <= 0) {
            return SQLUtils.toSQLString(countQueryBlock, dbType);
        }


        OracleSelectQueryBlock offsetQueryBlock = new OracleSelectQueryBlock();
        offsetQueryBlock.getSelectList().add(new SQLSelectItem(new SQLAllColumnExpr()));
        offsetQueryBlock.setFrom(new SQLSubqueryTableSource(new SQLSelect(countQueryBlock), "XXX"));
        offsetQueryBlock.setWhere(new SQLBinaryOpExpr(new SQLIdentifierExpr("RN"), //
                                                      SQLBinaryOperator.GreaterThan, //
                                                      new SQLNumberExpr(offset)));

View Full Code Here

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


        SQLSelectQuery query = select.getQuery();
        clearOrderBy(query);


        if (query instanceof SQLSelectQueryBlock) {
            SQLSelectItem countItem = createCountItem(dbType);


            SQLSelectQueryBlock queryBlock = (SQLSelectQueryBlock) query;


            if (queryBlock.getGroupBy() != null && queryBlock.getGroupBy().getItems().size() > 0) {
                return createCountUseSubQuery(select, dbType);

View Full Code Here

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

    }


    private static String createCountUseSubQuery(SQLSelect select, String dbType) {
        SQLSelectQueryBlock countSelectQuery = createQueryBlock(dbType);


        SQLSelectItem countItem = createCountItem(dbType);
        countSelectQuery.getSelectList().add(countItem);


        SQLSubqueryTableSource fromSubquery = new SQLSubqueryTableSource(select);
        fromSubquery.setAlias("ALIAS_COUNT");
        countSelectQuery.setFrom(fromSubquery);

View Full Code Here

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

    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.statement.SQLSelectItem

    }


    protected final void parseSelectList(SQLSelectQueryBlock queryBlock) {
        final List<SQLSelectItem> selectList = queryBlock.getSelectList();
        for (;;) {
            final SQLSelectItem selectItem = parseSelectItem();
            selectList.add(selectItem);


            if (lexer.token() != Token.COMMA) {
                break;
            }

View Full Code Here

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

        } else {
            expr = expr();
        }
        final String alias = as();


        return new SQLSelectItem(expr, alias);
    }

View Full Code Here

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

        // insert .. select
        SQLSelect select = x.getQuery();
        if (select != null) {
            List<SQLSelectQueryBlock> queryBlocks = splitSQLSelectQuery(select.getQuery());
            for (SQLSelectQueryBlock queryBlock : queryBlocks) {
                queryBlock.getSelectList().add(new SQLSelectItem(value));
            }
        }


        visitor.setSqlModified(true);
    }

View Full Code Here

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

        }


        if (!(x.getParent() instanceof SQLSelectItem)) {
            return false;
        }
        SQLSelectItem item = (SQLSelectItem) x.getParent();


        if (!(item.getParent() instanceof SQLSelectQueryBlock)) {
            return false;
        }


        SQLSelectQueryBlock queryBlock = (SQLSelectQueryBlock) item.getParent();
        if (!queryBlockFromIsNull(visitor, queryBlock)) {
            return false;
        }


        if (!(queryBlock.getParent() instanceof SQLSelect)) {

View Full Code Here

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


        if (!(x.getParent() instanceof SQLSelectItem)) {
            return false;
        }


        SQLSelectItem item = (SQLSelectItem) x.getParent();
        return isTopSelectStatement(item.getParent());
    }

View Full Code Here

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

            for (SQLSelectOrderByItem item : x.getItems()) {
                SQLExpr expr = item.getExpr();
                if (expr instanceof SQLIntegerExpr) {
                    int intValue = ((SQLIntegerExpr) expr).getNumber().intValue() - 1;
                    if (intValue < query.getSelectList().size()) {
                        SQLSelectItem selectItem = query.getSelectList().get(intValue);
                        selectItem.getExpr().accept(orderByVisitor);
                    }
                }
            }
        }
        x.accept(orderByVisitor);

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.