leetcode-interview-intelligence/stats.py at main · TrailBlazer-1081729/leetcode-interview-intelligence · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
from database.db import get_connection
def get_dashboard_stats():
    conn=get_connection()
    cursor=conn.cursor()
    stats={}
    cursor.execute("SELECT COUNT(*) FROM problems")
    stats["total_questions"]=cursor.fetchone()[0]

    cursor.execute("select count(*) from companies")
    stats["total_companies"]=cursor.fetchone()[0]

    cursor.execute("select count(*) from problems where difficulty='EASY'")
    stats["easy"]=cursor.fetchone()[0]

    cursor.execute("select count(*) from problems where difficulty='MEDIUM'")
    stats["medium"] = cursor.fetchone()[0]

    cursor.execute("select count(*) from problems where difficulty='HARD'")
    stats["hard"] = cursor.fetchone()[0]

    conn.close()
    return stats

def get_all_companies():
    conn=get_connection()
    cursor=conn.cursor()
    cursor.execute("select name from companies order by name")
    companies=[row[0] for row in cursor.fetchall()]
    conn.close()
    return companies
def get_all_topics():
    conn=get_connection()
    cursor=conn.cursor()
    cursor.execute("select name from topics order by name")
    topics=[row[0] for row in cursor.fetchall()]
    conn.close()
    return topics