aboutsummaryrefslogtreecommitdiffstats
path: root/pysite/views/main/jams/index.py
blob: 8d34fa50a2c7d1f41ba387b6c565fc5436a54932 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
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"

    def get(self):
        query = (
            self.db.query(self.table_name)
            .filter(rethinkdb.row["state"] != "planning")
            .order_by(rethinkdb.desc("number"))
            .limit(5)
        )

        jams = self.db.run(query, coerce=list)
        return self.render("main/jams/index.html", jams=jams)