Package eu.dnetlib.organizations.repository

Interface RelationshipRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<Relationship,RelationshipPK>, org.springframework.data.jpa.repository.JpaRepository<Relationship,RelationshipPK>, org.springframework.data.repository.PagingAndSortingRepository<Relationship,RelationshipPK>, org.springframework.data.repository.query.QueryByExampleExecutor<Relationship>, org.springframework.data.repository.Repository<Relationship,RelationshipPK>

public interface RelationshipRepository
extends org.springframework.data.jpa.repository.JpaRepository<Relationship,RelationshipPK>

Method Summary

Modifier and Type	Method	Description
void	deleteById1(String id1)
void	deleteById2(String id2)
List<Relationship>	findById1(String id1)
List<Relationship>	findById1OrId2(String id1, String id2)
List<Relationship>	findById2(String id2)
void	updateCreatedByIfMissing(String id1, String id2, String relType, String user)
void	updateModificationDate(String id1, String id2, String relType, 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

findById1

List<Relationship> findById1(String id1)

findById2

List<Relationship> findById2(String id2)

findById1OrId2

List<Relationship> findById1OrId2(String id1,
 String id2)

deleteById1

void deleteById1(String id1)

deleteById2

void deleteById2(String id2)

updateCreatedByIfMissing

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

updateModificationDate

@Modifying
@Query(value="update relationships set modified_by = ?4, modification_date = ?5 where id1 = ?1 and id2 = ?2 and reltype = ?3",
       nativeQuery=true)
void updateModificationDate(String id1,
 String id2,
 String relType,
 String user,
 OffsetDateTime now)