• Home
• io.mosip.compliance
• compliance-toolkit-batch-job
• 1.4.0
• source code
• TestRunDetailsArchiveRepository.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.compliance.toolkit.batchjob.repository.TestRunDetailsArchiveRepository Maven / Gradle / Ivy

package io.mosip.compliance.toolkit.batchjob.repository;

import javax.transaction.Transactional;

import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import io.mosip.compliance.toolkit.batchjob.entity.TestRunDetailsArchiveEntity;
import io.mosip.compliance.toolkit.batchjob.entity.TestRunDetailsPK;
import io.mosip.kernel.core.dataaccess.spi.repository.BaseRepository;

@Repository("TestRunDetailsArchiveRepository")
public interface TestRunDetailsArchiveRepository extends BaseRepository {

	
	@Modifying
	@Transactional
	@Query(value = "INSERT INTO toolkit.test_run_details (SELECT * FROM toolkit.test_run_details_archive trd WHERE trd.run_id = ?1)", nativeQuery = true)
	public void revertCopyTestRunDetailsToArchive(String runId);
	
	@Modifying
	@Transactional
	@Query("DELETE FROM TestRunDetailsArchiveEntity e WHERE e.runId = ?1")
	public void deleteById(String runId);
	
}