/// <summary>
/// Read the data from the legacy flat-file format, add them to the new
/// repository, and commit the new data.
/// </summary>
/// <param name="fishingLeaderboardDataPath">The path to the file containing the leaderboard data.</param>
/// <param name="leaderboardRepository">The repository to import the leaderboard data to.</param>
/// <param name="fishRepository">The repository containing the fish data.</param>
/// <param name="userLookup">The user lookup system to convert the stored usernames into user ids.</param>
/// <param name="token">The oauth token used to fetch user ids.</param>
/// <param name="clientId">The client id used to identify the call to fetch the user ids.</param>
/// <returns>Whether or not the data was imported.</returns>
public static bool ImportLeaderboardDataIntoSql(string fishingLeaderboardDataPath, IRepository <Catch> leaderboardRepository, IRepository <Fish> fishRepository, UserLookup userLookup, string token, string clientId)
{
if (File.Exists(fishingLeaderboardDataPath))
{
var fishingLeaderboard = JsonConvert.DeserializeObject <List <LegacyCatch> >(File.ReadAllText(FishingLeaderboardPath));
foreach (var record in fishingLeaderboard)
{
userLookup.GetId(record.caughtBy);
}
userLookup.UpdateCache(token, clientId);
foreach (var record in fishingLeaderboard)
{
leaderboardRepository.Create(new Catch()
{
Fish = fishRepository.ReadById(record.ID - 1),
UserId = userLookup.GetId(record.caughtBy),
Length = record.length,
Weight = record.weight
});
}
leaderboardRepository.Commit();
return(true);
}
return(false);
}
/// <summary>
/// Read the data from the legacy flat-file format, add them to the new
/// repository, and commit the new data.
/// </summary>
/// <param name="fisherDataPath">The path to the file containing the fisher data.</param>
/// <param name="fisherRepository">The repository to import the fisher data to.</param>
/// <param name="fishRepository">The repository containing the fish data.</param>
/// <param name="userLookup">The user lookup system to convert the stored usernames into user ids.</param>
/// <param name="token">The oauth token used to fetch user ids.</param>
/// <param name="clientId">The client id used to identify the call to fetch the user ids.</param>
/// <returns>Whether or not the data was imported.</returns>
public static bool ImportFisherDataIntoSql(string fisherDataPath, IRepository <Fisher> fisherRepository, IRepository <Fish> fishRepository, UserLookup userLookup, string token, string clientId)
{
if (File.Exists(fisherDataPath))
{
var fisherList = JsonConvert.DeserializeObject <Dictionary <string, LegacyFisher> >(File.ReadAllText(FisherDataPath));
foreach (var fisher in fisherList)
{
userLookup.GetId(fisher.Value.username);
}
userLookup.UpdateCache(token, clientId);
foreach (var fisher in fisherList)
{
var records = new List <Catch>();
foreach (var fish in fisher.Value.biggestFish)
{
records.Add(new Catch()
{
Fish = fishRepository.ReadById(fish.ID - 1),
UserId = userLookup.GetId(fish.caughtBy),
Length = fish.length,
Weight = fish.weight
});
}
fisherRepository.Create(new Fisher()
{
UserId = userLookup.GetId(fisher.Value.username),
Records = records
});
}
fisherRepository.Commit();
return(true);
}
return(false);
}
public void TournamentRecordsCompactGetsNullIfUserHasNeverEntered()
{
var command = TournamentModule.Commands.Where(x => x.Name.Equals("TournamentRecords")).FirstOrDefault();
var results = command.CompactExecutor("", UserLookup.GetId("Buzz"));
Assert.IsNull(results);
}
public void TournamentResultsCompactReturnsNullIfNoTournamentsHaveTakenPlace()
{
TournamentResultsData.Clear();
var command = TournamentModule.Commands.Where(x => x.Name.Equals("TournamentResults")).FirstOrDefault();
var results = command.CompactExecutor("", UserLookup.GetId("Buzz"));
Assert.IsNull(results);
}
public void TournamentRecordsGetsErrorWhenUserHasNotCompetedInAnyTournaments()
{
var command = TournamentModule.Commands.Where(x => x.Name.Equals("TournamentRecords")).FirstOrDefault();
var results = command.Executor("", UserLookup.GetId("Buzz"));
Assert.IsNotNull(results.Responses);
Assert.AreEqual(1, results.Responses.Count);
}
public void TournamentResultsGetsErrorMessageWhenNoTournamentHasCompleted()
{
TournamentResultsData.Clear();
var command = TournamentModule.Commands.Where(x => x.Name.Equals("TournamentResults")).FirstOrDefault();
var results = command.Executor("", UserLookup.GetId("Foo"));
Assert.IsNotNull(results.Responses);
Assert.AreEqual(1, results.Responses.Count);
}
public void TournamentRecordsGetsUsersRecords()
{
var command = TournamentModule.Commands.Where(x => x.Name.Equals("TournamentRecords")).FirstOrDefault();
var results = command.Executor("", UserLookup.GetId("Foo"));
Assert.IsNotNull(results.Responses);
Assert.AreEqual(2, results.Responses.Count);
Assert.IsTrue(results.Responses.Any(x => x.Contains("1st") && x.Contains("35 points")));
Assert.IsTrue(results.Responses.Any(x => x.Contains("2nd") && x.Contains("40 points")));
}
public void TournamentResultsGetsLatestTournamentWithoutParticipation()
{
var command = TournamentModule.Commands.Where(x => x.Name.Equals("TournamentResults")).FirstOrDefault();
var results = command.Executor("", UserLookup.GetId("Buzz"));
Assert.IsNotNull(results.Responses);
Assert.AreEqual(2, results.Responses.Count);
Assert.IsTrue(results.Responses.Any(x => x.Contains("30 seconds")));
Assert.IsTrue(results.Responses.Any(x => x.Contains("02") && x.Contains("30")));
}
public void TournamentRecordsCompactGetsUserRecords()
{
var command = TournamentModule.Commands.Where(x => x.Name.Equals("TournamentRecords")).FirstOrDefault();
var results = command.CompactExecutor("", UserLookup.GetId("Foo"));
var resultObject = RecordsFromCompact(results.ToCompact().First());
Assert.IsNotNull(resultObject);
Assert.AreEqual(1, resultObject.TopRank);
Assert.AreEqual(35, resultObject.TopRankScore);
Assert.AreEqual(40, resultObject.TopScore);
Assert.AreEqual(2, resultObject.TopScoreRank);
}
public void TournamentResultsCompactIncludesUserData()
{
var command = TournamentModule.Commands.Where(x => x.Name.Equals("TournamentResults")).FirstOrDefault();
var results = command.CompactExecutor("", UserLookup.GetId("Foo"));
var resultObject = ResultsFromCompact(results.ToCompact().First());
Assert.IsNotNull(resultObject);
Assert.AreEqual(UserLookup.GetId("Fizz"), resultObject.Winner);
Assert.AreEqual(3, resultObject.Participants);
Assert.AreEqual(30, resultObject.WinnerPoints);
Assert.AreEqual(3, resultObject.Rank);
Assert.AreEqual(10, resultObject.UserPoints);
}
/// <summary>
/// Processes a message from a user to check for and execute a command.
/// </summary>
/// <param name="message">The message the user sent.</param>
/// <param name="user">The user's name.</param>
/// <returns>Whether a command was found and executed.</returns>
public CommandResult ProcessMessage(string message, string user)
{
var request = CommandRequest.Parse(message);
if (commandStringToIdMap.TryGetValue(request.CommandString, out var commandId))
{
request.CommandId = commandId;
request.UserId = UserLookup.GetId(user);
if (request.UserId == null && !CanExecuteAnonymously(request.CommandId))
{
return(new CommandResult("User ID not found in cache, please try again in a few minutes. "
+ "If you continue to see this error, please let the streamer or a mod know."));
}
if (CanUserExecute(request.CommandId, request.UserId))
{
return(TryExecuteCommand(request));
}
return(new CommandResult(true, new Exception[] { new UnauthorizedAccessException($"User \"{user}\" attempted to execute unauthorized command \"{message}\"") }));
}
return(new CommandResult());
}
public DatabaseMigrationResult Update(SqliteContext context, SqliteRepositoryManager repositoryManager)
{
var result = new DatabaseMigrationResult {
Success = true
};
var commands = new string[]
{
"CREATE TABLE \"AppSettings\" ([Id] INTEGER PRIMARY KEY, [DatabaseVersion] nvarchar, [GeneralCacheUpdateTime] int NOT NULL, [FishingCastMinimum] int NOT NULL, [FishingCastMaximum] int NOT NULL, [FishingHookLength] int NOT NULL, [FishingUseNormalRarity] bit NOT NULL, [FishingUseNormalSizes] bit NOT NULL, [FishingGloatCost] int NOT NULL, [FishingTournamentDuration] int NOT NULL, [FishingTournamentInterval] int NOT NULL, [FishingTournamentCastMinimum] int NOT NULL, [FishingTournamentCastMaximum] int NOT NULL)",
"CREATE TABLE \"Catches\" ([Id] INTEGER PRIMARY KEY, [UserId] nvarchar, [Length] real NOT NULL, [Weight] real NOT NULL, [Points] int NOT NULL, [Fish_Id] int, [Fisher_Id] int, FOREIGN KEY (Fish_Id) REFERENCES \"Fish\"(Id), FOREIGN KEY (Fisher_Id) REFERENCES \"Fishers\"(Id))",
"CREATE TABLE \"Fish\" ([Id] INTEGER PRIMARY KEY, [Name] nvarchar, [MinimumLength] real NOT NULL, [MaximumLength] real NOT NULL, [MinimumWeight] real NOT NULL, [MaximumWeight] real NOT NULL, [FlavorText] nvarchar, [Rarity_Id] int, [SizeCategory_Id] int, FOREIGN KEY (Rarity_Id) REFERENCES \"FishRarities\"(Id), FOREIGN KEY (SizeCategory_Id) REFERENCES \"FishSizes\"(Id))",
"CREATE TABLE \"FishRarities\" ([Id] INTEGER PRIMARY KEY, [Name] nvarchar, [Weight] real NOT NULL)",
"CREATE TABLE \"FishSizes\" ([Id] INTEGER PRIMARY KEY, [Name] nvarchar, [Message] nvarchar)",
"CREATE TABLE \"Fishers\" ([Id] INTEGER PRIMARY KEY, [UserId] nvarchar)",
"CREATE TABLE \"UserMaps\" ([Id] INTEGER PRIMARY KEY, [Username] nvarchar, [TwitchId] nvarchar)",
"CREATE INDEX \"IX_Catch_Fish_Id\" ON \"Catches\" (\"Fish_Id\")",
"CREATE INDEX \"IX_Catch_Fisher_Id\" ON \"Catches\" (\"Fisher_Id\")",
"CREATE INDEX \"IX_Fish_Rarity_Id\" ON \"Fish\" (\"Rarity_Id\")",
"CREATE INDEX \"IX_Fish_SizeCategory_Id\" ON \"Fish\" (\"SizeCategory_Id\")",
"ALTER TABLE \"TournamentEntries\" RENAME COLUMN [Name] TO [UserId]"
};
result.DebugOutput.Add("Executing SQL statements to add/update tables...");
foreach (var command in commands)
{
result.DebugOutput.Add(command);
try
{
context.Database.ExecuteSqlCommand(command);
}
catch (Exception e)
{
result.DebugOutput.Add($"Exception: {e}");
}
}
foreach (var tournament in repositoryManager.TournamentResults.Read())
{
foreach (var entry in tournament.Entries)
{
UserLookup.GetId(entry.UserId);
}
}
foreach (var userRole in repositoryManager.UserRoles.Read())
{
var userList = userRole.UserIds;
foreach (var user in userList)
{
UserLookup.GetId(user);
}
}
UserLookup.UpdateCache(Token, ClientId);
foreach (var tournament in repositoryManager.TournamentResults.Read())
{
foreach (var entry in tournament.Entries)
{
entry.UserId = UserLookup.GetId(entry.UserId);
}
repositoryManager.TournamentResults.Update(tournament);
}
repositoryManager.TournamentResults.Commit();
foreach (var userRole in repositoryManager.UserRoles.Read())
{
var userList = userRole.UserIds;
var idList = new List <string>();
foreach (var user in userList)
{
idList.Add(UserLookup.GetId(user));
}
userRole.UserIds = idList;
repositoryManager.UserRoles.Update(userRole);
}
repositoryManager.UserRoles.Commit();
return(result);
}
