From 77a0b69d9a0dd755a0a59a4c1dc3f3d045327e89 Mon Sep 17 00:00:00 2001 From: Pinapelz Date: Wed, 22 Nov 2023 21:58:45 -0800 Subject: feat: re-implement individual statistic pages on next --- backend/sql/sql_handler.py | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) (limited to 'backend/sql') 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() -- cgit v1.2.3