Log out query errors

Log out failures in querying the database as errors to help with
catching issues with and debugging of queries.

1 files changed, 4 insertions, 0 deletions

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: