diff options
Diffstat (limited to 'backend/sql')
| -rw-r--r-- | backend/sql/sql_handler.py | 11 |
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() |
