Package com.profile.searcher.repository

Interface AlumniRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<AlumniEntity,UUID>, org.springframework.data.jpa.repository.JpaRepository<AlumniEntity,UUID>, org.springframework.data.repository.ListCrudRepository<AlumniEntity,UUID>, org.springframework.data.repository.ListPagingAndSortingRepository<AlumniEntity,UUID>, org.springframework.data.repository.PagingAndSortingRepository<AlumniEntity,UUID>, org.springframework.data.repository.query.QueryByExampleExecutor<AlumniEntity>, org.springframework.data.repository.Repository<AlumniEntity,UUID>

public interface AlumniRepository
extends org.springframework.data.jpa.repository.JpaRepository<AlumniEntity,UUID>

Method Summary

Modifier and Type	Method	Description
List<AlumniVO>	findAllAlumni(String currentDesignation, String university, Integer graduationYear)
org.springframework.data.domain.Page<AlumniVO>	findAllAlumni(org.springframework.data.domain.Pageable pageable)
List<AlumniVO>	findAllAlumniWithoutGraduationYear(String currentDesignation, String university)

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, flush, getById, getOne, getReferenceById, saveAllAndFlush, saveAndFlush

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

findAll, findAllById, saveAll

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

findAll

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

findAll

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

count, exists, findAll, findBy, findOne

Method Details

findAllAlumni

@Query("SELECT new com.profile.searcher.model.response.AlumniVO(a.id, a.title, a.fullName, u.name, a.profileHeadLine, a.location, a.connectionDegree, a.company, a.profileUrl, a.companyUrl, a.passedOutYear) FROM AlumniEntity a JOIN UniversityEntity u ON a.university = u where a.passedOutYear <= :graduationYear AND a.title = :currentDesignation AND u.name = :university")
List<AlumniVO> findAllAlumni(String currentDesignation,
 String university,
 Integer graduationYear)

findAllAlumniWithoutGraduationYear

@Query("SELECT new com.profile.searcher.model.response.AlumniVO(a.id, a.title, a.fullName, u.name, a.profileHeadLine, a.location, a.connectionDegree, a.company, a.profileUrl, a.companyUrl, a.passedOutYear) FROM AlumniEntity a JOIN UniversityEntity u ON a.university = u where a.title = :currentDesignation AND u.name = :university")
List<AlumniVO> findAllAlumniWithoutGraduationYear(String currentDesignation,
 String university)

findAllAlumni

@Query("SELECT new com.profile.searcher.model.response.AlumniVO(a.id, a.title, a.fullName, u.name, a.profileHeadLine, a.location, a.connectionDegree, a.company, a.profileUrl, a.companyUrl, a.passedOutYear) FROM AlumniEntity a JOIN UniversityEntity u ON a.university = u ")
org.springframework.data.domain.Page<AlumniVO> findAllAlumni(org.springframework.data.domain.Pageable pageable)