diff options
| author | jwansek <eddie.atten.ea29@gmail.com> | 2018-12-17 16:50:20 +0000 |
|---|---|---|
| committer | jwansek <eddie.atten.ea29@gmail.com> | 2018-12-17 16:50:20 +0000 |
| commit | 20dce4c47a4d0d71571ddf0e51a7d09a34ef60b8 (patch) | |
| tree | 4142d029f9eea5f47b6e2d095416ec34466b6e76 /database.py | |
| parent | aae7b7bbe9433624507ed926265c70440be9a9ac (diff) | |
| parent | 79891e47e1c789f0136a6d7e721ccd23bd33b0b6 (diff) | |
| download | SmallYTChannelBot-20dce4c47a4d0d71571ddf0e51a7d09a34ef60b8.tar.gz SmallYTChannelBot-20dce4c47a4d0d71571ddf0e51a7d09a34ef60b8.zip | |
updated database
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() |