Listing Ratings

The last remaining element on the Movie page is the list of ratings on the right-hand side of the page. Although the count in the header is now accurate, the ratings list being by the API needs to be implemented.

The list of ratings is populated by the forMovie() method in the RatingService, which currently returns a hardcoded list of ratings from the fixture ratings.json.

java
neoflix/services/RatingService.java
Unresolved directive in lesson.adoc - include::https://raw.githubusercontent.com/neo4j-graphacademy/llm-chatbot-python/main/src/main/java/neoflix/services/RatingService.java[tag=forMovie]

In this challenge, you will run the following Cypher statement in a read transaction:

cypher
Get Ratings
Unresolved directive in lesson.adoc - include::{cypher-repository-raw}/main/cypher/3-backlog/5-listing-ratings/listing-ratings.cypher[]

Your Task

  • Modify the forMovie() method to retrieve the ratings from Neo4j.

  • Remember to auto-close the session and use the toMap() function to convert the result record into native Java types.

Click to reveal the completed forMovie() method
java
neoflix/services/RatingService.java
Unresolved directive in lesson.adoc - include::https://raw.githubusercontent.com/neo4j-graphacademy/llm-chatbot-python/13-listing-ratings/src/main/java/neoflix/services/RatingService.java[tag=forMovie]

Testing

To test that this functionality has been correctly implemented, run the following code in a new terminal session:

sh
Running the test
mvn test -Dtest=neoflix._13_ListingRatingsTest

The test file is located at src/test/java/neoflix/_13_ListingRatingsTest.java.

Are you stuck? Click here for help

If you get stuck, you can see a working solution by checking out the 13-listing-ratings branch by running:

sh
Check out the 13-listing-ratings branch
git checkout 13-listing-ratings

You may have to commit or stash your changes before checking out this branch. You can also click here to expand the Support pane.

Verifying the Test

Who was the first user to rate Pulp Fiction?

As part of the test suite, the final test will log the name of the first user to rate the movie Pulp Fiction.

Paste the name of the user the box below without quotes or whitespace and click Check Answer.

  • ✓ Keith Howell

Hint

You can also find the answer by running the following Cypher statement:

cypher
Unresolved directive in questions/1-first-rating.adoc - include::{cypher-repository-raw}/main/cypher/3-backlog/5-listing-ratings/first-rating.cypher[]

Copy the answer without any quotes or whitespace.

Lesson Summary

In this Challenge, you modified the forMovie() method on the RatingService to return a paginated list of reviews for a movie from the Neo4j database.

In the next Challenge, you will update the PersonService to return list of actors and directors from Neo4j.

Chatbot

Hi, I am an Educational Learning Assistant for Intelligent Network Exploration. You can call me E.L.A.I.N.E.

How can I help you today?