namespace IStation
{
    /// <summary>
    /// 
    /// </summary>
    public class ConfigHelper
    {

        #region PostgreSql-ConnectionConfig
         
        /// <summary>
        /// PostgreSql连接配置
        /// </summary>
        internal static ConnectionConfig PostgreSqlConnectionConfig
        {
            get
            {
                //SnowFlakeSingle.WorkId = Settings.SqlSugar.SnowFlakeWorkId; 不同机器配置的唯一数字; // 单服务器不需要指定
                return new ConnectionConfig()
                {
                    DbType = SqlSugar.DbType.PostgreSQL,//数据库类型
                    ConnectionString = Settings.ParasHelper.DataBase.PostgreSql.ConnectString,
                    IsAutoCloseConnection = true,//是否自动关闭
                    MoreSettings = new ConnMoreSettings()
                    {
                        //PgSqlIsAutoToLower = false //数据库存在大写字段的 ，需要把这个设为false ，并且实体和字段名称要一样
                    },
                    AopEvents = new AopEvents
                    {
                        OnLogExecuting = (sql, p) =>
                        {
                            // var sqlString = UtilMethods.GetNativeSql(sql, p);
                            //LogHelper.Debug(sqlString);
                            // Console.WriteLine(sql);
                        }
                    }
                };
            }
        }
        #endregion

        #region SQLite-ConnectionConfig
         

        /// <summary>
        /// Analysis SQLite连接配置
        /// </summary>
        internal static ConnectionConfig AnalysisConnectionConfig
        {
            get
            {
                return GetConnectionConfig(Settings.ParasHelper.DataBase.SQLite.AnalysisConnectString);
            }
        }

        /// <summary>
        /// Schedule SQLite连接配置
        /// </summary>
        internal static ConnectionConfig ScheduleConnectionConfig
        {
            get
            {
                return GetConnectionConfig(Settings.ParasHelper.DataBase.SQLite.ScheduleConnectString);
            }
        }

        /// <summary>
        /// Hydraulic SQLite连接配置
        /// </summary>
        internal static ConnectionConfig HydraulicConnectionConfig
        {
            get
            { 
                return GetConnectionConfig(Settings.ParasHelper.DataBase.SQLite.HydraulicConnectString);
            }
        }

        /// <summary>
        /// Monitor SQLite连接配置
        /// </summary>
        internal static ConnectionConfig MonitorConnectionConfig
        {
            get
            { 
                return GetConnectionConfig(Settings.ParasHelper.DataBase.SQLite.MonitorConnectString);
            }
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="connection_string"></param>
        /// <returns></returns>
        private static ConnectionConfig GetConnectionConfig(string connection_string)
        { 
            var config = new ConnectionConfig
            {
                DbType = SqlSugar.DbType.Sqlite,//数据库类型
                ConnectionString = connection_string,
                IsAutoCloseConnection = true,//是否自动关闭
                MoreSettings = new ConnMoreSettings()
                {
                    //PgSqlIsAutoToLower = false //数据库存在大写字段的 ，需要把这个设为false ，并且实体和字段名称要一样
                },
                AopEvents = new AopEvents
                {
                    OnLogExecuting = (sql, p) =>
                    {
                        var sqlString = UtilMethods.GetNativeSql(sql, p);
                        Yw.LogHelper.Error(sqlString);
                    }
                },
                ConfigureExternalServices = new ConfigureExternalServices()
                {
                    EntityService = (property, column) =>
                    {
                        //除主键外都可空
                        if (!column.IsPrimarykey)
                        {
                            column.IsNullable = true;
                        }
                    }
                }
            };
            return config;
        }

      

        #endregion

         

    }
}