From fcf50be2e34e0eb82fbd301e119f8873d2735cf9 Mon Sep 17 00:00:00 2001
From: jwansek <eddie.atten@yahoo.co.uk>
Date: Mon, 17 Dec 2018 16:37:46 +0000
Subject: added statistics

---
 database.py | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'database.py')

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()
-- 
cgit v1.2.3