package com.tourguide.modules.system.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.tourguide.modules.system.entity.SystemRoleMenu;
|
import org.apache.ibatis.annotations.Insert;
|
import org.apache.ibatis.annotations.Update;
|
|
public interface SystemRoleMenuMapper extends BaseMapper<SystemRoleMenu> {
|
@Update("UPDATE sys_role_menu SET deleted = 1 WHERE role_id = #{roleId} AND deleted = 0")
|
int markDeletedByRoleId(Long roleId);
|
|
@Insert("INSERT INTO sys_role_menu (role_id, menu_id, deleted) VALUES (#{roleId}, #{menuId}, 0) " +
|
"ON DUPLICATE KEY UPDATE deleted = 0")
|
int upsert(SystemRoleMenu relation);
|
}
|
