public async Task MediaRepositoryMethodAllTest()
{
//[6][1][0] DbContextOptions 개체 생성
var options = new DbContextOptionsBuilder <MachineDbContext>()
.UseInMemoryDatabase(databaseName: "MediaApp").Options;
//[6][1][1] AddAsync() Method Test
using (var context = new MachineDbContext(options))
//[6][1][1][1] DbContext 개체 생성 및 데이터 입력
{
//[?] Repository Object Creation
var repository = new MediaRepository(context);
var machine = new Media()
{
Name = "[1] T7910", Created = DateTime.Now
};
await repository.AddMediaAsync(machine);
await context.SaveChangesAsync(); //[!]
}
//[6][1][1][2] 제대로 입력되었는지 테스트
using (var context = new MachineDbContext(options))
{
Assert.AreEqual(1, await context.Medias.CountAsync());
var machine = await context.Medias.Where(m => m.Id == 1).SingleOrDefaultAsync();
Assert.AreEqual("[1] T7910", machine.Name);
}
//[6][1][2] GetAllAsync() Method Test
//[6][1][2][1] DbContext 개체 생성 및 추가 데이터 입력
using (var context = new MachineDbContext(options))
{
await(new MediaRepository(context)).AddMediaAsync(
new Media {
Name = "[2] Rugged Extreame", Created = DateTime.Now
});
context.Medias.Add(new Media {
Name = "[3] Alienware Aurora R8", Created = DateTime.Now
});
await context.SaveChangesAsync(); //[!]
}
//[6][1][2][2] 제대로 출력되는지 테스트
using (var context = new MachineDbContext(options))
{
var repository = new MediaRepository(context);
var machines = await repository.GetMediasAsync(); //[?] 전체 레코드 가져오기
Assert.AreEqual(3, machines.Count()); // 현재까지 3개 테스트
}
//[6][1][3] GetByIdAsync() Method Test
//[6][1][3][1] DbContext 개체 생성 및 추가 데이터 입력
using (var context = new MachineDbContext(options))
{
await(new MediaRepository(context)).AddMediaAsync(
new Media {
Name = "[4] Level 10 Limited Edtion", Created = DateTime.Now
});
await context.SaveChangesAsync(); //[!]
}
//[6][1][3][2] 제대로 출력되는지 테스트
using (var context = new MachineDbContext(options))
{
var repository = new MediaRepository(context);
var alienware = await repository.GetMediaByIdAsync(3);
Assert.IsTrue(alienware.Name.Contains("Alienware"));
Assert.AreEqual("[3] Alienware Aurora R8", alienware.Name);
}
//[6][1][4] EditAsync() Method Test
//[6][1][4][1] DbContext 개체 생성 및 추가 데이터 입력
using (var context = new MachineDbContext(options))
{
await(new MediaRepository(context)).AddMediaAsync(
new Media {
Name = "[5] Surface Pro", Created = DateTime.Now
});
await context.SaveChangesAsync(); //[!]
}
//[6][1][4][2] 제대로 수정되는지 테스트
using (var context = new MachineDbContext(options))
{
var repository = new MediaRepository(context);
var surface = await repository.GetMediaByIdAsync(5);
surface.Name = "[5] 서피스 프로";
await repository.EditMediaAsync(surface);
await context.SaveChangesAsync();
var newSurface = await repository.GetMediaByIdAsync(5);
Assert.AreEqual("[5] 서피스 프로", newSurface.Name);
}
//[6][1][5] DeleteAsync() Method Test
//[6][1][5][1] DbContext 개체 생성 및 추가 데이터 입력
using (var context = new MachineDbContext(options))
{
// Empty
}
//[6][1][5][2] 제대로 삭제되는지 테스트
using (var context = new MachineDbContext(options))
{
var repository = new MediaRepository(context);
await repository.DeleteMediaAsync(5);
await context.SaveChangesAsync();
Assert.AreEqual(4, await context.Medias.CountAsync());
Assert.IsNull(await repository.GetMediaByIdAsync(5));
}
//[6][1][6] GetMachinesPageAsync() Method Test
//[6][1][6][1] DbContext 개체 생성 및 추가 데이터 입력
using (var context = new MachineDbContext(options))
{
// Empty
}
//[6][1][6][2] 2번째 페이지의 First 항목 체크
using (var context = new MachineDbContext(options))
{
int pageIndex = 1;
int pageSize = 2;
var repository = new MediaRepository(context);
var machines = await repository.GetMediasPageAsync(pageIndex, pageSize); // 4, 3, [2, 1]
Assert.AreEqual("[2] Rugged Extreame", machines.Records.FirstOrDefault().Name);
Assert.AreEqual(4, machines.TotalRecords);
}
}
