Package com.alibaba.cloud.ai.mapper

Interface DatasourceMapper

All Superinterfaces:
com.baomidou.mybatisplus.core.mapper.BaseMapper<Datasource>, com.baomidou.mybatisplus.core.mapper.Mapper<Datasource>
@Mapper public interface DatasourceMapper extends com.baomidou.mybatisplus.core.mapper.BaseMapper<Datasource>
数据源 Mapper 接口
Author:
Alibaba Cloud AI

  • Method Summary

    Modifier and Type
    Method
    Description
    List<Datasource>
    selectByStatus(String status)
    根据状态查询数据源列表
    List<Datasource>
    selectByType(String type)
    根据类型查询数据源列表
    List<Map<String,Object>>
    selectStatusStats()
    获取数据源统计信息 - 按状态统计
    List<Map<String,Object>>
    selectTestStatusStats()
    获取数据源统计信息 - 按测试状态统计
    List<Map<String,Object>>
    selectTypeStats()
    获取数据源统计信息 - 按类型统计

    Methods inherited from interface com.baomidou.mybatisplus.core.mapper.BaseMapper

    delete, deleteBatchIds, deleteById, deleteById, deleteById, deleteByIds, deleteByIds, deleteByMap, exists, insert, insert, insert, insertOrUpdate, insertOrUpdate, insertOrUpdate, insertOrUpdate, insertOrUpdate, selectBatchIds, selectBatchIds, selectById, selectByIds, selectByIds, selectByMap, selectByMap, selectCount, selectList, selectList, selectList, selectList, selectMaps, selectMaps, selectMaps, selectMaps, selectMapsPage, selectObjs, selectObjs, selectOne, selectOne, selectPage, update, update, updateById, updateById, updateById

  • Method Details

    • selectByStatus

      @Select("SELECT * FROM datasource WHERE status = #{status} ORDER BY create_time DESC") List<Datasource> selectByStatus(@Param("status") String status)
      根据状态查询数据源列表

    • selectByType

      @Select("SELECT * FROM datasource WHERE type = #{type} ORDER BY create_time DESC") List<Datasource> selectByType(@Param("type") String type)
      根据类型查询数据源列表

    • selectStatusStats

      @Select("SELECT status, COUNT(*) as count FROM datasource GROUP BY status") List<Map<String,Object>> selectStatusStats()
      获取数据源统计信息 - 按状态统计

    • selectTypeStats

      @Select("SELECT type, COUNT(*) as count FROM datasource GROUP BY type") List<Map<String,Object>> selectTypeStats()
      获取数据源统计信息 - 按类型统计

    • selectTestStatusStats

      @Select("SELECT test_status, COUNT(*) as count FROM datasource GROUP BY test_status") List<Map<String,Object>> selectTestStatusStats()
      获取数据源统计信息 - 按测试状态统计