diff options
| author |  Gareth Coles <[email protected]> | 2018-06-23 19:00:07 +0000 |
|---|---|---|
| committer | Gareth Coles <[email protected]> | 2018-06-23 19:00:07 +0000 |
| commit | 90b9ebfe6b59a69e9783259a70e7927d989604f8 (patch) | |
| tree | a6b796051cb7b7811ce8528b2b4501278422591e /pysite/views/main/jams/index.py | |
| parent | Update Font-Awesome Pro to 5.1.0 (diff) | |
| parent | Add some documentation to the team_edit_repo route (diff) | |
Merge branch 'teams-user-frontend' into 'master'
User frontend for teams
See merge request python-discord/projects/site!9
Diffstat (limited to 'pysite/views/main/jams/index.py')
| -rw-r--r-- | pysite/views/main/jams/index.py | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/pysite/views/main/jams/index.py b/pysite/views/main/jams/index.py index 8d34fa50..abe2859f 100644 --- a/pysite/views/main/jams/index.py +++ b/pysite/views/main/jams/index.py @@ -9,10 +9,21 @@ class JamsIndexView(RouteView, DBMixin): name = "jams.index" table_name = "code_jams" + teams_table = "code_jam_teams" + def get(self): query = ( self.db.query(self.table_name) .filter(rethinkdb.row["state"] != "planning") + .merge( + lambda jam_obj: { + "teams": + self.db.query(self.teams_table) + .filter(lambda team_row: jam_obj["teams"].contains(team_row["id"])) + .pluck(["id"]) + .coerce_to("array") + } + ) .order_by(rethinkdb.desc("number")) .limit(5) ) |