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

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

1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
        return stmt;
    }

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

        if (lexer.token() == Token.INSERT) {
            accept(Token.INSERT);
        }
View Full Code Here
59
60
61
62
63
64
65
66
67
68
        return stmt;
    }

    public SQLInsertStatement explainToInsertSQLObject(MappingEngine engine, String sql, MappingContext context) {
        OracleStatementParser parser = new OracleStatementParser(sql);
        SQLInsertStatement stmt = (SQLInsertStatement) parser.parseInsert();
        MappingVisitorUtils.setTableSource(engine, stmt, context);
        return stmt;

    }
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
            }
            singleTableQueryExecuetePlan.setResultMetaData(resultMetaData);

            this.executePlan = singleTableQueryExecuetePlan;
        } else if (sqlStmt instanceof SQLInsertStatement) {
            SQLInsertStatement insertStmt = (SQLInsertStatement) sqlStmt;

            SQLEvalVisitor evalVisitor = SQLEvalVisitorUtils.createEvalVisitor(dbType);
            insertStmt.accept(evalVisitor);

            String tableName = ((SQLIdentifierExpr) insertStmt.getTableSource().getExpr()).getName();

            InsertExecutePlan insertExecutePlan = new InsertExecutePlan();
            insertExecutePlan.setTableName(tableName);

            for (int i = 0; i < insertStmt.getColumns().size(); ++i) {
                SQLExpr columnExpr = insertStmt.getColumns().get(i);
                SQLExpr valueExpr = insertStmt.getValues().getValues().get(i);

                String columnName = ((SQLIdentifierExpr) columnExpr).getName();
                insertExecutePlan.getColumns().put(columnName, valueExpr);
            }
View Full Code Here
201
202
203
204
205
206
207
208
209
210
211
212
213
214
    public String explainToInsertSQL(String sql) {
        return explainToInsertSQL(sql, new MappingContext());
    }

    public String explainToInsertSQL(String sql, MappingContext context) {
        SQLInsertStatement stmt = explainToInsertSQLObject(sql, context);

        MappingVisitor visitor = this.createMappingVisitor(context);
        stmt.accept(visitor);
        visitor.afterResolve();
        afterResole(visitor);

        return toSQL(stmt);
    }
View Full Code Here
278
279
280
281
282
283
284
285
286
287
    public void insert(Connection conn, String sql, List<Object> parameters) throws SQLException {
        insert(conn, sql, new MappingContext(parameters));
    }

    public void insert(Connection conn, String sql, MappingContext context) throws SQLException {
        SQLInsertStatement sqlObject = this.explainToInsertSQLObject(sql, context);
        exportParameters(sqlObject, context.getParameters());
        String rawSql = this.toSQL(sqlObject);
        JdbcUtils.execute(conn, rawSql, context.getParameters());
    }
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
        return stmt;
    }

    public SQLInsertStatement explainToInsertSQLObject(MappingEngine engine, String sql, MappingContext context) {
        MySqlStatementParser parser = new MySqlStatementParser(sql);
        SQLInsertStatement stmt = (SQLInsertStatement) parser.parseInsert();

        MappingVisitorUtils.setTableSource(engine, stmt, context);

        return stmt;
    }
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
        return stmt;
    }

    public SQLInsertStatement explainToInsertSQLObject(MappingEngine engine, String sql, MappingContext context) {
        SQLServerStatementParser parser = new SQLServerStatementParser(sql);
        SQLInsertStatement stmt = (SQLInsertStatement) parser.parseInsert();

        MappingVisitorUtils.setTableSource(engine, stmt, context);

        return stmt;
    }
View Full Code Here
346
347
348
349
350
351
352
353
354
355
356
        return stmt;
    }

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

        if (lexer.token() == Token.INSERT) {
            accept(Token.INSERT);
        }
View Full Code Here
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(3, insertStmt.getValues().getValues().size());
        Assert.assertEquals(0, insertStmt.getColumns().size());
        Assert.assertEquals(1, statementList.size());

        MySqlSchemaStatVisitor visitor = new MySqlSchemaStatVisitor();
        stmt.accept(visitor);
View Full Code Here
397
398
399
400
401
402
403
404
405
406
407
        return stmt;
    }

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

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

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

  • com.alibaba.druid.bvt.sql.mysql.MySqlInsertTest_0
  • com.alibaba.druid.bvt.sql.mysql.MySqlInsertTest_1
  • com.alibaba.druid.bvt.sql.mysql.MySqlInsertTest_2
  • com.alibaba.druid.bvt.sql.mysql.MySqlInsertTest_3
  • com.alibaba.druid.bvt.sql.mysql.MySqlInsertTest_9
  • com.alibaba.druid.bvt.sql.SQLASTVisitorAdapterTest
  • com.alibaba.druid.hdriver.impl.HPreparedStatementImpl
  • com.alibaba.druid.mapping.MappingEngine
  • com.alibaba.druid.mapping.spi.MSSQLServerMappingProvider
  • com.alibaba.druid.mapping.spi.MySqlMappingProvider
    • Copyright © 2018 www.massapicom. 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.