public TodoEntryFaker(IManageDatabase databaseManager, ILogger logger) { var random = new Random(); int randomNumber = random.Next(); Bogus.Randomizer.Seed = new Random(randomNumber); var entryStatusFaker = new TodoStatusFaker(databaseManager, logger); var entryStatusFake = entryStatusFaker.GetOne(); var entryStatusRepository = new TodoStatusRepository(databaseManager, new TodoStatusRepositorySql(), logger); var entryStatusFakeResult = entryStatusRepository.Create(entryStatusFake); entryStatusFake = entryStatusFakeResult.Model; _faker = new Bogus.Faker <TodoEntry>() .StrictMode(false) .Rules((f, m) => { m.TodoEntryId = null; m.Summary = f.Lorem.Sentence(10); m.Details = f.Lorem.Sentence(10); m.DueDate = f.Date.Past(); m.EntryStatusIdRef = entryStatusFake.TodoStatusId; }); }
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().ReflectedType.Name}_{MethodBase.GetCurrentMethod().Name}.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 todoStatusRepository = new TodoStatusRepository(databaseManager, new TodoStatusRepositorySql(), logger); Assert.NotNull(todoStatusRepository); // faker BrashActionResult <TodoStatus> result = null; var todoStatusFaker = new TodoStatusFaker(databaseManager, logger); Assert.NotNull(todoStatusFaker); // create var todoStatusCreateModel = todoStatusFaker.GetOne(); result = todoStatusRepository.Create(todoStatusCreateModel); Assert.True(result.Status == BrashActionStatus.SUCCESS, result.Message); Assert.True(result.Model.TodoStatusId > 0); // use model with id todoStatusCreateModel = result.Model; // update var todoStatusUpdateModel = todoStatusFaker.GetOne(); todoStatusUpdateModel.TodoStatusId = todoStatusCreateModel.TodoStatusId; result = todoStatusRepository.Update(todoStatusUpdateModel); Assert.True(result.Status == BrashActionStatus.SUCCESS, result.Message); // delete result = todoStatusRepository.Delete(todoStatusCreateModel); Assert.True(result.Status == BrashActionStatus.SUCCESS, result.Message); // fetch // - make fakes var fakes = todoStatusFaker.GetMany(10); // - add fakes to database List <int?> ids = new List <int?>(); foreach (var f in fakes) { result = todoStatusRepository.Create(f); Assert.True(result.Status == BrashActionStatus.SUCCESS, result.Message); Assert.True(result.Model.TodoStatusId >= 0); ids.Add(result.Model.TodoStatusId); } // - get fakes from database foreach (var id in ids) { var model = new TodoStatus() { TodoStatusId = id }; result = todoStatusRepository.Fetch(model); Assert.True(result.Status == BrashActionStatus.SUCCESS, result.Message); Assert.True(result.Model.TodoStatusId >= 0); } }