1
package org.hisp.dhis.importexport.hibernate;
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.Collection;
32
import org.hibernate.Criteria;
33
import org.hibernate.Query;
34
import org.hibernate.Session;
35
import org.hibernate.criterion.Restrictions;
36
import org.hisp.dhis.importexport.ImportDataValue;
37
import org.hisp.dhis.hibernate.HibernateSessionManager;
38
import org.hisp.dhis.importexport.ImportDataValueStore;
39
import org.hisp.dhis.importexport.ImportObjectStatus;
42
* @author Lars Helge Overland
43
* @version $Id: HibernateImportDataValueStore.java 4663 2008-02-29 09:10:33Z larshelg $
45
public class HibernateImportDataValueStore
46
implements ImportDataValueStore
48
// ----------------------------------------------------------------------
50
// ----------------------------------------------------------------------
52
private HibernateSessionManager sessionManager;
54
public void setSessionManager( HibernateSessionManager sessionManager )
56
this.sessionManager = sessionManager;
59
// ----------------------------------------------------------------------
60
// ImportDataValueStore implementation
61
// ----------------------------------------------------------------------
63
public void addImportDataValue( ImportDataValue importDataValue )
65
Session session = sessionManager.getCurrentSession();
67
session.save( importDataValue );
70
@SuppressWarnings( "unchecked" )
71
public Collection<ImportDataValue> getImportDataValues( ImportObjectStatus status )
73
Session session = sessionManager.getCurrentSession();
75
Criteria criteria = session.createCriteria( ImportDataValue.class );
77
criteria.add( Restrictions.eq( "status", status.name() ) );
79
return criteria.list();
82
public void deleteImportDataValues()
84
Session session = sessionManager.getCurrentSession();
86
String hql = "DELETE FROM ImportDataValue";
88
session.createQuery( hql ).executeUpdate();
91
public void deleteImportDataValuesByDataElement( int dataElementId )
93
Session session = sessionManager.getCurrentSession();
95
String hql = "DELETE FROM ImportDataValue WHERE dataElementId = :dataElementId";
97
Query query = session.createQuery( hql );
99
query.setInteger( "dataElementId", dataElementId );
101
query.executeUpdate();
104
public void deleteImportDataValuesBySource( int sourceId )
106
Session session = sessionManager.getCurrentSession();
108
String hql = "DELETE FROM ImportDataValue WHERE sourceId = :sourceId";
110
Query query = session.createQuery( hql );
112
query.setInteger( "sourceId", sourceId );
114
query.executeUpdate();