1 package org.onap.nbi.apis.serviceorder.repositories;
3 import org.onap.nbi.apis.serviceorder.model.orchestrator.ExecutionTask;
4 import org.springframework.data.jpa.repository.Modifying;
5 import org.springframework.data.jpa.repository.Query;
6 import org.springframework.data.repository.CrudRepository;
7 import org.springframework.data.repository.query.Param;
8 import org.springframework.transaction.annotation.Propagation;
9 import org.springframework.transaction.annotation.Transactional;
10 import java.util.List;
12 public interface ExecutionTaskRepository extends CrudRepository<ExecutionTask, Long> {
14 @Query("SELECT t FROM ExecutionTask t WHERE TRIM(t.reliedTasks) LIKE '' ")
15 List<ExecutionTask> findByReliedTasksIsEmpty();
17 @Transactional(propagation = Propagation.REQUIRED, readOnly = false)
19 @Query("UPDATE ExecutionTask t SET t.reliedTasks = REPLACE(t.reliedTasks, :internalId, '') WHERE t.reliedTasks "
20 + "LIKE CONCAT('%', :internalId, '%')")
21 void updateReliedTaskAfterDelete(@Param("internalId") Long internalId);
23 @Query("SELECT t FROM ExecutionTask t WHERE t.reliedTasks LIKE CONCAT('%', :internalId, '%')")
24 List<ExecutionTask> findTasksReliedToAnOrderItemId(@Param("internalId") Long internalId);