void UpdateSummonerByName(LookupJob job)
{
//Attempt to retrieve an existing account ID to work with in order to avoid looking up the account ID again
//Perform lower case comparison to account for misspelled versions of the name
//LoL internally merges these to a mangled "internal name" for lookups anyways
DatabaseCommand nameLookup = Command("select id, account_id, summoner_name, summoner_level from summoner where region = cast(:region as region_type) and lower(summoner_name) = lower(:name)");
nameLookup.Set("region", Profile.Identifier);
nameLookup.Set("name", job.SummonerName);
using (var nameReader = nameLookup.ExecuteReader())
{
if (nameReader.Read())
{
//The summoner already exists in the database
int id = nameReader.Integer();
int accountId = nameReader.Integer();
string name = nameReader.String();
int summonerLevel = nameReader.Integer();
//This is not entirely correct as the name may have changed, but whatever
UpdateSummoner(new SummonerDescription(name, id, accountId), false);
job.ProvideResult(name, accountId, summonerLevel);
}
else
{
//We might be dealing with a new summoner
PublicSummoner publicSummoner = RPC.GetSummonerByName(job.SummonerName);
if (publicSummoner == null)
{
WriteLine("No such summoner: {0}", job.SummonerName);
job.ProvideResult(JobQueryResult.NotFound);
return;
}
DatabaseCommand check = Command("select id from summoner where account_id = :account_id and region = cast(:region as region_type)");
check.Set("account_id", publicSummoner.acctId);
check.Set("region", Profile.Identifier);
using (var checkReader = check.ExecuteReader())
{
if (checkReader.Read())
{
//We are dealing with an existing summoner even though the name lookup failed
int id = checkReader.Integer();
UpdateSummoner(new SummonerDescription(publicSummoner.name, id, publicSummoner.acctId), true);
}
else
InsertNewSummoner(publicSummoner.acctId, publicSummoner.summonerId, publicSummoner.name, publicSummoner.internalName, publicSummoner.summonerLevel, publicSummoner.profileIconId);
}
job.ProvideResult(publicSummoner.name, publicSummoner.acctId, publicSummoner.summonerLevel);
}
}
}
public LookupJob PerformSummonerLookup(string summonerName)
{
LookupJob job = new LookupJob(summonerName);
lock (LookupJobs)
LookupJobs.Enqueue(job);
ActivateWorkers();
job.Execute();
return job;
}
