1
package org.hisp.dhis.dataset;
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.ResultSet;
31
import java.sql.SQLException;
33
import org.hisp.dhis.jdbc.StatementHolder;
34
import org.hisp.dhis.jdbc.StatementManager;
35
import org.hisp.dhis.period.Period;
36
import org.hisp.dhis.source.Source;
37
import org.hisp.dhis.system.deletion.DeletionHandler;
40
* @author Lars Helge Overland
43
public class CompleteDataSetRegistrationDeletionHandler
44
extends DeletionHandler
46
// -------------------------------------------------------------------------
48
// -------------------------------------------------------------------------
50
public CompleteDataSetRegistrationService completeDataSetRegistrationService;
52
public void setCompleteDataSetRegistrationService( CompleteDataSetRegistrationService completeDataSetRegistrationService )
54
this.completeDataSetRegistrationService = completeDataSetRegistrationService;
57
private StatementManager statementManager;
59
public void setStatementManager( StatementManager statementManager )
61
this.statementManager = statementManager;
64
// -------------------------------------------------------------------------
65
// DeletionHandler implementation
66
// -------------------------------------------------------------------------
69
public String getClassName()
71
return CompleteDataSetRegistration.class.getSimpleName();
75
public void deleteDataSet( DataSet dataSet )
77
completeDataSetRegistrationService.deleteCompleteDataSetRegistrations( dataSet );
81
public boolean allowDeletePeriod( Period period )
83
StatementHolder holder = statementManager.getHolder();
87
String sql = "SELECT COUNT(*) FROM completedatasetregistration where periodid=" + period.getId();
89
ResultSet resultSet = holder.getStatement().executeQuery( sql );
91
int count = resultSet.next() ? resultSet.getInt( 1 ) : 0;
95
catch ( SQLException ex )
97
throw new RuntimeException( "Failed to get number of completedatasetregistrations for period", ex );
105
public boolean allowDeleteSource( Source source )
107
StatementHolder holder = statementManager.getHolder();
111
String sql = "SELECT COUNT(*) FROM completedatasetregistration where sourceid=" + source.getId();
113
ResultSet resultSet = holder.getStatement().executeQuery( sql );
115
int count = resultSet.next() ? resultSet.getInt( 1 ) : 0;
119
catch ( SQLException ex )
121
throw new RuntimeException( "Failed to get number of completedatasetregistrations for source", ex );