public void CreateUpdateDeleteFetch()
{
// file system
var path = "/shop/randomsilo/modern-web/backends/TodoList";
var project = "TodoList";
var outputPath = $"{path}/{project}.Infrastructure.Test/TestOutput/";
var databaseFile = GetDatabase(outputPath, MethodBase.GetCurrentMethod());
// logger
ILogger logger = GetLogger($"{outputPath}/{MethodBase.GetCurrentMethod()}.log");
// database setup
// - context
IDatabaseContext databaseContext = new DatabaseContext(
$"Data Source={databaseFile}"
, "TestDb"
, "TestSchema"
, $"{path}/sql/sqlite/ALL.sql"
);
Assert.NotNull(databaseContext);
// - manager
IManageDatabase databaseManager = new DatabaseManager(databaseContext);
Assert.NotNull(databaseManager);
// - create tables
databaseManager.CreateDatabase();
// - repository
var todoNotesRepository = new TodoNotesRepository(databaseManager, new TodoNotesRepositorySql(), logger);
Assert.NotNull(todoNotesRepository);
// - service
var todoNotesService = new TodoNotesService(todoNotesRepository, logger);
Assert.NotNull(todoNotesService);
// faker
BrashActionResult <TodoNotes> serviceResult = null;
var todoNotesFaker = new TodoNotesFaker(databaseManager, logger);
Assert.NotNull(todoNotesFaker);
// create
var todoNotesCreateModel = todoNotesFaker.GetOne();
serviceResult = todoNotesService.Create(todoNotesCreateModel);
Assert.True(serviceResult.Status == BrashActionStatus.SUCCESS, serviceResult.Message);
Assert.True(serviceResult.Model.TodoNotesId > 0);
// use model with id
todoNotesCreateModel = serviceResult.Model;
// update
var todoNotesUpdateModel = todoNotesFaker.GetOne();
todoNotesUpdateModel.TodoNotesId = todoNotesCreateModel.TodoNotesId;
serviceResult = todoNotesService.Update(todoNotesUpdateModel);
Assert.True(serviceResult.Status == BrashActionStatus.SUCCESS, serviceResult.Message);
// delete
serviceResult = todoNotesService.Delete(todoNotesCreateModel);
Assert.True(serviceResult.Status == BrashActionStatus.SUCCESS, serviceResult.Message);
// fetch
// - make fakes
var fakes = todoNotesFaker.GetMany(10);
// - add fakes to database
List <int?> ids = new List <int?>();
foreach (var f in fakes)
{
serviceResult = todoNotesService.Create(f);
Assert.True(serviceResult.Status == BrashActionStatus.SUCCESS, serviceResult.Message);
Assert.True(serviceResult.Model.TodoNotesId >= 0);
ids.Add(serviceResult.Model.TodoNotesId);
}
// - get fakes from database
foreach (var id in ids)
{
var model = new TodoNotes()
{
TodoNotesId = id
};
serviceResult = todoNotesService.Fetch(model);
Assert.True(serviceResult.Status == BrashActionStatus.SUCCESS, serviceResult.Message);
Assert.True(serviceResult.Model.TodoNotesId >= 0);
}
}
public TodoNotesController(TodoNotesService todoNotesService, Serilog.ILogger logger) : base()
{
_todoNotesService = todoNotesService;
_logger = logger;
}
