001package ball.tv.epg.repository; 002/*- 003 * ########################################################################## 004 * TV H/W, EPGs, and Recording 005 * $Id: ScheduleRepository.java 5285 2020-02-05 04:23:21Z ball $ 006 * $HeadURL: svn+ssh://svn.hcf.dev/var/spool/scm/repository.svn/ball-tv/trunk/src/main/java/ball/tv/epg/repository/ScheduleRepository.java $ 007 * %% 008 * Copyright (C) 2013 - 2020 Allen D. Ball 009 * %% 010 * Licensed under the Apache License, Version 2.0 (the "License"); 011 * you may not use this file except in compliance with the License. 012 * You may obtain a copy of the License at 013 * 014 * http://www.apache.org/licenses/LICENSE-2.0 015 * 016 * Unless required by applicable law or agreed to in writing, software 017 * distributed under the License is distributed on an "AS IS" BASIS, 018 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 019 * See the License for the specific language governing permissions and 020 * limitations under the License. 021 * ########################################################################## 022 */ 023import ball.tv.epg.entity.Schedule; 024import java.util.List; 025import java.util.Optional; 026import org.springframework.data.jpa.repository.JpaRepository; 027import org.springframework.data.jpa.repository.Query; 028import org.springframework.stereotype.Repository; 029import org.springframework.transaction.annotation.Transactional; 030 031/** 032 * {@link Schedule} {@link JpaRepository}. 033 * 034 * @author {@link.uri mailto:ball@hcf.dev Allen D. Ball} 035 * @version $Revision: 5285 $ 036 */ 037@Repository 038@Transactional(readOnly = true) 039public interface ScheduleRepository 040 extends JpaRepository<Schedule,Schedule.PK> { 041 @Transactional 042 public long deleteByStationIDAndAirDateTimeGreaterThanEqual(int stationID, long dateTime); 043 044 @Query("SELECT schedule.programID FROM #{#entityName} schedule") 045 public List<String> getAllProgramIDs(); 046 047 @Query("SELECT schedule FROM #{#entityName} schedule WHERE schedule.stationID = ?1 AND schedule.airDateTime <= ?2 AND ?2 < (schedule.airDateTime + schedule.duration)") 048 public Optional<Schedule> getSchedule(int stationID, long dateTime); 049}