@Override\r
public long countMedia(SpecimenOrObservationBase occurence) {\r
checkNotInPriorView("OccurrenceDaoHibernateImpl.countMedia(SpecimenOrObservationBase occurence)");\r
- Query query = getSession().createQuery("select count(media) from SpecimenOrObservationBase occurence join occurence.media media where occurence = :occurence");\r
+ Query query = getSession().createQuery("SELECT count(media) FROM SpecimenOrObservationBase occurence JOIN occurence.media media WHERE occurence = :occurence");\r
query.setParameter("occurence", occurence);\r
\r
return (Long)query.uniqueResult();\r
@Override\r
public List<DerivationEvent> getDerivationEvents(SpecimenOrObservationBase occurence, Integer pageSize,Integer pageNumber, List<String> propertyPaths) {\r
checkNotInPriorView("OccurrenceDaoHibernateImpl.getDerivationEvents(SpecimenOrObservationBase occurence, Integer pageSize,Integer pageNumber)");\r
- Query query = getSession().createQuery("select distinct derivationEvent from DerivationEvent derivationEvent join derivationEvent.originals occurence where occurence = :occurence");\r
+ Query query = getSession().createQuery("SELECT DISTINCT derivationEvent FROM DerivationEvent derivationEvent JOIN derivationEvent.originals occurence WHERE occurence = :occurence");\r
query.setParameter("occurence", occurence);\r
\r
addPageSizeAndNumber(query, pageSize, pageNumber);\r
*/
public DeleteResult deleteTaxon(UUID taxonUuid, TaxonDeletionConfigurator config, UUID classificationUuid);
-
public UpdateResult moveFactualDateToAnotherTaxon(UUID fromTaxonUuid,
UUID toTaxonUuid);
-
- /**
- * @param synonymUuid
- * @param toTaxonUuid
- * @param taxonRelationshipType
- * @param citation
- * @param microcitation
- * @return
- */
public UpdateResult changeSynonymToRelatedTaxon(UUID synonymUuid, UUID toTaxonUuid, TaxonRelationshipType taxonRelationshipType,
Reference citation, String microcitation);
- /**
- * @param fromTaxonUuid
- * @param toTaxonUuid
- * @param oldRelationshipType
- * @param synonymType
- * @return
- * @throws DataChangeNoRollbackException
- */
public UpdateResult changeRelatedTaxonToSynonym(UUID fromTaxonUuid, UUID toTaxonUuid,
TaxonRelationshipType oldRelationshipType, SynonymType synonymType) throws DataChangeNoRollbackException;
/**
* Returns a list of taxon relationships for a given taxon as DTO.
- * @param taxonUuid
- * @param directTypes
- * @param inversTypes
- * @param direction
- * @param groupMisapplications
- * @param includeUnpublished
- * @param pageSize
- * @param pageNumber
- * @return
*/
public TaxonRelationshipsDTO listTaxonRelationships(UUID taxonUuid,
Set<TaxonRelationshipType> directTypes,
Set<TaxonRelationshipType> inversTypes, Direction direction, boolean groupMisapplications,
boolean includeUnpublished, Integer pageSize, Integer pageNumber);
- /**
- * @param clazz
- * @param restrictions
- * @param pageSize
- * @param pageIndex
- * @param orderHints
- * @param propertyPaths
- * @param includeUnpublished
- * @return
- */
public <S extends TaxonBase> Pager<S> page(Class<S> clazz, List<Restriction<?>> restrictions, Integer pageSize, Integer pageIndex,
List<OrderHint> orderHints, List<String> propertyPaths, boolean includeUnpublished);