public async Task CorrectUserIdIsFoundForFriend()
{
// Arrange
using (var con = OpenConnection())
using (var cache = new SqliteCache(con))
{
using (var cmd = con.CreateCommand())
{
cmd.CommandText = "INSERT INTO UserFriends (UserId, FriendId) VALUES (1, 5), (2,4), (3,5);";
cmd.ExecuteNonQuery();
}
// Act
var noFriend = await cache.FindFriend(15);
var single = await cache.FindFriend(4);
var two = await cache.FindFriend(5);
// Assert
Assert.AreEqual(0ul, noFriend);
Assert.AreEqual(2ul, single);
Assert.IsTrue(two == 1ul || two == 3ul, two.ToString());
}
}