Package edu.ucsb.cs156.courses.repositories

Interface EnrollmentDataPointRepository

All Superinterfaces:

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

@Repository
public interface EnrollmentDataPointRepository
extends org.springframework.data.repository.CrudRepository<EnrollmentDataPoint,Long>

Method Summary

Modifier and Type	Method	Description
List<EnrollmentDataPoint>	findByQuarterRangeAndCourseIdAndOptionalFilters(String startQtr, String endQtr, String courseId, String enrollCd, String section)
Iterable<EnrollmentDataPoint>	findByYyyyq(String yyyyq)

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

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

Method Details

findByYyyyq

Iterable<EnrollmentDataPoint> findByYyyyq(String yyyyq)

findByQuarterRangeAndCourseIdAndOptionalFilters

@Query("SELECT e FROM enrollmentdatapoint e\nWHERE e.yyyyq >= :startQtr\n  AND e.yyyyq <= :endQtr\n  AND e.courseId LIKE CONCAT(:courseId, \'%\')\n  AND (:enrollCd IS NULL OR e.enrollCd = :enrollCd)\n  AND (:section IS NULL OR e.section = :section)\nORDER BY e.dateCreated ASC, e.yyyyq ASC, e.courseId ASC, e.section ASC, e.enrollCd ASC, e.id ASC\n")
List<EnrollmentDataPoint> findByQuarterRangeAndCourseIdAndOptionalFilters(@Param("startQtr")
 String startQtr,
 @Param("endQtr")
 String endQtr,
 @Param("courseId")
 String courseId,
 @Param("enrollCd")
 String enrollCd,
 @Param("section")
 String section)