CTFtime scoreboard generator for CTFd

ctftime_scoreboard.py

#!/usr/bin/python3
import json

from CTFd import create_app
from CTFd.models import Users, Challenges


scoreboard = dict()
scoreboard["standings"] = list()

app = create_app()

with app.app_context():
    for u in Users.query.all():
        pos = u.get_place(numeric=True)
        if pos == None:
            continue
        taskStats = {}
        for solve in u.get_solves():
            taskStats[solve.challenge.name] = {
                "points": solve.challenge.value,
                "time": int(solve.date.timestamp()),
            }
        scoreboard["standings"].append(
            {
                "pos": pos,
                "team": u.name,
                "score": u.score,
                "taskStats": taskStats,
                "lastAccept": max([ts["time"] for ts in taskStats.values()]),
            }
        )
    scoreboard["standings"].sort(key=lambda team: team["pos"])
    scoreboard["tasks"] = [c.name for c in Challenges.query.all()]
    print(json.dumps(scoreboard))