PSQL-Query/lib/PSQL/Query/tt/xhtml.tt

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
   3 "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
   4 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
   5         <head>
   6                 <meta http-equiv="Content-Type" content="application/xhtml+xml; charset=UTF-8" />
   7                 <title> Pgsql-plus Query </title>
   8                 <style type="text/css">
   9                         /* original notice: (this version is modified)
  10                                 Plain old table styles written by Chris Heilmann http://wait-till-i.com
  11                         */
  12                         table,td,th{
  13                                 border:1px solid #000;
  14                                 border-collapse:collapse;
  15                                 margin:0;
  16                                 padding:0;
  17                         }
  18                         td,th{
  19                                 padding:.2em .5em;
  20                                 vertical-align:top;
  21                                 font-weight:normal;
  22                         }
  23                         thead th{
  24                                 text-transform:uppercase;
  25                                 background:#666;
  26                                 color:#fff;
  27                         }
  28                         tbody td{
  29                                 background:#ccc;
  30                         }
  31                         tbody th{
  32                                 background:#999;
  33                         }
  34                         tbody tr.odd td{
  35                                 background:#eee;
  36                         }
  37                         tbody tr.odd th{
  38                                 background:#ccc;
  39                         }
  40                         caption{
  41                                 text-align:center;
  42                                 font-size:140%;
  43                                 text-transform:uppercase;
  44                                 letter-spacing:-1px;
  45                         }
  46                         table th a:link{
  47                                 color:#030;
  48                         }
  49                         table th a:visited{
  50                                 color:#003;
  51                         }
  52                         table td a:link{
  53                                 color:#369;
  54                         }
  55                         table td a:visited{
  56                                 color:#000;
  57                         }
  58                         table a:hover{
  59                                 text-decoration:none;
  60                         }
  61                         table a:active{
  62                                 color:#000;
  63                         }
  64                 </style>
  65         </head>
  66         <body>
  67                 <h1> PSQL - Query Planner [ xhtml v1.1 ] </h1>
  68                 <table>
  69                         <caption> The following is a query plan outputed for %THIS QUERY% on %DATE, at %TIME. </caption>
  70                         <colgroup>
  71                                 <col span="2" />
  72                                 <col span="4" />
  73                                 <col span="4" />
  74                                 <col span="2" />
  75                         </colgroup>
  76                         <thead>
  77                                 <tr>
  78                                         <th colspan="2" />
  79                                         <th scope="colgroup" colspan="4"> Cost Estimate </th>
  80                                         <th scope="colgroup" colspan="4"> Hi-Res Time </th>
  81                                         <th scope="colgroup" colspan="2"> Verbose </th>
  82                                 </tr>
  83                                 <tr>
  84                                         <th scope="col"> Name </th>
  85                                         <th scope="col" abbr="Dom Lvl"> Document Object Model Level </th>
  86                                         <th scope="col"> Startup </th>
  87                                         <th scope="col"> Total </th>
  88                                         <th scope="col"> Rows </th>
  89                                         <th scope="col"> Width </th>
  90                                         <th scope="col"> Startup </th>
  91                                         <th scope="col"> Total </th>
  92                                         <th scope="col"> Rows </th>
  93                                         <th scope="col"> Loops </th>
  94                                         <th scope="col" abbr="Add. Info"> Additional Info </th>
  95                                 </tr>
  96                         </thead>
  97                         <tbody>
  98                                 [% WHILE ( row = query.shift_row ) %]
  99                                 <tr>
 100                                         <td class="name" scope="row"> [% row.name | html_entity %] </td>
 101                                         <td class="dom"> [% row.dom_level | html_entity %] </td>
 102
 103                                         <td class="cost startup"> [% row.cost.startup | html_entity %] </td>
 104                                         <td class="cost total"> [% row.cost.total | html_entity %] </td>
 105                                         <td class="cost rows"> [% row.cost.rows | html_entity %] </td>
 106                                         <td class="cost width"> [% row.cost.width | html_entity %] </td>
 107
 108                                         <td class="time startup"> [% row.time.startup | html_entity %] </td>
 109                                         <td class="time total"> [% row.time.total | html_entity %] </td>
 110                                         <td class="time rows"> [% row.time.rows | html_entity %] </td>
 111                                         <td class="time loops"> [% row.time.loops | html_entity %] </td>
 112
 113                                         [% IF row.has_info %]
 114                                         <td class="info">
 115                                                 <ol>
 116                                                         [% WHILE ( info = row.shift_info ) %]
 117                                                         <li>
 118                                                                 <span class="short"> [% info.name | html_entity %] </span>
 119                                                                 <span class="long"> [% info.verbose | html_entity %] </span>
 120                                                         </li>
 121                                                         [% END %]
 122                                                 </ol>
 123                                         </td>
 124                                         [% ELSE %]
 125                                         <td class="info" />
 126                                         [% END %]
 127
 128                                 </tr>
 129                                 [% END %]
 130                         </tbody>
 131                 </table>
 132         </body>
 133 </html>