using Attribute;
using Model;
using Model.Base;
using Repository;
using Service;
using Microsoft.AspNetCore.Mvc;
using Vo.Admin;
using Dto.Admin;
using Custom;
using Common;


namespace Services
{
    /// <summary>
    /// 数据库配置Service业务层处理
    /// </summary>
    [AppService(ServiceType = typeof(IDatabaseInfoService), ServiceLifetime = LifeTime.Transient)]
    public class DatabaseInfoService : BaseService<DatabaseInfo>, IDatabaseInfoService
    {
        /// <summary>
        /// 数据库配置-列表
        /// </summary>
        /// <param name="param">参数请求体</param>
        /// <param name="page">分页参数</param>
        /// <returns>列表</returns>
        public PagedInfo<GetDatabaseInfoListVo> getDatabaseInfoList([FromQuery] PagerInfo page, [FromQuery] DatabaseInfo param)
        {
            //拼装查询条件
            var predicate = Expressionable.Create<DatabaseInfo>();
            predicate = predicate.AndIF(!string.IsNullOrEmpty(param.dbName), m => m.dbName.Contains(param.dbName));
            predicate = predicate.AndIF(!string.IsNullOrEmpty(param.hostAddress), m => m.hostAddress.Contains(param.hostAddress));
            var response = Queryable()
                .Where(predicate.ToExpression())
                .OrderByDescending(m => m.id)
                .ToPage<DatabaseInfo, GetDatabaseInfoListVo>(page);
            return response;
        }



        /// <summary>
        /// 生成SQL脚本
        /// </summary>
        /// <param name="param">参数请求体</param>
        /// <returns>生成</returns>
        public void makeDatabaseInfo([FromBody] MakeDatabaseInfoDto param, List<DatabaseTable> tables, List<DatabaseField> fields, TokenModel loginUser)
        {
            DatabaseInfo databaseInfo = GetById(param.id) ?? new DatabaseInfo();
            foreach(DatabaseTable table in tables)
            {
                table.fields = fields.Where(m => m.tableId == table.id).ToList();
            }

            MakeData makeData = new();
            string requestId = DateTime.Now.ToString("yyyyMMddHHmmssfff") + Function.get_Random(8);
            makeData.requestId = requestId;
            makeData.modePath = "Sql/db.sql";
            Dictionary<string, string> attach = new();
            attach.Add("id", param.id.ToString());
            attach.Add("kind", "db");
            attach.Add("operator", loginUser.username);
            makeData.attach = Newtonsoft.Json.JsonConvert.SerializeObject(attach);
            makeData.data = new Dictionary<string, object>();
            makeData.data.Add("databaseInfo", databaseInfo);
            makeData.data.Add("databaseTable", tables);
            RabbitMQClient.Instance.Push("MakeSqlQueue", Newtonsoft.Json.JsonConvert.SerializeObject(makeData));
        }



    }
}