stats.py 文件源码

def getstats(db):
    stats = {}
    with db.cursor(cursor_factory=DictCursor) as cur:
        cur.execute("SELECT * FROM dailystats WHERE date = %s;", (datetime.utcnow().date(),))
        stats['daily'] = cur.fetchone()
        cur.execute("SELECT * FROM stats;")
        totalstats = {}
        for i in cur.fetchall():
            totalstats[i[0]] = i[1]
        stats['total'] = totalstats
        print()
        return stats