| | |
| | | import cn.iocoder.yudao.framework.common.pojo.PageResult; |
| | | import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX; |
| | | import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX; |
| | | import cn.iocoder.yudao.framework.mybatis.core.query.QueryWrapperX; |
| | | import cn.iocoder.yudao.module.ai.controller.admin.model.vo.apikey.AiApiKeyPageReqVO; |
| | | import cn.iocoder.yudao.module.ai.dal.dataobject.model.AiApiKeyDO; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | |
| | | /** |
| | | * AI API 密钥 Mapper |
| | | * |
| | | * @author 芋道源码 |
| | | */ |
| | | @Mapper |
| | | public interface AiApiKeyMapper extends BaseMapperX<AiApiKeyDO> { |
| | | |
| | | default PageResult<AiApiKeyDO> selectPage(AiApiKeyPageReqVO reqVO) { |
| | | return selectPage(reqVO, new LambdaQueryWrapperX<AiApiKeyDO>() |
| | | .likeIfPresent(AiApiKeyDO::getName, reqVO.getName()) |
| | | .eqIfPresent(AiApiKeyDO::getPlatform, reqVO.getPlatform()) |
| | | .eqIfPresent(AiApiKeyDO::getStatus, reqVO.getStatus()) |
| | | default AiApiKeyDO selectFirstByPlatformAndStatus(String platform, Integer status) { |
| | | return selectOne(new LambdaQueryWrapperX<AiApiKeyDO>() |
| | | .eq(AiApiKeyDO::getPlatform, platform) |
| | | .eq(AiApiKeyDO::getStatus, status) |
| | | .last("LIMIT 1")); |
| | | } |
| | | |
| | | default PageResult<AiApiKeyDO> selectPage(AiApiKeyPageReqVO pageReqVO) { |
| | | return selectPage(pageReqVO, new LambdaQueryWrapperX<AiApiKeyDO>() |
| | | .likeIfPresent(AiApiKeyDO::getName, pageReqVO.getName()) |
| | | .eqIfPresent(AiApiKeyDO::getPlatform, pageReqVO.getPlatform()) |
| | | .eqIfPresent(AiApiKeyDO::getStatus, pageReqVO.getStatus()) |
| | | .orderByDesc(AiApiKeyDO::getId)); |
| | | } |
| | | |
| | | default AiApiKeyDO selectFirstByPlatformAndStatus(String platform, Integer status) { |
| | | return selectOne(new QueryWrapperX<AiApiKeyDO>() |
| | | .eq("platform", platform) |
| | | .eq("status", status) |
| | | .limitN(1) |
| | | .orderByAsc("id")); |
| | | } |
| | | |
| | | } |
| | | } |