using System.Collections.Generic;
using System.Data;
using CSFramework.DB.Models;

namespace CSFramework.DB
{
    /// <summary>
    /// CSFramework.DB数据库底层元数据接口
    /// </summary>
    public interface IDbMetalQuery
    {
        /// <summary>
        /// 获取当前数据库的表或视图
        /// </summary>
        /// <param name="dbName">数据库名称</param>
        /// <returns></returns>
        DataTable meta_GetTableNames(string dbName = "");

        /// <summary>
        /// 获取当前数据库的表结构
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <returns></returns>
        DataTable meta_GetTableStru(string tableName);

        /// <summary>
        /// 获取数据库名称列表
        /// </summary>
        /// <returns></returns>
        DataTable meta_GetDatabase();

        /// <summary>
        /// 获取数据库名称列表
        /// </summary>
        /// <returns></returns>
        List<MetaDBNames> meta_GetDatabaseList();

        /// <summary>
        /// 获取当前数据库的表或视图
        /// </summary>
        /// <param name="dbName">数据库名称</param>
        /// <returns></returns>
        List<MetaTableNames> meta_GetTableNamesList(string dbName = "");

        /// <summary>
        /// 获取当前数据库的所有表结构
        /// </summary>
        /// <param name="tableName">表名</param>
        /// <returns></returns>
        List<MetaTableStructure> meta_GetTableStruList(string tableName);

        /// <summary>
        /// 获取数据库所有用户自定义存储过程和函数
        /// </summary>
        /// <param name="dbName">数据库名称</param>
        /// <returns></returns>
        List<MetaStoreProcedure> meta_GetStoreProcList(string dbName = "");
    }
}