seecoder-devcloud/web/src/main/java/cn/seecoder/web/dao/apitest/ApiTestMapper.java

package cn.seecoder.web.dao.apitest;

import cn.seecoder.web.model.vo.apitest.ApiTestResultVO;
import org.apache.ibatis.annotations.*;
import cn.seecoder.web.dao.provider.GeneralInsertUpdateSqlProvider;
import cn.seecoder.web.model.po.apitest.TestInfo;
import cn.seecoder.web.model.po.apitest.TestResult;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author zhaoxingrui
 * @date 2021/3/20
 * @description:
 */
@Repository
public interface ApiTestMapper {

    @InsertProvider(type = GeneralInsertUpdateSqlProvider.class, method = "insert")
    @Options(useGeneratedKeys = true, keyProperty = "param1.testId")
    boolean insert(TestInfo testInfo, String... ignoredCols);

    @Select("select * from test_info where project_id = #{id}")
    List<TestInfo> selectByProjectId(Integer id);

    @Select("select * from test_info where test_id = #{id}")
    TestInfo selectByTestId(Integer id);

    @Delete("delete from test_info where test_id = #{id}")
    boolean delete(Integer id);

    @InsertProvider(type = GeneralInsertUpdateSqlProvider.class, method = "insert")
    @Options(useGeneratedKeys = true, keyProperty = "param1.id")
    boolean execute(TestResult testResult, String... ignoredCols);

    @Select("select * from test_result where test_id = #{testId} and pipeline_record_id = #{pipelineRecordId}")
    List<TestResult> selectTestResultByTestId(@Param("testId") Integer testId,@Param("pipelineRecordId") Integer pipelineRecordId);

    @Delete("delete from test_result where test_id = #{id}")
    boolean deleteTestResult(Integer id);

    @Select("select * from test_result where test_id = #{testId} and pipeline_record_id = #{pipelineRecordId} order by id DESC LIMIT 0,1")
    TestResult selectLatestTestResultById(@Param("testId") Integer testId,@Param("pipelineRecordId") Integer pipelineRecordId);

    @Select("select * from test_result where pipeline_record_id = #{recordId} and test_id = #{testId}")
    List<ApiTestResultVO> selectByPipelineRecordId(@Param("recordId") Integer recordId, @Param("testId") Integer testId);
}