blob: 0a9506f1080f7ba6cfe33ba8c9ff9762563ee19d (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
from pysite.base_route import RouteView
from pysite.mixins import DBMixin, OAuthMixin
class JamsTeamView(RouteView, DBMixin, OAuthMixin):
path = "/jams/teams"
name = "jams.teams_list"
def get(self):
# list teams a user is (or was) a part of
if not self.user_data:
return self.redirect_login()
query = self.db.query("code_jam_teams").filter(
lambda team: team["members"].contains(self.user_data["user_id"])
).merge(
lambda team: {
"members":
self.db.query("users")
.filter(lambda user: team["members"].contains(user["user_id"]))
.coerce_to("array")
}
)
teams = self.db.run(query)
entries = []
for team in teams:
# find the jam for this team
query = self.db.query("code_jams").filter(
lambda jam: jam["teams"].contains(team["id"])
)
jam = next(self.db.run(query))
entries.append({
"team": team,
"jam": jam
})
return self.render(
"main/jams/teams_list.html",
entries=entries
)
|
