aboutsummaryrefslogtreecommitdiffstats
path: root/debug_toolbar/panels/sql.py
diff options
context:
space:
mode:
authorDavid Cramer2011-03-24 16:50:09 -0700
committerDavid Cramer2011-03-24 16:50:09 -0700
commit4bb644ad825ed9009176c7e78967b6ba07d7a681 (patch)
tree4059fc3b3da5a75473110cd72fa2d6fd187b0a68 /debug_toolbar/panels/sql.py
parent335ac292949330bd6e9c72c205d027985c873e72 (diff)
downloaddjango-debug-toolbar-4bb644ad825ed9009176c7e78967b6ba07d7a681.tar.bz2
Only show connections which executed queries. Show number of used connections in title
Diffstat (limited to 'debug_toolbar/panels/sql.py')
-rw-r--r--debug_toolbar/panels/sql.py20
1 files changed, 13 insertions, 7 deletions
diff --git a/debug_toolbar/panels/sql.py b/debug_toolbar/panels/sql.py
index 8fd07d3..15c6ff3 100644
--- a/debug_toolbar/panels/sql.py
+++ b/debug_toolbar/panels/sql.py
@@ -22,7 +22,7 @@ from django.utils import simplejson
from django.utils.encoding import force_unicode
from django.utils.hashcompat import sha_constructor
from django.utils.safestring import mark_safe
-from django.utils.translation import ugettext_lazy as _
+from django.utils.translation import ugettext_lazy as _, ungettext_lazy as __
from debug_toolbar.panels import DebugPanel
from debug_toolbar.utils import sqlparse
@@ -161,11 +161,13 @@ class SQLDebugPanel(DebugPanel):
self._databases = {}
for alias in connections:
db_queries = connections[alias].queries[self._offset[alias]:]
- self._databases[alias] = {
- 'time_spent': sum(q['duration'] for q in db_queries),
- 'queries': len(db_queries),
- }
- self._queries.extend([(alias, q) for q in db_queries])
+ num_queries = len(db_queries)
+ if num_queries:
+ self._databases[alias] = {
+ 'time_spent': sum(q['duration'] for q in db_queries),
+ 'queries': num_queries,
+ }
+ self._queries.extend([(alias, q) for q in db_queries])
self._queries.sort(key=lambda x: x[1]['start_time'])
self._sql_time = sum([d['time_spent'] for d in self._databases.itervalues()])
@@ -178,7 +180,11 @@ class SQLDebugPanel(DebugPanel):
)
def title(self):
- return _('SQL Queries')
+ count = len(self._databases)
+
+ return __('SQL Queries from %(count)d connection', 'SQL Queries from %(count)d connections', count) % dict(
+ count=count,
+ )
def url(self):
return ''