duke-encounters/src/main/java/de/dominikschadow/dukeencounters/encounter/EncounterRepository.java
/*
* Copyright (C) 2016 Dominik Schadow, dominikschadow@gmail.com
*
* This file is part of the Application Intrusion Detection project.
*
* 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 de.dominikschadow.dukeencounters.encounter;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import java.util.List;
/**
* JPA repository class to access {@link Encounter}s.
*
* @author Dominik Schadow
*/
public interface EncounterRepository extends JpaRepository<Encounter, Long>, JpaSpecificationExecutor {
@Query(value = "select e from Encounter e")
List<Encounter> findWithPageable(Pageable latestTen);
@Query(value = "select e from Encounter e, DukeEncountersUser u where e.user = u.id and u.username = :username "
+ "order by e.date desc ")
List<Encounter> findAllByUsername(@Param("username") String username);
@Query(value = "select e from Encounter e, DukeEncountersUser u where e.user = u.id and u.username = :username "
+ "and e.id = :encounterId")
Encounter findByIdAndUsername(@Param("encounterId") long encounterId, @Param("username") String username);
List<Encounter> findByEventContaining(String event);
}