Package edu.ucsb.cs156.courses.collections

Interface ConvertedSectionCollection

All Superinterfaces:

org.springframework.data.repository.CrudRepository<ConvertedSection,org.bson.types.ObjectId>, org.springframework.data.repository.ListCrudRepository<ConvertedSection,org.bson.types.ObjectId>, org.springframework.data.repository.ListPagingAndSortingRepository<ConvertedSection,org.bson.types.ObjectId>, org.springframework.data.mongodb.repository.MongoRepository<ConvertedSection,org.bson.types.ObjectId>, org.springframework.data.repository.PagingAndSortingRepository<ConvertedSection,org.bson.types.ObjectId>, org.springframework.data.repository.query.QueryByExampleExecutor<ConvertedSection>, org.springframework.data.repository.Repository<ConvertedSection,org.bson.types.ObjectId>

@Repository
public interface ConvertedSectionCollection
extends org.springframework.data.mongodb.repository.MongoRepository<ConvertedSection,org.bson.types.ObjectId>

Method Summary

Modifier and Type	Method	Description
List<ConvertedSection>	findByQuarter(String quarter)
List<ConvertedSection>	findByQuarterAndBuildingCode(String quarter, String buildingCode)
List<ConvertedSection>	findByQuarterAndSubjectArea(String quarter, String subjectArea, String sectionRegex, int minTimeLocations)	Find sections by quarter and subject area.
List<ConvertedSection>	findByQuarterRangeAndBuildingCode(String startQuarter, String endQuarter, String buildingCode)
List<ConvertedSection>	findByQuarterRangeAndCourseId(String startQuarter, String endQuarter, String courseId)
List<ConvertedSection>	findByQuarterRangeAndInstructor(String startQuarter, String endQuarter, String instructor, String functionCode)
Optional<ConvertedSection>	findOneByQuarterAndEnrollCode(String quarter, String enrollCode)

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

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

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

findAll, findAllById, saveAll

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

findAll

Methods inherited from interface org.springframework.data.mongodb.repository.MongoRepository

findAll, findAll, insert, insert

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

findAll

Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findBy, findOne

Method Details

findOneByQuarterAndEnrollCode

@Query("{\'courseInfo.quarter\': ?0, \'section.enrollCode\': ?1}")
Optional<ConvertedSection> findOneByQuarterAndEnrollCode(String quarter,
 String enrollCode)

findByQuarterRangeAndCourseId

@Query("{\'courseInfo.quarter\': { $gte: ?0, $lte: ?1 }, \'courseInfo.courseId\': { $regex: ?2 } }")
List<ConvertedSection> findByQuarterRangeAndCourseId(String startQuarter,
 String endQuarter,
 String courseId)

findByQuarterRangeAndInstructor

@Query("{\'courseInfo.quarter\': {$gte: ?0, $lte: ?1}, \'section.instructors\': { \'$elemMatch\': { \'instructor\': { $regex: ?2 }, \'functionCode\': { $regex: ?3 }}}}")
List<ConvertedSection> findByQuarterRangeAndInstructor(String startQuarter,
 String endQuarter,
 String instructor,
 String functionCode)

findByQuarterRangeAndBuildingCode

@Query("{\'courseInfo.quarter\': { $gte: ?0, $lte: ?1 }, \'section.timeLocations.building\': { $regex: ?2, $options: \'i\' } }")
List<ConvertedSection> findByQuarterRangeAndBuildingCode(String startQuarter,
 String endQuarter,
 String buildingCode)

findByQuarterAndBuildingCode

@Query("{\'courseInfo.quarter\': { $eq: ?0 }, \'section.timeLocations.building\': { $regex: ?1, $options: \'i\' } }")
List<ConvertedSection> findByQuarterAndBuildingCode(String quarter,
 String buildingCode)

findByQuarter

@Query("{\'courseInfo.quarter\': { $eq: ?0 } }")
List<ConvertedSection> findByQuarter(String quarter)

findByQuarterAndSubjectArea

@Query("{\'courseInfo.quarter\': { $eq: ?0 }, \'courseInfo.courseId\': { $regex: ?1 }, \'section.section\': { $regex: ?2 }, $expr: { $gte: [ { $size: \'$section.timeLocations\' }, ?3 ] } }")
List<ConvertedSection> findByQuarterAndSubjectArea(String quarter,
 String subjectArea,
 String sectionRegex,
 int minTimeLocations)

Find sections by quarter and subject area.

Parameters:

quarter - Quarter in yyyyq format

subjectArea - regex (first eight should be subjectArea, then next character determines level; e.g. ' ' for lower div ugrad, 1 for upper div ugrad, 2 or above for grad)

sectionRegex - use `00$` to omit sections or `.*` for all sections

minTimeLocations - use 0 for all courses (including independent studies), 1 for only course that have a time and/or locations assigned

Returns: