package kr.wisestone.owl.repository;

import kr.wisestone.owl.domain.ProjectRole;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

public interface ProjectRoleRepository extends JpaRepository<ProjectRole, Long> {
    ProjectRole findByProjectId(@Param("projectId") Long projectId);

    ProjectRole findByProjectIdAndRoleType(@Param("projectId") Long projectId, @Param("roleType") String roleType);

    @Query(name="ProjectRole.findByUserIdAndProjectId")
    ProjectRole findByUserIdAndProjectId(@Param("userId") Long userId, @Param("projectId") Long projectId);
}