public void Finish(SessionRecord sessionRecord)
{
sessionRecord.FinishedAtUtc = DateTime.UtcNow;
_conn.Execute(@"
update Sessions set IsActive = 1, FinishedAtUtc = @FinishedAtUtc where RowId = @RowId;
update Sessions set IsActive = 0 where RowId <> @RowId and IsActive = 1 and QueryName = @QueryName;
", sessionRecord);
}
public SessionRecord Insert(SessionRecord record)
{
record.StartedAtUtc = DateTime.UtcNow;
var rowId = _conn.Query <int>(
"insert into Sessions(QueryName, IsActive, StartedAtUtc) values(@QueryName, 0, @StartedAtUtc); select last_insert_rowid()",
record).Single();
record.RowId = rowId;
return(record);
}