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

Package com.alibaba.druid.sql.ast.statement

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

com.alibaba.druid.sql.ast.statement.SQLSubqueryTableSource

        SQLSelectQueryBlock countSelectQuery = createQueryBlock(dbType);


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


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


        SQLSelect countSelect = new SQLSelect(countSelectQuery);
        SQLSelectStatement countStmt = new SQLSelectStatement(countSelect);

View Full Code Here

            SQLTableSource tableSource;
            if (lexer.token() == Token.SELECT || lexer.token() == Token.WITH) {
                SQLSelect select = select();
                accept(Token.RPAREN);
                queryRest(select.getQuery());
                tableSource = new SQLSubqueryTableSource(select);
            } else if (lexer.token() == Token.LPAREN) {
                tableSource = parseTableSource();
                accept(Token.RPAREN);
            } else {
                tableSource = parseTableSource();

View Full Code Here


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


        return SQLUtils.toSQLString(offsetQueryBlock, dbType);

View Full Code Here

        SQLSelectQueryBlock countSelectQuery = createQueryBlock(dbType);


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


        countSelectQuery.setFrom(new SQLSubqueryTableSource(select));


        SQLSelect countSelect = new SQLSelect(countSelectQuery);
        SQLSelectStatement countStmt = new SQLSelectStatement(countSelect);


        return SQLUtils.toSQLString(countStmt, dbType);

View Full Code Here

    public static boolean isSimpleCountTableSource(WallVisitor visitor, SQLTableSource tableSource) {
        if (!(tableSource instanceof SQLSubqueryTableSource)) {
            return false;
        }


        SQLSubqueryTableSource subQuery = (SQLSubqueryTableSource) tableSource;


        return isSimpleCountTableSource(visitor, subQuery.getSelect());
    }

View Full Code Here

    public static boolean isSimpleCountTableSource(WallVisitor visitor, SQLTableSource tableSource) {
        if (!(tableSource instanceof SQLSubqueryTableSource)) {
            return false;
        }


        SQLSubqueryTableSource subQuery = (SQLSubqueryTableSource) tableSource;


        return isSimpleCountTableSource(visitor, subQuery.getSelect());
    }

View Full Code Here

    public static boolean isSimpleCountTableSource(SQLTableSource tableSource) {
        if (!(tableSource instanceof SQLSubqueryTableSource)) {
            return false;
        }


        SQLSubqueryTableSource subQuery = (SQLSubqueryTableSource) tableSource;


        return isSimpleCountTableSource(subQuery.getSelect());
    }

View Full Code Here

0 1 2 3 4 5 6

TOP

Related Classes of com.alibaba.druid.sql.ast.statement.SQLSubqueryTableSource

com.alibaba.druid.sql.dialect.odps.parser.OdpsStatementParser

com.alibaba.druid.sql.PagerUtils

com.alibaba.druid.sql.parser.SQLSelectParser

com.alibaba.druid.wall.spi.WallVisitorUtils

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.