• Home
• io.mosip.pms
• pms-common
• 1.1.5.4
• source code
• PartnerPolicyRequestRepository.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

io.mosip.pms.common.repository.PartnerPolicyRequestRepository Maven / Gradle / Ivy

package io.mosip.pms.common.repository;

import java.util.List;

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

import io.mosip.pms.common.entity.PartnerPolicyRequest;

public interface PartnerPolicyRequestRepository extends JpaRepository{
		
	@Query(value = "select * from partner_policy_request ppr where ppr.part_id=?", nativeQuery = true )
	List findByPartnerId(String part_id);

	@Query(value = "select * from partner_policy_request ppr where ppr.part_id=?1 and ppr.policy_id=?2", nativeQuery = true )
	List findByPartnerIdAndPolicyId(String partnerId, String policyId);
	
	@Query(value = "select * from partner_policy_request ppr where ppr.part_id=?1 and ppr.id=?2", nativeQuery = true )
	PartnerPolicyRequest findByPartnerIdAndReqId(String partnerId, String apikeyReqId);
	
	@Query(value = "select * from partner_policy_request ppr where ppr.part_id=?1 and ppr.policy_id=?2 and ppr.status_code=?3", nativeQuery = true )
	List findByPartnerIdAndPolicyIdAndStatusCode(String partnerId, String policyId, String status);
}