content: package com.sky.mapper;
  
  import com.sky.entity.SetmealDish;
  import org.apache.ibatis.annotations.Delete;
  import org.apache.ibatis.annotations.Mapper;
  import org.apache.ibatis.annotations.Select;
  
  import java.util.List;
  
  /**
   * @version 1.0
   * @Author Imak
   * @Date 2024/8/7 16:53
   * @菜品和套餐的关系表
   */
  @Mapper
  public interface SetmealDishMapper {
      /**
       * 根据菜品id查询对应的套餐id
       * @param dishIds
       * @return
       */
      //select setmeal_id from setmeal_dish where dish_id in (1,2,3,4)
      List<Long> getSetmealIdsByDishIds(List<Long> dishIds);
  
      /**
       * 批量插入套餐的菜品
       * @param setmealDishList
       */
      void insertBatch(List<SetmealDish> setmealDishList);
  
      /**
       * 根据套餐id删除套餐和菜品的关联关系
       * @param setmealId
       */
      @Delete("delete from setmeal_dish where setmeal_id = #{setmealId}")
      void deleteBySetmealId(Long setmealId);
  
      /**
       * 根据套餐id查询套餐和菜品的关联关系
       * @param setmealId
       * @return
       */
      @Select("select * from setmeal_dish where setmeal_id = #{setmealId}")
      List<SetmealDish> getBySetmealId(Long setmealId);
  }