Optional Lesson
This lesson is optional and will not count towards your achievement.
To view the completed code, check out the 10-genre-details branch.
When the user clicks a genre in the list, they are taken to a list of movies for that genre. This list is populated by an API request to /api/genres/[name], for example http://localhost:3000/api/genres/Comedy.
The find() method the the GenreService accepts one argument, the name of the genre, and should return the information about the genre, along with a count of movies and a poster image.
async find(name) {
// TODO: Open a new session
// TODO: Get Genre information from the database
// TODO: Throw a 404 Error if the genre is not found
// TODO: Close the session
return genres.find(genre => genre.name === name)
}In this challenge, you will modify the method to run the following Cypher statement in a read transaction:
MATCH (g:Genre {name: $name})<-[:IN_GENRE]-(m:Movie)
WHERE m.imdbRating IS NOT NULL AND m.poster IS NOT NULL AND g.name <> '(no genres listed)'
WITH g, m
ORDER BY m.imdbRating DESC
WITH g, head(collect(m)) AS movie
RETURN g {
.name,
movies: count { (g)<-[:IN_GENRE]-() },
poster: movie.poster
} AS genreWhat does this query do?
This query uses the MATCH clause for a Genre node with the name passed through with the function call as a parameter.
The query then finds the highest rated movie with a poster property and uses that image as the background to the card in the UI.
The size() function uses a precalculated value stored against the Genre node to return the number of incoming IN_GENRE relationships the Genre node.
Your Task
-
Modify the
find()method on theGenreServiceto call the Neo4j database and return details for a genre. -
The
namevariable should be passed to therun()call as a parameter. -
If no records are found, a
NotFoundErrorshould be thrown. -
Remember to close the session and use the
toNativeTypes()function to convert the genre value to native JavaScript types.
Open src/services/genre.service.js
Working Solution
Click here to view the completed find() method.
async find(name) {
// Open a new Session
const session = this.driver.session()
// Get Genre information from the database
const res = await session.executeRead(tx => tx.run(`
MATCH (g:Genre {name: $name})<-[:IN_GENRE]-(m:Movie)
WHERE m.imdbRating IS NOT NULL
AND m.poster IS NOT NULL
AND g.name <> '(no genres listed)'
WITH g, m
ORDER BY m.imdbRating DESC
WITH g, head(collect(m)) AS movie
RETURN g {
link: '/genres/'+ g.name,
.name,
movies: size((g)<-[:IN_GENRE]-()),
poster: movie.poster
} AS genre
`, { name }))
// Throw a 404 Error if the genre is not found
if ( res.records.length === 0 ) {
throw new NotFoundError(`Could not find a genre with the name '${name}'`)
}
// Close the session
await session.close()
// Return results
const [ row ] = res.records
return toNativeTypes(row.get('genre'))
}Testing
To test that this functionality has been correctly implemented, run the following code in a new terminal session:
npm run test 10The test file is located at test/challenges/10-genre-details.spec.js.
Are you stuck? Click here for help
If you get stuck, you can see a working solution by checking out the 10-genre-details branch by running:
git checkout 10-genre-detailsYou 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
How many movies are in the Action genre?
After the test has succeeded, the test suite will log the count of movies in the Action genre to the console.
Enter the number of movies below and click Check Answer.
-
✓ 1545
Hint
You can also find the answer by running the following Cypher statement:
MATCH (g:Genre {name: "Action"})
RETURN count { (g)<-[:IN_GENRE]-() }Lesson Summary
In this Challenge, you modified the find() method in the GenreService to retrieve genre information from Neo4j.
In the next Challenge, you will update multiple methods in the MovieService that return a paginated list of movies.