def rate_movie(id): rating_number = int(request.form['rating']) user_id = session['user_id'] rating = db_session.query(Rating).filter_by(user_id=user_id, movie_id=id).first() if not rating: flash("Rating added") rating = Rating(user_id=user_id, movie_id=id) db_session.add(rating) else: flash("Rating updated") rating.rating = rating_number db_session.commit() return redirect(url_for("view_movie", id=id))
def rating(): if not g.user_id: flash("You have to be logged in to rate a movie.") return redirect(redirect_url()) else: user_id = session['user_id'] value = int(request.form["rating"]) movie_id = request.form['movie_id'] rating = db_session.query(Rating).filter(Rating.user_id==user_id).filter(Rating.movie_id==movie_id).first() if not rating: flash("Your rating has been added") rating = Rating(user_id=user_id, movie_id=movie_id) db_session.add(rating) else: flash("Your rating has been updated") rating.rating=value db_session.commit() return redirect (url_for('movie', id=movie_id))
def add_rating(): #get movie from search in movie_prof.html movie_id = int(request.form.get("id")) movie_from_wall = request.form.get("rating_from_wall") user_id = int(session["user"].id) not_interested = request.form.get("not_interested") rating = dbsession.query(Rating).filter_by(user_id = user_id, movie_id=movie_id).first() if not_interested: # add new 0 rating score = 0 review = "" else: score = int(request.form.get("star_rating")) review = request.form.get("movie_review") if not review: review = "" if not rating: # add new rating rating = Rating(movie_id = movie_id, user_id = user_id, rating = score, review = review) else: # update existing rating rating.rating = score rating.review = review dbsession.add(rating) dbsession.commit() clear_user_cache() ## flash message that it's been added? if movie_from_wall: return redirect("/wall") else: return redirect("/movie_prof?id=%d" % movie_id)