/// <summary>
/// 在接受到群消息时使用
/// </summary>
/// <param name="sender">sender object</param>
/// <param name="eventArgs">CQAppEnableEventArgs类</param>
public SuiseiDBHelper(object sender, CQGroupMessageEventArgs eventArgs)
{
this.QQID = eventArgs.FromQQ.Id;
this.GroupId = eventArgs.FromGroup.Id;
this.Sender = sender;
this.SuiseiGroupMessageEventArgs = eventArgs;
this.TriggerTime = Utils.GetTodayStamp();//触发日期
DBPath = SugarUtils.GetDBPath(eventArgs.CQApi.GetLoginQQ().Id.ToString());
}
/// <summary>
/// 初始化数据库
/// </summary>
/// <param name="eventArgs">CQAppEnableEventArgs</param>
public static void Init(ConnectEventArgs eventArgs)
{
string DBPath = SugarUtils.GetDBPath(eventArgs.LoginUid.ToString());
ConsoleLog.Debug("IO", $"获取数据路径{DBPath}");
if (!File.Exists(DBPath))//查找数据文件
{
//数据库文件不存在，新建数据库
ConsoleLog.Warning("数据库初始化", "未找到数据库文件，创建新的数据库");
Directory.CreateDirectory(Path.GetPathRoot(DBPath) ?? String.Empty);
File.Create(DBPath).Close();
}
SqlSugarClient dbClient = new SqlSugarClient(new ConnectionConfig()
{
ConnectionString = $"DATA SOURCE={DBPath}",
DbType = DbType.Sqlite,
IsAutoCloseConnection = true,
InitKeyType = InitKeyType.Attribute
});
try
{
if (!SugarUtils.TableExists <SuiseiData>(dbClient)) //彗酱数据库初始化
{
ConsoleLog.Warning("数据库初始化", "未找到慧酱数据表 - 创建一个新表");
SugarUtils.CreateTable <SuiseiData>(dbClient);
}
if (!SugarUtils.TableExists <MemberInfo>(dbClient)) //成员状态表的初始化
{
ConsoleLog.Warning("数据库初始化", "未找到成员状态表 - 创建一个新表");
SugarUtils.CreateTable <MemberInfo>(dbClient);
}
if (!SugarUtils.TableExists <BiliSubscription>(dbClient)) //动态记录表的初始化
{
ConsoleLog.Warning("数据库初始化", "未找到动态记录表 - 创建一个新表");
SugarUtils.CreateTable <BiliSubscription>(dbClient);
}
if (!SugarUtils.TableExists <GuildBattleBoss>(dbClient)) //会战数据表的初始化
{
ConsoleLog.Warning("数据库初始化", "未找到会战数据表 - 创建一个新表");
SugarUtils.CreateTable <GuildBattleBoss>(dbClient);
//写入初始化数据
dbClient.Insertable(GuildBattleBoss.GetInitBossInfos()).ExecuteCommand();
}
if (!SugarUtils.TableExists <GuildInfo>(dbClient)) //会战状态表的初始化
{
ConsoleLog.Warning("数据库初始化", "未找到会战状态表 - 创建一个新表");
SugarUtils.CreateTable <GuildInfo>(dbClient);
}
}
catch (Exception exception)
{
ConsoleLog.Fatal("数据库初始化错误", ConsoleLog.ErrorLogBuilder(exception));
Thread.Sleep(5000);
throw;
}
}
private static string DBPath; //数据库路径
#endregion
#region 构造函数
/// <summary>
/// 在接受到群消息时使用
/// </summary>
/// <param name="sender">sender object</param>
/// <param name="eventArgs">CQAppEnableEventArgs类</param>
/// <param name="time">触发时间</param>
public GuildManagerDBHelper(object sender, CQGroupMessageEventArgs eventArgs)
{
this.QQID = eventArgs.FromQQ.Id;
this.GroupId = eventArgs.FromGroup.Id;
this.Sender = sender;
this.EventArgs = eventArgs;
GuildId = new string[] //公会信息
{
GroupId.ToString(), //公会所在群号
};
DBPath = SugarUtils.GetDBPath(eventArgs.CQApi.GetLoginQQ().Id.ToString());
}
/// <summary>
/// 初始化数据库
/// </summary>
/// <param name="e">CQAppEnableEventArgs</param>
public static void Init(CQAppEnableEventArgs e)
{
string DBPath = SugarUtils.GetDBPath(e.CQApi.GetLoginQQ().Id.ToString());
ConsoleLog.Info("IO", $"获取数据路径{DBPath}");
if (!File.Exists(DBPath))//查找数据文件
{
//数据库文件不存在，新建数据库
ConsoleLog.Warning("数据库初始化", "未找到数据库文件，创建新的数据库");
Directory.CreateDirectory(Path.GetPathRoot(DBPath));
File.Create(DBPath).Close();
}
SqlSugarClient dbClient = new SqlSugarClient(new ConnectionConfig()
{
ConnectionString = $"DATA SOURCE={DBPath}",
DbType = DbType.Sqlite,
IsAutoCloseConnection = true,
InitKeyType = InitKeyType.Attribute
});
if (!SugarUtils.TableExists <SuiseiData>(dbClient)) //彗酱数据库初始化
{
ConsoleLog.Warning("数据库初始化", "未找到慧酱数据表 - 创建一个新表");
SugarUtils.CreateTable <SuiseiData>(dbClient);
}
if (!SugarUtils.TableExists <GuildData>(dbClient)) //公会数据库初始化
{
ConsoleLog.Warning("数据库初始化", "未找到公会表数据表 - 创建一个新表");
SugarUtils.CreateTable <GuildData>(dbClient);
}
if (!SugarUtils.TableExists <MemberData>(dbClient)) //公会成员数据库初始化
{
ConsoleLog.Warning("数据库初始化", "未找到成员表数据表 - 创建一个新表");
SugarUtils.CreateTable <MemberData>(dbClient);
}
if (!SugarUtils.TableExists <MemberStatus>(dbClient))//成员状态表的初始化
{
ConsoleLog.Warning("数据库初始化", "未找到成员状态表 - 创建一个新表");
SugarUtils.CreateTable <MemberStatus>(dbClient);
}
if (!SugarUtils.TableExists <BossInfo>(dbClient))//Boss信息表的初始化
{
ConsoleLog.Warning("数据库初始化", "未找到Boss信息表 - 创建一个新表");
SugarUtils.CreateTable <BossInfo>(dbClient);
}
if (!SugarUtils.TableExists <BiliSubscription>(dbClient)) //动态记录表的初始化
{
ConsoleLog.Warning("数据库初始化", "未找到动态记录表 - 创建一个新表");
SugarUtils.CreateTable <BiliSubscription>(dbClient);
}
}
/// <summary>
/// 初始化数据库
/// </summary>
/// <param name="eventArgs">CQAppEnableEventArgs</param>
public static void UserDataInit(ConnectEventArgs eventArgs)
{
string DBPath = SugarUtils.GetDBPath(eventArgs.LoginUid.ToString());
Log.Debug("IO", $"获取用户数据路径{DBPath}");
//检查文件是否存在
IOUtils.CheckFileExists(DBPath);
//创建数据库链接
SqlSugarClient dbClient = SugarUtils.CreateSqlSugarClient(DBPath);
try
{
if (!SugarUtils.TableExists <MemberInfo>(dbClient)) //成员状态表的初始化
{
Log.Warning("数据库初始化", "未找到成员状态表 - 创建一个新表");
SugarUtils.CreateTable <MemberInfo>(dbClient);
}
if (!SugarUtils.TableExists <BiliDynamicSubscription>(dbClient)) //动态记录表的初始化
{
Log.Warning("数据库初始化", "未找到动态订阅表 - 创建一个新表");
SugarUtils.CreateTable <BiliDynamicSubscription>(dbClient);
}
if (!SugarUtils.TableExists <GuildBattleBoss>(dbClient)) //会战数据表的初始化
{
Log.Warning("数据库初始化", "未找到会战数据表 - 创建一个新表");
SugarUtils.CreateTable <GuildBattleBoss>(dbClient);
}
if (!SugarUtils.TableExists <BiliLiveSubscription>(dbClient))
{
Log.Warning("数据库初始化", "未找到直播订阅表 - 创建一个新表");
SugarUtils.CreateTable <BiliLiveSubscription>(dbClient);
}
if (!SugarUtils.TableExists <GuildInfo>(dbClient)) //会战状态表的初始化
{
Log.Warning("数据库初始化", "未找到会战状态表 - 创建一个新表");
SugarUtils.CreateTable <GuildInfo>(dbClient);
}
}
catch (Exception exception)
{
Log.Fatal("数据库初始化错误", Log.ErrorLogBuilder(exception));
Thread.Sleep(5000);
Environment.Exit(-1);
}
}
private readonly string DBPath; //数据库路径
#endregion
#region 构造函数
public SubscriptionDBHelper(long uid)
{
DBPath = SugarUtils.GetDBPath(uid.ToString());
}
public GuildBattleMgrDBHelper(object sender, CQGroupMessageEventArgs eventArgs)
{
GroupId = eventArgs.FromGroup.Id;
DBPath = SugarUtils.GetDBPath(eventArgs.CQApi.GetLoginQQ().Id.ToString());
}
/// <summary>
/// 在接受到群消息时使用
/// </summary>
/// <param name="guildEventArgs">CQAppEnableEventArgs类</param>
public GuildManagerDBHelper(CQGroupMessageEventArgs guildEventArgs)
{
this.GuildEventArgs = guildEventArgs;
this.DBPath = SugarUtils.GetDBPath(guildEventArgs.CQApi.GetLoginQQ().Id.ToString());
}
public GuildBattleMgrDBHelper(CQGroupMessageEventArgs eventArgs)
{
GuildEventArgs = eventArgs;
DBPath = SugarUtils.GetDBPath(eventArgs.CQApi.GetLoginQQ().Id.ToString());
BattleTableName = $"{SugarTableUtils.GetTableName<GuildBattle>()}_{GuildEventArgs.FromGroup.Id}";
}
/// <summary>
/// 基类构造函数
/// </summary>
/// <param name="eventArgs">群聊事件参数</param>
protected BaseGuildBattleDBHelper(GroupMessageEventArgs eventArgs)
{
GuildEventArgs = eventArgs;
DBPath = SugarUtils.GetDBPath(eventArgs.LoginUid.ToString());
}
/// <summary>
/// 基类构造函数
/// </summary>
/// <param name="loginUid">登录账号ID</param>
protected BaseGuildBattleDBHelper(long loginUid)
{
DBPath = SugarUtils.GetDBPath(loginUid.ToString());
}
private readonly string DBPath;//数据库路径
#endregion
#region 构造函数
public SubscriptionDBHelper(CQApi api)
{
DBPath = SugarUtils.GetDBPath(api.GetLoginQQ().Id.ToString());
}
