Add edit comment feature

This is handled in javascript. When clicking the edit link:

1. a form is shown to edit the RST source of the comment.
2. on submit, an AJAX POST request is sent to the new "comment" endpoint in the
   flask app.
3. the endpoint compiles the RST source, update the comment in the database and
   sends back formatted content to the client.
4. the client then updates the comment content and hides the form.

1 files changed, 17 insertions, 1 deletions

diff --git a/famille.py b/famille.py
index c1cedd3..d958bcb 100644
--- a/famille.py
+++ b/famille.py
@@ -2,7 +2,7 @@
 import sqlite3
 #all the imports
 from flask import Flask, request, session, g, redirect,\
-    url_for, render_template, flash
+    url_for, render_template, flash, jsonify
 from functools import wraps
 import hashlib
 from pytz import timezone
@@ -203,6 +203,22 @@ def show_news(news_id):
         return redirect(url_for('show_news', news_id=news_id))
 
 
+@app.route('/comment/<int:comment_id>', methods=['POST'])
+@login_required
+def update_comment(comment_id):
+    comment = query_db("SELECT * FROM comments WHERE comments.id = ?",
+                       (comment_id,), True)
+    if comment["user_id"] == session["user_id"]:
+        content = request.form['content']
+        content_cache = rstify(content)
+        db = get_db()
+        db.execute("UPDATE comments set content=?, content_cache=? "
+                   "WHERE comments.id=?",
+                   (content, content_cache, comment_id))
+        db.commit()
+        return jsonify(content=content, content_cache=content_cache)
+
+
 @app.route('/news/<int:news_id>/edit', methods=['GET', 'POST'])
 @login_required
 def edit_news(news_id):