public async Task Completing_more_than_once_should_only_write_once()
{
var connectionString = CreateUniqueConnectionString();
await InitializeDatabase(connectionString);
using var sut = new LongLivedDbTransaction(() => new SqliteConnection(connectionString));
await sut.ExecuteAsync(new InsertRandomText());
await sut.CompleteAsync();
await sut.CompleteAsync();
var recordCount = await _keepConnectionOpen.ExecuteScalarAsync <int>("SELECT COUNT(1) FROM TextEntries");
recordCount.Should().Be(1);
}
