def apply_vote(user_id, post_id, vote):
#if the post dne, return false
post = Post.find_post(post_id)
if post is None:
return False
userpost = db.session.query(UserPost).filter(UserPost.post_id==post_id,\
UserPost.user_id==user_id).first()
# if the post has not been voted on by this user, we create an entry
# and add it to the db
# Standardize values
if (vote > 1):
vote = 1
elif (vote < -1):
vote = -1
# Edit userpost table
if userpost is None:
userpost = UserPost(user_id, post_id, vote)
db.session.add(userpost)
difference = vote
else:
currentvote = userpost.get_vote()
difference = vote - currentvote
userpost.set_vote(vote)
# Change value of votes on that post
post = Post.find_post(post_id)
post.increment_vote(difference)
db.session.commit()
return True
