public void Delete_NonexistentPower_PreservesNumberOfRecords()
{
// Arrange
var numPreExistingPowers = AdapterTestHelpers.CountSqlPowers(ConnectionString);
// Act
Adapter.Delete(Guid.NewGuid());
// Assert
var numPostExistingPowers = AdapterTestHelpers.CountSqlPowers(ConnectionString);
Assert.AreEqual(numPreExistingPowers, numPostExistingPowers);
}
public void Save_NewPower_InsertsOneRecord()
{
// Arrange
var numPreExistingPowers = AdapterTestHelpers.CountSqlPowers(ConnectionString);
var newPower = new Power(Guid.NewGuid(), "Super Archery");
// Act
Adapter.Save(newPower);
// Assert
var numPostExistingPowers = AdapterTestHelpers.CountSqlPowers(ConnectionString);
Assert.AreEqual(numPreExistingPowers + 1, numPostExistingPowers);
}
public void Delete_ExistingPower_RemovesOneRecord()
{
// Arrange
// make sure at least one power exists, so we can delete it
var power = new Power(Guid.NewGuid(), "Some ridiculous Silver Age stuff");
Adapter.Save(power);
var numPreExistingPowers = AdapterTestHelpers.CountSqlPowers(ConnectionString);
// Act
Adapter.Delete(power.Id);
// Assert
var numPostExistingPowers = AdapterTestHelpers.CountSqlPowers(ConnectionString);
Assert.AreEqual(numPreExistingPowers - 1, numPostExistingPowers);
}
public void Save_ExistingPower_PreservesNumberOfRecords()
{
// Arrange
// make sure at least one power exists, so we have something to update
var oldPower = new Power(Guid.NewGuid(), "Flight");
Adapter.Save(oldPower);
var numPreExistingPowers = AdapterTestHelpers.CountSqlPowers(ConnectionString);
// Act
var newPower = new Power(oldPower.Id, "SUUUUPER FLIGHT");
Adapter.Save(newPower);
// Assert
var numPostExistingPowers = AdapterTestHelpers.CountSqlPowers(ConnectionString);
Assert.AreEqual(numPreExistingPowers, numPostExistingPowers);
}