def route_edit_answer(answer_id):
if request.method == 'GET':
original_answer = data_manager2.get_answer_by_id(answer_id)
return render_template('edit_answer.html',
answer_id=answer_id,
original_answer=original_answer)
if request.method == 'POST':
original_answer = data_manager2.get_answer_by_id(answer_id)
question_id = original_answer[0]['question_id']
submission_time = datetime.now(),
message = request.form.get('message'),
data_manager2.update_answer_by_id(answer_id, submission_time, message)
return redirect(url_for("route_question", question_id=question_id))
def delete_answer(answer_id):
answer_id = answer_id
answers = data_manager2.get_answer_by_id(answer_id)
question_id = answers['question_id']
data_manager2.delete_comment_by_answer_id(answer_id)
data_manager2.delete_answer_by_answer_id(answer_id)
return redirect(url_for("route_question", question_id=question_id))
def addvote_answer(answer_id):
answerss = data_manager2.get_answer_by_id(answer_id)
print(answerss)
question_id = answerss['question_id']
vote_number = answerss['vote_number'] + 1
data_manager2.update_answer_votenum_by_id(answer_id, vote_number)
return redirect(url_for("route_question", question_id=question_id))
def delete_comment(comment_id):
comment_id = comment_id
comment = data_manager2.get_comment_by_id(comment_id)
if comment[0]['question_id'] is not None:
question_id = comment[0]['question_id']
else:
answer = data_manager2.get_answer_by_id(comment[0]['answer_id'])
question_id = answer['question_id']
data_manager2.delete_comment_by_comment_id(comment_id)
return redirect(url_for("route_question", question_id=question_id))
def addcomment_answer(answer_id):
if request.method == "GET":
return render_template('addcomment2.html', answer_id=answer_id)
if request.method == "POST":
answer_id = answer_id
submission_time = datetime.now(),
message = request.form.get("message"),
answer = data_manager2.get_answer_by_id(answer_id)
print(answer)
question_id = answer['question_id']
print(question_id)
edited_count = 0,
data_manager2.add_comment_for_answer(submission_time, message,
edited_count, answer_id)
return redirect(url_for("route_question", question_id=question_id))
def route_edit_comment(comment_id):
if request.method == 'GET':
original_comment = data_manager2.get_comment_by_id(comment_id)
return render_template('edit_comment.html',
comment_id=comment_id,
original_comment=original_comment)
if request.method == 'POST':
original_comment = data_manager2.get_comment_by_id(comment_id)
question_id = original_comment[0]['question_id']
if question_id is None:
answer = data_manager2.get_answer_by_id(
original_comment[0]['answer_id'])
question_id = answer['question_id']
submission_time = datetime.now(),
message = request.form.get('message'),
edited_count = original_comment[0]['edited_count'] + 1
data_manager2.update_comment_by_id(comment_id, submission_time,
message, edited_count)
return redirect(url_for("route_question", question_id=question_id))