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);
}