data-analysis/server/src/main/java/edp/davinci/dao/DataRulesMapper.java

package edp.davinci.dao;

import edp.davinci.model.DataRules;
import edp.davinci.model.DataSubject;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Component;

import java.util.List;

@Component
public interface DataRulesMapper
{
    int insert(DataRules dataRules);

    @Delete({"delete from `data_rules` where id = #{id}"})
    int deleteById(@Param("id") Long id);

    @Update({
            "update `dict_type`",
            "set `dict_name` = #{dictName,jdbcType=VARCHAR},",
            "`dict_type` = #{dictType,jdbcType=VARCHAR},",
            "`status` = #{status,jdbcType=BIGINT},",
            "`remark` = #{remark,jdbcType=VARCHAR},",
            "`update_by` = #{updateBy,jdbcType=BIGINT},",
            "`update_time` = #{updateTime,jdbcType=TIMESTAMP}",
            "where dict_id = #{dictId,jdbcType=BIGINT}"
    })
    int update(DataRules dataRules);


    @Select({"select * from `data_rules`"})
    List<DataSubject> getDataRulesList();
}