/*
 *  (C) Copyright 2017 TheOtherP (theotherp@posteo.net)
 *
 *  Licensed under the Apache License, Version 2.0 (the "License");
 *  you may not use this file except in compliance with the License.
 *  You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 *  Unless required by applicable law or agreed to in writing, software
 *  distributed under the License is distributed on an "AS IS" BASIS,
 *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *  See the License for the specific language governing permissions and
 *  limitations under the License.
 */

package org.nzbhydra.searching.db;


import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;

public interface SearchRepository extends JpaRepository<SearchEntity, Integer> {

    @Query("select t from SearchEntity t where t.username = :username and t.source = 'INTERNAL' order by t.time desc")
    Page<SearchEntity> findForUserSearchHistory(@Param("username") String username, Pageable pageable);

    @Query("select t from SearchEntity t where t.source = 'INTERNAL' order by t.time desc")
    Page<SearchEntity> findForUserSearchHistory(Pageable pageable);

    List<SearchEntity> findAllByTitle(String title);
}
