public async Task StatusCanBeRemoved()
{
// Arrange
using (var con = OpenConnection())
using (var cache = new SqliteCache(con))
{
using (var cmd = con.CreateCommand())
{
cmd.CommandText = "INSERT INTO Statuses (Id, UserId, StatusData) VALUES (123, 111, 'test');";
cmd.ExecuteNonQuery();
}
// Act
await cache.RemoveStatus(123);
// Assert
using (var cmd = con.CreateCommand())
{
cmd.CommandText = "SELECT Id FROM Statuses WHERE Id = 123;";
var fromDb = cmd.ExecuteScalar();
Assert.IsNull(fromDb);
}
}
}
public async Task NonExistingStatusIsNotFetchedForColumn()
{
// Arrange
using (var con = OpenConnection())
using (var cache = new SqliteCache(con))
{
var status = DummyGenerator.CreateDummyStatus();
status.ID = 123;
var colId = Guid.NewGuid();
await cache.AddStatuses(new[] { status });
await cache.MapStatusesToColumn(new[] { status }, colId);
// Act
var beforeDelete = await cache.GetStatusesForColumn(colId, 1);
await cache.RemoveStatus(status.ID);
var afterDelete = await cache.GetStatusesForColumn(colId, 1);
// Assert
Assert.AreEqual(1, beforeDelete.Count);
Assert.AreEqual(0, afterDelete.Count);
}
}