diff options
Diffstat (limited to 'database.py')
| -rw-r--r-- | database.py | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/database.py b/database.py index f31a338..0048296 100644 --- a/database.py +++ b/database.py @@ -74,7 +74,6 @@ class Database: self.cursor.execute("SELECT users.user_name, users.lambda, COUNT(users.user_name) FROM lambdas INNER JOIN users ON users.userID = lambdas.userID GROUP BY users.user_name;") return self.cursor.fetchall() - def update_stats(self): query = """INSERT INTO stats (lambdaCount, helpGiven, uniqueUsers, date) VALUES ( (SELECT SUM(lambda) FROM users), @@ -84,3 +83,7 @@ class Database: self.cursor.execute(query) self.connection.commit() + + def get_stats(self): + self.cursor.execute("SELECT * FROM stats;") + return self.cursor.fetchall() |