Java Code Examples for com.alibaba.druid.sql.parser.SQLStatementParser#parseStatementList()
The following examples show how to use
com.alibaba.druid.sql.parser.SQLStatementParser#parseStatementList() .
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: DefaultRouteStrategy.java From dble with GNU General Public License v2.0 | 6 votes |
@Override public SQLStatement parserSQL(String originSql) throws SQLSyntaxErrorException { SQLStatementParser parser = new MySqlStatementParser(originSql); /** * thrown SQL SyntaxError if parser error */ try { List<SQLStatement> list = parser.parseStatementList(); if (list.size() > 1) { throw new SQLSyntaxErrorException("MultiQueries is not supported,use single query instead "); } return list.get(0); } catch (Exception t) { LOGGER.info("routeNormalSqlWithAST", t); if (t.getMessage() != null) { throw new SQLSyntaxErrorException(t.getMessage()); } else { throw new SQLSyntaxErrorException(t); } } }
Example 2
Source File: MySQLDialect.java From Zebra with Apache License 2.0 | 6 votes |
@Override public String getCountSql(String sql) { SQLStatementParser parser = new MySqlStatementParser(sql); List<SQLStatement> stmtList = parser.parseStatementList(); // 将AST通过visitor输出 StringBuilder out = new StringBuilder(); MysqlCountOutputVisitor visitor = new MysqlCountOutputVisitor(out); for (SQLStatement stmt : stmtList) { if (stmt instanceof SQLSelectStatement) { stmt.accept(visitor); out.append(";"); } } return out.toString(); }
Example 3
Source File: ElasticSearchPreparedStatement.java From elasticsearch-sql with Apache License 2.0 | 6 votes |
public String getExecutableSql() { if (parametersSize < 1) { return sql; } List<Object> parameters = new ArrayList<>(parametersSize); JdbcParameter jdbcParam; for (int i = 0; i < parametersSize; ++i) { jdbcParam = this.parameters[i]; parameters.add(jdbcParam != null ? jdbcParam.getValue() : null); } try { SQLStatementParser parser = ESActionFactory.createSqlStatementParser(sql); List<SQLStatement> statementList = parser.parseStatementList(); return SQLUtils.toSQLString(statementList, JdbcConstants.MYSQL, parameters, sqlFormatOption); } catch (ClassCastException | ParserException ex) { LOG.warn("format error", ex); return sql; } }
Example 4
Source File: ElasticSearchDruidDataSource.java From elasticsearch-sql with Apache License 2.0 | 5 votes |
private void oracleValidationQueryCheck() { if (validationQuery == null) { return; } if (validationQuery.length() == 0) { return; } SQLStatementParser sqlStmtParser = SQLParserUtils.createSQLStatementParser(validationQuery, this.dbType); List<SQLStatement> stmtList = sqlStmtParser.parseStatementList(); if (stmtList.size() != 1) { return; } SQLStatement stmt = stmtList.get(0); if (!(stmt instanceof SQLSelectStatement)) { return; } SQLSelectQuery query = ((SQLSelectStatement) stmt).getSelect().getQuery(); if (query instanceof SQLSelectQueryBlock) { if (((SQLSelectQueryBlock) query).getFrom() == null) { LOG.error("invalid oracle validationQuery. " + validationQuery + ", may should be : " + validationQuery + " FROM DUAL"); } } }
Example 5
Source File: ElasticSearchDruidDataSource.java From elasticsearch-sql with Apache License 2.0 | 5 votes |
private void db2ValidationQueryCheck() { if (validationQuery == null) { return; } if (validationQuery.length() == 0) { return; } SQLStatementParser sqlStmtParser = SQLParserUtils.createSQLStatementParser(validationQuery, this.dbType); List<SQLStatement> stmtList = sqlStmtParser.parseStatementList(); if (stmtList.size() != 1) { return; } SQLStatement stmt = stmtList.get(0); if (!(stmt instanceof SQLSelectStatement)) { return; } SQLSelectQuery query = ((SQLSelectStatement) stmt).getSelect().getQuery(); if (query instanceof SQLSelectQueryBlock) { if (((SQLSelectQueryBlock) query).getFrom() == null) { LOG.error("invalid db2 validationQuery. " + validationQuery + ", may should be : " + validationQuery + " FROM SYSDUMMY"); } } }
Example 6
Source File: DBUtil.java From DataLink with Apache License 2.0 | 4 votes |
public static void sqlValid(String sql, DataBaseType dataBaseType){ SQLStatementParser statementParser = SQLParserUtils.createSQLStatementParser(sql,dataBaseType.getTypeName()); statementParser.parseStatementList(); }