aboutsummaryrefslogtreecommitdiffstats
path: root/debug_toolbar/templates
diff options
context:
space:
mode:
authorRob Hudson2008-10-06 13:07:56 -0700
committerRob Hudson2008-10-06 13:07:56 -0700
commite9271bf69ab50cb24e38ac2205847c8d32b83ca8 (patch)
tree621d0ae253fc1990c65224fafac2af1c9a974223 /debug_toolbar/templates
parent49a177a41f790a494a933963fd7b2f5216f98a85 (diff)
downloaddjango-debug-toolbar-e9271bf69ab50cb24e38ac2205847c8d32b83ca8.tar.bz2
Just like EXPLAIN, adding the output of straight SELECT statements so you can
view the raw SQL output.
Diffstat (limited to 'debug_toolbar/templates')
-rw-r--r--debug_toolbar/templates/debug_toolbar/panels/sql.html1
-rw-r--r--debug_toolbar/templates/debug_toolbar/panels/sql_select.html30
2 files changed, 31 insertions, 0 deletions
diff --git a/debug_toolbar/templates/debug_toolbar/panels/sql.html b/debug_toolbar/templates/debug_toolbar/panels/sql.html
index 6a2d077..2abb68f 100644
--- a/debug_toolbar/templates/debug_toolbar/panels/sql.html
+++ b/debug_toolbar/templates/debug_toolbar/panels/sql.html
@@ -13,6 +13,7 @@
<td>{{ query.time|floatformat:"4" }}</td>
<td>
{% if query.params %}
+ <a class="remoteCall" href="/__debug__/sql_select/?sql={{ query.raw_sql|urlencode }}&params={{ query.params|urlencode }}&time={{ query.time|floatformat:"4"|urlencode }}&hash={{ query.hash }}">SELECT</a>
<a class="remoteCall" href="/__debug__/sql_explain/?sql={{ query.raw_sql|urlencode }}&params={{ query.params|urlencode }}&time={{ query.time|floatformat:"4"|urlencode }}&hash={{ query.hash }}">EXPLAIN</a>
{% endif %}
</td>
diff --git a/debug_toolbar/templates/debug_toolbar/panels/sql_select.html b/debug_toolbar/templates/debug_toolbar/panels/sql_select.html
new file mode 100644
index 0000000..73109ef
--- /dev/null
+++ b/debug_toolbar/templates/debug_toolbar/panels/sql_select.html
@@ -0,0 +1,30 @@
+<a class="back" href="">&laquo;&nbsp;Back</a>
+<h3>SQL Selected</h3>
+<dl>
+ <dt>Executed SQL</dt>
+ <dd><pre>{{ sql|safe }}</pre></dd>
+ <dt>Time</dt>
+ <dd>{{ time }} ms</dd>
+</dl>
+{% if result %}
+<table>
+ <thead>
+ <tr>
+ {% for h in headers %}
+ <th>{{ h|upper }}</th>
+ {% endfor %}
+ </tr>
+ </thead>
+ <tbody>
+ {% for row in result %}
+ <tr class="{% cycle 'odd' 'even' %}">
+ {% for column in row %}
+ <td>{{ column|escape }}</td>
+ {% endfor %}
+ </tr>
+ {% endfor %}
+ </tbody>
+</table>
+{% else %}
+ <p>Empty set</p>
+{% endif %}