package com.dacrt.SBIABackend.repository;

import javax.transaction.Transactional;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;
import com.dacrt.SBIABackend.entity.Externalreqs;


@Repository
public interface ExternalreqsRepository extends JpaRepository<Externalreqs,Integer>,JpaSpecificationExecutor<Externalreqs>{

	@Transactional
	@Modifying
	@Query(" DELETE FROM Externalreqs e where e.id = ?1 ")
	void deleteExternalreqsbyid(Integer id);
}