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: 5285 $

Author:

Allen D. Ball

Method Summary

Modifier and Type	Method and Description
long	deleteByStationIDAndAirDateTimeGreaterThanEqual(int stationID, long dateTime)
List<String>	getAllProgramIDs()
Optional<Schedule>	getSchedule(int stationID, long dateTime)

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)

getAllProgramIDs

@Query(value="SELECT schedule.programID FROM #{#entityName} schedule")
List<String> getAllProgramIDs()

getSchedule

@Query(value="SELECT schedule FROM #{#entityName} schedule WHERE schedule.stationID = ?1 AND schedule.airDateTime <= ?2 AND ?2 < (schedule.airDateTime + schedule.duration)")
Optional<Schedule> getSchedule(int stationID,
                                                                                                                                                                                                             long dateTime)