package com.example.demo.repository;

import java.util.List;
import java.util.UUID;

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

import com.example.demo.entity.AdunitDeal;

public interface AdunitDealRepository extends JpaRepository<AdunitDeal,UUID>{
	
	@Query(nativeQuery=true,value="SELECT * FROM app_deal_adunit_assoc WHERE adunit_id= :adunit_id")
	List<AdunitDeal> findbyadunitid(@Param ("adunit_id") UUID adunit_id);

	@Query(nativeQuery=true,value="SELECT * FROM app_deal_adunit_assoc WHERE adunit_id = :adunit_id AND deal_id = :deal_id")
	AdunitDeal findbyadunitanddeal(@Param ("adunit_id") UUID adunit_id,@Param ("deal_id") UUID deal_id);
}