diff options
| author | Rob Hudson | 2008-10-06 13:07:56 -0700 |
|---|---|---|
| committer | Rob Hudson | 2008-10-06 13:07:56 -0700 |
| commit | e9271bf69ab50cb24e38ac2205847c8d32b83ca8 (patch) | |
| tree | 621d0ae253fc1990c65224fafac2af1c9a974223 /debug_toolbar/templates | |
| parent | 49a177a41f790a494a933963fd7b2f5216f98a85 (diff) | |
| download | django-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.html | 1 | ||||
| -rw-r--r-- | debug_toolbar/templates/debug_toolbar/panels/sql_select.html | 30 |
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 }}¶ms={{ 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 }}¶ms={{ 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="">« 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 %} |
