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