1
package org.hisp.dhis.jdbc.batchhandler;
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.util.HashMap;
33
import org.hisp.dhis.jdbc.JDBCConfiguration;
34
import org.hisp.dhis.datavalue.DataValue;
37
* @author Lars Helge Overland
38
* @version $Id: DataValueBatchHandler.java 5062 2008-05-01 18:10:35Z larshelg $
40
public class DataValueBatchHandler
41
extends AbstractBatchHandler
43
// -------------------------------------------------------------------------
45
// -------------------------------------------------------------------------
47
public DataValueBatchHandler( JDBCConfiguration configuration )
49
super( configuration );
51
hasSinglePrimaryKey = false;
54
// -------------------------------------------------------------------------
55
// AbstractBatchHandler implementation
56
// -------------------------------------------------------------------------
58
protected void setTableName()
60
this.tableName = "datavalue";
63
protected void openSqlStatement()
67
sqlBuffer.append( statementBuilder.getInsertStatementOpening( tableName ) );
70
protected String getUpdateSqlStatement( Object object )
76
return statementBuilder.getUpdateStatement( tableName );
79
protected String getIdentifierStatement( Object objectName )
81
throw new UnsupportedOperationException( "DataValue has no single unique identifier" );
84
protected String getUniquenessStatement( Object object )
86
DataValue value = (DataValue) object;
88
Map<String, String> fieldMap = new HashMap<String, String>();
90
fieldMap.put( "dataelementid", String.valueOf( value.getDataElement().getId() ) );
91
fieldMap.put( "categoryoptioncomboid", String.valueOf( value.getOptionCombo().getId() ) );
92
fieldMap.put( "periodid", String.valueOf( value.getPeriod().getId() ) );
93
fieldMap.put( "sourceid", String.valueOf( value.getSource().getId() ) );
95
return statementBuilder.getValueStatement( tableName, "dataelementid", fieldMap, true );
98
protected void addColumns()
100
statementBuilder.setColumn( "dataelementid" );
101
statementBuilder.setColumn( "periodid" );
102
statementBuilder.setColumn( "sourceid" );
103
statementBuilder.setColumn( "value" );
104
statementBuilder.setColumn( "storedby" );
105
statementBuilder.setColumn( "lastupdated" );
106
statementBuilder.setColumn( "comment" );
107
statementBuilder.setColumn( "categoryoptioncomboid" );
110
protected void addValues( Object object )
112
DataValue value = (DataValue) object;
114
statementBuilder.setInt( value.getDataElement().getId() );
115
statementBuilder.setInt( value.getPeriod().getId() );
116
statementBuilder.setInt( value.getSource().getId() );
117
statementBuilder.setString( value.getValue() );
118
statementBuilder.setString( value.getStoredBy() );
119
statementBuilder.setDate( value.getTimestamp() );
120
statementBuilder.setString( value.getComment() );
121
statementBuilder.setInt( value.getOptionCombo().getId() );