public void TestRemoveVideoCallConnection_ShouldReturnEmptyReader() { // Insert mock tables mockDataGenerator.InsertTable1(); mockDataGenerator.InsertTable2(); // Insert databaseManager.SetVideoCallConnection(mockDataGenerator.table1["TABLE_NUMBER"], mockDataGenerator.table2["TABLE_NUMBER"]); // Remove databaseManager.RemoveVideoCallConnection(mockDataGenerator.table1["TABLE_NUMBER"], mockDataGenerator.table2["TABLE_NUMBER"]); // Get the inserted call connection var testDbHelper = new TestDatabaseHelper(); var reader = testDbHelper.GetCallConnection(mockDataGenerator.table1["TABLE_NUMBER"], mockDataGenerator.table2["TABLE_NUMBER"]); // Try to read the reader, since the reader.HasRows does not work. try { reader.Read(); Assert.Fail(); }catch { //Ignore the catch, this is expected. } // Close the connection created by GetCallConnection(). testDbHelper.CloseConnection(); // Delete mock rows. mockDataGenerator.DeleteTable1(); mockDataGenerator.DeleteTable2(); }
public void TestSetVideoCallConnection_NonExitingCallConnection_ShouldPass() { // Insert mock tables mockDataGenerator.InsertTable1(); mockDataGenerator.InsertTable2(); // Insert databaseManager.SetVideoCallConnection(mockDataGenerator.table1["TABLE_NUMBER"], mockDataGenerator.table2["TABLE_NUMBER"]); var testDbHelper = new TestDatabaseHelper(); var reader = testDbHelper.GetCallConnection(mockDataGenerator.table1["TABLE_NUMBER"], mockDataGenerator.table2["TABLE_NUMBER"]); // Assert that the reader is returned. Assert.IsNotNull(reader); // Assert that there is data in the reader. Assert.IsTrue(reader.HasRows); // Read the first row. reader.Read(); for (int i = 0; i < reader.FieldCount; i++) { // Get the column name. var name = reader.GetName(i); // Assert that the name is either "TABLE_NUMBER" or "HOTEL_ID". Assert.IsTrue(name.Equals("TABLE_NUMBER_1") || name.Equals("TABLE_NUMBER_2")); // Get the value of the column. var value = reader.GetValue(i); // Assert that the values are those of the inserted table. Assert.IsTrue(value.Equals(int.Parse(mockDataGenerator.table1["TABLE_NUMBER"])) || value.Equals(int.Parse(mockDataGenerator.table2["TABLE_NUMBER"]))); } //Close the connection created by the user. testDbHelper.CloseConnection(); //Remove the mock data. testDbHelper.RemoveCallConnection(mockDataGenerator.table1["TABLE_NUMBER"], mockDataGenerator.table2["TABLE_NUMBER"]); mockDataGenerator.DeleteTable1(); mockDataGenerator.DeleteTable2(); }