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}