Examples of SQLInsertStatement

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

414
415
416
417
418
419
420
421
422
423
424
        return stmt;
    }

    public SQLStatement parseInsert() {
        SQLInsertStatement insertStatement = new SQLInsertStatement();

        if (lexer.token() == Token.INSERT) {
            accept(Token.INSERT);
        }
View Full Code Here

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

187
188
189
190
191
192
193
194
195
196
197
        return stmt;
    }

    public SQLStatement parseInsert() {
        SQLInsertStatement insertStatement = new SQLInsertStatement();
       
        if (lexer.token() == Token.INSERT) {
            accept(Token.INSERT);
        }
View Full Code Here

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

341
342
343
344
345
346
347
348
349
350
351
        return stmt;
    }

    public SQLStatement parseInsert() {
        SQLInsertStatement insertStatement = new SQLInsertStatement();

        if (lexer.token() == Token.INSERT) {
            accept(Token.INSERT);
        }
View Full Code Here

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

133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
    public SQLStatement parseInsert() {
        accept(Token.INSERT);
        accept(Token.INTO);

        SQLInsertStatement insertStatement = new SQLInsertStatement();

        SQLName tableName = this.exprParser.name();
        insertStatement.setTableName(tableName);

        if (lexer.token() == Token.IDENTIFIER) {
            insertStatement.setAlias(lexer.stringVal());
            lexer.nextToken();
        }

        if (lexer.token() == (Token.LPAREN)) {
            lexer.nextToken();
            this.exprParser.exprList(insertStatement.getColumns());
            accept(Token.RPAREN);
        }

        if (lexer.token() == (Token.VALUES)) {
            lexer.nextToken();
            accept(Token.LPAREN);
            SQLInsertStatement.ValuesClause values = new SQLInsertStatement.ValuesClause();
            this.exprParser.exprList(values.getValues());
            insertStatement.setValues(values);
            accept(Token.RPAREN);
        } else if (lexer.token() == (Token.SELECT)) {
            SQLQueryExpr queryExpr = (SQLQueryExpr) this.createExprParser().expr();
            insertStatement.setQuery(queryExpr.getSubQuery());
        }
        return insertStatement;
    }
View Full Code Here

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

348
349
350
351
352
353
354
355
356
357
358
        return stmt;
    }

    public SQLStatement parseInsert() {
        SQLInsertStatement insertStatement = new SQLInsertStatement();

        if (lexer.token() == Token.INSERT) {
            accept(Token.INSERT);
        }
View Full Code Here

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

33
34
35
36
37
38
39
40
41
42
43
44
45
46
        MySqlStatementParser parser = new MySqlStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement stmt = statementList.get(0);

        SQLInsertStatement insertStmt = (SQLInsertStatement) stmt;

        Assert.assertEquals(2, insertStmt.getValues().getValues().size());
        Assert.assertEquals(2, insertStmt.getColumns().size());
        Assert.assertEquals(1, statementList.size());

        MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
        stmt.accept(visitor);
View Full Code Here

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

1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
        return stmt;
    }

    public SQLStatement parseInsert() {
        SQLInsertStatement insertStatement = new SQLInsertStatement();

        if (lexer.token() == Token.INSERT) {
            accept(Token.INSERT);
        }
View Full Code Here

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

44
45
46
47
48
49
50
51
52
53
54
        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 NotNullConstraint ().accept(adapter);
        new SQLMethodInvokeExpr ().accept(adapter);
        new SQLCallStatement ().accept(adapter);
        new SQLSomeExpr ().accept(adapter);
View Full Code Here

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

33
34
35
36
37
38
39
40
41
42
43
44
45
46
        MySqlStatementParser parser = new MySqlStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement stmt = statementList.get(0);

        SQLInsertStatement insertStmt = (SQLInsertStatement) stmt;

        Assert.assertEquals(2, insertStmt.getValues().getValues().size());
        Assert.assertEquals(2, insertStmt.getColumns().size());
        Assert.assertEquals(1, statementList.size());

        MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
        stmt.accept(visitor);
View Full Code Here

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

50
51
52
53
54
55
56
57
58
59
60
61
62
        MySqlStatementParser parser = new MySqlStatementParser(sql);
        List<SQLStatement> statementList = parser.parseStatementList();
        SQLStatement stmt = statementList.get(0);

        SQLInsertStatement insertStmt = (SQLInsertStatement) stmt;

        SQLCharExpr charExpr = (SQLCharExpr) insertStmt.getValues().getValues().get(0);
        String text = charExpr.getText();
        Assert.assertEquals('1', text.charAt(charExpr.getText().length() - 1));
        Assert.assertEquals('\\', text.charAt(charExpr.getText().length() - 2));

        print(statementList);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.