Package com.amos2020.javabackend.repository

Interface FacCritRepository

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

  • Method Summary

    Modifier and Type Method Description
    java.util.List<FacCrit> getFacCritsByInterviewId​(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

    • getFacCritsByInterviewId

      @Query("select f from FacCrit f where f.id in (select a.faccritId from Answer a where a.interviewId=:interviewId)") java.util.List<FacCrit> getFacCritsByInterviewId​(@Param("interviewId") int interviewId)