From 891cc5a533a57b992d18b6204faf4eb9c57472c1 Mon Sep 17 00:00:00 2001 From: lixiaojun <1287241240@qq.com> Date: 星期日, 24 三月 2024 16:04:58 +0800 Subject: [PATCH] 版本大升级 --- Yw.Service.Unit.Core/00-core/ConfigHelper.cs | 54 ++++++++++++++++++++++++++++++++++++++++++++++-------- 1 files changed, 46 insertions(+), 8 deletions(-) diff --git a/Yw.Service.Unit.Core/00-core/ConfigHelper.cs b/Yw.Service.Unit.Core/00-core/ConfigHelper.cs index 4536e88..f75e1c1 100644 --- a/Yw.Service.Unit.Core/00-core/ConfigHelper.cs +++ b/Yw.Service.Unit.Core/00-core/ConfigHelper.cs @@ -14,7 +14,7 @@ return new ConnectionConfig() { DbType = SqlSugar.DbType.PostgreSQL,//鏁版嵁搴撶被鍨� - ConnectionString = UnitParasHelper.Unit.DataBase.ConnectString, + ConnectionString = UnitParasHelper.Unit.DataBase.PostgreSql.ConnectString, IsAutoCloseConnection = true,//鏄惁鑷姩鍏抽棴 MoreSettings = new ConnMoreSettings() { @@ -33,26 +33,63 @@ } } - /// <summary> - /// 缂撳瓨淇濇寔鏃堕棿 锛堝垎閽燂級 + /// PostgreSql杩炴帴閰嶇疆 /// </summary> - public static int CacheKeepTime + internal static ConnectionConfig PostgreSqlConnectionConfig { get { - return MemoryCacheParasHelper.MemoryCache.KeepTime; + //SnowFlakeSingle.WorkId = Settings.SqlSugar.SnowFlakeWorkId; 涓嶅悓鏈哄櫒閰嶇疆鐨勫敮涓�鏁板瓧; // 鍗曟湇鍔″櫒涓嶉渶瑕佹寚瀹� + return new ConnectionConfig() + { + DbType = SqlSugar.DbType.PostgreSQL,//鏁版嵁搴撶被鍨� + ConnectionString = UnitParasHelper.Unit.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); + } + } + }; } } /// <summary> - /// 缂撳瓨闅忔満鏃堕棿 锛堢锛� + /// SQLite杩炴帴閰嶇疆 /// </summary> - public static int CacheRandomTime + internal static ConnectionConfig SQLiteConnectionConfig { get { - return RandomHelper.Random(0, MemoryCacheParasHelper.MemoryCache.RandomTime); + //SnowFlakeSingle.WorkId = Settings.SqlSugar.SnowFlakeWorkId; 涓嶅悓鏈哄櫒閰嶇疆鐨勫敮涓�鏁板瓧; // 鍗曟湇鍔″櫒涓嶉渶瑕佹寚瀹� + return new ConnectionConfig() + { + DbType = SqlSugar.DbType.Sqlite,//鏁版嵁搴撶被鍨� + ConnectionString = UnitParasHelper.Unit.DataBase.SQLite.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); + } + } + }; } } @@ -68,5 +105,6 @@ + } } -- Gitblit v1.9.3