Added news page

2 files changed, 24 insertions, 0 deletions

diff --git a/app.py b/app.py
index 79ad458..7869de9 100644
--- a/app.py
+++ b/app.py
@@ -124,3 +124,12 @@ def hydematch():
     cur.execute("SELECT * FROM matches ORDER BY id DESC")
     results = cur.fetchall()
     return render_template("hyde.html", matches=results)
+
+
+@app.route("/news")
+def news():
+    db = get_db()
+    cur = db.cursor()
+    cur.execute("SELECT * FROM news ORDER BY id DESC")
+    results = cur.fetchall()
+    return render_template("news.html", news=results)
diff --git a/templates/news.html b/templates/news.html
new file mode 100644
index 0000000..f2ada33
--- /dev/null
+++ b/templates/news.html
@@ -0,0 +1,15 @@
+{% extends "base.html" %}
+
+{% block content %}
+<main class="centered">
+    <h2>Drosera Springs eNewsletter</h2>
+    {% for article in news %}
+    <br>
+    <article>
+        <h3>{{ article.title }}</h3>
+        <small>Published {{ article.date }}</small>
+        <p>{{ article.content }}</p>
+    </article>
+    {% endfor %}
+</main>
+{% endblock %}
\ No newline at end of file