@GET public List<BasicQueryInfo> getAllQueryInfo(@QueryParam("state") String stateFilter) { QueryState expectedState = stateFilter == null ? null : QueryState.valueOf(stateFilter.toUpperCase(Locale.ENGLISH)); ImmutableList.Builder<BasicQueryInfo> builder = new ImmutableList.Builder<>(); for (BasicQueryInfo queryInfo : queryManager.getQueries()) { if (stateFilter == null || queryInfo.getState() == expectedState) { builder.add(queryInfo); } } return builder.build(); }
@GET public List<BasicQueryInfo> getAllQueryInfo(@QueryParam("state") String stateFilter) { QueryState expectedState = stateFilter == null ? null : QueryState.valueOf(stateFilter.toUpperCase(Locale.ENGLISH)); ImmutableList.Builder<BasicQueryInfo> builder = new ImmutableList.Builder<>(); for (BasicQueryInfo queryInfo : queryManager.getQueries()) { if (stateFilter == null || queryInfo.getState() == expectedState) { builder.add(queryInfo); } } return builder.build(); }
private QueryState getQueryState(String queryId) throws SQLException { String sql = format("SELECT state FROM system.runtime.queries WHERE query_id = '%s'", queryId); try (Connection connection = createConnection(); Statement statement = connection.createStatement(); ResultSet rs = statement.executeQuery(sql)) { assertTrue(rs.next(), "query not found"); return QueryState.valueOf(rs.getString("state")); } }
private QueryState getQueryState(String queryId) throws SQLException { String sql = format("SELECT state FROM system.runtime.queries WHERE query_id = '%s'", queryId); try (Connection connection = createConnection(); Statement statement = connection.createStatement(); ResultSet resultSet = statement.executeQuery(sql)) { assertTrue(resultSet.next(), "Query was not found"); return QueryState.valueOf(requireNonNull(resultSet.getString(1))); } }
private QueryState getQueryState(String queryId) throws SQLException { String sql = format("SELECT state FROM system.runtime.queries WHERE query_id = '%s'", queryId); try (Connection connection = createConnection(); Statement statement = connection.createStatement(); ResultSet resultSet = statement.executeQuery(sql)) { assertTrue(resultSet.next(), "Query was not found"); return QueryState.valueOf(requireNonNull(resultSet.getString(1))); } }
private Optional<QueryState> findQueryState(String text) throws SQLException { String sql = format("SELECT state FROM system.runtime.queries WHERE regexp_like(query, '%s$') /* */", Pattern.quote(text)); try (Connection connection = createConnection(); Statement statement = connection.createStatement(); ResultSet resultSet = statement.executeQuery(sql)) { if (!resultSet.next()) { return Optional.empty(); } QueryState state = QueryState.valueOf(requireNonNull(resultSet.getString(1))); assertFalse(resultSet.next(), "Found multiple queries"); return Optional.of(state); } }
private Optional<QueryState> findQueryState(String text) throws SQLException { String sql = format("SELECT state FROM system.runtime.queries WHERE regexp_like(query, '%s$') /* */", Pattern.quote(text)); try (Connection connection = createConnection(); Statement statement = connection.createStatement(); ResultSet resultSet = statement.executeQuery(sql)) { if (!resultSet.next()) { return Optional.empty(); } QueryState state = QueryState.valueOf(requireNonNull(resultSet.getString(1))); assertFalse(resultSet.next(), "Found multiple queries"); return Optional.of(state); } }