package com.qianwen.smartman.modules.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import java.util.List;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import com.qianwen.smartman.common.constant.CommonConstant;
import com.qianwen.smartman.modules.system.entity.MetaObjectType;
import com.qianwen.smartman.modules.system.entity.TableColumn;
import com.qianwen.smartman.modules.system.entity.TableDetail;
import com.qianwen.smartman.modules.system.vo.MetaObjectTypeVO;

/* loaded from: blade-api.jar:BOOT-INF/classes/org/springblade/modules/system/mapper/MetaObjectTypeMapper.class */
public interface MetaObjectTypeMapper extends BaseMapper<MetaObjectType> {
    List<MetaObjectTypeVO> selectMetaObjectTypePage(IPage page, MetaObjectTypeVO metaObjectType);

    @Select.List({@Select(value = {"select table_name as tableName, table_comment as tableComment from information_schema.`TABLES` where table_schema=#{database}"}, databaseId = "mysql"), @Select(value = {"select lower(a.table_name) as tableName , b.comments from dba_tables a, all_tab_comments b  where a.owner=#{database} and b.owner=#{database} and a.table_name = b.table_name "}, databaseId = "dm"), @Select(value = {"select lower(a.table_name) as tableName , b.comments from dba_tables a, all_tab_comments b  where a.owner=upper(#{database}) and b.owner=upper(#{database}) and a.table_name = b.table_name "}, databaseId = CommonConstant.ORACLE)})
    List<TableDetail> selectAllTables(@Param("database") String database);

    @Select.List({@Select(value = {"select column_name, column_comment from information_schema.COLUMNS  where table_name = #{tableName} and table_schema = #{database}"}, databaseId = "mysql"), @Select(value = {"select lower(column_name) as column_name, comments as column_comment from user_col_comments  where table_name = #{tableName} and owner = #{database}"}, databaseId = "dm"), @Select(value = {"select lower(column_name) as column_name, comments as column_comment from user_col_comments  where table_name = upper(#{tableName}) "}, databaseId = CommonConstant.ORACLE)})
    List<TableColumn> selectTableColumns(@Param("database") String database, @Param("tableName") String tableName);
}