• Home
• io.mosip.pms
• partner-management-service
• 1.3.0-dp.1
• source code
• SecureBiometricInterfaceRepository.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.device.authdevice.repository.SecureBiometricInterfaceRepository Maven / Gradle / Ivy

package io.mosip.pms.device.authdevice.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.device.authdevice.entity.SecureBiometricInterface;

@Repository
public interface SecureBiometricInterfaceRepository extends JpaRepository{
	@Query(value ="select * from  secure_biometric_interface d where d.id = ?1 AND (d.is_deleted is null or d.is_deleted = false)",nativeQuery = true)
	SecureBiometricInterface findByIdAndIsDeletedFalseOrIsDeletedIsNull(String id);
	
	@Query(value ="select * from  secure_biometric_interface d where d.id = ?1 AND (d.is_deleted is null or d.is_deleted = false) AND d.is_active=true",nativeQuery = true)
	SecureBiometricInterface findByIdAndIsDeletedFalseOrIsDeletedIsNullAndIsActiveTrue(String id);
	
	@Query(value = "select * from  secure_biometric_interface d where d.provider_id = ?1 AND d.sw_version=?2 AND (d.is_deleted is null or d.is_deleted = false)", nativeQuery = true)
	List findByProviderIdAndSwVersion(String providerId, String swversion);
}