templates/skin/common.database-debug.tpl

   1 {**************************************************************************}
   2 {*                                                                        *}
   3 {*  Copyright (C) 2003-2007 Polytechnique.org                             *}
   4 {*  http://opensource.polytechnique.org/                                  *}
   5 {*                                                                        *}
   6 {*  This program is free software; you can redistribute it and/or modify  *}
   7 {*  it under the terms of the GNU General Public License as published by  *}
   8 {*  the Free Software Foundation; either version 2 of the License, or     *}
   9 {*  (at your option) any later version.                                   *}
  10 {*                                                                        *}
  11 {*  This program is distributed in the hope that it will be useful,       *}
  12 {*  but WITHOUT ANY WARRANTY; without even the implied warranty of        *}
  13 {*  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the         *}
  14 {*  GNU General Public License for more details.                          *}
  15 {*                                                                        *}
  16 {*  You should have received a copy of the GNU General Public License     *}
  17 {*  along with this program; if not, write to the Free Software           *}
  18 {*  Foundation, Inc.,                                                     *}
  19 {*  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA               *}
  20 {*                                                                        *}
  21 {**************************************************************************}
  22
  23
  24 {foreach item=query from=$trace_data}
  25 {if $query.explain}
  26 {assign var=cols value=$query.explain[0]|@count}
  27 {else}
  28 {assign var=cols value=1}
  29 {/if}
  30 <table class="bicol" style="width: 75%; font-size: smaller; margin-left:2px; margin-top: 3px;">
  31   <tr class="impair">
  32     <td colspan="{$cols}">
  33       <strong>QUERY:</strong>
  34       <pre style="padding: 0; margin: 0;">{$query.query}</pre>
  35       <br/>
  36     </td>
  37   </tr>
  38   {if $query.error}
  39   <tr>
  40     <td colspan="{$cols}">
  41       <strong style="color: #f00">ERROR:</strong><br />
  42       {$query.error|nl2br}
  43     </td>
  44   </tr>
  45   {else}
  46   <tr>
  47     <td colspan="{$cols}">
  48       <strong>INFO:</strong><br />
  49       {$query.rows} enregistrement{if $query.rows > 1}s{/if} en {$query.exectime}ms
  50     </td>
  51   </tr>
  52   {/if}
  53 {if $query.explain}
  54   <tr>
  55     {foreach key=key item=item from=$query.explain[0]}
  56     <th style="font-size: smaller">{$key}</th>
  57     {/foreach}
  58   </tr>
  59   {foreach item=explain_row from=$query.explain}
  60   <tr class="impair">
  61     {foreach item=item from=$explain_row}
  62     <td class="center" style="font-size: smaller">{$item}</td>
  63     {/foreach}
  64   </tr>
  65   {/foreach}
  66 {/if}
  67 </table>
  68 {/foreach}
  69
  70 {* vim:set et sw=2 sts=2 sws=2 enc=utf-8: *}