From 3e14440cb203d28923ba9cfec39ceff15f2c35e7 Mon Sep 17 00:00:00 2001
From: lixiaojun <1287241240@qq.com>
Date: 星期二, 26 三月 2024 09:55:08 +0800
Subject: [PATCH] 版本大更新
---
Yw.Service.Run.Core/00-core/ConfigHelper.cs | 125 +++++++++++++++++++++++++++++++++++++----
1 files changed, 111 insertions(+), 14 deletions(-)
diff --git a/Yw.Service.Run.Core/00-core/ConfigHelper.cs b/Yw.Service.Run.Core/00-core/ConfigHelper.cs
index a71c41a..2666d93 100644
--- a/Yw.Service.Run.Core/00-core/ConfigHelper.cs
+++ b/Yw.Service.Run.Core/00-core/ConfigHelper.cs
@@ -3,7 +3,6 @@
internal class ConfigHelper
{
-
/// <summary>
/// 榛樿杩炴帴閰嶇疆
/// </summary>
@@ -15,7 +14,7 @@
return new ConnectionConfig()
{
DbType = SqlSugar.DbType.PostgreSQL,//鏁版嵁搴撶被鍨�
- ConnectionString = RunParasHelper.Run.DataBase.ConnectString,
+ ConnectionString = RunParasHelper.Run.DataBase.PostgreSql.ConnectString,
IsAutoCloseConnection = true,//鏄惁鑷姩鍏抽棴
MoreSettings = new ConnMoreSettings()
{
@@ -25,7 +24,8 @@
{
OnLogExecuting = (sql, p) =>
{
- LogHelper.Debug(sql);
+ // var sqlString = UtilMethods.GetNativeSql(sql, p);
+ //LogHelper.Debug(sqlString);
// Console.WriteLine(sql);
}
}
@@ -34,9 +34,9 @@
}
/// <summary>
- /// 璁板綍杩炴帴閰嶇疆
+ /// PostgreSql杩炴帴閰嶇疆
/// </summary>
- internal static ConnectionConfig RecordConnectionConfig
+ internal static ConnectionConfig PostgreSqlConnectionConfig
{
get
{
@@ -44,7 +44,7 @@
return new ConnectionConfig()
{
DbType = SqlSugar.DbType.PostgreSQL,//鏁版嵁搴撶被鍨�
- ConnectionString = RunParasHelper.Run.DataBase.RecordConnectString,
+ ConnectionString = RunParasHelper.Run.DataBase.PostgreSql.ConnectString,
IsAutoCloseConnection = true,//鏄惁鑷姩鍏抽棴
MoreSettings = new ConnMoreSettings()
{
@@ -54,7 +54,8 @@
{
OnLogExecuting = (sql, p) =>
{
- LogHelper.Debug(sql);
+ // var sqlString = UtilMethods.GetNativeSql(sql, p);
+ //LogHelper.Debug(sqlString);
// Console.WriteLine(sql);
}
}
@@ -62,29 +63,125 @@
}
}
-
/// <summary>
- /// 缂撳瓨淇濇寔鏃堕棿 锛堝垎閽燂級
+ /// SQLite杩炴帴閰嶇疆
/// </summary>
- public static int CacheKeepTime
+ internal static ConnectionConfig SQLiteConnectionConfig
{
get
{
- return MemoryCacheParasHelper.MemoryCache.KeepTime;
+ //SnowFlakeSingle.WorkId = Settings.SqlSugar.SnowFlakeWorkId; 涓嶅悓鏈哄櫒閰嶇疆鐨勫敮涓�鏁板瓧; // 鍗曟湇鍔″櫒涓嶉渶瑕佹寚瀹�
+ return new ConnectionConfig()
+ {
+ DbType = SqlSugar.DbType.Sqlite,//鏁版嵁搴撶被鍨�
+ ConnectionString = RunParasHelper.Run.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);
+ }
+ }
+ };
}
}
/// <summary>
- /// 缂撳瓨闅忔満鏃堕棿 锛堢锛�
+ /// 榛樿璁板綍杩炴帴閰嶇疆
/// </summary>
- public static int CacheRandomTime
+ internal static ConnectionConfig DefaultRecordConnectionConfig
{
get
{
- return RandomHelper.Random(0, MemoryCacheParasHelper.MemoryCache.RandomTime);
+ //SnowFlakeSingle.WorkId = Settings.SqlSugar.SnowFlakeWorkId; 涓嶅悓鏈哄櫒閰嶇疆鐨勫敮涓�鏁板瓧; // 鍗曟湇鍔″櫒涓嶉渶瑕佹寚瀹�
+ return new ConnectionConfig()
+ {
+ DbType = SqlSugar.DbType.PostgreSQL,//鏁版嵁搴撶被鍨�
+ ConnectionString = RunParasHelper.Run.DataBase.PostgreSql.RecordConnectString,
+ 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>
+ /// PostgreSql璁板綍杩炴帴閰嶇疆
+ /// </summary>
+ internal static ConnectionConfig PostgreSqlRecordConnectionConfig
+ {
+ get
+ {
+ //SnowFlakeSingle.WorkId = Settings.SqlSugar.SnowFlakeWorkId; 涓嶅悓鏈哄櫒閰嶇疆鐨勫敮涓�鏁板瓧; // 鍗曟湇鍔″櫒涓嶉渶瑕佹寚瀹�
+ return new ConnectionConfig()
+ {
+ DbType = SqlSugar.DbType.PostgreSQL,//鏁版嵁搴撶被鍨�
+ ConnectionString = RunParasHelper.Run.DataBase.PostgreSql.RecordConnectString,
+ 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>
+ internal static ConnectionConfig SQLiteRecordConnectionConfig
+ {
+ get
+ {
+ //SnowFlakeSingle.WorkId = Settings.SqlSugar.SnowFlakeWorkId; 涓嶅悓鏈哄櫒閰嶇疆鐨勫敮涓�鏁板瓧; // 鍗曟湇鍔″櫒涓嶉渶瑕佹寚瀹�
+ return new ConnectionConfig()
+ {
+ DbType = SqlSugar.DbType.Sqlite,//鏁版嵁搴撶被鍨�
+ ConnectionString = RunParasHelper.Run.DataBase.SQLite.RecordConnectString,
+ 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);
+ }
+ }
+ };
+ }
+ }
--
Gitblit v1.9.3