blob: 652779b26ee9dbff97b3f73d16ba02ce202743a3 (
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
43
44
45
46
|
import rethinkdb
from pysite.base_route import RouteView
from pysite.mixins import DBMixin
class JamsIndexView(RouteView, DBMixin):
path = "/jams"
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)
)
jams = self.db.run(query, coerce=list)
return self.render("main/jams/index.html", jams=jams, has_applied_to_jam=self.has_applied_to_jam)
def get_jam_response(self, jam, user_id):
query = self.db.query("code_jam_responses").filter({"jam": jam, "snowflake": user_id})
result = self.db.run(query, coerce=list)
if result:
return result[0]
return None
def has_applied_to_jam(self, jam):
# whether the user has applied to this jam
if not self.logged_in:
return False
return self.get_jam_response(jam, self.user_data["user_id"])
|