Notflix | Kotlin Multiplatform playground | Architecture library

Me and my partner need to get the average rating per movie. Movie and Rating are two separate collections on our MongoDB database.

So, first we need to get all the movies. After that, all we should still need is to iterate in a for-loop through the length of the list of movies returned. In every iteration we Rating.find on the tt_number of the movie that is currently on the index of the for-loop. At that point, it should calculate an average of all of that movie's ratings and store the result in a string JSON. This is done for every movie.

However, the code I included down here does nothing like that. Instead, the for-loop first completes, and then it performs the Rating.find three times afterwards, except with the tt_number of the last iterated movie every time.