import sample.data.jpa.domain.RatingCount; //导入依赖的package包/类
@Test
public void executesQueryMethodsCorrectly() {
	City city = this.cityRepository
			.findAll(new PageRequest(0, 1, Direction.ASC, "name")).getContent()
			.get(0);
	assertThat(city.getName()).isEqualTo("Atlanta");

	Page<HotelSummary> hotels = this.repository.findByCity(city,
			new PageRequest(0, 10, Direction.ASC, "name"));
	Hotel hotel = this.repository.findByCityAndName(city,
			hotels.getContent().get(0).getName());
	assertThat(hotel.getName()).isEqualTo("Doubletree");

	List<RatingCount> counts = this.repository.findRatingCounts(hotel);
	assertThat(counts).hasSize(1);
	assertThat(counts.get(0).getRating()).isEqualTo(Rating.AVERAGE);
	assertThat(counts.get(0).getCount()).isGreaterThan(1L);
}
 

import sample.data.jpa.domain.RatingCount; //导入依赖的package包/类
@Test
public void executesQueryMethodsCorrectly() {
	City city = this.cityRepository
			.findAll(new PageRequest(0, 1, Direction.ASC, "name")).getContent()
			.get(0);
	assertThat(city.getName(), is("Atlanta"));

	Page<HotelSummary> hotels = this.repository.findByCity(city,
			new PageRequest(0, 10, Direction.ASC, "name"));
	Hotel hotel = this.repository.findByCityAndName(city,
			hotels.getContent().get(0).getName());
	assertThat(hotel.getName(), is("Doubletree"));

	List<RatingCount> counts = this.repository.findRatingCounts(hotel);
	assertThat(counts, hasSize(1));
	assertThat(counts.get(0).getRating(), is(Rating.AVERAGE));
	assertThat(counts.get(0).getCount(), is(greaterThan(1L)));
}
 

import sample.data.jpa.domain.RatingCount; //导入依赖的package包/类
@Override
public ReviewsSummary getReviewSummary(Hotel hotel) {
	List<RatingCount> ratingCounts = this.hotelRepository.findRatingCounts(hotel);
	return new ReviewsSummaryImpl(ratingCounts);
}
 

import sample.data.jpa.domain.RatingCount; //导入依赖的package包/类
public ReviewsSummaryImpl(List<RatingCount> ratingCounts) {
	this.ratingCount = new HashMap<>();
	for (RatingCount ratingCount : ratingCounts) {
		this.ratingCount.put(ratingCount.getRating(), ratingCount.getCount());
	}
}
 

import sample.data.jpa.domain.RatingCount; //导入依赖的package包/类
@Query("select r.rating as rating, count(r) as count "
		+ "from Review r where r.hotel = ?1 group by r.rating order by r.rating DESC")
List<RatingCount> findRatingCounts(Hotel hotel);
 

import sample.data.jpa.domain.RatingCount; //导入依赖的package包/类
public ReviewsSummaryImpl(List<RatingCount> ratingCounts) {
	this.ratingCount = new HashMap<Rating, Long>();
	for (RatingCount ratingCount : ratingCounts) {
		this.ratingCount.put(ratingCount.getRating(), ratingCount.getCount());
	}
}
 

import sample.data.jpa.domain.RatingCount; //导入依赖的package包/类
@Query("select new sample.data.jpa.domain.RatingCount(r.rating, count(r)) "
		+ "from Review r where r.hotel = ?1 group by r.rating order by r.rating DESC")
List<RatingCount> findRatingCounts(Hotel hotel);