package com.genersoft.iot.vmp.storager.dao;

import com.genersoft.iot.vmp.storager.dao.dto.Role;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface RoleMapper {

    @Insert("INSERT INTO wvp_user_role (name, authority, create_time, update_time) VALUES" +
            "(#{name}, #{authority}, #{createTime}, #{updateTime})")
    int add(Role role);

    @Update(value = {" <script>" +
            "UPDATE wvp_user_role " +
            "SET update_time=#{updateTime} " +
            "<if test=\"name != null\">, name=#{name}</if>" +
            "<if test=\"authority != null\">, authority=#{authority}</if>" +
            "WHERE id != 1 and id=#{id}" +
            " </script>"})
    int update(Role role);

    @Delete("DELETE from wvp_user_role WHERE  id != 1 and id=#{id}")
    int delete(int id);

    @Select("select * from wvp_user_role WHERE id=#{id}")
    Role selectById(int id);

    @Select("select * from wvp_user_role")
    List<Role> selectAll();
}