Revision 443f1bb1
Added by Niels Hoffmann almost 14 years ago
| cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/occurrence/OccurrenceDaoHibernateImpl.java | ||
|---|---|---|
| 6 | 6 |
|
| 7 | 7 |
package eu.etaxonomy.cdm.persistence.dao.hibernate.occurrence; |
| 8 | 8 |
|
| 9 |
import java.util.ArrayList; |
|
| 9 | 10 |
import java.util.List; |
| 10 | 11 |
import java.util.Set; |
| 12 |
import java.util.UUID; |
|
| 11 | 13 |
|
| 12 | 14 |
import org.apache.log4j.Logger; |
| 13 | 15 |
import org.hibernate.Criteria; |
| ... | ... | |
| 22 | 24 |
import org.hibernate.search.Search; |
| 23 | 25 |
import org.springframework.stereotype.Repository; |
| 24 | 26 |
|
| 27 |
import eu.etaxonomy.cdm.model.common.UuidAndTitleCache; |
|
| 25 | 28 |
import eu.etaxonomy.cdm.model.media.Media; |
| 26 | 29 |
import eu.etaxonomy.cdm.model.molecular.DnaSample; |
| 27 | 30 |
import eu.etaxonomy.cdm.model.occurrence.DerivationEvent; |
| ... | ... | |
| 34 | 37 |
import eu.etaxonomy.cdm.model.occurrence.Observation; |
| 35 | 38 |
import eu.etaxonomy.cdm.model.occurrence.Specimen; |
| 36 | 39 |
import eu.etaxonomy.cdm.model.occurrence.SpecimenOrObservationBase; |
| 37 |
import eu.etaxonomy.cdm.model.taxon.SynonymRelationship; |
|
| 38 | 40 |
import eu.etaxonomy.cdm.model.taxon.TaxonBase; |
| 39 | 41 |
import eu.etaxonomy.cdm.model.view.AuditEvent; |
| 40 | 42 |
import eu.etaxonomy.cdm.persistence.dao.hibernate.common.IdentifiableDaoBase; |
| ... | ... | |
| 266 | 268 |
defaultBeanInitializer.initializeAll(results, propertyPaths); |
| 267 | 269 |
return results; |
| 268 | 270 |
} |
| 271 |
|
|
| 272 |
@Override |
|
| 273 |
public List<UuidAndTitleCache<DerivedUnitBase>> getDerivedUnitBaseUuidAndTitleCache() {
|
|
| 274 |
List<UuidAndTitleCache<DerivedUnitBase>> list = new ArrayList<UuidAndTitleCache<DerivedUnitBase>>(); |
|
| 275 |
Session session = getSession(); |
|
| 276 |
|
|
| 277 |
Query query = session.createQuery("select uuid, titleCache from " + type.getSimpleName() + " where NOT dtype = " + FieldObservation.class.getSimpleName());
|
|
| 278 |
|
|
| 279 |
List<Object[]> result = query.list(); |
|
| 280 |
|
|
| 281 |
for(Object[] object : result){
|
|
| 282 |
list.add(new UuidAndTitleCache<DerivedUnitBase>(DerivedUnitBase.class, (UUID) object[0], (String) object[1])); |
|
| 283 |
} |
|
| 284 |
|
|
| 285 |
return list; |
|
| 286 |
} |
|
| 287 |
|
|
| 288 |
@Override |
|
| 289 |
public List<UuidAndTitleCache<FieldObservation>> getFieldObservationUuidAndTitleCache() {
|
|
| 290 |
List<UuidAndTitleCache<FieldObservation>> list = new ArrayList<UuidAndTitleCache<FieldObservation>>(); |
|
| 291 |
Session session = getSession(); |
|
| 292 |
|
|
| 293 |
Query query = session.createQuery("select uuid, titleCache from " + type.getSimpleName() + " where dtype = " + FieldObservation.class.getSimpleName());
|
|
| 294 |
|
|
| 295 |
List<Object[]> result = query.list(); |
|
| 296 |
|
|
| 297 |
for(Object[] object : result){
|
|
| 298 |
list.add(new UuidAndTitleCache<FieldObservation>(FieldObservation.class, (UUID) object[0], (String) object[1])); |
|
| 299 |
} |
|
| 300 |
|
|
| 301 |
return list; |
|
| 302 |
} |
|
| 269 | 303 |
} |
Also available in: Unified diff
merging the last changes from SPRINT-Cichoriea1 into trunk