public void GetYearTest()
{
using (var cursor = Substitute.For <ICursor>())
{
cursor.GetInt(0).Returns(1999);
cursor.GetInt(1).Returns(7);
cursor.GetColumnIndex("year").Returns(0);
cursor.GetColumnIndex("count").Returns(1);
using (var dataAccess = Substitute.For <IDataAccess>())
{
dataAccess.ExecuteQueryWithParametersAsync(Arg.Any <string>(), Arg.Any <List <SQLiteParameter> >()).Returns(cursor);
using (var statisticsController = new StatisticsController(dataAccess))
{
var countAlbumsPerYear = statisticsController.GetCountofAlbumsPerYearAsync().Result;
Assert.IsNotNull(countAlbumsPerYear);
Assert.IsInstanceOf <Dictionary <int, int> >(countAlbumsPerYear);
Assert.AreEqual(1, countAlbumsPerYear.Count);
Assert.IsTrue(countAlbumsPerYear.ContainsKey(1999));
Assert.AreEqual(7, countAlbumsPerYear[1999]);
}
}
}
}