using Custom.Utils.Framework;
using SqlSugar;
using System;
using DbType = SqlSugar.DbType;

namespace CompressorXN_Service
{
    public partial class DbContext
    {
        public DbContext()
        {
            ConnectDb();
        }

        /// <summary>
        /// 连接符字串
        /// $"Server={Server};Port={Port};Database={Database};User Id={UserId};Password={passWord}"
        /// </summary>
        public static string ConnStr = "";

        public static SqlSugarScope db = null;

        public static void GetConStr(string server, string port, string database, string userId, string passWord, bool isEncrypt, string schema)
        {
            if (isEncrypt)
            {
                // 解密
                passWord = DesHelper.DecryptStringFromBytes_Aes(passWord);
            }
            ConnStr = $"Server={server};Port={port};Database={database};User Id={userId};Password={passWord};Search Path={schema}";
            ConnectDb();
        }

        private static void ConnectDb()
        {
            if (db == null)
            {
                //用单例模式
                db = new SqlSugarScope(new ConnectionConfig()
                {
                    DbType = DbType.PostgreSQL, //数据库类型
                    ConnectionString = ConnStr,//连接符字串
                    IsAutoCloseConnection = true //不设成true要手动close 
                },
                db =>
                {
                    //(A)全局生效配置点
                    //调试SQL事件，可以删掉
                    //db.Aop.OnLogExecuting = (sql, pars) =>
                    //{
                    //    Console.WriteLine(sql);//输出sql,查看执行sql
                    //};
                    db.Aop.OnError = (sqlSugarException) =>
                    {
                        Console.WriteLine(sqlSugarException.Sql);
                    };
                });
                //db.DbMaintenance.CreateDatabase();
                AppContext.SetSwitch("Npgsql.EnableLegacyTimestampBehavior", true);
                AppContext.SetSwitch("Npgsql.DisableDateTimeInfinityConversions", true);
            }
        }
    }
}