using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using UnitTestSharp;
using UnitTestSharp.DataDriven;

namespace TestsForUnitTestSharp.DataDriven
{
	public class DataSourceManagerClassTests : TestFixture
	{
		DataSourceManager Manager = new DataSourceManager();

		const string _file = "ExcelReaderTest.xls";
		const string _table = "Comments";
		const string _table2 = "Empty";
		const string _table3 = "Second Table";

		public override void TestSetup()
		{
			Manager.Reset();
		}

		public void AsUser_OnlyAccessesDiskOnce_OneTable()
		{
			CheckEqual(0, Manager.DiskAccesses);
			Manager.FindDataTable(_file, _table);
			CheckEqual(1, Manager.DiskAccesses);
		}

		public void AsUser_OnlyAccessesDiskOnce_MultipleTables()
		{
			CheckEqual(0, Manager.DiskAccesses);
			Manager.FindDataTable(_file, _table);
			Manager.FindDataTable(_file, _table3);
			CheckEqual(1, Manager.DiskAccesses);
		}

		public void AsUser_CanAccessEmptyTable()
		{
            var table = Manager.FindDataTable(_file, _table2);
            CheckEqual(1, table.RowCount);
            foreach (var row in table)
                CheckNull(row);
		}

		public void AsUser_ReturnsValidTable()
		{
			CheckNotNull(Manager.FindDataTable(_file, _table));
		}
	}
}