public async Task DeleteSwitch(PKSwitch sw)
{
using (var conn = await _conn.Obtain())
await conn.ExecuteAsync("delete from switches where id = @Id", new { Id = sw.Id });
_logger.Information("Deleted switch {Switch}");
}
public async Task <IEnumerable <PKMember> > GetSwitchMembers(PKSwitch sw)
{
using (var conn = await _conn.Obtain())
return(await conn.QueryAsync <PKMember>(
"select * from switch_members, members where switch_members.member = members.id and switch_members.switch = @Switch order by switch_members.id",
new { Switch = sw.Id }));
}
public async Task MoveSwitch(PKSwitch sw, Instant time)
{
using (var conn = await _conn.Obtain())
await conn.ExecuteAsync("update switches set timestamp = @Time where id = @Id",
new { Time = time, Id = sw.Id });
_logger.Information("Moved switch {Switch} to {Time}", sw.Id, time);
}
public async Task <IEnumerable <int> > GetSwitchMemberIds(PKSwitch sw)
{
using (var conn = await _conn.Obtain())
return(await conn.QueryAsync <int>("select member from switch_members where switch = @Switch order by switch_members.id",
new { Switch = sw.Id }));
}
