Package eu.dnetlib.organizations.repository

Interface OpenaireDuplicateRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<OpenaireDuplicate,OpenaireDuplicatePK>, org.springframework.data.jpa.repository.JpaRepository<OpenaireDuplicate,OpenaireDuplicatePK>, org.springframework.data.repository.PagingAndSortingRepository<OpenaireDuplicate,OpenaireDuplicatePK>, org.springframework.data.repository.query.QueryByExampleExecutor<OpenaireDuplicate>, org.springframework.data.repository.Repository<OpenaireDuplicate,OpenaireDuplicatePK>

@Repository
public interface OpenaireDuplicateRepository
extends org.springframework.data.jpa.repository.JpaRepository<OpenaireDuplicate,OpenaireDuplicatePK>

Method Summary

Modifier and Type	Method	Description
List<OpenaireDuplicate>	findByLocalId(String localId)
List<OpenaireDuplicate>	findByOaOriginalId(String oaOriginalId)
void	updateCreatedByIfMissing(String id1, String id2, String user)
void	updateModificationDate(String id1, String id2, String user, OffsetDateTime now)

Methods inherited from interface org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findById, save

Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getById, getOne, saveAll, saveAllAndFlush, saveAndFlush

Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

findAll

Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findOne

Method Details

findByLocalId

List<OpenaireDuplicate> findByLocalId(String localId)

updateModificationDate

@Modifying
@Query(value="update oa_duplicates set modified_by = ?3, modification_date = ?4 where (local_id = ?1 and oa_original_id = ?2) or (local_id = ?2 and oa_original_id = ?1)",
       nativeQuery=true)
void updateModificationDate(String id1,
 String id2,
 String user,
 OffsetDateTime now)

updateCreatedByIfMissing

@Modifying
@Query(value="update oa_duplicates set created_by = ?3 where ((local_id = ?1 and oa_original_id = ?2) or (local_id = ?2 and oa_original_id = ?1)) and (created_by is null or created_by = \'\')",
       nativeQuery=true)
void updateCreatedByIfMissing(String id1,
 String id2,
 String user)

findByOaOriginalId

List<OpenaireDuplicate> findByOaOriginalId(String oaOriginalId)