Examples with SQLCurrentOfCursorExpr com.alibaba.druid.sql.ast.expr.SQLCurrentOfCursorExpr used on opensource projects

Example 1 with SQLCurrentOfCursorExpr

use of com.alibaba.druid.sql.ast.expr.SQLCurrentOfCursorExpr in project druid by alibaba.

the class PGSQLStatementParser method parseDeleteStatement.

public PGDeleteStatement parseDeleteStatement() {
    lexer.nextToken();
    PGDeleteStatement deleteStatement = new PGDeleteStatement();
    if (lexer.token() == (Token.FROM)) {
        lexer.nextToken();
    }
    if (lexer.token() == (Token.ONLY)) {
        lexer.nextToken();
        deleteStatement.setOnly(true);
    }
    SQLName tableName = exprParser.name();
    deleteStatement.setTableName(tableName);
    if (lexer.token() == Token.AS) {
        accept(Token.AS);
    }
    if (lexer.token() == Token.IDENTIFIER) {
        deleteStatement.setAlias(lexer.stringVal());
        lexer.nextToken();
    }
    if (lexer.token() == Token.USING) {
        lexer.nextToken();
        for (; ; ) {
            SQLName name = this.exprParser.name();
            deleteStatement.getUsing().add(name);
            if (lexer.token() == Token.COMMA) {
                lexer.nextToken();
                continue;
            }
            break;
        }
    }
    if (lexer.token() == (Token.WHERE)) {
        lexer.nextToken();
        if (lexer.token() == Token.CURRENT) {
            lexer.nextToken();
            accept(Token.OF);
            SQLName cursorName = this.exprParser.name();
            SQLExpr where = new SQLCurrentOfCursorExpr(cursorName);
            deleteStatement.setWhere(where);
        } else {
            SQLExpr where = this.exprParser.expr();
            deleteStatement.setWhere(where);
        }
    }
    if (lexer.token() == Token.RETURNING) {
        lexer.nextToken();
        accept(Token.STAR);
        deleteStatement.setReturning(true);
    }
    return deleteStatement;
}

Example 2 with SQLCurrentOfCursorExpr

use of com.alibaba.druid.sql.ast.expr.SQLCurrentOfCursorExpr in project druid by alibaba.

the class SQLASTVisitorAdapterTest method test_adapter.

public void test_adapter() throws Exception {
    SQLASTVisitorAdapter adapter = new SQLASTVisitorAdapter();
    new SQLBinaryOpExpr().accept(adapter);
    new SQLInListExpr().accept(adapter);
    new SQLSelectQueryBlock().accept(adapter);
    new SQLDropTableStatement().accept(adapter);
    new SQLCreateTableStatement().accept(adapter);
    new SQLDeleteStatement().accept(adapter);
    new SQLCurrentOfCursorExpr().accept(adapter);
    new SQLInsertStatement().accept(adapter);
    new SQLUpdateStatement().accept(adapter);
    new SQLNotNullConstraint().accept(adapter);
    new SQLMethodInvokeExpr().accept(adapter);
    new SQLCallStatement().accept(adapter);
    new SQLSomeExpr().accept(adapter);
    new SQLAnyExpr().accept(adapter);
    new SQLAllExpr().accept(adapter);
    new SQLDefaultExpr().accept(adapter);
    new SQLCommentStatement().accept(adapter);
    new SQLDropViewStatement().accept(adapter);
    new SQLSavePointStatement().accept(adapter);
    new SQLReleaseSavePointStatement().accept(adapter);
    new SQLCreateDatabaseStatement().accept(adapter);
    new SQLAlterTableDropIndex().accept(adapter);
    new SQLOver().accept(adapter);
    new SQLWithSubqueryClause().accept(adapter);
    new SQLAlterTableAlterColumn().accept(adapter);
    new SQLAlterTableStatement().accept(adapter);
    new SQLAlterTableDisableConstraint().accept(adapter);
    new SQLAlterTableEnableConstraint().accept(adapter);
    new SQLColumnCheck().accept(adapter);
    new SQLExprHint().accept(adapter);
    new SQLAlterTableDropConstraint().accept(adapter);
}