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}")
    List<APITestResultVO> selectByPipelineRecordId(Integer recordId);
}