package ru.fsep.abacus.repositories;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import ru.fsep.abacus.dto.ClassroomDto;
import ru.fsep.abacus.models.Classroom;
import ru.fsep.abacus.models.User;

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

/**
 * 25.08.2017
 *
 * @author Marsel Sidikov (First Software Engineering Platform)
 * @version 1.0
 */
public interface ClassroomsRepository extends JpaRepository<Classroom, Long> {
    @Query(nativeQuery = true)
    List<Classroom> findAllByPartnerCreatorId(@Param("param1")long partnerCreatorId);

    @Query(nativeQuery = true)
    List<Classroom> findAll();

    List<Classroom> findAllByPartnerCreator(User partner);

    Optional<Classroom> findOneByClassTitle(String classTitle);
}