From c69294efd979bc117218f247b0ce058893603018 Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Fri, 17 Nov 2023 11:59:29 +0300
Subject: Log out query errors

Log out failures in querying the database as errors to help with
catching issues with and debugging of queries.
---
 wqflask/wqflask/database.py | 4 ++++
 1 file changed, 4 insertions(+)

diff --git a/wqflask/wqflask/database.py b/wqflask/wqflask/database.py
index 0c1fddf1..331ad380 100644
--- a/wqflask/wqflask/database.py
+++ b/wqflask/wqflask/database.py
@@ -1,6 +1,8 @@
 # Module to initialize sqlalchemy with flask
 import os
 import sys
+import logging
+import traceback
 from typing import Tuple, Protocol, Any, Iterator
 from urllib.parse import urlparse
 import importlib
@@ -42,6 +44,8 @@ def database_connection(sql_uri: str) -> Iterator[Connection]:
         yield connection
         connection.commit()
     except Exception as _exc:
+        logging.error("===== Query Error =====\r\n%s\r\n===== END: Query Error",
+                      traceback.format_exc())
         connection.rollback()
         raise _exc
     finally:
-- 
cgit 1.4.1