public void SaveToDatabase_And_LoadFromDatabase()
{
// Arrange
StockEngine engine = GetEngine();
List <Quote> stocks = new List <Quote>();
Quote stock1 = new Quote("SYM1")
{
Id = Guid.NewGuid(),
LastTradePrice = 1.50m,
};
Quote stock2 = new Quote("SYM2")
{
Id = Guid.NewGuid(),
LastTradePrice = 2.50m
};
stocks.Add(stock1);
stocks.Add(stock2);
// Act
engine.InsertQuotes(stocks);
List <Quote> stocksFromDb = engine.AllQuotes().ToList();
// Assert
Assert.That(stocksFromDb.Count, Is.EqualTo(2));
Assert.That(stocksFromDb[0].Id, Is.EqualTo(stock1.Id));
Assert.That(stocksFromDb[0].LastTradePrice, Is.EqualTo(stock1.LastTradePrice));
Assert.That(stocksFromDb[0].Symbol, Is.EqualTo(stock1.Symbol));
Assert.That(stocksFromDb[1].Id, Is.EqualTo(stock2.Id));
Assert.That(stocksFromDb[1].LastTradePrice, Is.EqualTo(stock2.LastTradePrice));
Assert.That(stocksFromDb[1].Symbol, Is.EqualTo(stock2.Symbol));
}
public void Query300Symbols()
{
// Arrange
StockEngine engine = GetEngine();
// Act
IEnumerable <string> symbols = engine.LoadSymbolsFromTextFile("aim.txt");
IEnumerable <Quote> stocks = engine.LookupPrices(symbols.Take(300));
engine.InsertQuotes(stocks);
List <Quote> stocksFromDb = engine.AllQuotes().ToList();
// Assert
Assert.That(stocksFromDb.Count(), Is.GreaterThan(200));
}
