|
217
|
1 |
<#--
|
|
|
2 |
============================================================================
|
|
618
|
3 |
Name : faults_metadata_orm.ftl
|
|
217
|
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 |
<#include "diamonds_header.ftl">
|
|
|
23 |
|
|
|
24 |
<#setting number_format="0">
|
|
|
25 |
|
|
|
26 |
<#assign table_info = pp.loadData('com.nokia.helium.metadata.ORMFMPPLoader',
|
|
|
27 |
"${dbPath}") >
|
|
587
|
28 |
<faults>
|
|
618
|
29 |
<total severity="error">${table_info['jpasingle']['select Count(m.id) from MetadataEntry m JOIN m.priority as p JOIN m.logFile as l where LOWER(l.path) like \'%\\_compile.log\' ESCAPE \'\\\' and LOWER(l.path) not like \'%\\_clean\\_%compile.log\' ESCAPE \'\\\' and p.priority = \'ERROR\''][0]
|
|
|
30 |
+ table_info['jpasingle']['select Count(w.id) from WhatLogEntry w JOIN w.component as c JOIN c.logFile as l where LOWER(l.path) like \'%\\_compile.log\' ESCAPE \'\\\' and LOWER(l.path) not like \'%\\_clean\\_%compile.log\' ESCAPE \'\\\' and w.missing = \'true\''][0]}</total>
|
|
|
31 |
<total severity="warning">${table_info['jpasingle']['select Count(m.id) from MetadataEntry m JOIN m.priority as p JOIN m.logFile as l where LOWER(l.path) like \'%\\_compile.log\' ESCAPE \'\\\' and LOWER(l.path) not like \'%\\_clean\\_%compile.log\' ESCAPE \'\\\' and p.priority = \'WARNING\''][0]}</total>
|
|
|
32 |
<total severity="warning_rvct_other">${table_info['jpasingle']['select Count(m.id) from MetadataEntry m JOIN m.priority as p JOIN m.logFile as l where LOWER(l.path) like \'%\\_compile.log\' ESCAPE \'\\\' and LOWER(l.path) not like \'%\\_clean\\_%compile.log\' ESCAPE \'\\\' and UPPER(p.priority) = \'WARNING\''][0]}</total>
|
|
217
|
33 |
<!-- todo update to calculate the correct value -->
|
|
618
|
34 |
<total severity="warning_rvct_bad">${table_info['jpasingle']['select Count(m.id) from MetadataEntry m JOIN m.priority as p JOIN m.logFile as l where LOWER(l.path) like \'%\\_compile.log\' ESCAPE \'\\\' and LOWER(l.path) not like \'%\\_clean\\_%compile.log\' ESCAPE \'\\\' and UPPER(p.priority) = \'REMARK\''][0]}</total>
|
|
|
35 |
<#list table_info['native:java.lang.String']['select DISTINCT component.component from component INNER JOIN logfile ON logfile.logpath_id=component.logpath_id where logfile.path like \'%_compile.log\' and logfile.path not like \'%\\_clean\\_%compile.log\''] as component>
|
|
217
|
36 |
<component>
|
|
587
|
37 |
<name>${component}</name>
|
|
618
|
38 |
<total severity="error">${table_info['jpasingle']['select Count(m.id) from MetadataEntry m JOIN m.logFile as l JOIN m.priority as p JOIN m.component as c where UPPER(p.priority)=\'ERROR\' and c.component=\'${component}\' and LOWER(l.path) like \'%\\_compile.log\' ESCAPE \'\\\' and LOWER(l.path) not like \'%\\_clean\\_%compile.log\' ESCAPE \'\\\''][0]
|
|
|
39 |
+ table_info['jpasingle']['select Count(w.id) from WhatLogEntry w JOIN w.component as c JOIN c.logFile as l where c.component=\'${component}\' and LOWER(l.path) like \'%\\_compile.log\' ESCAPE \'\\\' and LOWER(l.path) not like \'%\\_clean\\_%compile.log\' ESCAPE \'\\\' and w.missing = \'true\''][0]}</total>
|
|
|
40 |
<total severity="warning">${table_info['jpasingle']['select Count(m.id) from MetadataEntry m JOIN m.logFile as l JOIN m.priority as p JOIN m.component as c where UPPER(p.priority)=\'WARNING\' and c.component=\'${component}\' and LOWER(l.path) like \'%\\_compile.log\' ESCAPE \'\\\' and LOWER(l.path) not like \'%\\_clean\\_%compile.log\' ESCAPE \'\\\''][0]}</total>
|
|
|
41 |
<total severity="critical">${table_info['jpasingle']['select Count(m.id) from MetadataEntry m JOIN m.logFile as l JOIN m.priority as p JOIN m.component as c where UPPER(p.priority)=\'REMARK\' and c.component=\'${component}\' and LOWER(l.path) like \'%\\_compile.log\' ESCAPE \'\\\' and LOWER(l.path) not like \'%\\_clean\\_%compile.log\' ESCAPE \'\\\''][0]}</total>
|
|
217
|
42 |
</component>
|
|
|
43 |
</#list>
|
|
|
44 |
</faults>
|
|
618
|
45 |
|
|
|
46 |
<!-- all components -->
|
|
217
|
47 |
<components>
|
|
618
|
48 |
<#list table_info['native:java.lang.String']['select DISTINCT component.component from component INNER JOIN logfile ON logfile.logpath_id=component.logpath_id where logfile.path like \'%_compile.log\' and logfile.path not like \'%\\_clean\\_%compile.log\''] as component>
|
|
587
|
49 |
<component>${component}</component>
|
|
217
|
50 |
</#list>
|
|
|
51 |
</components>
|
|
|
52 |
<#include "diamonds_footer.ftl"> |