// private Lua luaState;
// TODO
// add char and league service to singleton
public PoeFetcherManager(ILogger <PoeFetcherManager> logger)
{
_logger = logger;
this.PoeContext = new PoeDbContext();
this.characterService = new CharacterService(this.PoeContext);
this.leagueService = new LeagueService(this.PoeContext);
}
public LeaguesController(PoeDbContext context, LeagueService _leagueService, IDistributedCache distributedCache, ILogger <LeaguesController> logger)
{
PoeContext = context;
this.distributedCache = distributedCache;
this._logger = logger;
this.leagueService = _leagueService;
// TODO
// move to Startup file or dbcontext?
SqlMapper.AddTypeHandler <PoeAccount>(new JsonConvertHandler <PoeAccount>());
SqlMapper.AddTypeHandler <List <CharEntry> >(new JsonConvertHandler <List <CharEntry> >());
SqlMapper.AddTypeHandler <List <UniqueEntry> >(new JsonConvertHandler <List <UniqueEntry> >());
SqlMapper.AddTypeHandler <List <SkillEntry> >(new JsonConvertHandler <List <SkillEntry> >());
SqlMapper.AddTypeHandler <List <KeystoneEntry> >(new JsonConvertHandler <List <KeystoneEntry> >());
SqlMapper.AddTypeHandler <List <WeaponTypeEntry> >(new JsonConvertHandler <List <WeaponTypeEntry> >());
SqlMapper.AddTypeHandler <List <ClassEntry> >(new JsonConvertHandler <List <ClassEntry> >());
SqlMapper.AddTypeHandler <CharEntry[]>(new JsonConvertHandler <CharEntry[]>());
SqlMapper.AddTypeHandler <UniqueEntry[]>(new JsonConvertHandler <UniqueEntry[]>());
SqlMapper.AddTypeHandler <SkillEntry[]>(new JsonConvertHandler <SkillEntry[]>());
SqlMapper.AddTypeHandler <KeystoneEntry[]>(new JsonConvertHandler <KeystoneEntry[]>());
SqlMapper.AddTypeHandler <WeaponTypeEntry[]>(new JsonConvertHandler <WeaponTypeEntry[]>());
SqlMapper.AddTypeHandler <ClassEntry[]>(new JsonConvertHandler <ClassEntry[]>());
SqlMapper.AddTypeHandler <MainSkillSupportCountEntry[]>(new JsonConvertHandler <MainSkillSupportCountEntry[]>());
}
private async Task FetchAndUpsertLeagues()
{
List <PoeLeagueModel> leagues = await PoeFetcher.GetLeagues();
using (var PoeContext = new PoeDbContext())
{
await PoeContext.Leagues.UpsertRange(leagues.ToArray()).On(x => new { LeagueId = x.LeagueId }).RunAsync();
}
}
public LeagueService(PoeDbContext _PoeContext)
{
PoeContext = _PoeContext;
SqlMapper.AddTypeHandler <List <CharEntry> >(new JsonConvertHandler <List <CharEntry> >());
SqlMapper.AddTypeHandler <List <UniqueEntry> >(new JsonConvertHandler <List <UniqueEntry> >());
SqlMapper.AddTypeHandler <List <SkillEntry> >(new JsonConvertHandler <List <SkillEntry> >());
SqlMapper.AddTypeHandler <List <KeystoneEntry> >(new JsonConvertHandler <List <KeystoneEntry> >());
SqlMapper.AddTypeHandler <List <WeaponTypeEntry> >(new JsonConvertHandler <List <WeaponTypeEntry> >());
SqlMapper.AddTypeHandler <List <ClassEntry> >(new JsonConvertHandler <List <ClassEntry> >());
SqlMapper.AddTypeHandler <CharEntry[]>(new JsonConvertHandler <CharEntry[]>());
SqlMapper.AddTypeHandler <UniqueEntry[]>(new JsonConvertHandler <UniqueEntry[]>());
SqlMapper.AddTypeHandler <SkillEntry[]>(new JsonConvertHandler <SkillEntry[]>());
SqlMapper.AddTypeHandler <KeystoneEntry[]>(new JsonConvertHandler <KeystoneEntry[]>());
SqlMapper.AddTypeHandler <WeaponTypeEntry[]>(new JsonConvertHandler <WeaponTypeEntry[]>());
SqlMapper.AddTypeHandler <ClassEntry[]>(new JsonConvertHandler <ClassEntry[]>());
SqlMapper.AddTypeHandler <MainSkillSupportCountEntry[]>(new JsonConvertHandler <MainSkillSupportCountEntry[]>());
}
public CharacterService(PoeDbContext PoeContext)
{
this.PoeContext = PoeContext;
SqlMapper.AddTypeHandler <PoeAccount>(new JsonConvertHandler <PoeAccount>());
SqlMapper.AddTypeHandler <List <CharEntry> >(new JsonConvertHandler <List <CharEntry> >());
SqlMapper.AddTypeHandler <List <UniqueEntry> >(new JsonConvertHandler <List <UniqueEntry> >());
SqlMapper.AddTypeHandler <List <SkillEntry> >(new JsonConvertHandler <List <SkillEntry> >());
SqlMapper.AddTypeHandler <List <KeystoneEntry> >(new JsonConvertHandler <List <KeystoneEntry> >());
SqlMapper.AddTypeHandler <List <WeaponTypeEntry> >(new JsonConvertHandler <List <WeaponTypeEntry> >());
SqlMapper.AddTypeHandler <List <ClassEntry> >(new JsonConvertHandler <List <ClassEntry> >());
SqlMapper.AddTypeHandler <CharEntry[]>(new JsonConvertHandler <CharEntry[]>());
SqlMapper.AddTypeHandler <UniqueEntry[]>(new JsonConvertHandler <UniqueEntry[]>());
SqlMapper.AddTypeHandler <SkillEntry[]>(new JsonConvertHandler <SkillEntry[]>());
SqlMapper.AddTypeHandler <KeystoneEntry[]>(new JsonConvertHandler <KeystoneEntry[]>());
SqlMapper.AddTypeHandler <WeaponTypeEntry[]>(new JsonConvertHandler <WeaponTypeEntry[]>());
SqlMapper.AddTypeHandler <ClassEntry[]>(new JsonConvertHandler <ClassEntry[]>());
SqlMapper.AddTypeHandler <MainSkillSupportCountEntry[]>(new JsonConvertHandler <MainSkillSupportCountEntry[]>());
}
private void ForceUpdateCharactersPob(CancellationToken stoppingToken)
{
List <PoeCharacterModel> _chars =
PoeContext.Characters
.Select(c => new PoeCharacterModel {
CharacterId = c.CharacterId, PobCode = c.PobCode
})
.ToList();
foreach (var _c in _chars)
{
if (stoppingToken.IsCancellationRequested)
{
return;
}
try
{
string newPobXml = PobUtils.GetBuildXmlByXml(PobUtils.CodeToXml(_c.PobCode));
string nextPobCode = PobUtils.XmlToCode(newPobXml);
PathOfBuilding nextPob = PobUtils.XmlToPob(newPobXml);
_c.PobCode = nextPobCode;
_c.Pob = nextPob;
_c.Pob = PobUtils.XmlToPob(PobUtils.CodeToXml(_c.PobCode));
using (var db = new PoeDbContext())
{
db.Characters.Attach(_c);
db.Entry(_c).Property(x => x.PobCode).IsModified = true;
db.Entry(_c).Property(x => x.Pob).IsModified = true;
db.SaveChanges();
}
}
catch (System.Exception e)
{
_logger.LogError(e.ToString());
}
}
}
public CharactersController(PoeDbContext context)
{
PoeContext = context;
}
