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.resourcetable.OrganisationUnitStructure;
34
import org.hisp.dhis.jdbc.JDBCConfiguration;
36
* @author Lars Helge Overland
37
* @version $Id: OrganisationUnitStructureBatchHandler.java 5359 2008-06-06 10:36:39Z larshelg $
39
public class OrganisationUnitStructureBatchHandler
40
extends AbstractBatchHandler
42
// -------------------------------------------------------------------------
44
// -------------------------------------------------------------------------
46
public OrganisationUnitStructureBatchHandler( JDBCConfiguration configuration )
48
super( configuration );
51
// -------------------------------------------------------------------------
52
// AbstractBatchHandler implementation
53
// -------------------------------------------------------------------------
55
protected void setTableName()
57
this.tableName = "orgunitstructure";
60
protected void openSqlStatement()
62
statementBuilder.setAutoIncrementColumnIndex( 0 );
63
statementBuilder.setAutoIncrementColumnName( "orgunitstructureid" );
67
sqlBuffer.append( statementBuilder.getInsertStatementOpening( tableName ) );
70
protected String getUpdateSqlStatement( Object object )
76
return statementBuilder.getUpdateStatement( tableName );
79
protected String getIdentifierStatement( Object objectName )
81
return statementBuilder.getValueStatement( tableName, "orgunitstructureid", "organisationunitid", String.valueOf( objectName ) );
84
protected String getUniquenessStatement( Object object )
86
OrganisationUnitStructure structure = (OrganisationUnitStructure) object;
88
Map<String, String> fieldMap = new HashMap<String, String>();
90
fieldMap.put( "organisationUnitId", String.valueOf( structure.getOrganisationUnitId() ) );
92
return statementBuilder.getValueStatement( tableName, "orgunitstructureid", fieldMap, false );
95
protected void addColumns()
97
statementBuilder.setColumn( "organisationunitid" );
98
statementBuilder.setColumn( "level" );
100
statementBuilder.setColumn( "idlevel1" );
101
statementBuilder.setColumn( "idlevel2" );
102
statementBuilder.setColumn( "idlevel3" );
103
statementBuilder.setColumn( "idlevel4" );
104
statementBuilder.setColumn( "idlevel5" );
105
statementBuilder.setColumn( "idlevel6" );
106
statementBuilder.setColumn( "idlevel7" );
107
statementBuilder.setColumn( "idlevel8" );
109
statementBuilder.setColumn( "geolevel1" );
110
statementBuilder.setColumn( "geolevel2" );
111
statementBuilder.setColumn( "geolevel3" );
112
statementBuilder.setColumn( "geolevel4" );
113
statementBuilder.setColumn( "geolevel5" );
114
statementBuilder.setColumn( "geolevel6" );
115
statementBuilder.setColumn( "geolevel7" );
116
statementBuilder.setColumn( "geolevel8" );
119
protected void addValues( Object object )
121
OrganisationUnitStructure structure = (OrganisationUnitStructure) object;
123
statementBuilder.setInt( structure.getOrganisationUnitId() );
124
statementBuilder.setInt( structure.getLevel() );
126
statementBuilder.setInt( structure.getIdLevel1() );
127
statementBuilder.setInt( structure.getIdLevel2() );
128
statementBuilder.setInt( structure.getIdLevel3() );
129
statementBuilder.setInt( structure.getIdLevel4() );
130
statementBuilder.setInt( structure.getIdLevel5() );
131
statementBuilder.setInt( structure.getIdLevel6() );
132
statementBuilder.setInt( structure.getIdLevel7() );
133
statementBuilder.setInt( structure.getIdLevel8() );
135
statementBuilder.setString( structure.getGeoCodeLevel1() );
136
statementBuilder.setString( structure.getGeoCodeLevel2() );
137
statementBuilder.setString( structure.getGeoCodeLevel3() );
138
statementBuilder.setString( structure.getGeoCodeLevel4() );
139
statementBuilder.setString( structure.getGeoCodeLevel5() );
140
statementBuilder.setString( structure.getGeoCodeLevel6() );
141
statementBuilder.setString( structure.getGeoCodeLevel7() );
142
statementBuilder.setString( structure.getGeoCodeLevel8() );