Start work on individual team view

1 files changed, 47 insertions, 0 deletions

diff --git a/pysite/views/main/jams/team_view.py b/pysite/views/main/jams/team_view.py
new file mode 100644
index 00000000..ebb1a5ce
--- /dev/null
+++ b/pysite/views/main/jams/team_view.py
@@ -0,0 +1,47 @@
+import logging
+
+from rethinkdb import ReqlNonExistenceError
+from werkzeug.exceptions import NotFound
+
+from pysite.base_route import RouteView
+from pysite.mixins import DBMixin, OAuthMixin
+
+log = logging.getLogger(__name__)
+
+
+class JamsTeamsListView(RouteView, DBMixin, OAuthMixin):
+    path = "/jams/team/<string:team_id>"
+    name = "jams.team_view"
+
+    table_name = "code_jam_teams"
+
+    def get(self, team_id: str):
+        try:
+            query = self.db.query(self.table_name).get(team_id).merge(
+                lambda team: {
+                    "members":
+                        self.db.query("users")
+                            .filter(lambda user: team["members"].contains(user["user_id"]))
+                            .merge(
+                            lambda user: {
+                                "gitlab_username": self.db.query("code_jam_participants").filter(
+                                    {"id": user["user_id"]}
+                                ).coerce_to("array")[0]["gitlab_username"]
+                            }
+                        ).coerce_to("array"),
+                    "jam":
+                        self.db.query("code_jams").filter(
+                            lambda jam: jam["teams"].contains(team["id"])
+                        ).coerce_to("array")[0]
+                }
+            )
+
+            team = self.db.run(query)
+        except ReqlNonExistenceError:
+            log.exception("Failed RethinkDB query")
+            raise NotFound()
+
+        return self.render(
+            "main/jams/team_view.html",
+            team=team
+        )