public Worker(IGlobalHandler globalHandler, StatisticsService statisticsService, EngineRegionProfile regionProfile, Configuration configuration, Database provider)
{
Running = false;
GlobalHandler = globalHandler;
StatisticsService = statisticsService;
Provider = provider;
Configuration = configuration;
Profile = regionProfile;
AutomaticUpdatesThread = null;
MassiveSummonerLookupThread = null;
Connected = false;
Profiler = new Profiler();
ActiveAccountIds = new HashSet<int>();
Region = (RegionType)Profile.Identifier;
AutomaticUpdateInterval = configuration.AutomaticUpdateInterval;
InitialiseAuthenticationProfile();
}
public DatabaseCommand(string query, DbConnection connection, Profiler profiler = null, params object[] arguments)
{
Fields = null;
CommandProfiler = profiler;
Query = string.Format(query, arguments);
Command = connection.CreateCommand();
Command.CommandText = Query;
}
public DatabaseCommand(string query, DbConnection connection, Profiler profiler = null, params object[] arguments)
{
Fields = null;
CommandProfiler = profiler;
Query = string.Format(query, arguments);
Command = connection.CreateCommand();
if (connection.IsMySQL())
{
ParameterPrefix = MySQLParameterPrefix;
//This could break some things...
Query = Query.Replace(StandardParameterPrefix, MySQLParameterPrefix);
}
else
ParameterPrefix = StandardParameterPrefix;
Command.CommandText = Query;
}
public WebService(IGlobalHandler globalHandler, Configuration configuration, StatisticsService statisticsService, Database databaseProvider)
{
GlobalHandler = globalHandler;
ProgramConfiguration = configuration;
ServiceConfiguration = configuration.Web;
StatisticsService = statisticsService;
Server = new WebServer(ServiceConfiguration.Host, ServiceConfiguration.Port, ServiceConfiguration.EnableReverseProxyRealIPMode, this, this);
DatabaseProvider = databaseProvider;
WebServiceProfiler = new Profiler();
Serialiser = new JavaScriptSerializer();
Views = new HashSet<string>();
PRNG = new Random();
LoadIndex();
InitialiseHandlers();
}
List<AggregatedChampionStatistics> LoadAggregatedChampionStatisticsWithTemporaryView(Summoner summoner, MapType map, GameModeType gameMode, DbConnection connection)
{
Profiler profiler = new Profiler(false, "LoadAggregatedChampionStatisticsWithTemporaryView", GlobalHandler);
string viewName = GetViewName();
try
{
//Create a temporary view with a dynamically generated name to emulate the former CTE
string temporaryString = connection.IsMySQL() ? "" : "temporary ";
string createViewQuery = "create " + temporaryString + "view {0} as select game.map, game.game_mode, game.blue_team_id, game.purple_team_id, game.blue_team_won, player.team_id, player.summoner_id, player.champion_id, player.kills, player.deaths, player.assists, player.gold, player.minion_kills from game, player where game.blue_team_id = player.team_id or game.purple_team_id = player.team_id";
using (var createView = Command(createViewQuery, connection, viewName))
{
createView.Execute();
string commonWhereClause = string.Format("{0}.summoner_id = :summoner_id and {0}.map = :map and {0}.game_mode = :game_mode", viewName);
string selectQuery =
"select statistics.champion_id, coalesce(champion_wins.wins, 0) as wins, coalesce(champion_losses.losses, 0) as losses, statistics.kills, statistics.deaths, statistics.assists, statistics.gold, statistics.minion_kills from " +
"(select {0}.champion_id, sum({0}.kills) as kills, sum({0}.deaths) as deaths, sum({0}.assists) as assists, sum({0}.gold) as gold, sum({0}.minion_kills) as minion_kills from {0} where {1} group by {0}.champion_id) " +
"as statistics " +
"left outer join " +
"(select champion_id, count(*) as wins from {0} where {1} and ((blue_team_won = 1 and blue_team_id = team_id) or (blue_team_won = 0 and purple_team_id = team_id)) group by champion_id) " +
"as champion_wins " +
"on statistics.champion_id = champion_wins.champion_id " +
"left outer join " +
"(select champion_id, count(*) as losses from {0} where {1} and ((blue_team_won = 0 and blue_team_id = team_id) or (blue_team_won = 1 and purple_team_id = team_id)) group by champion_id) " +
"as champion_losses " +
"on statistics.champion_id = champion_losses.champion_id";
using (var select = Command(selectQuery, connection, viewName, commonWhereClause))
{
select.Set("map", map);
select.Set("game_mode", gameMode);
select.Set("summoner_id", summoner.Id);
profiler.Start("ExecuteReader");
using (var reader = select.ExecuteReader())
{
profiler.Stop();
profiler.Start("AggregatedChampionStatistics/drop");
List<AggregatedChampionStatistics> output = new List<AggregatedChampionStatistics>();
while (reader.Read())
{
AggregatedChampionStatistics statistics = new AggregatedChampionStatistics(reader);
output.Add(statistics);
}
reader.Close();
using (var dropView = Command("drop view {0}", connection, viewName))
dropView.Execute();
profiler.Stop();
return output;
}
}
}
}
finally
{
ReleaseViewName(viewName);
}
}
SummonerStatistics GetSummonerStatistics(Summoner summoner, DbConnection connection)
{
Profiler profiler = new Profiler(false, "GetSummonerStatistics", GlobalHandler);
profiler.Start("GetSummonerRatings");
List<SummonerRating> ratings = GetSummonerRatings(summoner, connection);
profiler.Stop();
profiler.Start("GetSummonerRankedStatistics");
List<List<SummonerRankedStatistics>> rankedStatistics = new List<List<SummonerRankedStatistics>>();
for (int i = 0; i < StatisticsService.Seasons; i++)
rankedStatistics.Add(GetSummonerRankedStatistics(summoner, i, connection));
profiler.Stop();
profiler.Start("twistedTreelineStatistics");
List<AggregatedChampionStatistics> twistedTreelineStatistics = LoadAggregatedChampionStatistics(summoner, MapType.TwistedTreeline, GameModeType.Normal, connection);
profiler.Stop();
profiler.Start("summonersRiftStatistics");
List<AggregatedChampionStatistics> summonersRiftStatistics = LoadAggregatedChampionStatistics(summoner, MapType.SummonersRift, GameModeType.Normal, connection);
profiler.Stop();
profiler.Start("dominionStatistics");
List<AggregatedChampionStatistics> dominionStatistics = LoadAggregatedChampionStatistics(summoner, MapType.Dominion, GameModeType.Normal, connection);
profiler.Stop();
profiler.Start("SummonerStatistics");
SummonerStatistics statistics = new SummonerStatistics(ratings, rankedStatistics, twistedTreelineStatistics, summonersRiftStatistics, dominionStatistics);
profiler.Stop();
return statistics;
}
Reply ApiSummonerStatistics(Request request)
{
Profiler profiler = new Profiler(false, "ApiSummonerStatistics", GlobalHandler);
profiler.Start("PrivilegeCheck");
PrivilegeCheck(request);
profiler.Stop();
profiler.Start("GetSummoner");
var arguments = request.Arguments;
string regionAbbreviation = (string)request.Arguments[0];
int accountId = (int)request.Arguments[1];
Worker worker = GetWorkerByAbbreviation(regionAbbreviation);
SummonerStatisticsResult output;
Summoner summoner = StatisticsService.GetSummoner(worker.Region, accountId);
profiler.Stop();
if (summoner != null)
{
using (var connection = GetConnection())
{
profiler.Start("GetSummonerStatistics");
SummonerStatistics statistics = GetSummonerStatistics(summoner, connection);
profiler.Stop();
profiler.Start("SummonerStatisticsResult");
output = new SummonerStatisticsResult(statistics);
profiler.Stop();
}
}
else
output = new SummonerStatisticsResult(OperationResult.NotFound);
profiler.Start("GetJSONReply");
Reply reply = GetJSONReply(output);
profiler.Stop();
return reply;
}
