RawSourceCcJudgmentRepository.java

package pl.edu.icm.saos.persistence.repository;

import java.util.List;

import org.joda.time.DateTime;
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 pl.edu.icm.saos.persistence.model.importer.RawSourceCcJudgment;

/**
 * @author Łukasz Dumiszewski
 */

public interface RawSourceCcJudgmentRepository extends JpaRepository<RawSourceCcJudgment, Long> {

    
    RawSourceCcJudgment findOneBySourceIdAndDataMd5(String sourceId, String dataMd5);
    
    
    @Query("select max(rJudgment.publicationDate) from RawSourceCcJudgment rJudgment")
    DateTime findMaxPublicationDate();
    
    /**
     * Finds all {@link RawSourceCcJudgment}s that are not marked as processed ({@link RawSourceCcJudgment#isProcessed()})
     */
    @Query("select rJudgment from RawSourceCcJudgment rJudgment where rJudgment.processed=false order by publicationDate, id")
    Page<RawSourceCcJudgment> findNotProcessed(Pageable pageable);
    
    List<RawSourceCcJudgment> findBySourceIdAndProcessed(String sourceJudgmentId, boolean processed);
    
}