thread view, also fix file extensions

1 files changed, 19 insertions, 0 deletions

diff --git a/apioforum/thread.py b/apioforum/thread.py
new file mode 100644
index 0000000..24b7766
--- /dev/null
+++ b/apioforum/thread.py
@@ -0,0 +1,19 @@
+# view posts in thread
+
+from flask import (
+    Blueprint, render_template
+)
+from .db import get_db
+
+bp = Blueprint("thread", __name__, url_prefix="/thread")
+
+@bp.route("/view/<int:thread_id>")
+def view_thread(thread_id):
+    db = get_db()
+    thread = db.execute("SELECT * FROM threads WHERE id = ?;",(thread_id,)).fetchone()
+    if thread is None:
+        abort(404)
+    else:
+        posts = db.execute("SELECT * FROM posts WHERE thread = ? ORDER BY idx;",(thread_id,)).fetchall()
+        return render_template("view_thread.html",posts=posts,thread=thread)
+