public void MakeConnection_With_NonExistent_Excel_File_Throws_FileNotFoundException(string nonExistentExcelFileName) { Assert.That( () => ExcelOleDbHelper.MakeConnection(nonExistentExcelFileName), Throws.InstanceOf <FileNotFoundException>() ); }
public void MakeConnection_With_NonExcel_Filename_Throws_ArgumentException(string nonExcelFileName) { Assert.That( () => ExcelOleDbHelper.MakeConnection(nonExcelFileName), Throws.ArgumentException ); }
public void GetRowsFromDataSheets_With_Null_Connection_Throws_ArgumentNullException() { OleDbConnection nullConnection = null; Assert.That( () => ExcelOleDbHelper.GetRowsFromDataSheets(nullConnection), Throws.InstanceOf <ArgumentNullException>() ); }
public void MakeConnection_With_Valid_Excel_Filename_Returns_OleDbConnection(string excelFileName) { OleDbConnection connection = null; Assert.That( () => connection = ExcelOleDbHelper.MakeConnection(excelFileName), Throws.Nothing ); Assert.NotNull(connection); Assert.AreEqual(excelFileName, connection.DataSource); }
public void GetRowsFromDataSheets_Gets_All_Rows_From_All_Data_Sheets(string excelFileName) { OleDbConnection connection = ExcelOleDbHelper.MakeConnection(excelFileName); var rows = ExcelOleDbHelper.GetRowsFromDataSheets(connection); Assert.AreEqual(3, rows.Count()); for (int i = 0; i < rows.Count(); i++) { Assert.AreEqual(String.Format("baz{0}", i + 1), rows.ElementAt(i)["foo"]); Assert.AreEqual(String.Format("qux{0}", i + 1), rows.ElementAt(i)["bar"]); } }
public void MakeConnection_With_Empty_Filename_Throws_Exception() { string nullInput = null; string emptyInput = String.Empty; Assert.That( () => ExcelOleDbHelper.MakeConnection(nullInput), Throws.ArgumentException ); Assert.That( () => ExcelOleDbHelper.MakeConnection(emptyInput), Throws.ArgumentException ); }
public void GetRowsFromDataSheets_Opens_And_Closes_The_Connection(string excelFileName) { OleDbConnection connection = ExcelOleDbHelper.MakeConnection(excelFileName); //manually open and close the connection to ensure it is closed connection.Open(); connection.Close(); //assert the connection is really closed Assert.AreEqual(ConnectionState.Closed, connection.State); //GetRowsFromDataSheet on a *closed* connection shouldn't throw an exception Assert.That( () => ExcelOleDbHelper.GetRowsFromDataSheets(connection), Throws.Nothing ); //assert that the connection was not left open Assert.AreEqual(ConnectionState.Closed, connection.State); }