package ru.mcs.diary.subject;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Optional;

@Repository
public interface SubjectRepository extends JpaRepository<Subject, Long> {

    List<Subject> findAllByTeacherIdOrderByNameAsc(Long teacherId);

    Optional<Subject> findByIdAndTeacherId(Long id, Long teacherId);

    boolean existsByNameAndTeacherId(String name, Long teacherId);

    long countByTeacherId(Long teacherId);
}