ball.tv.epg.repository

Interface ScheduleRepository

All Superinterfaces:

CrudRepository<Schedule,Schedule.PK>, JpaRepository<Schedule,Schedule.PK>, PagingAndSortingRepository<Schedule,Schedule.PK>, QueryByExampleExecutor<Schedule>, Repository<Schedule,Schedule.PK>

@Repository
 @Transactional(readOnly=true)
public interface ScheduleRepository
extends JpaRepository<Schedule,Schedule.PK>

Schedule JpaRepository.

Version:

$Revision: 7215 $

Author:

Allen D. Ball

Method Summary

Modifier and Type	Method and Description
long	deleteByStationIDAndAirDateTimeGreaterThanEqual(int stationID, long dateTime)
List<Schedule>	findAiringAt(long dateTime)
Set<String>	findAllProgramIDs()

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.CrudRepository

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

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

count, exists, findAll, findOne

Method Detail

deleteByStationIDAndAirDateTimeGreaterThanEqual

@Transactional
long deleteByStationIDAndAirDateTimeGreaterThanEqual(int stationID,
                                                                    long dateTime)

findAllProgramIDs

@Query(value="SELECT DISTINCT schedule.programID FROM #{#entityName} schedule")
Set<String> findAllProgramIDs()

findAiringAt

@Query(value="SELECT schedule FROM #{#entityName} schedule WHERE ?1 BETWEEN schedule.airDateTime AND (schedule.airDateTime + schedule.duration)")
List<Schedule> findAiringAt(long dateTime)