def movie_details(movie_id):
"""Show details about a movie."""
movie = Movie.get_movie_by_id(movie_id)
release_date = movie.released_at.strftime("%B %d, %Y")
return render_template('movie_detail.html', movie=movie, release_date=release_date, scores=SCORES)
def update_rating():
"""Creates/Updates user rating of a specific movie."""
username = session["username"]
movie_id = request.form.get("movie_id")
score = request.form.get("score")
movie_title = Movie.get_movie_by_id(movie_id).title
rating_user_id = User.query.filter_by(email=username).first().user_id
existing_rating = Rating.query.filter(Rating.user_id == rating_user_id, Rating.movie_id == movie_id).first()
if existing_rating:
existing_rating.score = score
else:
new_rating = Rating(movie_id=int(movie_id), user_id=int(rating_user_id), score=int(score))
db.session.add(new_rating)
db.session.commit()
flash("Your rating of " + score + " for " + movie_title + " has successfully been recorded.")
return redirect("/movies")
