SurveyQuestionsDAO

All Superinterfaces:: org.springframework.data.repository.CrudRepository<SurveyQuestions,Integer>, org.springframework.data.repository.Repository<SurveyQuestions,Integer>

public interface SurveyQuestionsDAO extends org.springframework.data.repository.CrudRepository<SurveyQuestions,Integer>

Method Summary

Modifier and Type

Method

Description

Iterable<SurveyQuestions>

questionBySurvey(int idSurvey)

SurveyQuestions

questionHandler(int idQuestion, int idSurvey)

Iterable<SurveyQuestions>

questionNotIn(List<Integer> idIn, int idSurvey)

Methods inherited from interface org.springframework.data.repository.CrudRepository
count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findAll, findAllById, findById, save, saveAll

Method Details
- questionHandler
  
  @Query("SELECT s FROM SurveyQuestions s Where s.question.id = :idQuestion AND s.survey.id = :idSurvey") SurveyQuestions questionHandler(@Param("idQuestion") int idQuestion, @Param("idSurvey") int idSurvey)
- questionNotIn
  
  @Query("SELECT s FROM SurveyQuestions s Where s.survey.id = :idSurvey AND s.question.id NOT IN (:idIn)") Iterable<SurveyQuestions> questionNotIn(@Param("idIn") List<Integer> idIn, @Param("idSurvey") int idSurvey)
- questionBySurvey
  
  @Query("SELECT s FROM SurveyQuestions s Where s.survey.id = :idSurvey") Iterable<SurveyQuestions> questionBySurvey(@Param("idSurvey") int idSurvey)