com.didiglobal.logi.job.mapper.LogIJobMapper Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of logi-job-spring-boot-starter Show documentation

logi-job 提供分布式的定时调度服务

There is a newer version: 1.0.31

Show newest version

package com.didiglobal.logi.job.mapper;

import com.didiglobal.logi.job.common.po.LogIJobPO;

import java.util.List;

import org.apache.ibatis.annotations.*;

/**
 * 
 * 正在执行的job信息 Mapper 接口.
 * 
 *
 * @author ds
 * @since 2020-11-10
 */
@Mapper
public interface LogIJobMapper {

    @Delete("delete from logi_job where job_code=#{code}")
    int deleteByCode(String code);

    @Insert("INSERT INTO logi_job(job_code, task_code, class_name, try_times, worker_code, start_time, "
            + "create_time, update_time, app_name) VALUES(#{jobCode}, #{taskCode}, #{className}, #{tryTimes}, "
            + "#{workerCode}, #{startTime}, #{createTime}, #{updateTime}, #{appName})")
    int insert(LogIJobPO logIJobPO);

    @Select("select id, job_code, task_code, class_name, try_times, worker_code, start_time, create_time,"
            + " update_time, app_name from logi_job")
    List selectAll();

    @Select("select id, job_code, task_code, class_name, try_times, worker_code, start_time, create_time,"
            + " update_time, app_name from logi_job where app_name=#{appName}")
    List selectByAppName(@Param("appName") String appName);


    @Select("select id, job_code, task_code, class_name, try_times, worker_code, start_time, create_time,"
            + " update_time, app_name from logi_job where job_code=#{JobCode} and app_name=#{appName}")
    LogIJobPO selectByCode(@Param("code") String code, @Param("appName") String appName);

}