#!/usr/bin/python3
from json import dumps
from datetime import datetime
import os
from bottle import app as bottleapp
from bottle import route, run, static_file, template
from pymongo import MongoClient
import sprout

os.chdir(os.path.dirname(os.path.abspath(__file__)))

mongo = MongoClient('localhost', 27017)
col = mongo['plant-rank']['users']

def readable(obj):
    obj['class_name'] = {0: '陌生人',
                         1: '算法班',
                         2: 'C語法',
                         3: 'Py語法'}[obj['category']]
    obj['class'] = {0: '',
                    1: 'label-primary',
                    2: 'label-warning',
                    3: 'label-success'}[obj['category']]
    obj['algopoints'] = len(obj['algoprobs'])
    obj['points'] = len(obj['problems'])
    obj['problems'] = ', '.join(map(str, sorted(obj['problems'])))
    obj['updated_at'] = datetime.fromtimestamp(
            obj['updated_at']).strftime('%Y/%m/%d %H:%M:%S')
    return obj

@route('/assets/<filename:path>')
def assets(filename):
    return static_file(filename, root='./assets/')

@route('/')
def index():
    board = list(map(readable, col.find({})))
    countboard = sorted(board, key=lambda x: (x['points'], x['rate']), reverse=True)
    algocountboard = sorted(board, key=lambda x: (x['algopoints'], x['points']),
                            reverse=True)
    algoboard = sorted(board, key=lambda x: (x['rate'] if x['category'] == 1 else 0,
                                             x['points']),
                       reverse=True)
    return template('index.html', locals())

@route('/users/<uid>')
def user(uid):
    board = map(readable, col.find({'uid': int(uid)}).limit(1))
    return template('user.html', locals())

@route('/users/<uid>', method="POST")
def refresh(uid):
    try:
        sprout.refresh(int(uid))
    except:
        return dumps({'status': False})
    else:
        return dumps({'status': True})

run(app=bottleapp(), port=8787, host="0.0.0.0", debug=False, server='meinheld')

#!/usr/bin/python3
from json import dumps
from datetime import datetime
import os
from bottle import app as bottleapp
from bottle import route, run, static_file, template
from pymongo import MongoClient
import sprout

os.chdir(os.path.dirname(os.path.abspath(__file__)))

mongo = MongoClient('localhost', 27017)
col = mongo['plant-rank']['users']

def readable(obj):
    obj['class_name'] = {0: '陌生人',
                         1: '算法班',
                         2: 'C語法',
                         3: 'Py語法'}[obj['category']]
    obj['class'] = {0: '',
                    1: 'label-primary',
                    2: 'label-warning',
                    3: 'label-success'}[obj['category']]
    obj['algopoints'] = len(obj['algoprobs'])
    obj['points'] = len(obj['problems'])
    obj['problems'] = ', '.join(map(str, sorted(obj['problems'])))
    obj['updated_at'] = (datetime.fromtimestamp(obj['updated_at'])
                         .strftime('%Y/%m/%d %H:%M'))
    return obj

@route('/assets/<filename:path>')
def assets(filename):
    return static_file(filename, root='./assets/')

@route('/')
def index():
    board = list(map(readable, col.find({})))
    countboard = sorted(board, key=lambda x: (x['points'], x['rate']), reverse=True)
    algocountboard = sorted(board, key=lambda x: (x['algopoints'], x['points']),
                            reverse=True)
    algoboard = sorted(board, key=lambda x: (x['rate'] if x['category'] == 1 else 0,
                                             x['points']),
                       reverse=True)
    return template('index.html', locals())

@route('/users/<uid>')
def user(uid):
    board = map(readable, col.find({'uid': int(uid)}).limit(1))
    return template('user.html', locals())

@route('/users/<uid>', method="POST")
def refresh(uid):
    try:
        sprout.refresh(int(uid))
    except:
        return dumps({'status': False})
    else:
        return dumps({'status': True})

run(app=bottleapp(), port=8787, host="0.0.0.0", debug=False, server='meinheld')

Remove second from time field on the table