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 %}  | 
