package com.dy.pipIrrGlobal.daoRm;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dy.pipIrrGlobal.pojoUg.UgRtuProgram;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

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

/**
 * @Author: liurunyu
 * @Date: 2024/11/5 8:52
 * @Description
 */
@Mapper
public interface UgRtuProgramMapper extends BaseMapper<UgRtuProgram> {

    /**
     * 逻辑删除
     * @param id primaryKey
     * @return update count
     */
    int deleteLogicById(Long id);

    /**
     * delete by primary key
     * @param id primaryKey
     * @return deleteCount
     */
    int deleteByPrimaryKey(Long id);

    /**
     * insert record to table
     * @param record the record
     * @return insert count
     */
    int insert(UgRtuProgram record);

    /**
     * insert record to table selective
     * @param record the record
     * @return insert count
     */
    int insertSelective(UgRtuProgram record);

    /**
     * select by primary key
     * @param id primary key
     * @return object by primary key
     */
    UgRtuProgram selectByPrimaryKey(Long id);


    /**
     * 查询总数
     * @param params 查询条件
     * @return 总数
     * */
    Long selectTotal(Map<?,?> params);

    /**
     * 分页查询一些
     * @param params 查询条件
     * @return 实体集合
     * */
    List<UgRtuProgram> selectSome(Map<?,?> params) ;


    /**
     * 得到所有升级程序记录ID和文件名称
     * @return 实体集合
     * */
    List<UgRtuProgram> selectAll() ;
    /**
     * 查询数据库，是否存在给定升级文件名称
     * @param programFileName 文件名称
     * @return bool
     */
    Long selectByFileName(@Param("programFileName") String programFileName) ;

    /**
     * update record selective
     * @param record the updated record
     * @return update count
     */
    int updateByPrimaryKeySelective(UgRtuProgram record);

    /**
     * update record
     * @param record the updated record
     * @return update count
     */
    int updateByPrimaryKey(UgRtuProgram record);
}