public async Task GetAllAsync__All_tickets_found__Should_return_IEnumerable_for_all_tickets()
{
using (var factory = new DbContextFactory())
{
using (var context = await factory.CreateContextAsync())
{
int expectedLength = context.Tickets.ToArray().Length;
var service = new TicketDbService(context, _logger);
var result = await service.GetAllAsync();
result.Count().Should().Be(expectedLength);
}
}
}
public async Task GetAllAsync__Resource_is_null__Should_throw_InternalDbServiceException()
{
using (var factory = new DbContextFactory())
{
using (var context = await factory.CreateContextAsync())
{
context.Tickets = null as DbSet <Ticket>;
var service = new TicketDbService(context, _logger);
Func <Task> action = async() => await service.GetAllAsync();
await action.Should().ThrowExactlyAsync <InternalDbServiceException>("Because resource reference is set to null");
}
}
}
public async Task GetAllAsync__Resource_is_empty__Should_return_empty_IEnumerable()
{
using (var factory = new DbContextFactory())
{
using (var context = await factory.CreateContextAsync())
{
context.Tickets.RemoveRange(await context.Tickets.ToArrayAsync());
await context.SaveChangesAsync();
}
using (var context = await factory.CreateContextAsync())
{
var service = new TicketDbService(context, _logger);
var result = await service.GetAllAsync();
result.Count().Should().Be(0);
}
}
}
public async Task GetAllAsync__Resource_doesnt_exit__Should_throw_InternalDbServiceException()
{
using (var factory = new DbContextFactory())
{
using (var context = await factory.CreateContextAsync())
{
// Drop Tickets table.
context.Database.ExecuteSqlCommand("DROP TABLE [Tickets]");
}
using (var context = await factory.CreateContextAsync())
{
var service = new TicketDbService(context, _logger);
Func <Task> action = async() => await service.GetAllAsync();
await action.Should().ThrowExactlyAsync <InternalDbServiceException>("Because resource doesnt exist and cannot get single instance of Ticket. " +
"NOTE Excaption actually is type of 'SqLiteError' only if database provider is SQLite.");
}
}
}