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 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 IAsyncEnumerable <PKMember> GetSwitchMembers(PKSwitch sw) { return(_conn.QueryStreamAsync <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 })); }