Package edu.ucsb.cs.scaffold.repository

Interface RosterStudentRepository

All Superinterfaces:

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

public interface RosterStudentRepository
extends org.springframework.data.jpa.repository.JpaRepository<RosterStudent,Long>

Method Summary

Modifier and Type	Method	Description
List<RosterStudent>	findAllByEmail(String email)
Iterable<RosterStudent>	findAllByUser(User user)
Iterable<RosterStudent>	findByCourseId(Long courseId)
Optional<RosterStudent>	findByCourseIdAndEmail(Long courseId, String email)
List<RosterStudent>	findByCourseIdAndRosterStatusInOrderByFirstNameAscLastNameAscIgnoreCase(Long courseId, List<RosterStatus> statuses)
Optional<RosterStudent>	findByCourseIdAndStudentId(Long courseId, String studentId)
Iterable<RosterStudent>	findByCourseIdOrderByFirstNameAscLastNameAscIgnoreCase(Long courseId)

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

findAllByEmail

List<RosterStudent> findAllByEmail(String email)

findByCourseId

Iterable<RosterStudent> findByCourseId(Long courseId)

findByCourseIdOrderByFirstNameAscLastNameAscIgnoreCase

@Query("    SELECT r\n    FROM RosterStudent r\n    WHERE r.course.id = :courseId\n    ORDER BY LOWER(r.firstName), LOWER(r.lastName)\n")
Iterable<RosterStudent> findByCourseIdOrderByFirstNameAscLastNameAscIgnoreCase(Long courseId)

findByCourseIdAndRosterStatusInOrderByFirstNameAscLastNameAscIgnoreCase

@Query("    SELECT r\n    FROM RosterStudent r\n    WHERE r.course.id = :courseId\n      AND r.rosterStatus in :statuses\n    ORDER BY LOWER(r.firstName), LOWER(r.lastName)\n")
List<RosterStudent> findByCourseIdAndRosterStatusInOrderByFirstNameAscLastNameAscIgnoreCase(Long courseId,
 List<RosterStatus> statuses)

findByCourseIdAndStudentId

Optional<RosterStudent> findByCourseIdAndStudentId(Long courseId,
 String studentId)

findByCourseIdAndEmail

Optional<RosterStudent> findByCourseIdAndEmail(Long courseId,
 String email)

findAllByUser

Iterable<RosterStudent> findAllByUser(User user)