1 <#--

     2 ============================================================================ 

     3 Name        : macro.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 <#setting number_format="0">

    23 <#assign table_info = pp.loadData('com.nokia.helium.metadata.ORMFMPPLoader', "${dbPath}") >

    24 <#list table_info['native:java.lang.String']['select DISTINCT component.component from component INNER JOIN logfile ON logfile.logfile_id=component.logfile_id where logfile.path like \'%_compile%.log\' and logfile.path not like \'%_compile_clean%.log\''] as component>

    25 ${component}:error:${table_info['jpasingle']['select Count(m.id) from MetadataEntry m JOIN m.logFile as l JOIN m.severity as p JOIN m.component as c where UPPER(p.severity) like \'%ERROR%\' and c.component=\'${component}\' and LOWER(l.path) like \'%\\_compile%.log\' ESCAPE \'\\\' and LOWER(l.path) not like \'%\\_compile\\_clean%.log\' ESCAPE \'\\\''][0]}

    26 ${component}:whatlog:${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 \'%\\_compile\\_clean%.log\' ESCAPE \'\\\''][0]}

    27 </#list>