From 64bde9f6ee49d79fac5ce042c74b08f069a9b389 Mon Sep 17 00:00:00 2001
From: Gareth Coles <gdude2002@gmail.com>
Date: Sat, 19 May 2018 16:15:28 +0100
Subject: [Jams] Some amount of public display, but links not ready yet

---
 pysite/views/main/jams/index.py | 17 ++++++++++++++---
 1 file changed, 14 insertions(+), 3 deletions(-)

(limited to 'pysite/views/main/jams/index.py')

diff --git a/pysite/views/main/jams/index.py b/pysite/views/main/jams/index.py
index 1e66de4f..a1771675 100644
--- a/pysite/views/main/jams/index.py
+++ b/pysite/views/main/jams/index.py
@@ -1,7 +1,18 @@
-from pysite.base_route import TemplateView
+import rethinkdb
 
+from pysite.base_route import RouteView
+from pysite.mixins import DBMixin
 
-class JamsIndexView(TemplateView):
+
+class JamsIndexView(RouteView, DBMixin):
     path = "/jams"
     name = "jams.index"
-    template = "main/jams/index.html"
+    table_name = "code_jams"
+
+    def get(self):
+        jams = self.db.run(
+            self.db.query(self.table_name).filter(rethinkdb.row["state"] != "planning").order_by("number").limit(5),
+            coerce=list
+        )
+        print(jams)
+        return self.render("main/jams/index.html", jams=jams)
-- 
cgit v1.2.3