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

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

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

com.alibaba.druid.sql.ast.statement.SQLSelect


        return false;
    }


    public boolean visit(SQLSelectStatement stmt) {
        SQLSelect select = stmt.getSelect();


        select.accept(this);


        return false;
    }

View Full Code Here

                lexer.nextToken();
                if (lexer.token() == Token.LPAREN) {
                    SQLAnyExpr anyExpr = new SQLAnyExpr();


                    accept(Token.LPAREN);
                    SQLSelect anySubQuery = createSelectParser().select();
                    anyExpr.setSubQuery(anySubQuery);
                    accept(Token.RPAREN);


                    anySubQuery.setParent(anyExpr);


                    sqlExpr = anyExpr;
                } else {
                    sqlExpr = new SQLIdentifierExpr("ANY");
                }
                break;
            case SOME:
                lexer.nextToken();
                SQLSomeExpr someExpr = new SQLSomeExpr();


                accept(Token.LPAREN);
                SQLSelect someSubQuery = createSelectParser().select();
                someExpr.setSubQuery(someSubQuery);
                accept(Token.RPAREN);


                someSubQuery.setParent(someExpr);


                sqlExpr = someExpr;
                break;
            case ALL:
                lexer.nextToken();
                SQLAllExpr allExpr = new SQLAllExpr();


                accept(Token.LPAREN);
                SQLSelect allSubQuery = createSelectParser().select();
                allExpr.setSubQuery(allSubQuery);
                accept(Token.RPAREN);


                allSubQuery.setParent(allExpr);


                sqlExpr = allExpr;
                break;
            case LITERAL_ALIAS:
                sqlExpr = new SQLIdentifierExpr('"' + lexer.stringVal() + '"');

View Full Code Here

                lexer.nextToken();


                parameter.setName(this.exprParser.name());


                accept(Token.IS);
                SQLSelect select = this.createSQLSelectParser().select();


                SQLDataTypeImpl dataType = new SQLDataTypeImpl();
                dataType.setName("CURSOR");
                parameter.setDataType(dataType);

View Full Code Here

                clause.setElseItem(insertInto);
            }
            stmt.getEntries().add(clause);
        }


        SQLSelect subQuery = this.createSQLSelectParser().select();
        stmt.setSubQuery(subQuery);


        return stmt;
    }

View Full Code Here

            print("CURSOR ");
            x.getName().accept(this);
            print(" IS");
            incrementIndent();
            println();
            SQLSelect select = ((SQLQueryExpr) x.getDefaultValue()).getSubQuery();
            select.accept(this);
            decrementIndent();


        } else {
            x.getName().accept(this);
            print(" ");

View Full Code Here


        return false;
    }


    public boolean visit(SQLSelectStatement stmt) {
        SQLSelect select = stmt.getSelect();


        select.accept(this);


        return false;
    }

View Full Code Here


        return false;
    }


    public boolean visit(SQLSelectStatement stmt) {
        SQLSelect select = stmt.getSelect();


        select.accept(this);


        return false;
    }

View Full Code Here

        }


        if (lexer.token() == (Token.LPAREN)) {
            lexer.nextToken();
            if (lexer.token() == (Token.SELECT)) {
                SQLSelect select = this.exprParser.createSelectParser().select();
                select.setParent(insertStatement);
                insertStatement.setQuery(select);
            } else {
                this.exprParser.exprList(insertStatement.getColumns());
            }
            accept(Token.RPAREN);
        }


        if (lexer.token() == Token.VALUES || identifierEquals("VALUE")) {
            lexer.nextToken();


            for (;;) {
                accept(Token.LPAREN);
                SQLInsertStatement.ValuesClause values = new SQLInsertStatement.ValuesClause();
                this.exprParser.exprList(values.getValues());
                insertStatement.getValuesList().add(values);
                accept(Token.RPAREN);


                if (lexer.token() == Token.COMMA) {
                    lexer.nextToken();
                    continue;
                } else {
                    break;
                }
            }
        } else if (lexer.token() == Token.SET) {
            lexer.nextToken();


            SQLInsertStatement.ValuesClause values = new SQLInsertStatement.ValuesClause();
            insertStatement.getValuesList().add(values);


            for (;;) {
                SQLName name = this.exprParser.name();
                insertStatement.getColumns().add(name);
                if (lexer.token() == Token.EQ) {
                    lexer.nextToken();
                } else {
                    accept(Token.COLONEQ);
                }
                values.getValues().add(this.exprParser.expr());


                if (lexer.token() == Token.COMMA) {
                    lexer.nextToken();
                    continue;
                }


                break;
            }


        } else if (lexer.token() == (Token.SELECT)) {
            SQLSelect select = this.exprParser.createSelectParser().select();
            select.setParent(insertStatement);
            insertStatement.setQuery(select);
        } else if (lexer.token() == (Token.LPAREN)) {
            lexer.nextToken();
            SQLSelect select = this.exprParser.createSelectParser().select();
            select.setParent(insertStatement);
            insertStatement.setQuery(select);
            accept(Token.RPAREN);
        }


        if (lexer.token() == Token.ON) {

View Full Code Here

        SQLObject parent = x.getParent();
        if (parent instanceof ConditionalInsertClause) {
            parent = parent.getParent();
        }
        if (parent instanceof OracleMultiInsertStatement) {
            SQLSelect subQuery = ((OracleMultiInsertStatement) parent).getSubQuery();
            if (subQuery != null) {
                String table = (String) subQuery.getAttribute("_table_");
                setCurrentTable(x, table);
            }
        }
        x.getWhen().accept(this);
        x.getThen().accept(this);

View Full Code Here

                lexer.nextToken();
                if (lexer.token() == Token.LPAREN) {
                    SQLAnyExpr anyExpr = new SQLAnyExpr();


                    accept(Token.LPAREN);
                    SQLSelect anySubQuery = createSelectParser().select();
                    anyExpr.setSubQuery(anySubQuery);
                    accept(Token.RPAREN);


                    anySubQuery.setParent(anyExpr);


                    sqlExpr = anyExpr;
                } else {
                    sqlExpr = new SQLIdentifierExpr("ANY");
                }
                break;
            case SOME:
                lexer.nextToken();
                SQLSomeExpr someExpr = new SQLSomeExpr();


                accept(Token.LPAREN);
                SQLSelect someSubQuery = createSelectParser().select();
                someExpr.setSubQuery(someSubQuery);
                accept(Token.RPAREN);


                someSubQuery.setParent(someExpr);


                sqlExpr = someExpr;
                break;
            case ALL:
                lexer.nextToken();
                SQLAllExpr allExpr = new SQLAllExpr();


                accept(Token.LPAREN);
                SQLSelect allSubQuery = createSelectParser().select();
                allExpr.setSubQuery(allSubQuery);
                accept(Token.RPAREN);


                allSubQuery.setParent(allExpr);


                sqlExpr = allExpr;
                break;
            default:
                throw new ParserException("ERROR. token : " + tok + " " + lexer.stringVal());

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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

com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_10

com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_11

com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_12

com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_13

com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_14

com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_15

com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_16

com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_7

com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_8

com.alibaba.druid.bvt.sql.mysql.MySqlSelectTest_9

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.