diff options
| -rw-r--r-- | app.py | 9 | ||||
| -rw-r--r-- | templates/news.html | 15 |
2 files changed, 24 insertions, 0 deletions
@@ -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 |