com.chutneytesting.execution.infra.storage.DatabaseExecutionJpaRepository Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of server Show documentation
The newest version!
/*
 * SPDX-FileCopyrightText: 2017-2024 Enedis
 *
 * SPDX-License-Identifier: Apache-2.0
 *
 */

package com.chutneytesting.execution.infra.storage;

import com.chutneytesting.execution.infra.storage.jpa.ScenarioExecutionEntity;
import com.chutneytesting.server.core.domain.execution.report.ServerReportStatus;
import jakarta.persistence.Tuple;
import java.util.List;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

public interface DatabaseExecutionJpaRepository extends JpaRepository, JpaSpecificationExecutor {

    List findByStatus(ServerReportStatus status);

    List findByScenarioIdOrderByIdDesc(String scenarioId);

    /**
     * Finds the last executions with the specified status if available, otherwise the last executions.
     *
     * @param scenarioIds A list of scenario IDs to filter the executions by.
     * @param status      The status to filter the executions by.
     * @return A list of tuples representing the last execution id and the scenario id.
     */
    @Query("""
            SELECT
                CASE
                    WHEN EXISTS (SELECT 1 FROM SCENARIO_EXECUTIONS se_tmp WHERE se_tmp.scenarioId = se.scenarioId AND se_tmp.status = :status)
                        THEN MAX(CASE WHEN se.status = :status THEN se.id END)
                    ELSE MAX(CASE WHEN se.status != 'NOT_EXECUTED' THEN se.id END)
                    END AS max_id,
                se.scenarioId
            FROM
                SCENARIO_EXECUTIONS se
            WHERE
                se.scenarioId IN :scenarioIds
            GROUP BY
                se.scenarioId
            """)
        List findLastByStatusAndScenariosIds(@Param("scenarioIds") List scenarioIds, @Param("status")  ServerReportStatus status);

    List findAllByScenarioId(String scenarioId);

    @Query(value = """
                select se from SCENARIO s, SCENARIO_EXECUTIONS_REPORTS ser
                  inner join ser.scenarioExecution se
                where s.activated = true
                  and cast(s.id as string) = se.scenarioId
                  and ser.scenarioExecutionId in (:executionsIds)
                order by se.id desc
        """)
    List getExecutionReportByIds(@Param("executionsIds") List executionsIds);
}