I've modified the template for torque html-export to look nicer.

tom schindl

-- 
b e s t s o l u t i o n . a t                        EDV Systemhaus GmbH
------------------------------------------------------------------------
Thomas Schindl            Project Management   mobile ++43/664/314 59 58
------------------------------------------------------------------------
Anton-Rauch-Str.6a        A-6020 Innsbruck     fax       ++43/512/935834
http://www.bestsolution.at                     phone     ++43/512/935834
Title: $dataModel.name
#set ( $database = $dataModel.database )
#foreach ($tbl in $database.tables) #end
Table Name OM Class Description
$tbl.Name $tbl.JavaName #if ($tbl.Description) $tbl.Description#else  #end
#foreach ($tbl in $database.tables) $generator.parse("doc/html/table.vm",$outFile,"table",$tbl) #end
<a name="$table.Name"/>
<h2>$table.Name</h2>
$!table.Description
<p/>
<table border="1" cellspacing="0">
  <tr>
    <th class="normalFont" bgcolor="#CCCCCC">Name</th>
    <th class="normalFont" bgcolor="#CCCCCC">Type</th>
    <th class="normalFont" bgcolor="#CCCCCC">Size</th>
    <th class="normalFont" bgcolor="#CCCCCC">Default</th>
    <th class="normalFont" bgcolor="#CCCCCC">JavaName</th>
    <th class="normalFont" bgcolor="#CCCCCC">PK</th>
    <th class="normalFont" bgcolor="#CCCCCC">FK</th>
    <th class="normalFont" bgcolor="#CCCCCC">not null</th>
    <th class="normalFont" bgcolor="#CCCCCC">Description</th>
  </tr>
#foreach ($col in $table.Columns)
  <tr>
    <td class="normalFont" id="$table.Name$col.Name">$col.Name</td>
    <td class="normalFont">$col.Type</td>
    <td class="normalFont">#if ($col.printSize()) $col.printSize() &nbsp;#else 
&nbsp;#end</td>
    <td class="normalFont">#if ($col.DefaultValue) $col.DefaultValue#else 
&nbsp;#end</td>
    <td class="normalFont">$col.JavaName</td>
    <td class="normalFont">#if ($col.isPrimaryKey()==true)X#else &nbsp;#end</td>
    <td class="normalFont">#if ($col.isForeignKey()==true)X#else &nbsp;#end</td>
    <td class="normalFont">#if ($col.isNotNull()==true)X#else &nbsp;#end</td>
    <td class="normalFont">#if ($col.Description) $col.Description#else &nbsp;#end</td>
  </tr>
#end
</table>
<script>
#foreach ( $fk in $table.ForeignKeys )
if( document.getElementById  )
{
var col = document.getElementById("$table.Name$fk.LocalColumnNames");
col.style.backgroundColor = "afe295";
col.title="Foreignkey from $fk.ForeignTableName.$fk.ForeignColumnNames";
}
#end
</script>

Attachment: signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil

Reply via email to