package com.tourguide.modules.user.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.tourguide.modules.user.entity.GuideScenicConfig;
|
import org.apache.ibatis.annotations.Insert;
|
import org.apache.ibatis.annotations.Update;
|
|
public interface GuideScenicConfigMapper extends BaseMapper<GuideScenicConfig> {
|
@Update("UPDATE guide_scenic_config SET deleted = 1 WHERE guide_id = #{guideId} AND deleted = 0")
|
int markDeletedByGuideId(Long guideId);
|
|
@Insert("INSERT INTO guide_scenic_config (guide_id, scenic_name, city_name, deleted) " +
|
"VALUES (#{guideId}, #{scenicName}, #{cityName}, 0) " +
|
"ON DUPLICATE KEY UPDATE city_name = VALUES(city_name), deleted = 0")
|
int upsert(GuideScenicConfig config);
|
}
|
