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