Examples of com.alibaba.druid.sql.dialect.oracle.ast.stmt.OracleMergeStatement$MergeInsertClause

Package com.alibaba.druid.sql.dialect.oracle.ast.stmt

Examples of com.alibaba.druid.sql.dialect.oracle.ast.stmt.OracleMergeStatement$MergeInsertClause

com.alibaba.druid.sql.dialect.oracle.ast.stmt.OracleMergeStatement

    }


    public OracleMergeStatement parseMerge() {
        accept(Token.MERGE);


        OracleMergeStatement stmt = new OracleMergeStatement();


        parseHints(stmt.getHints());


        accept(Token.INTO);
        stmt.setInto(exprParser.name());


        stmt.setAlias(as());


        accept(Token.USING);


        SQLTableSource using = this.createSQLSelectParser().parseTableSource();
        stmt.setUsing(using);


        accept(Token.ON);
        stmt.setOn(exprParser.expr());


        boolean insertFlag = false;
        if (lexer.token() == Token.WHEN) {
            lexer.nextToken();
            if (lexer.token() == Token.MATCHED) {
                OracleMergeStatement.MergeUpdateClause updateClause = new OracleMergeStatement.MergeUpdateClause();
                lexer.nextToken();
                accept(Token.THEN);
                accept(Token.UPDATE);
                accept(Token.SET);


                for (;;) {
                    SQLUpdateSetItem item = new SQLUpdateSetItem();
                    item.setColumn(this.exprParser.name());
                    accept(Token.EQ);
                    item.setValue(this.exprParser.expr());


                    updateClause.getItems().add(item);


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


                    break;
                }


                if (lexer.token() == Token.WHERE) {
                    lexer.nextToken();
                    updateClause.setWhere(exprParser.expr());
                }


                if (lexer.token() == Token.DELETE) {
                    lexer.nextToken();
                    accept(Token.WHERE);
                    updateClause.setWhere(exprParser.expr());
                }


                stmt.setUpdateClause(updateClause);
            } else if (lexer.token() == Token.NOT) {
                lexer.nextToken();
                insertFlag = true;
            }
        }


        if (!insertFlag) {
            if (lexer.token() == Token.WHEN) {
                lexer.nextToken();
            }


            if (lexer.token() == Token.NOT) {
                lexer.nextToken();
                insertFlag = true;
            }
        }


        if (insertFlag) {
            OracleMergeStatement.MergeInsertClause insertClause = new OracleMergeStatement.MergeInsertClause();


            accept(Token.MATCHED);
            accept(Token.THEN);
            accept(Token.INSERT);


            if (lexer.token() == Token.LPAREN) {
                accept(Token.LPAREN);
                exprParser.exprList(insertClause.getColumns());
                accept(Token.RPAREN);
            }
            accept(Token.VALUES);
            accept(Token.LPAREN);
            exprParser.exprList(insertClause.getValues());
            accept(Token.RPAREN);


            if (lexer.token() == Token.WHERE) {
                lexer.nextToken();
                insertClause.setWhere(exprParser.expr());
            }


            stmt.setInsertClause(insertClause);
        }


        OracleErrorLoggingClause errorClause = parseErrorLoggingClause();
        stmt.setErrorLoggingClause(errorClause);


        return stmt;
    }

View Full Code Here

                     "e.email,e.phone_number,e.hire_date,e.job_id, " + //
                     "e.salary,e.commission_pct,e.manager_id,e.department_id)";


        SQLStatementParser parser = new OracleStatementParser(sql);
        List<SQLStatement> stmtList = parser.parseStatementList();
        OracleMergeStatement mergeStatement = (OracleMergeStatement) stmtList.get(0);
        String result = SQLUtils.toOracleString(mergeStatement);
        Assert.assertEquals("MERGE INTO copy_emp c" //
                                    + "\nUSING employees e ON (c.employee_id = e.employee_id) " //
                                    + "\nWHEN MATCHED THEN UPDATE SET c.first_name = e.first_name, c.last_name = e.last_name, c.department_id = e.department_id" //
                                    + "\nWHEN NOT MATCHED THEN INSERT VALUES (e.employee_id, e.first_name, e.last_name, e.email, e.phone_number, e.hire_date, e.job_id, e.salary, e.commission_pct, e.manager_id, e.department_id)",

View Full Code Here

    }


    public OracleMergeStatement parseMerge() {
        accept(Token.MERGE);


        OracleMergeStatement stmt = new OracleMergeStatement();


        parseHints(stmt.getHints());


        accept(Token.INTO);
        stmt.setInto(exprParser.name());


        stmt.setAlias(as());


        accept(Token.USING);


        SQLTableSource using = this.createSQLSelectParser().parseTableSource();
        stmt.setUsing(using);


        accept(Token.ON);
        stmt.setOn(exprParser.expr());


        boolean insertFlag = false;
        if (lexer.token() == Token.WHEN) {
            lexer.nextToken();
            if (lexer.token() == Token.MATCHED) {
                OracleMergeStatement.MergeUpdateClause updateClause = new OracleMergeStatement.MergeUpdateClause();
                lexer.nextToken();
                accept(Token.THEN);
                accept(Token.UPDATE);
                accept(Token.SET);


                for (;;) {
                    SQLUpdateSetItem item = new SQLUpdateSetItem();
                    item.setColumn(this.exprParser.name());
                    accept(Token.EQ);
                    item.setValue(this.exprParser.expr());


                    updateClause.getItems().add(item);


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


                    break;
                }


                if (lexer.token() == Token.WHERE) {
                    lexer.nextToken();
                    updateClause.setWhere(exprParser.expr());
                }


                if (lexer.token() == Token.DELETE) {
                    lexer.nextToken();
                    accept(Token.WHERE);
                    updateClause.setWhere(exprParser.expr());
                }


                stmt.setUpdateClause(updateClause);
            } else if (lexer.token() == Token.NOT) {
                lexer.nextToken();
                insertFlag = true;
            }
        }


        if (!insertFlag) {
            if (lexer.token() == Token.WHEN) {
                lexer.nextToken();
            }


            if (lexer.token() == Token.NOT) {
                lexer.nextToken();
                insertFlag = true;
            }
        }


        if (insertFlag) {
            OracleMergeStatement.MergeInsertClause insertClause = new OracleMergeStatement.MergeInsertClause();


            accept(Token.MATCHED);
            accept(Token.THEN);
            accept(Token.INSERT);


            if (lexer.token() == Token.LPAREN) {
                accept(Token.LPAREN);
                exprParser.exprList(insertClause.getColumns());
                accept(Token.RPAREN);
            }
            accept(Token.VALUES);
            accept(Token.LPAREN);
            exprParser.exprList(insertClause.getValues());
            accept(Token.RPAREN);


            if (lexer.token() == Token.WHERE) {
                lexer.nextToken();
                insertClause.setWhere(exprParser.expr());
            }


            stmt.setInsertClause(insertClause);
        }


        OracleErrorLoggingClause errorClause = parseErrorLoggingClause();
        stmt.setErrorLoggingClause(errorClause);


        return stmt;
    }

View Full Code Here

    }


    public OracleMergeStatement parseMerge() {
        accept(Token.MERGE);


        OracleMergeStatement stmt = new OracleMergeStatement();


        parseHints(stmt.getHints());


        accept(Token.INTO);
        stmt.setInto(exprParser.name());


        stmt.setAlias(as());


        accept(Token.USING);


        SQLTableSource using = this.createSQLSelectParser().parseTableSource();
        stmt.setUsing(using);


        accept(Token.ON);
        stmt.setOn(exprParser.expr());


        boolean insertFlag = false;
        if (lexer.token() == Token.WHEN) {
            lexer.nextToken();
            if (lexer.token() == Token.MATCHED) {
                OracleMergeStatement.MergeUpdateClause updateClause = new OracleMergeStatement.MergeUpdateClause();
                lexer.nextToken();
                accept(Token.THEN);
                accept(Token.UPDATE);
                accept(Token.SET);


                for (;;) {
                    SQLUpdateSetItem item = new SQLUpdateSetItem();
                    item.setColumn(this.exprParser.name());
                    accept(Token.EQ);
                    item.setValue(this.exprParser.expr());


                    updateClause.getItems().add(item);


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


                    break;
                }


                if (lexer.token() == Token.WHERE) {
                    lexer.nextToken();
                    updateClause.setWhere(exprParser.expr());
                }


                if (lexer.token() == Token.DELETE) {
                    lexer.nextToken();
                    accept(Token.WHERE);
                    updateClause.setWhere(exprParser.expr());
                }


                stmt.setUpdateClause(updateClause);
            } else if (lexer.token() == Token.NOT) {
                lexer.nextToken();
                insertFlag = true;
            }
        }


        if (!insertFlag) {
            if (lexer.token() == Token.WHEN) {
                lexer.nextToken();
            }


            if (lexer.token() == Token.NOT) {
                lexer.nextToken();
                insertFlag = true;
            }
        }


        if (insertFlag) {
            OracleMergeStatement.MergeInsertClause insertClause = new OracleMergeStatement.MergeInsertClause();


            accept(Token.MATCHED);
            accept(Token.THEN);
            accept(Token.INSERT);


            if (lexer.token() == Token.LPAREN) {
                accept(Token.LPAREN);
                exprParser.exprList(insertClause.getColumns());
                accept(Token.RPAREN);
            }
            accept(Token.VALUES);
            accept(Token.LPAREN);
            exprParser.exprList(insertClause.getValues());
            accept(Token.RPAREN);


            if (lexer.token() == Token.WHERE) {
                lexer.nextToken();
                insertClause.setWhere(exprParser.expr());
            }


            stmt.setInsertClause(insertClause);
        }


        OracleErrorLoggingClause errorClause = parseErrorLoggingClause();
        stmt.setErrorLoggingClause(errorClause);


        return stmt;
    }

View Full Code Here

0 1

TOP

Related Classes of com.alibaba.druid.sql.dialect.oracle.ast.stmt.OracleMergeStatement$MergeInsertClause

com.alibaba.druid.bvt.sql.oracle.OracleMergeTest7

com.alibaba.druid.bvt.sql.oracle.visitor.OracleASTVisitorAdapterTest

com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser

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.