public async Task <int> WriteSingle <T>(T thing) where T : class
{
using (var conn = dbFactory.CreateRaw())
{
conn.Open();
return(await conn.InsertAsync(thing));
}
}
public async Task <User> GetUserByWhatever(string whereClause, object parameters)
{
using var dbcon = dbFactory.CreateRaw();
var user = (await dbcon.QueryAsync <User>($"select * from {userTable} {whereClause}", parameters)).FirstOrDefault();
if (user == null || user.deleted)
{
throw new NotFoundException($"User not found");
}
if (user.type != UserType.user)
{
throw new ForbiddenException("Can only perform user session actions with real users!");
}
return(user);
}
