diff options
| author | jwansek <eddie.atten@yahoo.co.uk> | 2018-12-17 16:37:46 +0000 |
|---|---|---|
| committer | jwansek <eddie.atten@yahoo.co.uk> | 2018-12-17 16:37:46 +0000 |
| commit | fcf50be2e34e0eb82fbd301e119f8873d2735cf9 (patch) | |
| tree | d6d2bcb35d0bb6c123698718df47750c23d7d3c7 /database.py | |
| parent | 60ecebe1a08dfc70194259922783ce06cc8894aa (diff) | |
| download | SmallYTChannelBot-fcf50be2e34e0eb82fbd301e119f8873d2735cf9.tar.gz SmallYTChannelBot-fcf50be2e34e0eb82fbd301e119f8873d2735cf9.zip | |
added statistics
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() |