217
|
1 |
<#--
|
|
2 |
============================================================================
|
|
3 |
Name : error.csv.ftl
|
|
4 |
Part of : Helium
|
|
5 |
|
|
6 |
Copyright (c) 2009 Nokia Corporation and/or its subsidiary(-ies).
|
|
7 |
All rights reserved.
|
|
8 |
This component and the accompanying materials are made available
|
|
9 |
under the terms of the License "Eclipse Public License v1.0"
|
|
10 |
which accompanies this distribution, and is available
|
|
11 |
at the URL "http://www.eclipse.org/legal/epl-v10.html".
|
|
12 |
|
|
13 |
Initial Contributors:
|
|
14 |
Nokia Corporation - initial contribution.
|
|
15 |
|
|
16 |
Contributors:
|
|
17 |
|
|
18 |
Description:
|
|
19 |
|
|
20 |
============================================================================
|
|
21 |
-->
|
|
22 |
Component,Errors,Warnings
|
|
23 |
<#assign table_info = pp.loadData('com.nokia.helium.metadata.SQLFMPPLoader', "${dbPath}") >
|
|
24 |
<#assign error_table = table_info['select *
|
|
25 |
FROM ((SELECT data.component AS ecomponent, count(data.line_number) AS ecount
|
|
26 |
FROM (SELECT * from component LEFT OUTER JOIN metadata ON component.id=metadata.component_id) AS data, logfiles, priority
|
|
27 |
WHERE logfiles.id=data.logPath_id and logfiles.path like \'%_compile.log\' and priority.id=data.priority_id and priority.priority=\'ERROR\'
|
|
28 |
GROUP BY data.component) AS error LEFT OUTER JOIN (SELECT dataw.component AS wcomponent, count(dataw.line_number) AS wcount
|
|
29 |
FROM (SELECT * from component LEFT OUTER JOIN metadata ON component.id=metadata.component_id) AS dataw, logfiles, priority
|
|
30 |
WHERE logfiles.id=dataw.logPath_id and logfiles.path like \'%_compile.log\' and priority.id=dataw.priority_id and priority.priority=\'WARNING\'
|
|
31 |
GROUP BY dataw.component) AS warning ON error.ecomponent=warning.wcomponent)']>
|
|
32 |
<#list error_table as row>
|
|
33 |
${row['ecomponent']},${row['ecount']},${row['wcount']}
|
|
34 |
</#list> |