l1024-jav/src/main/java/top/lvzhiqiang/mapper/CrawlerIkoaDownloadLogMapper.java

package top.lvzhiqiang.mapper;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Select;
import top.lvzhiqiang.entity.CrawlerIkoaDownloadLog;

import java.util.List;
import java.util.Map;

/**
 * 爬虫IKOA下载记录表Mapper
 *
 * @author lvzhiqiang
 * 2022/10/10 15:37
 */
public interface CrawlerIkoaDownloadLogMapper {

    /**
     * 删除所有
     */
    @Delete("DELETE FROM crawler_ikoa_downloadlog where 1=1")
    void deleteAll();

    /**
     * 批量新增
     *
     * @param crawlerIkoaDownloadLogList
     */
    @Insert({"<script>" +
            "INSERT INTO crawler_ikoa_downloadlog(cid, package_image, ua, status, create_time, modify_time) " +
            "VALUES " +
            "<foreach collection='list' item='cidl' index=\"index\" separator=\",\">" +
            "   (#{cidl.cid}, #{cidl.packageImage}, #{cidl.ua}, #{cidl.status}, #{cidl.createTime}, #{cidl.modifyTime})" +
            " </foreach>" +
            "</script>"})
    int insertList(List<CrawlerIkoaDownloadLog> crawlerIkoaDownloadLogList);

    /**
     * 新增
     *
     * @param crawlerIkoaDownloadLog
     */
    @Insert("INSERT INTO crawler_ikoa_downloadlog(cid, package_image, ua, status, create_time, modify_time) " +
            "VALUES (#{cid}, #{packageImage}, #{ua}, #{status}, #{createTime}, #{modifyTime})")
    @Options(useGeneratedKeys = true, keyProperty = "id", keyColumn = "id")
    int insert(CrawlerIkoaDownloadLog crawlerIkoaDownloadLog);

    /**
     * 查询所有
     */
    @Select("SELECT * FROM crawler_ikoa_downloadlog WHERE delete_flag = 1")
    List<CrawlerIkoaDownloadLog> findAll();

    /**
     * 查询最新的一条
     */
    @Select("SELECT * FROM crawler_ikoa_downloadlog WHERE delete_flag = 1 order by create_time desc limit 1")
    CrawlerIkoaDownloadLog findLatestInfo();

    @Select({"<script>" +
            "select * from crawler_ikoa_downloadlog WHERE delete_flag = 1" +
            "<if test=\"keyword != null and keyword != ''\">" +
            "   and cid like concat('%',#{keyword},'%')" +
            "</if>" +
            "<if test=\"order != null and order != ''\">" +
            "   order by ${orderField} ${order}" +
            "</if>" +
            "</script>"})
    List<CrawlerIkoaDownloadLog> findIkoaDownloadLog4MultipleParams(Map<String, Object> params);
}