def addDiagnoseComment(): form = CommentsForm(request.form) resultForm=form.validate() if resultForm.status==rs.SUCCESS.status: #session['remember_me'] = form.remember_me.data # login and validate the user... diagnoseComment=Comment(form.userId,form.receiverId,form.diagnoseId,form.content) db_session.add(diagnoseComment) db_session.commit() db_session.flush() score=constant.DiagnoseScore[form.score] diagnose=Diagnose.getDiagnoseById(form.diagnoseId) diagnose.score=form.score Diagnose.save(diagnose) #为医生添加一些冗余字段 if hasattr(diagnose,'doctor'): doctor=diagnose.doctor if score!=0: if doctor.goodFeedbackCount: doctor.goodFeedbackCount+=1 else: doctor.goodFeedbackCount=1 if doctor.feedbackCount: doctor.feedbackCount+=1 else: doctor.feedbackCount=1 Doctor.save(doctor) #flash('成功添加诊断评论') return jsonify(rs.SUCCESS.__dict__) return jsonify(rs.FAILURE.__dict__)
def addDiagnoseComment(): form = CommentsForm(request.form) resultForm = form.validate() if resultForm.status == rs.SUCCESS.status: #session['remember_me'] = form.remember_me.data # login and validate the user... diagnoseComment = Comment(form.userId, form.receiverId, form.diagnoseId, form.content) db_session.add(diagnoseComment) db_session.commit() db_session.flush() score = constant.DiagnoseScore[form.score] diagnose = Diagnose.getDiagnoseById(form.diagnoseId) diagnose.score = form.score Diagnose.save(diagnose) #为医生添加一些冗余字段 if hasattr(diagnose, 'doctor'): doctor = diagnose.doctor if score != 0: if doctor.goodFeedbackCount: doctor.goodFeedbackCount += 1 else: doctor.goodFeedbackCount = 1 if doctor.feedbackCount: doctor.feedbackCount += 1 else: doctor.feedbackCount = 1 Doctor.save(doctor) #flash('成功添加诊断评论') return jsonify(rs.SUCCESS.__dict__) return jsonify(rs.FAILURE.__dict__)
def discussion_page(id): #POSSIBLE BUG HERE form = CommentsForm(request.form) # Create cursor c, conn = connection() # select current article page that was clicked c.execute("SELECT * FROM articles WHERE id = %s", [id]) article = c.fetchone() # article title is need so you can put inside comment table current_title = article['title'] # Fetch all comments for html page c.execute("SELECT * FROM comments WHERE article_title=%s AND common_id=%s", [current_title, id]) # fetch all into variable for later use comments = c.fetchall() # if post means comment is being added if request.method == 'POST' and form.validate(): # get form body data as this is post method and create cursor dont need if post as this is post already at the top # THIS IS RETURNING AN EMPTY STRING WHY~~~~ answer: compare login html input and discussion html render field new_comment = form.comment.data # Create Cursor c, conn = connection() # Execute query c.execute( "INSERT INTO comments(article_title, comment, author, common_id) VALUES(%s, %s, %s, %s)", (current_title, new_comment, session['username'], id)) # Commit to DB conn.commit() # Close connection c.close() conn.close() flash('Comment added!', 'success') return redirect(url_for('discussion_page', id=id)) return render_template('discussion.html', article=article, form=form, comments=comments)
def view(id): if request.method == "GET": info = blogs.get(blogs.c.id == id) form = CommentsForm() comment = comments.filter(comments.c.blog_id == id) return {'form':form, 'info':info, 'comment':comment} if request.method == "POST": form = CommentsForm() flag = form.validate(request.params) if flag: info = comments(**form.data) info.blog_id = id info.save() return redirect('/view/%s' % id)
def edit_comment(id): # Create Cursor c, conn = connection() # Get comment by id c.execute("SELECT * FROM comments WHERE id = %s", [id]) # represents all rows of 1 comment of given id comment = c.fetchone() # Get form form = CommentsForm(request.form) # Populate comment form fields form.comment.data = comment['comment'] # Before Post check if author of comment is the one editing comment_author = comment['author'] # this variable is made so the redirect can be directed to correct article id comment_common_id = comment['common_id'] if session['username'] == comment_author: pass else: flash('Cannot edit must be appropriate author', 'danger') return redirect(url_for('discussion_page', id=comment_common_id)) if request.method == 'POST' and form.validate(): new_comment = request.form['comment'] # Execute c.execute("UPDATE comments SET comment=%s WHERE id = %s", (new_comment, id)) # Commit to DB conn.commit() # Close connection c.close() conn.close() flash('Comment Updated', 'success') return redirect(url_for('discussion_page', id=comment_common_id)) return render_template('edit_comment.html', form=form, comment=comment)