@Test void should_find_stocks_when_find_all_by_symbol_given_valid_input() { given(findBySymbol.bind("ABC", i1, i2)).willReturn(bound); given(session.execute(bound)).willReturn(resultSet); given(resultSet.one()).willReturn(row1, row2, null); given(row1.getString(SYMBOL)).willReturn(stock1.getSymbol()); given(row1.getInstant(DATE)).willReturn(stock1.getDate()); given(row1.getBigDecimal(VALUE)).willReturn(stock1.getValue()); given(row2.getString(SYMBOL)).willReturn(stock2.getSymbol()); given(row2.getInstant(DATE)).willReturn(stock2.getDate()); given(row2.getBigDecimal(VALUE)).willReturn(stock2.getValue()); var stockRepository = new SyncStockRepository(session, insert, delete, findById, findBySymbol, rowMapper); var result = stockRepository.findAllBySymbol("ABC", i1, i2, 0, 10); assertThat(result).isNotEmpty().containsExactly(stock1, stock2); verify(session).execute(bound); }
@NonNull public Stream<Stock> findAllBySymbol( @NonNull String symbol, @NonNull Instant start, @NonNull Instant end, long offset, long limit) { BoundStatement bound = findBySymbol.bind(symbol, start, end); ResultSet rs = session.execute(bound); Stream<Row> stream = Stream.iterate(rs.one(), Objects::nonNull, row -> rs.one()); return stream.skip(offset).limit(limit).map(rowMapper); }
SyncStockRepository { @NonNull public Stream<Stock> findAllBySymbol( @NonNull String symbol, @NonNull Instant start, @NonNull Instant end, long offset, long limit) { BoundStatement bound = findBySymbol.bind(symbol, start, end); ResultSet rs = session.execute(bound); Stream<Row> stream = Stream.iterate(rs.one(), Objects::nonNull, row -> rs.one()); return stream.skip(offset).limit(limit).map(rowMapper); } }
SyncStockRepository { @NonNull public Stream<Stock> findAllBySymbol( @NonNull String symbol, @NonNull Instant start, @NonNull Instant end, long offset, long limit) { BoundStatement bound = findBySymbol.bind(symbol, start, end); ResultSet rs = session.execute(bound); Stream<Row> stream = Stream.iterate(rs.one(), Objects::nonNull, row -> rs.one()); return stream.skip(offset).limit(limit).map(rowMapper); } SyncStockRepository(
      CqlSession session,
      @Qualifier("stocks.prepared.insert") PreparedStatement insert,
      @Qualifier("stocks.prepared.deleteById") PreparedStatement deleteById,
      @Qualifier("stocks.prepared.findById") PreparedStatement findById,
      @Qualifier("stocks.prepared.findBySymbol") PreparedStatement findBySymbol,
      Function<Row, Stock> rowMapper); }
SyncStockRepository { @NonNull public Stream<Stock> findAllBySymbol( @NonNull String symbol, @NonNull Instant start, @NonNull Instant end, long offset, long limit) { BoundStatement bound = findBySymbol.bind(symbol, start, end); ResultSet rs = session.execute(bound); Stream<Row> stream = Stream.iterate(rs.one(), Objects::nonNull, row -> rs.one()); return stream.skip(offset).limit(limit).map(rowMapper); } SyncStockRepository(
      CqlSession session,
      @Qualifier("stocks.prepared.insert") PreparedStatement insert,
      @Qualifier("stocks.prepared.deleteById") PreparedStatement deleteById,
      @Qualifier("stocks.prepared.findById") PreparedStatement findById,
      @Qualifier("stocks.prepared.findBySymbol") PreparedStatement findBySymbol,
      Function<Row, Stock> rowMapper); @NonNull Stock save(@NonNull Stock stock); void deleteById(@NonNull String symbol, @NonNull Instant date); @NonNull Optional<Stock> findById(@NonNull String symbol, @NonNull Instant date); @NonNull Stream<Stock> findAllBySymbol(
      @NonNull String symbol,
      @NonNull Instant start,
      @NonNull Instant end,
      long offset,
      long limit); }
SyncStockRepository { @NonNull public Stream<Stock> findAllBySymbol( @NonNull String symbol, @NonNull Instant start, @NonNull Instant end, long offset, long limit) { BoundStatement bound = findBySymbol.bind(symbol, start, end); ResultSet rs = session.execute(bound); Stream<Row> stream = Stream.iterate(rs.one(), Objects::nonNull, row -> rs.one()); return stream.skip(offset).limit(limit).map(rowMapper); } SyncStockRepository(
      CqlSession session,
      @Qualifier("stocks.prepared.insert") PreparedStatement insert,
      @Qualifier("stocks.prepared.deleteById") PreparedStatement deleteById,
      @Qualifier("stocks.prepared.findById") PreparedStatement findById,
      @Qualifier("stocks.prepared.findBySymbol") PreparedStatement findBySymbol,
      Function<Row, Stock> rowMapper); @NonNull Stock save(@NonNull Stock stock); void deleteById(@NonNull String symbol, @NonNull Instant date); @NonNull Optional<Stock> findById(@NonNull String symbol, @NonNull Instant date); @NonNull Stream<Stock> findAllBySymbol(
      @NonNull String symbol,
      @NonNull Instant start,
      @NonNull Instant end,
      long offset,
      long limit);  }