feat: re-implement individual statistic pages on next

1 files changed, 10 insertions, 1 deletions

diff --git a/backend/sql/sql_handler.py b/backend/sql/sql_handler.py
index 9d1c10d..82f071d 100644
--- a/backend/sql/sql_handler.py
+++ b/backend/sql/sql_handler.py
@@ -140,8 +140,17 @@ class SQLHandler:
             print("Error updating row")
             print(err)
     
-    def execute_query(self, query: str):
+    def execute_query(self, query: str, data: tuple = None):
         cursor = self.connection.cursor(buffered=True)
+        if data:
+            try:
+                cursor.execute(query, data)
+                result = cursor.fetchall()
+                return result
+            except Error as err:
+                print("Error executing query")
+                print(err)
+                return None
         try:
             cursor.execute(query)
             result = cursor.fetchall()