public void SaveInvestmentTotalsInDb() { var filePath = @"Investments.csv"; var connection = new SqliteConnection("DataSource=:memory:"); connection.Open(); try { var options = new DbContextOptionsBuilder <DatabaseContext>() .UseSqlite(connection) .Options; using var context = new DatabaseContext(options); context.Database.EnsureCreated(); _databaseService = new DatabaseService(context); var csvService = new CsvService(); _uploaderService = new UploaderService(csvService, new Aggregator(), _databaseService); _uploaderService.UploadInvestmentsFromCsvToDb(filePath); var investmentsAfter = _databaseService.GetInvestmentTotals(); investmentsAfter.SingleOrDefault().Should().NotBeNull(); } finally { connection.Close(); } }
public void ReadDataFromCsv_WhenUploadFromCsvToDb() { _uploaderService.UploadInvestmentsFromCsvToDb(@"Investments.csv"); _csvServiceMock.Verify(c => c.GetInvestments(It.IsAny <string>()), Times.Once); }