def index(self):
s = select([t_users.c.id, t_users.c.nick_name,
func.sum(case([(t_avatar_guesses.c.guessed==True, 1)],
else_=0)),
func.count(t_avatar_guesses.c.guessed)],
from_obj=[t_avatar_guesses.join(t_users)]). \
group_by(t_users.c.id, t_users.c.nick_name)
c.players = Session.execute(s)
c.title = 'igrice'
return render('/games/index.mako')
def index(self):
s = select(
[
t_users.c.id,
t_users.c.nick_name,
func.sum(case([(t_avatar_guesses.c.guessed == True, 1)], else_=0)),
func.count(t_avatar_guesses.c.guessed),
],
from_obj=[t_avatar_guesses.join(t_users)],
).group_by(t_users.c.id, t_users.c.nick_name)
c.players = Session.execute(s)
c.title = "igrice"
return render("/games/index.mako")
