← Back to branch summary

~mortenoh/+junk/dhis2-detailed-import-export

« back to all changes in this revision

Viewing changes to dhis-2/dhis-services/dhis-service-datamart-default/src/main/java/org/hisp/dhis/datamart/startup/DataElementCategoryOptionComboStartupRoutine.java

  • Committer: larshelge at gmail
  • Date: 2009-03-03 16:46:36 UTC
  • Revision ID: larshelge@gmail.com-20090303164636-2sjlrquo7ib1gf7r
Initial check-in

Show diffs side-by-side

added added

removed removed

Lines of Context:
dhis-2/dhis-services/dhis-service-datamart-default/src/main/java/org/hisp/dhis/datamart/startup/DataElementCategoryOptionComboStartupRoutine.java
 
1
package org.hisp.dhis.datamart.startup;
 
2
 
 
3
/*
 
4
 * Copyright (c) 2004-2007, University of Oslo
 
5
 * All rights reserved.
 
6
 *
 
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.
 
17
 *
 
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.
 
28
 */
 
29
 
 
30
import java.util.ArrayList;
 
31
import java.util.List;
 
32
 
 
33
import org.apache.commons.logging.Log;
 
34
import org.apache.commons.logging.LogFactory;
 
35
import org.hisp.dhis.jdbc.StatementHolder;
 
36
import org.hisp.dhis.jdbc.StatementManager;
 
37
import org.hisp.dhis.dataelement.DataElementCategoryCombo;
 
38
import org.hisp.dhis.dataelement.DataElementCategoryComboService;
 
39
import org.hisp.dhis.dataelement.DataElementCategoryOptionComboService;
 
40
import org.hisp.dhis.system.startup.AbstractStartupRoutine;
 
41
 
 
42
import org.hisp.dhis.dataelement.DataElementCategoryOptionCombo;
 
43
 
 
44
/**
 
45
 * @author Lars Helge Overland
 
46
 * @version $Id$
 
47
 */
 
48
public class DataElementCategoryOptionComboStartupRoutine
 
49
    extends AbstractStartupRoutine
 
50
{
 
51
    private static final Log log = LogFactory.getLog( DataElementCategoryOptionComboStartupRoutine.class );
 
52
 
 
53
    // -------------------------------------------------------------------------
 
54
    // Dependencies
 
55
    // -------------------------------------------------------------------------
 
56
 
 
57
    private DataElementCategoryOptionComboService categoryOptionComboService;
 
58
    
 
59
    public void setCategoryOptionComboService( DataElementCategoryOptionComboService categoryOptionComboService )
 
60
    {
 
61
        this.categoryOptionComboService = categoryOptionComboService;
 
62
    }
 
63
    
 
64
    private DataElementCategoryComboService categoryComboService;
 
65
 
 
66
    public void setCategoryComboService( DataElementCategoryComboService categoryComboService )
 
67
    {
 
68
        this.categoryComboService = categoryComboService;
 
69
    }
 
70
 
 
71
    private StatementManager statementManager;
 
72
 
 
73
    public void setStatementManager( StatementManager statementManager )
 
74
    {
 
75
        this.statementManager = statementManager;
 
76
    }
 
77
 
 
78
    // -------------------------------------------------------------------------
 
79
    // AbstractStartupRoutine implementation
 
80
    // -------------------------------------------------------------------------
 
81
 
 
82
    public void execute()
 
83
        throws Exception
 
84
    {
 
85
        StatementHolder holder = statementManager.getHolder();
 
86
        
 
87
        try
 
88
        {
 
89
            List<DataElementCategoryOptionCombo> combos = new ArrayList<DataElementCategoryOptionCombo>();
 
90
            
 
91
            for ( DataElementCategoryOptionCombo combo : categoryOptionComboService.getAllDataElementCategoryOptionCombos() )
 
92
            {
 
93
                DataElementCategoryOptionCombo duplicate = combo.get( combos );
 
94
                
 
95
                if ( duplicate != null )
 
96
                {
 
97
                    final DataElementCategoryOptionCombo combo1 = combo;
 
98
                    final DataElementCategoryOptionCombo combo2 = duplicate;
 
99
                    
 
100
                    duplicate = combo1.getId() > combo2.getId() ? combo1 : combo2;
 
101
                    combo = combo1.getId() < combo2.getId() ? combo1 : combo2;
 
102
                    
 
103
                    log.warn( "Categoryoptioncombo id='" + combo.getId() + "' duplicate id='" + duplicate.getId() + "'" );
 
104
                    
 
105
                    try
 
106
                    {                    
 
107
                        String sql = "update datavalue set categoryoptioncomboid=" + combo.getId() + " where categoryoptioncomboid=" + duplicate.getId();
 
108
                    
 
109
                        int result = holder.getStatement().executeUpdate( sql );
 
110
                        
 
111
                        log.info( "Moved " + result + " datavalues from duplicate to existing categoryoptioncombo" );                        
 
112
                    }
 
113
                    catch ( Exception ex ) // Moving values resulted in duplicate datavalues
 
114
                    {
 
115
                        String sql = "delete from datavalue where categoryoptioncomboid=" + duplicate.getId();
 
116
                        
 
117
                        int result = holder.getStatement().executeUpdate( sql );
 
118
                        
 
119
                        log.info( "Deleted " + result + " datavalues registered for duplicate categoryoptioncombo" );
 
120
                    }
 
121
                    
 
122
                    DataElementCategoryCombo categoryCombo = duplicate.getCategoryCombo();
 
123
                    
 
124
                    categoryCombo.getOptionCombos().remove( duplicate );
 
125
                    
 
126
                    categoryComboService.updateDataElementCategoryCombo( categoryCombo );
 
127
 
 
128
                    categoryOptionComboService.deleteDataElementCategoryOptionCombo( duplicate );
 
129
                    
 
130
                    log.info( "Deleted duplicate categoryoptioncombo" );
 
131
                }
 
132
                else
 
133
                {
 
134
                    combos.add( combo );
 
135
                }
 
136
            }
 
137
        }
 
138
        finally
 
139
        {
 
140
            holder.close();
 
141
        }
 
142
        
 
143
        log.info( "Verified CategoryOptionCombos" );
 
144
    }
 
145
}