<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="io.dataease.base.mapper.ext.ExtPluginSysMenuMapper">

    <delete id="deletePluginMenu">
        delete from plugin_sys_menu
    </delete>

    <insert id="savePluginMenu">
        INSERT INTO `plugin_sys_menu` ( menu_id, title, pid, sub_count, permission, hidden ) VALUES
        <foreach collection="menuList" item="menu" index="index" separator=",">
            (#{menu.menuId},#{menu.title},#{menu.pid},#{menu.subCount},#{menu.permission},#{menu.hidden})
        </foreach>
    </insert>


</mapper>
