public async Task ExpiredHashtagIsNotRetrieved() { // Arrange using (var con = OpenConnection()) using (var cache = new SqliteCache(con)) { using (var cmd = con.CreateCommand()) { cmd.CommandText = "INSERT INTO Hashtags (Tag, Expires) VALUES ('test', 100);"; cmd.ExecuteNonQuery(); } // Act var tags = (await cache.GetKnownHashtags()).ToArray(); // Assert Assert.AreEqual(0, tags.Length); } }
public async Task CachedHastagsCanBeRetrieved() { // Arrange using (var con = OpenConnection()) using (var cache = new SqliteCache(con)) { using (var cmd = con.CreateCommand()) { cmd.CommandText = "INSERT INTO Hashtags (Tag) VALUES ('test'), ('abc');"; cmd.ExecuteNonQuery(); } // Act var tags = (await cache.GetKnownHashtags()).ToArray(); // Assert CollectionAssert.AreEquivalent(new[] { "test", "abc" }, tags); } }
public async Task ClearRemovesAllDataFromCache() { // Arrange using (var con = OpenConnection()) using (var cache = new SqliteCache(con)) { await cache.AddHashtags(new[] { "one", "two", "three" }); await cache.AddMessages(new[] { new MessageCacheEntry(DummyGenerator.CreateDummyMessage()) }); await cache.AddStatuses(new[] { DummyGenerator.CreateDummyStatus() }); var userToCache = DummyGenerator.CreateDummyUserEx(1); userToCache.Name = userToCache.ScreenName = "test"; await cache.AddUsers(new[] { new UserCacheEntry(userToCache) }); // Act await cache.Clear(); // Assert var tags = await cache.GetKnownHashtags(); Assert.AreEqual(0, tags.Count()); var msg = await cache.GetMessages(); Assert.AreEqual(0, msg.Count); var user = await cache.GetUser(1); Assert.IsNull(user); var status = await cache.GetStatus(0); Assert.IsNull(status); } }