1
package org.hisp.dhis.importexport.dhis14.file.typehandler;
4
* Copyright (c) 2004-2007, University of Oslo
7
* Redistribution and use in source and binary forms, with or without
8
* modification, are permitted provided that the following conditions are met:
9
* * Redistributions of source code must retain the above copyright notice, this
10
* list of conditions and the following disclaimer.
11
* * Redistributions in binary form must reproduce the above copyright notice,
12
* this list of conditions and the following disclaimer in the documentation
13
* and/or other materials provided with the distribution.
14
* * Neither the name of the HISP project nor the names of its contributors may
15
* be used to endorse or promote products derived from this software without
16
* specific prior written permission.
18
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
19
* ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
20
* WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
21
* DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR
22
* ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
23
* (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
24
* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON
25
* ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
26
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
27
* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
30
import java.sql.SQLException;
32
import org.hisp.dhis.dataelement.DataElement;
34
import com.ibatis.sqlmap.client.extensions.ParameterSetter;
35
import com.ibatis.sqlmap.client.extensions.ResultGetter;
36
import com.ibatis.sqlmap.client.extensions.TypeHandlerCallback;
39
* @author Lars Helge Overland
40
* @version $Id: AggregationOperatorTypeHandler.java 6216 2008-11-06 18:06:42Z eivindwa $
42
public class AggregationOperatorTypeHandler
43
implements TypeHandlerCallback
45
private static final String JDBC_SUM = "Sum";
46
private static final String JDBC_AVERAGE = "Avg";
47
private static final String JDBC_COUNT = "Count";
49
static final Integer NON_EXISTING = -1;
51
// -------------------------------------------------------------------------
52
// TypeHandlerCallback implementation
53
// -------------------------------------------------------------------------
55
public Object getResult( ResultGetter getter )
58
String result = getter.getString();
62
if ( result.equalsIgnoreCase( JDBC_SUM ) )
64
return DataElement.AGGREGATION_OPERATOR_SUM;
66
else if ( result.equalsIgnoreCase( JDBC_AVERAGE ) )
68
return DataElement.AGGREGATION_OPERATOR_AVERAGE;
70
else if ( result.equalsIgnoreCase( JDBC_COUNT ) )
72
return DataElement.AGGREGATION_OPERATOR_COUNT;
76
throw new RuntimeException( "Illegal aggregation operator: " + result );
81
throw new RuntimeException( "Aggregation operator is not present" );
85
public void setParameter( ParameterSetter setter, Object parameter )
91
public Object valueOf( String result )
97
else if ( result.equalsIgnoreCase( JDBC_SUM ) )
99
return DataElement.AGGREGATION_OPERATOR_SUM;
101
else if ( result.equalsIgnoreCase( JDBC_AVERAGE ) )
103
return DataElement.AGGREGATION_OPERATOR_AVERAGE;
105
else if ( result.equalsIgnoreCase( JDBC_COUNT ) )
107
return DataElement.AGGREGATION_OPERATOR_COUNT;
111
throw new RuntimeException( "Illegal aggregation operator: " + result );