public void Initialize()
{
new DataBaseOperations();
DataBaseOperations.ConnectToDB();
s_connection = DataBaseOperations.Connection;
TT = new TerritoryTable();
}
public void TestRetrieveNumberOfColsInTableMethodShouldReturnIntNotNUll()
{
//Arrange
var sut = new TerritoryTable();
//Act
int numberReturned = sut.RetriveNumberOfColsInTable();
//Assert
Assert.IsNotNull(numberReturned);
}
public void TestTableExistsMethodToSeeIfAKnownTableExists()
{
// Arrange
var sut = new TerritoryTable();
// Act
bool tableExists = sut.TableExists(sut.TableName);
bool expected = true;
bool actual = tableExists;
//Assert
Assert.AreEqual(expected, actual);
}
public void TestToSeeIfRowIsDeleted()
{
// Arrange
int count = 1;
var sut = new TerritoryTable();
String territoryIndexString = "This is territoryIndex1";
String sqlString = "DELETE FROM Territories WHERE territoryIndex='" + territoryIndexString + "';";
// Act
TT.DeleteRowFromTable(territoryIndexString);
SqlCommand command = new SqlCommand(sqlString, s_connection);
SqlDataReader myReader = command.ExecuteReader();
while (myReader.Read())
{
count++;
}
// Assert
Assert.AreEqual(1, count);
}