───────┬────────────────────────────────────────────────────────────────────────
       File: src/main//java/jp/ac/kobe_u/cs/itspecialist/todoapp/repository/ToDoRepository.java
───────┼────────────────────────────────────────────────────────────────────────
   1    package jp.ac.kobe_u.cs.itspecialist.todoapp.repository;
   2    
   3    import java.util.List;
   4    
   5    import org.springframework.data.domain.Page;
   6    import org.springframework.data.domain.Pageable;
   7    import org.springframework.data.repository.CrudRepository;
   8    import org.springframework.stereotype.Repository;
   9    
  10    import jp.ac.kobe_u.cs.itspecialist.todoapp.entity.ToDo;
  11    
  12    @Repository
  13    public interface ToDoRepository extends CrudRepository<ToDo, Long> {
  14        Page<ToDo> findAll(Pageable pageable);
  15        Page<ToDo> findByDone(boolean done, Pageable pageable);
  16        Page<ToDo> findByMid(String mid, Pageable pageable);
  17        Page<ToDo> findByMidAndDone(String mid, boolean done, Pageable pageable);
  18    
  19        // ソート機能を追加する.
  20        Page<ToDo> findByDoneOrderBySeqAsc(boolean done, Pageable pageable);
  21        Page<ToDo> findByDoneOrderBySeqDesc(boolean done, Pageable pageable);
  22        Page<ToDo> findByDoneOrderByTitleAsc(boolean done, Pageable pageable);
  23        Page<ToDo> findByDoneOrderByTitleDesc(boolean done, Pageable pageable);
  24        Page<ToDo> findByDoneOrderByMidAsc(boolean done, Pageable pageable);
  25        Page<ToDo> findByDoneOrderByMidDesc(boolean done, Pageable pageable);
  26        Page<ToDo> findByDoneOrderByCreatedAtAsc(boolean done, Pageable pageable);
  27        Page<ToDo> findByDoneOrderByCreatedAtDesc(boolean done, Pageable pageable);
  28        Page<ToDo> findByDoneOrderByDoneAtAsc(boolean done, Pageable pageable);
  29        Page<ToDo> findByDoneOrderByDoneAtDesc(boolean done, Pageable pageable);
  30        Page<ToDo> findByDoneOrderByDueAtAsc(boolean done, Pageable pageable);
  31        Page<ToDo> findByDoneOrderByDueAtDesc(boolean done, Pageable pageable);
  32    
  33        Page<ToDo> findByMidAndDoneOrderBySeqAsc(String mid, boolean done, Pageable pageable);
  34        Page<ToDo> findByMidAndDoneOrderBySeqDesc(String mid, boolean done, Pageable pageable);
  35        Page<ToDo> findByMidAndDoneOrderByTitleAsc(String mid, boolean done, Pageable pageable);
  36        Page<ToDo> findByMidAndDoneOrderByTitleDesc(String mid, boolean done, Pageable pageable);
  37        Page<ToDo> findByMidAndDoneOrderByCreatedAtAsc(String mid, boolean done, Pageable pageable);
  38        Page<ToDo> findByMidAndDoneOrderByCreatedAtDesc(String mid, boolean done, Pageable pageable);
  39        Page<ToDo> findByMidAndDoneOrderByDoneAtAsc(String mid, boolean done, Pageable pageable);
  40        Page<ToDo> findByMidAndDoneOrderByDoneAtDesc(String mid, boolean done, Pageable pageable);
  41        Page<ToDo> findByMidAndDoneOrderByDueAtAsc(String mid, boolean done, Pageable pageable);
  42        Page<ToDo> findByMidAndDoneOrderByDueAtDesc(String mid, boolean done, Pageable pageable);
  43    }
───────┴────────────────────────────────────────────────────────────────────────