mapperTemp

标签：mapperTemp int TIMESTAMP CURRENT flag threshold id

@Insert("INSERT INTO coxisolate.instanceinfo (instance_id, app_name, create_time, update_time, status, readiness_flag, isolate_flag, reason) " +
        "VALUES(#{instanceId}, #{appName}, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, #{status}, #{readinessFlag}, #{isolateFlag}, #{reason});")
int insert(IndicatorInfo indicatorInfo);

@Update("UPDATE coxisolate.instanceinfo " +
        "app_name=#{appName}, " +
        "update_time=CURRENT_TIMESTAMP, " +
        "status=#{status}, " +
        "readiness_flag=#{readinessFlag}, " +
        "isolate_flag=#{isolateFlag}, " +
        "reason=#{reason}" +
        "WHERE id=#{id};")
int updateById(IndicatorInfo indicatorInfo);

@Delete("DELETE FROM coxisolate.instanceinfo WHERE id=#{id};")
int deleteById(IndicatorInfo indicatorInfo);

@Insert("INSERT INTO coxisolate.indicatorconfig " +
        "(app_name, create_time, update_time, update_by, timeout_flag, timeout_threshold, exception_flag, exception_threshold, cpu_flag, cpu_threshold, memory_flag, memory_threshold, gc_flag, gc_threshold) " +
        "VALUES(#{appName}, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, #{updateBy}, #{timeoutFlag}, #{timeoutThreshold}, #{exceptionFlag}, #{exceptionThreshold}, #{cpuFlag}, #{cpuThreshold}, #{memoryFlag}, #{memoryThreshold}, #{gcFlag}, #{gcThreshold});")
int insert(IndicatorConfig indicatorConfig);

@Update("UPDATE coxisolate.indicatorconfig " +
        "update_time=CURRENT_TIMESTAMP, " +
        "update_by=#{updateBy}, " +
        "timeout_flag=#{timeoutFlag}, " +
        "timeout_threshold=#{timeoutThreshold}, " +
        "exception_flag=#{exceptionFlag}, " +
        "exception_threshold=#{exceptionThreshold}, " +
        "cpu_flag=#{cpuFlag}, " +
        "cpu_threshold=#{cpuThreshold}, " +
        "memory_flag=#{memoryFlag}, " +
        "memory_threshold=#{memoryThreshold}, " +
        "gc_flag=#{gcFlag}, " +
        "gc_threshold=#{gcThreshold} " +
        "WHERE id=#{id};")
int updateById(IndicatorConfig indicatorConfig);

@Delete("DELETE FROM coxisolate.indicatorconfig WHERE id=#{id};")
int deleteById(IndicatorConfig indicatorConfig);

@Insert("INSERT INTO coxisolate.applicationuser " +
        "(app_name, user_id, create_time, update_time) " +
        "VALUES(#{appName}, #{userId}, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);\n")
int insert(ApplicationUser applicationUser);

@Update("UPDATE coxisolate.applicationuser " +
        "SET user_id=#{userId}, " +
        "SET update_time=CURRENT_TIMESTAMP, " +
        "WHERE id=#{id};")
int updateById(ApplicationUser applicationUser);

@Delete("DELETE FROM coxisolate.applicationuser WHERE id=#{id};")
int deleteById(ApplicationUser applicationUser);

 

标签：mapperTemp,int,TIMESTAMP,CURRENT,flag,threshold,id
From： https://www.cnblogs.com/huangshiyun/p/17420331.html