• Home
• io.mosip.pms
• pms-common
• 1.1.5.4
• source code
• AuthPolicyRepository.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.AuthPolicyRepository 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 org.springframework.stereotype.Repository;

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

@Repository
public interface AuthPolicyRepository extends JpaRepository{

	@Query(value = "select * from auth_policy ap where ap.policy_group_id=?1 and ap.name = ?2",nativeQuery = true)
	AuthPolicy findByPolicyGroupAndName(String policyGroupId, String name);
	
	@Query(value = "select * from auth_policy ap where ap.policy_group_id=?1 and ap.id = ?2",nativeQuery = true)
	AuthPolicy findByPolicyGroupAndId(String policyGroupId, String policyId);
	
	@Query(value = "select * from auth_policy ap where ap.policy_group_id=?", nativeQuery = true)
	List findByPolicyGroupId(String policyId);
	
	AuthPolicy findByName(String name);

}