1 files changed, 14 insertions, 3 deletions
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)