public static CatMatchMariaDbContext GetDbContext()
{
var options = new DbContextOptionsBuilder <CatMatchMariaDbContext>();
options.UseMySql("Server=localhost;Database=catmatch;User=root;Password=root;", (actions) =>
{
actions.ServerVersion(new Version(10, 3, 14), ServerType.MariaDb);
});
var context = new CatMatchMariaDbContext(options.Options);
context.Database.EnsureCreated();
return(context);
}
private async Task <(int EloLeft, int EloRight)> LoadElo(int leftId, int rightId, CatMatchMariaDbContext context)
{
var left = await context.Cats.IncludeSubModels().AsNoTracking()
.Select(e => new { Id = e.Id, Elo = e.Rank.Elo })
.FirstOrDefaultAsync(c => c.Id == leftId)
.ConfigureAwait(false);
var right = await context.Cats.IncludeSubModels().AsNoTracking()
.Select(e => new { Id = e.Id, Elo = e.Rank.Elo })
.FirstOrDefaultAsync(c => c.Id == rightId)
.ConfigureAwait(false);
return(left.Elo, right.Elo);
}
