Examples of SQLSubqueryTableSource

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

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

            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

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

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


        SQLSubqueryTableSource subQuery = (SQLSubqueryTableSource) tableSource;


        return isSimpleCountTableSource(subQuery.getSelect());
    }

View Full Code Here

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

            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

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

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


        SQLSubqueryTableSource subQuery = (SQLSubqueryTableSource) tableSource;


        return isSimpleCountTableSource(subQuery.getSelect());
    }

View Full Code Here

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

    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

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

    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

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

            SQLTableSource tableSource;
            if (lexer.token() == Token.SELECT) {
                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 {
                throw new ParserException("TODO");

View Full Code Here

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

            SQLTableSource tableSource;
            if (lexer.token() == Token.SELECT) {
                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 {
                throw new ParserException("TODO");

View Full Code Here

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


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


        countQueryBlock.setFrom(new SQLSubqueryTableSource(select, "_X"));
        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), "_XX"));
        offsetQueryBlock.setWhere(new SQLBinaryOpExpr(new SQLIdentifierExpr("_RN"), //
                                                      SQLBinaryOperator.GreaterThan, //
                                                      new SQLNumberExpr(offset)));


        return SQLUtils.toSQLString(offsetQueryBlock, dbType);

View Full Code Here

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

        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

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.