package com.fd.repository;

import com.fd.entity.FileEntity;
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.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * Created by Owen on 2019/10/28 0028 11:36
 *
 * JpaSpecificationExecutor 条件分页查询
 */
public interface FileRepository extends JpaRepository<FileEntity, Long>, JpaSpecificationExecutor<FileEntity> {

    // 条件分页查询
    Page<FileEntity> findByType(String type, Pageable pageable);

    @Query(value = "select r from FileEntity r where r.type=?1 or r.type =?2")
    Page<FileEntity> findByType(String type, String type1, Pageable pageable);

    List<FileEntity> findByFileName(String fileName);

    List<FileEntity> findByFileNameAndType(String fileName, String type);

    List<FileEntity> findByDirectory(String directory);
}