From dc5bfa19ffc92dada57bdd6b052de6dfd25a010a Mon Sep 17 00:00:00 2001
From: lixiaojun <1287241240@qq.com>
Date: 星期二, 21 五月 2024 14:20:28 +0800
Subject: [PATCH] 编码更新，用于数据迁移
---
Yw.Service.Unit.Core/00-core/ConfigHelper.cs | 56 ++++++++++++++++++++++++++++++++++++++++++++++++--------
1 files changed, 48 insertions(+), 8 deletions(-)
diff --git a/Yw.Service.Unit.Core/00-core/ConfigHelper.cs b/Yw.Service.Unit.Core/00-core/ConfigHelper.cs
index 98c926e..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()
{
@@ -24,6 +24,8 @@
{
OnLogExecuting = (sql, p) =>
{
+ // var sqlString = UtilMethods.GetNativeSql(sql, p);
+ //LogHelper.Debug(sqlString);
// Console.WriteLine(sql);
}
}
@@ -31,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);
+ }
+ }
+ };
}
}
@@ -66,5 +105,6 @@
+
}
}
--
Gitblit v1.9.3