package io.delphiplatform.api.v3.rdb.repository;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;

import io.delphiplatform.api.v3.rdb.entity.ParticipantEntity;
import io.delphiplatform.api.v3.rdb.entity.ParticipantId;

public interface ParticipantRepository extends JpaRepository<ParticipantEntity, ParticipantId> {

    @Query("select p from participant p where p.participantId.artist.artistId = :artistId "
        + " and p.membershipType = 'Primary'")
    List<ParticipantEntity> findPrimaryByArtistId(@Param("artistId") String artistId);

    @Query("select p from participant p where p.participantId.participantId = :participantId "
        + " and p.membershipType = 'Primary'")
    List<ParticipantEntity> findPrimaryByParticipantId(@Param("participantId") String participantId);
}