Package edu.ucsb.cs156.happiercows.repositories

Interface StudentRepository

All Superinterfaces:

org.springframework.data.repository.CrudRepository<Student,Long>, org.springframework.data.repository.Repository<Student,Long>

@Repository
public interface StudentRepository
extends org.springframework.data.repository.CrudRepository<Student,Long>

Method Summary

Modifier and Type	Method	Description
Iterable<Student>	findByCourseId(Long courseId)
Iterable<Student>	findByCourseIdAndPerm(Long courseId, String perm)
Iterable<Student>	findByEmail(String email)
Iterable<Student>	findByPerm(String perm)

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

count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findAll, findAllById, findById, save, saveAll

Method Details

findByEmail

@Query("SELECT stu FROM student stu WHERE stu.email = :email")
Iterable<Student> findByEmail(String email)

findByCourseId

@Query("SELECT stu FROM student stu WHERE stu.courseId = :courseId")
Iterable<Student> findByCourseId(Long courseId)

findByPerm

@Query("SELECT stu FROM student stu WHERE stu.perm = :perm")
Iterable<Student> findByPerm(String perm)

findByCourseIdAndPerm

@Query("SELECT stu FROM student stu WHERE stu.courseId = :courseId AND stu.perm = :perm")
Iterable<Student> findByCourseIdAndPerm(Long courseId,
 String perm)