package com.mzl.flower.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.mzl.flower.domain.CategoryConfigDO;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface CategoryConfigMapper extends BaseMapper<CategoryConfigDO> {

//    @Insert("INSERT INTO category_config( user_id, category_id, name, `order`, is_enabled) " + "VALUES( #{userId}, #{categoryId}, #{name}, #{order}, #{isEnabled})")
//    void insert(CategoryConfigDO categoryConfigDO);
//
//    @Update("UPDATE category_config SET name = #{name}, `order` = #{order}, " + "is_enabled = #{isEnabled} WHERE id = #{id}")
//    void update(CategoryConfigDO categoryConfigDO);

//    @Select("SELECT * FROM category_config WHERE id = #{id}")
//    CategoryConfigDO findById(Long id);

    @Select("SELECT * FROM category_config WHERE user_id = #{userId}")
    List<CategoryConfigDO> findByUserId(String userId);

    @Delete("DELETE FROM category_config WHERE user_id = #{userId}")
    void deleteByUserId(String userId);
}