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

Go to download
package com.didiglobal.logi.job.mapper;

import com.didiglobal.logi.job.common.po.LogIWorkerPO;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * 
 * worker信息 Mapper 接口.
 * 
 *
 * @author ds
 * @since 2020-11-10
 */
@Mapper
public interface LogIWorkerMapper {

    @Insert("INSERT INTO logi_worker(worker_code, worker_name, ip, cpu, cpu_used, memory, memory_used, jvm_memory, "
            + "jvm_memory_used, job_num, heartbeat, app_name) "
            + "VALUES(#{workerCode}, #{workerName}, #{ip}, #{cpu}, #{cpuUsed}, "
            + "#{memory}, #{memoryUsed}, #{jvmMemory}, #{jvmMemoryUsed}, #{job_num}, #{heartbeat}, #{appName})")
    int insert(LogIWorkerPO logIWorkerPO);

    @Update("INSERT INTO logi_worker(worker_code, worker_name, ip, cpu, cpu_used, memory, memory_used, jvm_memory, "
            + "jvm_memory_used, job_num, heartbeat, app_name) "
            + "VALUES(#{workerCode}, #{workerName}, #{ip}, #{cpu}, #{cpuUsed}, "
            + "#{memory}, #{memoryUsed}, #{jvmMemory}, #{jvmMemoryUsed}, #{jobNum}, #{heartbeat}, #{appName}) "
            + "ON DUPLICATE KEY UPDATE cpu=#{cpu}, worker_name=#{workerName}, ip=#{ip}, cpu_used=#{cpuUsed}, "
            + "memory=#{memory}, memory_used=#{memoryUsed}, jvm_memory=#{jvmMemory}, "
            + "jvm_memory_used=#{jvmMemoryUsed}, job_num=#{jobNum}, heartbeat=#{heartbeat}, app_name=#{appName}")
    int saveOrUpdateById(LogIWorkerPO logIWorkerPO);

    @Delete("delete from logi_worker where worker_code=#{workerCode}")
    int deleteByCode(@Param("workerCode") String code);

    @Select("select worker_code, worker_name, ip, cpu, cpu_used, memory, memory_used, jvm_memory,"
            + "jvm_memory_used, job_num, heartbeat, app_name, update_time from logi_worker where app_name=#{appName}")
    List selectByAppName(@Param("appName") String appName);

    @Select("select count(1) from logi_worker where app_name=#{appName}")
    int countByAppName(@Param("appName") String appName);
}