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.hibernate.HibernateSessionManager;
37
import org.hisp.dhis.importexport.GroupMemberType;
38
import org.hisp.dhis.importexport.ImportObject;
39
import org.hisp.dhis.importexport.ImportObjectStatus;
40
import org.hisp.dhis.importexport.ImportObjectStore;
43
* @author Lars Helge Overland
44
* @version $Id: HibernateImportObjectStore.java 5793 2008-10-02 14:14:00Z larshelg $
46
public class HibernateImportObjectStore
47
implements ImportObjectStore
49
// ----------------------------------------------------------------------
51
// ----------------------------------------------------------------------
53
private HibernateSessionManager sessionManager;
55
public void setSessionManager( HibernateSessionManager sessionManager )
57
this.sessionManager = sessionManager;
60
// ----------------------------------------------------------------------
61
// ImportObjectStore implementation
62
// ----------------------------------------------------------------------
64
// ----------------------------------------------------------------------
66
// ----------------------------------------------------------------------
68
public int addImportObject( ImportObject importObject )
70
Session session = sessionManager.getCurrentSession();
72
return (Integer) session.save( importObject );
75
public void updateImportObject( ImportObject importObject )
77
Session session = sessionManager.getCurrentSession();
79
session.saveOrUpdate( importObject );
82
public ImportObject getImportObject( int id )
84
Session session = sessionManager.getCurrentSession();
86
return (ImportObject) session.get( ImportObject.class, id );
89
@SuppressWarnings( "unchecked" )
90
public Collection<ImportObject> getImportObjects( Class<?> clazz )
92
Session session = sessionManager.getCurrentSession();
94
Criteria criteria = session.createCriteria( ImportObject.class );
96
criteria.add( Restrictions.eq( "className", clazz.getName() ) );
98
return criteria.list();
101
@SuppressWarnings( "unchecked" )
102
public Collection<ImportObject> getImportObjects( ImportObjectStatus status, Class<?> clazz )
104
Session session = sessionManager.getCurrentSession();
106
Criteria criteria = session.createCriteria( ImportObject.class );
108
criteria.add( Restrictions.eq( "status", status ) );
109
criteria.add( Restrictions.eq( "className", clazz.getName() ) );
111
return criteria.list();
114
@SuppressWarnings( "unchecked" )
115
public Collection<ImportObject> getImportObjects( GroupMemberType groupMemberType )
117
Session session = sessionManager.getCurrentSession();
119
Criteria criteria = session.createCriteria( ImportObject.class );
121
criteria.add( Restrictions.eq( "groupMemberType", groupMemberType ) );
123
return criteria.list();
126
public void deleteImportObject( ImportObject importObject )
128
Session session = sessionManager.getCurrentSession();
130
session.delete( importObject );
133
@SuppressWarnings( "unchecked" )
134
public void deleteImportObjects( Class<?> clazz )
136
Session session = sessionManager.getCurrentSession();
138
String hql = "from ImportObject where className = :className";
140
Query query = session.createQuery( hql );
142
query.setString( "className", clazz.getName() );
144
Collection<ImportObject> importObjects = query.list();
146
for ( ImportObject importObject : importObjects )
148
session.evict( importObject );
151
hql = "delete " + hql;
153
query = session.createQuery( hql );
155
query.setString( "className", clazz.getName() );
157
query.executeUpdate();
160
@SuppressWarnings( "unchecked" )
161
public void deleteImportObjects( GroupMemberType groupMemberType )
163
Session session = sessionManager.getCurrentSession();
165
String hql = "from ImportObject where groupMemberType = :groupMemberType";
167
Query query = session.createQuery( hql );
169
query.setParameter( "groupMemberType", groupMemberType );
171
Collection<ImportObject> importObjects = query.list();
173
for ( ImportObject importObject : importObjects )
175
session.evict( importObject );
178
hql = "delete " + hql;
180
query = session.createQuery( hql );
182
query.setParameter( "groupMemberType", groupMemberType );
184
query.executeUpdate();
187
@SuppressWarnings( "unchecked" )
188
public void deleteImportObjects()
190
Session session = sessionManager.getCurrentSession();
192
String hql = "from ImportObject";
194
Collection<ImportObject> importObjects = session.createQuery( hql ).list();
196
for ( ImportObject importObject : importObjects )
198
session.evict( importObject );
201
hql = "delete " + hql;
203
session.createQuery( hql ).executeUpdate();