private void ConvertExcuses()
{
var oldexcuses = Database.GetCollection <OldModels.Excuse>().FindAll().ToArray();
var newExcuses = oldexcuses.Select(e => new TT2Bot.Models.Excuse
{
CreatorId = e.CreatorId,
ExcuseText = e.ExcuseText,
Id = (ulong)e.ExcuseNo,
Removed = false,
SubmissionTime = e.SubmissionTime
});
BotDb.Upsert(newExcuses).Wait();
}
private void ConvertUsers()
{
var oldUsers = Database.GetCollection <User>().FindAll().ToArray();
var newUsers = oldUsers.Select(u => new PlayerData
{
Id = u.DiscordId,
PlayerCode = u.SupportCode,
CanAddExcuse = true,
CanGHSubmit = u.CanSubmit,
CanBotSubmit = true
});
BotDb.Upsert(newUsers).Wait();
}
private void ConvertCmdPerms()
{
var oldPerms = Database.GetCollection <CmdPerm>().FindAll().ToArray();
var newPerms = oldPerms.Select(p => new TitanBot.Storage.Tables.CallPermission
{
Blacklisted = p.blackListed,
CallName = p.commandname,
GuildId = p.guildId,
Permission = p.permissionId,
Roles = p.roleIds
});
BotDb.Upsert(newPerms).Wait();
}
private void ConvertSubmissions()
{
var oldSubmissions = Database.GetCollection <OldModels.TT2Submission>().FindAll().ToArray();
var newSubmissions = oldSubmissions.Select(s => new TT2Bot.Models.TT2Submission
{
Answerer = s.Answerer,
Description = s.Description,
Id = (ulong)s.Id,
ImageUrl = s.ImageUrl,
Message = s.Message,
Reddit = s.Reddit,
ReplyTime = s.ReplyTime,
Response = s.Response,
SubmissionTime = s.SubmissionTime,
Submitter = s.Submitter,
Title = s.Title,
Type = (TT2Bot.Models.TT2Submission.SubmissionType)s.Type
});
BotDb.Upsert(newSubmissions).Wait();
}
private void ConvertRegistrations()
{
var oldRegistrations = Database.GetCollection <OldModels.Registration>().FindAll().ToArray();
var users = oldRegistrations.GroupBy(r => r.UserId).Select(u => new PlayerData
{
AttacksPerWeek = u.Max(r => r.CQPerWeek),
Id = u.Key,
MaxStage = u.Max(r => r.MaxStage),
Relics = u.Max(r => r.Relics),
TapsPerCQ = u.Max(r => r.Taps)
});
var registrations = oldRegistrations.Select(r => new TT2Bot.Models.Registration
{
ApplyTime = r.ApplyTime,
EditTime = r.EditTime,
GuildId = r.GuildId,
Images = r.Images,
Message = r.Message,
UserId = r.UserId
});
BotDb.Upsert(users).Wait();
BotDb.Upsert(registrations).Wait();
}
