rank.py

import os
import json
import msgpack
import tornado.web
import psycopg2
from req import Service
from req import RequestHandler
from req import reqenv
from user import UserConst
from user import UserService

class RankService:
    def __init__(self,db,rs):
        self.db = db
        self.rs = rs
        RankService.inst = self

class RankHandler(RequestHandler):
    @reqenv
    def get(self,pro_id):
        pro_id = int(pro_id)
        cur = yield self.db.cursor()
        # show best socre in rank
        yield cur.execute(('SELECT *'
            'FROM ('
            'SELECT DISTINCT ON ("challenge"."acct_id")'
            '"challenge"."chal_id",'
            '"challenge"."acct_id",'
            '"challenge"."timestamp",'
            '"account"."name" AS "acct_name",'
            '"challenge_state"."runtime",'
            '"challenge_state"."memory" '
            'FROM "challenge" '
            'INNER JOIN "account" '
            'ON "challenge"."acct_id"="account"."acct_id" '
            'LEFT JOIN "challenge_state" '
            'ON "challenge"."chal_id"="challenge_state"."chal_id" '
            'WHERE "account"."acct_type">=%s AND "challenge"."pro_id"=%s '
            'AND "challenge_state"."state"=1 '
            'ORDER BY "challenge"."acct_id" ASC, '
            '"challenge_state"."runtime" ASC, "challenge_state"."memory" ASC,'
            '"challenge"."timestamp" ASC, "challenge"."acct_id" ASC'
            ') temp '
            'ORDER BY "runtime" ASC, "memory" ASC,'
            '"timestamp" ASC, "acct_id" ASC;'),
            (self.acct['acct_type'],pro_id,))
        chal_list = list()
        for chal_id,acct_id,timestamp,acct_name,runtime,memory in cur:
            runtime = int(runtime)
            memory = int(memory)
            chal_list.append({
                'chal_id':chal_id,
                'acct_id':acct_id,
                'acct_name':acct_name,
                'runtime':runtime,
                'memory':memory,
                'timestamp':timestamp,
            })
        self.render('rank',pro_id = pro_id,chal_list = chal_list)
        return
    @reqenv
    def post(self):
        return