Package com.amos2020.javabackend.repository

Interface AnswerRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<Answer,​java.lang.Integer>, org.springframework.data.jpa.repository.JpaRepository<Answer,​java.lang.Integer>, org.springframework.data.repository.PagingAndSortingRepository<Answer,​java.lang.Integer>, org.springframework.data.repository.query.QueryByExampleExecutor<Answer>, org.springframework.data.repository.Repository<Answer,​java.lang.Integer>
public interface AnswerRepository
extends org.springframework.data.jpa.repository.JpaRepository<Answer,​java.lang.Integer>
Interface to access the answer table in the database

  • Method Summary

    Modifier and Type Method Description
    Answer findFirstByQuestionIdAndInterviewId​(int questionId, int interviewId)  
    java.util.List<Answer> getAnswersByInterviewId​(int interviewId)  

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

    count, delete, deleteAll, deleteAll, deleteById, existsById, findById, save

    Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

    deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getOne, saveAll, 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

    • getAnswersByInterviewId

      @Query("select a from Answer a where a.interviewId=:interviewId") java.util.List<Answer> getAnswersByInterviewId​(@Param("interviewId") int interviewId)

    • findFirstByQuestionIdAndInterviewId

      @Query("select a from Answer a where a.interviewId=:interviewId and a.questionId=:questionId") Answer findFirstByQuestionIdAndInterviewId​(@Param("questionId") int questionId, @Param("interviewId") int interviewId)