buildframework/helium/tools/common/templates/log/scan2_text_orm.html.ftl
author wbernard
Fri, 13 Aug 2010 14:59:05 +0300
changeset 628 7c4a911dc066
parent 217 0f5e3a7fb6af
permissions -rw-r--r--
helium_11.0.0-e00f171ca185
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
217
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
     1
<#--
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
     2
============================================================================ 
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
     3
Name        : scan2_text_orm.html.ftl 
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
     4
Part of     : Helium 
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
     5
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
     6
Copyright (c) 2009 Nokia Corporation and/or its subsidiary(-ies).
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
     7
All rights reserved.
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
     8
This component and the accompanying materials are made available
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
     9
under the terms of the License "Eclipse Public License v1.0"
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    10
which accompanies this distribution, and is available
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    11
at the URL "http://www.eclipse.org/legal/epl-v10.html".
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    12
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    13
Initial Contributors:
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    14
Nokia Corporation - initial contribution.
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    15
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    16
Contributors:
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    17
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    18
Description:
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    19
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    20
============================================================================
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    21
    -->
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    22
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    23
<#macro print_component_summary component href_c_id >
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    24
<#assign href_id = 0>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    25
<#assign component_time_list = table_info['jpasingle']['select t.componentTime from ComponentTime t where  t.componentId =${component.id}']>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    26
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    27
<#if component_time_list[0]?? >
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    28
    <#assign time = component_time_list[0]?number>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    29
<#else>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    30
    <#assign time = 0>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    31
</#if>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    32
<tr>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    33
<#assign hours = (time /(60 * 60))?floor>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    34
<#assign minutes_secs = (time % (60 * 60))?floor>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    35
<#assign minutes = (minutes_secs / 60)?floor>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    36
<#assign seconds = (minutes_secs % 60)?floor>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    37
    <td>${component.component}</td>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    38
<#--write each of the component tables information -->
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    39
<td align="center">${hours?string("00")}:${minutes?string("00")}:${seconds?string("00")}</td>
628
7c4a911dc066 helium_11.0.0-e00f171ca185
wbernard
parents: 217
diff changeset
    40
<#list color_list?keys as severity>
7c4a911dc066 helium_11.0.0-e00f171ca185
wbernard
parents: 217
diff changeset
    41
    <#assign count =  table_info['jpasingle']['select count(m.id) from MetadataEntry as m JOIN  m.severity as p JOIN m.component as c where p.severity=\'${severity?upper_case}\' and c.id=${component.id}'][0] >
217
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    42
    <#if count &gt; 0>
628
7c4a911dc066 helium_11.0.0-e00f171ca185
wbernard
parents: 217
diff changeset
    43
        <#assign color = color_list['${severity}']>
7c4a911dc066 helium_11.0.0-e00f171ca185
wbernard
parents: 217
diff changeset
    44
        <td align="center" bgcolor="${color}"><a href="#section${severity}${href_c_id}">${count}</a></td>
217
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    45
    <#else>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    46
        <td align="center">${count}</td>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    47
    </#if>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    48
    <#assign href_id = href_id + 1>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    49
</#list>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    50
</tr>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    51
</#macro>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    52
628
7c4a911dc066 helium_11.0.0-e00f171ca185
wbernard
parents: 217
diff changeset
    53
<#macro print_list_text severity component href_id>
7c4a911dc066 helium_11.0.0-e00f171ca185
wbernard
parents: 217
diff changeset
    54
<#assign count =  table_info['jpasingle']['select count(m.id) from MetadataEntry as m JOIN m.severity as p JOIN m.component as c where p.severity=\'${severity?upper_case}\' and c.id=${component.id}'][0] >
217
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    55
<#if count?? && count?number &gt; 0>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    56
<#if "${component.component}" != "general">
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    57
        <h3><a name="section${href_id}">${component.component}(${count})</a></h3>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    58
    <#else>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    59
        <h3><a name="section${href_id}">Uncategorized(${count})</a></h3>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    60
    </#if>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    61
</#if>
628
7c4a911dc066 helium_11.0.0-e00f171ca185
wbernard
parents: 217
diff changeset
    62
<#list table_info['native:com.nokia.helium.jpa.entity.metadata.MetadataEntry']['select * from metadataentry INNER JOIN component ON component.component_id=metadataentry.component_id INNER JOIN severity ON severity.severity_id=metadataentry.severity_id where component.component_id=${component.id} and severity.severity=\'${severity?upper_case}\''] as entry >
217
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    63
${logfile}:${entry.lineNumber}>${entry.text}<br />
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    64
</#list>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    65
</#macro>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    66
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    67
<#macro add_severity_count severity, color, count>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    68
<#assign additional_count = count>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    69
<#if severity == 'error'>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    70
    <#assign additional_count = count + 1>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    71
</#if>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    72
    <#if additional_count &gt; 0>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    73
        <#if severity == 'error'>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    74
<td width="12%%" align="center" bgcolor="${color}">${additional_count}</td>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    75
        <#else>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    76
<td align="center" bgcolor="${color}">${count}</td>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    77
        </#if>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    78
    <#else>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    79
    <td align="center">${count}</td>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    80
    </#if>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    81
</#macro>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    82
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    83
<#-- end of macros code starts here -->
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    84
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    85
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    86
<#if (doc)??>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    87
    <#assign logfile = "${doc.sbsinfo.logfile.@name}"?replace("\\","/") >
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    88
    <#assign time = "${doc.sbsinfo.duration.@time}" >
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    89
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    90
    <#assign table_info = pp.loadData('com.nokia.helium.metadata.ORMFMPPLoader',
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    91
        "${dbPath}") >
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    92
<#-- overall summary -->
628
7c4a911dc066 helium_11.0.0-e00f171ca185
wbernard
parents: 217
diff changeset
    93
<#assign logfile = table_info['jpasingle']['select l from LogFile l where LOWER(l.path) like \'${logfile?lower_case}\''][0] >
217
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    94
<html>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    95
<head><title>${logfile}</title></head>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    96
<body>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    97
<h2 STYLE="background-color :#FF0000">Generated using Text Parser instead of XML Parser because of Invalid XML output from Raptor</h2>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    98
<h2>Overall</h2>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
    99
<table border="1" cellpadding="0" cellspacing="0" width="100%%">
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   100
<tr>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   101
    <th width="22%%">&nbsp;</th>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   102
    <th width="11%%">Time</th>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   103
    <th width="11%%">Errors</th>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   104
    <th width="11%%">Warnings</th>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   105
    <th width="11%%">Critical</th>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   106
    <th width="23%%">Migration Notes</th>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   107
    <th width="11%%">Info</th>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   108
</tr>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   109
<tr>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   110
<#-- need to create variables for the items tobe displayed in the comment title Overall_Total
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   111
doing this the long winded way because I could not find a way to add items to a hash in a loop -->
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   112
<#assign color_list={'error': 'FF0000', 'warning': 'FFF000', 'critical': 'FF7000', 'remark': 'FFCCFF', 'info': 'FFFFFF'}>
628
7c4a911dc066 helium_11.0.0-e00f171ca185
wbernard
parents: 217
diff changeset
   113
<#assign severity_ids = color_list?keys>
217
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   114
<td width="22%%">Total</td>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   115
<td width="12%%" align="center">${time}</td>
628
7c4a911dc066 helium_11.0.0-e00f171ca185
wbernard
parents: 217
diff changeset
   116
<#list severity_ids as severity>
7c4a911dc066 helium_11.0.0-e00f171ca185
wbernard
parents: 217
diff changeset
   117
    <@add_severity_count severity='${severity}' color=color_list['${severity}'] 
7c4a911dc066 helium_11.0.0-e00f171ca185
wbernard
parents: 217
diff changeset
   118
        count = table_info['jpasingle']['select Count(m.id) from MetadataEntry m JOIN m.severity p where m.logFileId=${logfile.id} and p.severity=\'${severity?upper_case}\''][0] />
217
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   119
</#list>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   120
</tr>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   121
</table>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   122
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   123
<#-- Summary for each component -->
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   124
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   125
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   126
<h1>${logfile}</h1>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   127
<h2>By Component</h2>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   128
    <table border="1" cellpadding="0" cellspacing="0" width="100%%">
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   129
        <tr>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   130
            <th width="50%%">Component</th>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   131
            <th width="9%%">Time</th>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   132
            <th width="9%%">Errors</th>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   133
            <th width="9%%">Warnings</th>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   134
            <th width="9%%">Criticals</th>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   135
            <th width="9%%">Notes</th>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   136
            <th width="9%%">Info</th>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   137
        </tr>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   138
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   139
<#assign c_id = 0>
628
7c4a911dc066 helium_11.0.0-e00f171ca185
wbernard
parents: 217
diff changeset
   140
<#assign general_component_list = table_info['jpasingle']['select c from Component c where LOWER(c.component) like \'%general%\' and c.logFileId=${logfile.id}']>
217
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   141
<#if general_component_list[0]?? >
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   142
<#assign general_component = general_component_list[0] >
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   143
<@print_component_summary component=general_component  href_c_id="${c_id}"/>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   144
<#assign c_id = c_id + 1>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   145
</#if>
628
7c4a911dc066 helium_11.0.0-e00f171ca185
wbernard
parents: 217
diff changeset
   146
<#list table_info['jpa']['select c from Component c where c.logFileId=${logfile.id} and LOWER(c.component) not like \'%general%\' ORDER BY c.component'] as componentEntry>
217
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   147
<@print_component_summary component=componentEntry href_c_id="${c_id}"/>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   148
<#assign c_id = c_id + 1>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   149
</#list>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   150
</table>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   151
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   152
<#-- Individual components status -->
628
7c4a911dc066 helium_11.0.0-e00f171ca185
wbernard
parents: 217
diff changeset
   153
<#list severity_ids as p_id>
7c4a911dc066 helium_11.0.0-e00f171ca185
wbernard
parents: 217
diff changeset
   154
<#assign p_count = table_info['jpasingle']['select Count(m.id) from MetadataEntry m JOIN m.severity as p where m.logFileId=${logfile.id} and p.severity=\'${p_id?upper_case}\''][0]>
217
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   155
<#if p_count &gt; 0>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   156
    <h3><a>${p_id} Details By Component</a></h3>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   157
</#if>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   158
<#assign href_cid = 0>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   159
<#if general_component??>
628
7c4a911dc066 helium_11.0.0-e00f171ca185
wbernard
parents: 217
diff changeset
   160
    <@print_list_text severity="${p_id}" component=general_component href_id="${p_id}${href_cid}" /> 
217
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   161
    <#assign href_cid = href_cid + 1>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   162
</#if>
628
7c4a911dc066 helium_11.0.0-e00f171ca185
wbernard
parents: 217
diff changeset
   163
<#list table_info['jpa']['select c from Component c where c.logFileId=${logfile.id} and LOWER(c.component) not like \'%general%\' ORDER BY c.component'] as componentEntry>
7c4a911dc066 helium_11.0.0-e00f171ca185
wbernard
parents: 217
diff changeset
   164
    <@print_list_text severity="${p_id}" component=componentEntry href_id="${p_id}${href_cid}" />
217
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   165
    <#assign href_cid = href_cid + 1>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   166
</#list>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   167
</#list>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   168
</body>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   169
</html>
0f5e3a7fb6af helium_8.0-r15308
wbernard
parents:
diff changeset
   170
</#if>