Provide a means to debug queries that have been run.

It is sometimes necessary, when debugging, to see what query was
actually run, in order to make sense of, and fix failures. This commit
provides a means to see what the actual query that was run look(s/ed)
like.

1 files changed, 9 insertions, 0 deletions

diff --git a/gn_libs/mysqldb.py b/gn_libs/mysqldb.py
index f0bc651..897b0c7 100644
--- a/gn_libs/mysqldb.py
+++ b/gn_libs/mysqldb.py
@@ -1,6 +1,7 @@
 """This exte"""
 import logging
 import contextlib
+from logging import Logger
 from urllib.parse import urlparse
 from typing import Any, Iterator, Protocol, Callable
 
@@ -91,3 +92,11 @@ def database_connection(sql_uri: str, logger: logging.Logger = _logger) -> Itera
     finally:
         connection.commit()
         connection.close()
+
+
+def debug_query(cursor: Cursor, logger: Logger) -> None:
+    """Debug the actual query run with MySQLdb"""
+    for attr in ("_executed", "statement", "_last_executed"):
+        if hasattr(cursor, attr):
+            logger.debug("MySQLdb QUERY: %s", getattr(cursor, attr))
+            break