Package eu.dnetlib.organizations.repository

Interface OpenaireConflictRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<OpenaireConflict,OpenaireConflictPK>, org.springframework.data.jpa.repository.JpaRepository<OpenaireConflict,OpenaireConflictPK>, org.springframework.data.repository.PagingAndSortingRepository<OpenaireConflict,OpenaireConflictPK>, org.springframework.data.repository.query.QueryByExampleExecutor<OpenaireConflict>, org.springframework.data.repository.Repository<OpenaireConflict,OpenaireConflictPK>

@Repository
public interface OpenaireConflictRepository
extends org.springframework.data.jpa.repository.JpaRepository<OpenaireConflict,OpenaireConflictPK>

Method Summary

Modifier and Type	Method	Description
long	countByGroupNull()
Iterable<OpenaireConflict>	findById1AndGroupIsNull(String id)
Iterable<OpenaireConflict>	findById2AndGroupIsNull(String id)
void	resetGroupIds()
void	updateMultipleStatusAndResetGroup(String id, String status, String user, OffsetDateTime now)
void	updateStatusAndResetGroup(String id1, String id2, String status, 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

findById1AndGroupIsNull

Iterable<OpenaireConflict> findById1AndGroupIsNull(String id)

findById2AndGroupIsNull

Iterable<OpenaireConflict> findById2AndGroupIsNull(String id)

resetGroupIds

@Modifying
@Query(value="update oa_conflicts set idgroup = null",
       nativeQuery=true)
void resetGroupIds()

updateStatusAndResetGroup

@Modifying
@Query(value="update oa_conflicts set idgroup = null, status = ?3, modified_by = ?4, modification_date = ?5 where (id1 = ?1 and id2 = ?2) or (id1 = ?2 and id2 = ?1)",
       nativeQuery=true)
void updateStatusAndResetGroup(String id1,
 String id2,
 String status,
 String user,
 OffsetDateTime now)

countByGroupNull

long countByGroupNull()

updateMultipleStatusAndResetGroup

@Modifying
@Query(value="update oa_conflicts set idgroup = null, status = ?2, modified_by = ?3, modification_date = ?4 where id1 = ?1 or id2 = ?1",
       nativeQuery=true)
void updateMultipleStatusAndResetGroup(String id,
 String status,
 String user,
 OffsetDateTime now)