Package com.dataset.service.repository

Interface EmployeeRepository

All Superinterfaces:

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

public interface EmployeeRepository
extends org.springframework.data.jpa.repository.JpaRepository<EmployeeEntity,UUID>

Method Summary

Modifier and Type	Method	Description
List<EmployeeVO>	findAllEmployeeDetails()

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

findAllEmployeeDetails

@Query("SELECT new com.dataset.service.model.response.EmployeeVO(e.id, e.name, d.name, d.location, e.age) from EmployeeEntity e join DepartmentEntity d on e.department.id = d.id")
List<EmployeeVO> findAllEmployeeDetails()