public static boolean isSelectStatement(String sql) { String sql1 = sql.toLowerCase(Locale.ROOT); sql1 = removeCommentInSql(sql1); sql1 = sql1.trim(); return sql1.startsWith(KEYWORD_SELECT) || (sql1.startsWith(KEYWORD_WITH) && sql1.contains(KEYWORD_SELECT)) || (sql1.startsWith(KEYWORD_EXPLAIN) && sql1.contains(KEYWORD_SELECT)); }
ProjectInstance projectInstance = projectManager.getProject(project); KylinConfig kylinConfig = projectInstance.getConfig(); sql = removeCommentInSql(sql); while (sql.endsWith(";")) sql = sql.substring(0, sql.length() - 1);
Assert.assertEquals(originSql, QueryUtil.removeCommentInSql(sqlWithComment)); Assert.assertEquals(originSql, QueryUtil.removeCommentInSql(sqlWithComment)); Assert.assertEquals(originSql, QueryUtil.removeCommentInSql(sqlWithComment)); Assert.assertEquals(originSql, QueryUtil.removeCommentInSql(sqlWithComment)); Assert.assertEquals(originSql, QueryUtil.removeCommentInSql(sqlWithComment)); Assert.assertEquals(originSql, QueryUtil.removeCommentInSql(sqlWithComment)); Assert.assertEquals(originSql, QueryUtil.removeCommentInSql(sqlWithComment)); Assert.assertEquals(originSql, QueryUtil.removeCommentInSql(sqlWithComment)); Assert.assertEquals(originSql, QueryUtil.removeCommentInSql(sqlWithComment)); Assert.assertEquals(originSql, QueryUtil.removeCommentInSql(sqlWithComment)); Assert.assertEquals(originSql, QueryUtil.removeCommentInSql(sqlWithComment)); Assert.assertEquals(originSql2, QueryUtil.removeCommentInSql(sqlWithComment2)); Assert.assertEquals(originSql2, QueryUtil.removeCommentInSql(sqlWithComment2)); Assert.assertEquals(originSql2, QueryUtil.removeCommentInSql(sqlWithComment2)); Assert.assertEquals(originSql2, QueryUtil.removeCommentInSql(sqlWithComment2));
logger.info("The original query: " + sql); sql = QueryUtil.removeCommentInSql(sql);
public static boolean isSelectStatement(String sql) { String sql1 = sql.toLowerCase(Locale.ROOT); sql1 = removeCommentInSql(sql1); sql1 = sql1.trim(); return sql1.startsWith(KEYWORD_SELECT) || (sql1.startsWith(KEYWORD_WITH) && sql1.contains(KEYWORD_SELECT)) || (sql1.startsWith(KEYWORD_EXPLAIN) && sql1.contains(KEYWORD_SELECT)); }
ProjectInstance projectInstance = projectManager.getProject(project); KylinConfig kylinConfig = projectInstance.getConfig(); sql = removeCommentInSql(sql); while (sql.endsWith(";")) sql = sql.substring(0, sql.length() - 1);