I recently installed django-debug-toolbar. The toolbar works and I can see the tabs on the side. However, nothing shows up in the SQL tab even when I have obviously executed an SQL query (such as in the admin):
My settings are as follows:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2'
'NAME': 'mydatabase'
....
}
}
# Backwards compatability with apps
DATABASE_ENGINE = DATABASES['default']['ENGINE'].split('.')[-1]
DATABASE_NAME = DATABASES['default']['NAME']
MIDDLEWARE_CLASSES = (
'django.middleware.common.CommonMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'debug_toolbar.middleware.DebugToolbarMiddleware',
)
INSTALLED_APPS = (
...
'debug_toolbar',
...
)
# Settings for the django-debug-toolbar
DEBUG_TOOLBAR_PANELS = (
'debug_toolbar.panels.version.VersionDebugPanel',
'debug_toolbar.panels.cache.CacheDebugPanel',
'debug_toolbar.panels.timer.TimerDebugPanel',
'debug_toolbar.panels.settings_vars.SettingsVarsDebugPanel',
'debug_toolbar.panels.headers.HeaderDebugPanel',
'debug_toolbar.panels.request_vars.RequestVarsDebugPanel',
'debug_toolbar.panels.template.TemplateDebugPanel',
'debug_toolbar.panels.sql.SQLDebugPanel',
'debug_toolbar.panels.signals.SignalDebugPanel',
# 'debug_toolbar.panels.logger.LoggingPanel',
)
def custom_show_toolbar(request):
return request.user.is_staff
DEBUG_TOOLBAR_CONFIG = {
'INTERCEPT_REDIRECTS':False,
'SHOW_TOOLBAR_CALLBACK':custom_show_toolbar,
'SHOW_TEMPLATE_CONTEXT':True,
'HIDE_DJANGO_SQL':False,
}
I'm using Django 1.3 with Toolbar version 0.8.5. Any help with this problem would be awesome...
Edit: Based on the answer, I have decided to post how I am handling my view functions:
def func1(query, var1):
query = query.filter(var__icontains=var1)
return query
def func2(query, var2):
query = query.filter(var__icontains=var2)
return query
def parse(**kwargs):
# Based on some logic call func1 and func2
return query
def view(request, template="display.html"):
# Do some request processing
query = parse(request.GET.items())
return render(request, template, { 'items':list(query) })