diff options
| author | David Cramer | 2011-03-28 17:34:07 -0700 | 
|---|---|---|
| committer | David Cramer | 2011-03-28 17:34:07 -0700 | 
| commit | 9f0b1dfca0fe800b8ac5c94d83df3a0c782d59ee (patch) | |
| tree | 537b086cd5dda4defecece47f865e3a4e78543f2 | |
| parent | da85fc0a8b5e1855b6b6219076a34cd0df88bcc3 (diff) | |
| download | django-debug-toolbar-9f0b1dfca0fe800b8ac5c94d83df3a0c782d59ee.tar.bz2 | |
Add a note when no SQL queries are logged
| -rw-r--r-- | debug_toolbar/templates/debug_toolbar/panels/sql.html | 130 | 
1 files changed, 67 insertions, 63 deletions
| diff --git a/debug_toolbar/templates/debug_toolbar/panels/sql.html b/debug_toolbar/templates/debug_toolbar/panels/sql.html index 8560da0..bec97a4 100644 --- a/debug_toolbar/templates/debug_toolbar/panels/sql.html +++ b/debug_toolbar/templates/debug_toolbar/panels/sql.html @@ -10,68 +10,72 @@  	</ul>  </div> -<table> -	<thead> -		<tr> -			<th class="color"> </th> -			<th class="query" colspan="2">{% trans 'Query' %}</th> -			<th class="timeline">{% trans 'Timeline' %}</th> -			<th class="time">{% trans 'Time (ms)' %}</th> -			<th class="actions">{% trans "Action" %}</th> -		</tr> -	</thead> -	<tbody> -		{% for query in queries %} -			<tr class="djDebugHoverable {% cycle 'djDebugOdd' 'djDebugEven' %}{% if query.is_slow %} djDebugRowWarning{% endif %}" id="sqlMain_{{ forloop.counter }}"> -				<td class="color"><span style="background-color: rgb({{ query.rgb_color|join:", " }});"> </span></td> -				<td class="toggle"> -					<a class="djSQLToggleDetails" data-queryid="{{ forloop.counter }}" href="javascript:void(0)">+</a> -				</td> -				<td class="query"> -					<div class="djDebugSqlWrap"> -						<div class="djDebugSql">{{ query.sql|safe }}</div> -					</div> -				</td> -				<td class="timeline"> -					<div class="djDebugTimeline"><div class="djDebugLineChart{% if query.is_slow %} djDebugLineChartWarning{% endif %}" style="left:{{ query.start_offset }}%;"><strong style="width:{{ query.width_ratio }}%;">{{ query.width_ratio }}%</strong></div></div> -				</td> -				<td class="time"> -					{{ query.duration|floatformat:"2" }} -				</td> -				<td class="actions"> -				{% if query.params %} -					{% if query.is_select %} -						<a class="remoteCall" href="/__debug__/sql_select/?sql={{ query.raw_sql|urlencode }}&params={{ query.params|urlencode }}&duration={{ query.duration|floatformat:"2"|urlencode }}&hash={{ query.hash }}">Sel</a> -						<a class="remoteCall" href="/__debug__/sql_explain/?sql={{ query.raw_sql|urlencode }}&params={{ query.params|urlencode }}&duration={{ query.duration|floatformat:"2"|urlencode }}&hash={{ query.hash }}">Expl</a> -						{% if is_mysql %} -							<a class="remoteCall" href="/__debug__/sql_profile/?sql={{ query.raw_sql|urlencode }}&params={{ query.params|urlencode }}&duration={{ query.duration|floatformat:"2"|urlencode }}&hash={{ query.hash }}">Prof</a> -						{% endif %} -					{% endif %} -				{% endif %} -				</td> +{% if queries %} +	<table> +		<thead> +			<tr> +				<th class="color"> </th> +				<th class="query" colspan="2">{% trans 'Query' %}</th> +				<th class="timeline">{% trans 'Timeline' %}</th> +				<th class="time">{% trans 'Time (ms)' %}</th> +				<th class="actions">{% trans "Action" %}</th>  			</tr> -			<tr class="djHiddenByDefault djDebugHoverable {% cycle 'djDebugOdd' 'djDebugEven' %}{% if query.is_slow %} djDebugRowWarning{% endif %}" id="sqlDetails_{{ forloop.counter }}"> -				<td colspan="2"></td> -				<td colspan="4"> -					<div class="djSQLDetailsDiv"> -						<p><strong>Connection:</strong> {{ query.alias }}</p> -						{% if query.stacktrace %} -							<pre>{{ query.stacktrace }}</pre> -						{% endif %} -						{% if query.template_info %} -							<table> -								{% for line in query.template_info.context %} -								<tr> -									<td>{{ line.num }}</td> -									<td><code style="font-family: monospace;{% if line.highlight %}background-color: lightgrey{% endif %}">{{ line.content }}</code></td> -								</tr> -								{% endfor %} -							</table> -							<p><strong>{{ query.template_info.name|default:"(unknown)" }}</strong></p> +		</thead> +		<tbody> +			{% for query in queries %} +				<tr class="djDebugHoverable {% cycle 'djDebugOdd' 'djDebugEven' %}{% if query.is_slow %} djDebugRowWarning{% endif %}" id="sqlMain_{{ forloop.counter }}"> +					<td class="color"><span style="background-color: rgb({{ query.rgb_color|join:", " }});"> </span></td> +					<td class="toggle"> +						<a class="djSQLToggleDetails" data-queryid="{{ forloop.counter }}" href="javascript:void(0)">+</a> +					</td> +					<td class="query"> +						<div class="djDebugSqlWrap"> +							<div class="djDebugSql">{{ query.sql|safe }}</div> +						</div> +					</td> +					<td class="timeline"> +						<div class="djDebugTimeline"><div class="djDebugLineChart{% if query.is_slow %} djDebugLineChartWarning{% endif %}" style="left:{{ query.start_offset }}%;"><strong style="width:{{ query.width_ratio }}%;">{{ query.width_ratio }}%</strong></div></div> +					</td> +					<td class="time"> +						{{ query.duration|floatformat:"2" }} +					</td> +					<td class="actions"> +					{% if query.params %} +						{% if query.is_select %} +							<a class="remoteCall" href="/__debug__/sql_select/?sql={{ query.raw_sql|urlencode }}&params={{ query.params|urlencode }}&duration={{ query.duration|floatformat:"2"|urlencode }}&hash={{ query.hash }}">Sel</a> +							<a class="remoteCall" href="/__debug__/sql_explain/?sql={{ query.raw_sql|urlencode }}&params={{ query.params|urlencode }}&duration={{ query.duration|floatformat:"2"|urlencode }}&hash={{ query.hash }}">Expl</a> +							{% if is_mysql %} +								<a class="remoteCall" href="/__debug__/sql_profile/?sql={{ query.raw_sql|urlencode }}&params={{ query.params|urlencode }}&duration={{ query.duration|floatformat:"2"|urlencode }}&hash={{ query.hash }}">Prof</a> +							{% endif %}  						{% endif %} -					</div> -				</td> -			</tr> -		{% endfor %} -	</tbody> -</table> +					{% endif %} +					</td> +				</tr> +				<tr class="djHiddenByDefault djDebugHoverable {% cycle 'djDebugOdd' 'djDebugEven' %}{% if query.is_slow %} djDebugRowWarning{% endif %}" id="sqlDetails_{{ forloop.counter }}"> +					<td colspan="2"></td> +					<td colspan="4"> +						<div class="djSQLDetailsDiv"> +							<p><strong>Connection:</strong> {{ query.alias }}</p> +							{% if query.stacktrace %} +								<pre>{{ query.stacktrace }}</pre> +							{% endif %} +							{% if query.template_info %} +								<table> +									{% for line in query.template_info.context %} +									<tr> +										<td>{{ line.num }}</td> +										<td><code style="font-family: monospace;{% if line.highlight %}background-color: lightgrey{% endif %}">{{ line.content }}</code></td> +									</tr> +									{% endfor %} +								</table> +								<p><strong>{{ query.template_info.name|default:"(unknown)" }}</strong></p> +							{% endif %} +						</div> +					</td> +				</tr> +			{% endfor %} +		</tbody> +	</table> +{% else %} +	<p>No SQL queries were recorded during this request.</p> +{% endif %}
\ No newline at end of file | 
