Add SQL_DEBUG option that shows SQL queries being executed

[Yuri Baburov <burchik@…>]

This should be self-explanatory

Index: D:/web/projects/django-newforms/django/db/backends/util.py
===================================================================
--- D:/web/projects/django-newforms/django/db/backends/util.py	(revision 5753)
+++ D:/web/projects/django-newforms/django/db/backends/util.py	(working copy)
@@ -19,6 +19,15 @@
             return self.cursor.execute(sql, params)
         finally:
             stop = time()
+            from django.conf import settings
+            # If params was a list, convert it to a tuple, because string
+            # formatting with '%' only works with tuples or dicts.
+            if not isinstance(params, (tuple, dict)):
+                params = tuple(params)
+            if getattr(settings, 'SQL_DEBUG', False):
+                if not isinstance(params, (tuple, dict)):
+                    params = tuple(params)
+                print '>', sql % params
             self.db.queries.append({
                 'sql': smart_unicode(sql) % convert_args(params),
                 'time': "%.3f" % (stop - start),

[buriy <burchik@…>]

patch for SQL_DEBUG

[Adrian Holovaty]

Instead of yet another setting, I'd like a cleaner solution to the problem of SQL queries being hard to get at -- perhaps a signal. We've discussed this recently on the django-developers mailing list.