private static void UpdatePlayers(int[] playerIds)
{
int counter = 1;
foreach (int playerId in playerIds)
{
try
{
Console.Title = $"{counter}/{playerIds.Length}";
Console.WriteLine($"Start Create Player Id {playerId} ({counter++}/{playerIds.Length})");
if (!ConfigurationManager.AppSettings["updateExistPlayer"].ToBool() && DBMethods.IsPlayerExist(playerId))
{
Console.WriteLine("Already Exist In DB");
continue;
}
var player = new PlayerInfo(playerId);
if (player.Valid)
{
DBMethods.AddNewPlayer(player);
}
}
catch (Exception e)
{
Console.WriteLine(e);
File.AppendAllLines("Errors.txt", new[] { $"{playerId}" });
}
}
}
private static void UpdatePlayersInParallel(int[] playerIds)
{
Stopwatch sw = Stopwatch.StartNew();
int counter = 1;
var players = playerIds.AsParallel().WithExecutionMode(ParallelExecutionMode.ForceParallelism).WithDegreeOfParallelism(64).Select(id =>
{
Console.Title = $"{counter++}/{playerIds.Length}";
return(new PlayerInfo(id));
}).ToArray();
DBMethods.UpdatePlayersGames(players);
Console.WriteLine($"Total Runtime: {sw.Elapsed}");
}
static void Main(string[] args)
{
Console.WriteLine($"DB Path = {DBMethods.GetDataBaseConnectionString()}");
var playerIds = File.ReadAllLines("Teams.txt").AsParallel().WithDegreeOfParallelism(32).SelectMany(GetActivePlayersIds).OrderBy(i => i).ToArray();
//var playerIds = File.ReadAllText("playerIds.csv").Split(',').Select(s => s.ToInt()).ToArray();
//File.WriteAllText("playerIds.csv", string.Join(',', playerIds));
if (ConfigurationManager.AppSettings["updateSpecificPlayers"].ToBool())
{
playerIds = ConfigurationManager.AppSettings["specificPlayersIds"].
Split(',').Select(s => s.ToInt()).ToArray();
}
Console.WriteLine($"Found {playerIds.Length} PlayerIds");
if (ConfigurationManager.AppSettings["runInParallel"].ToBool())
{
UpdatePlayersInParallel(playerIds);
}
else
{
UpdatePlayers(playerIds);
}
}